microsoft.public.access

Message Index 2 for Usenet Archive microsoft.public.access

RE: Superscript and subscript in Access (by =?Utf-8?B?YXJsaW5lIHBsdWVy?= on 5 May 2004, 1 reply)
I am entering information into access 2000 and for the life of me can't get superscript or subscript items. I can use the character map and insert "some" of the characters I need but this is very time consuming. In word you have the option under fonts for these but in access I do not. Any suggestions? thanks for answering my e-mail. I'm sorry it took so long to get back to you. The character map is the only way I can find to do super or sub script. I'm doing a medical dictionary and this is really a problem for me. I can get most of the characters I need but I can't get capital letters in superscript. If you hear anything pleae let me know. Thanks again. ... (more)

RE: Superscript and subscript in Access (by =?Utf-8?B?YXJsaW5lIHBsdWVy?= on 5 May 2004, 1 reply)

I am entering information into access 2000 and for the life of me can't get superscript or subscript items. I can use the character map and insert "some" of the characters I need but this is very time consuming. In word you have the option under fonts for these but in access I do not. Any suggestions?

thanks for answering my e-mail. I'm sorry it took so long to get back to you. The character map is the only way I can find to do super or sub script. I'm doing a medical dictionary and this is really a problem for me. I can get most of the characters I need but I can't get capital letters in superscript. If you hear anything pleae let me know. Thanks again. ... (more)

backround picture and table (by =?Utf-8?B?YXVkcmV5?= on 5 May 2004, 3 replies)
I've done a search -- but nothing came up in the archives, so is it possible to have one large picture as the backround to a page, and then put a transparent table on top to lay text into? ... (more)

Scrolling with a Mouse on Access forms (by =?Utf-8?B?Um9uIEg=?= on 5 May 2004, 1 reply)
Win Me: Opp. System On loading a form the scroll wheel will not scroll to the bottom of the page but will change records instead. We have used two different mice, a Microsoft wheel mouse and a Digitech. We are using a Genius mouse on our second computer which uses windows XP and it is scrolling perfectally. Desperate. ... (more)

Fantastic (How can this be done?) (by =?Utf-8?B?UGFuZ28=?= on 5 May 2004, 3 replies)
Some ne on our network (a domained one) created a ms access application that has a form opening at start up. On that form there is a field that dispalys the windows user id on it. For instance if you log on to the domain as newguy then when you open that database you see, welcome newguy on the form. It actually doesn't prompt you for a username or password, but it greets you with your network id. ... (more)

Fantastic (How can this be done?) (by =?Utf-8?B?UGFuZ28=?= on 5 May 2004, 3 replies)

Some ne on our network (a domained one) created a ms access application that has a form opening at start up.
On that form there is a field that dispalys the windows user id on it. For instance if you log on to the domain as newguy then when you open that database you see, welcome newguy on the form.

It actually doesn't prompt you for a username or password, but it greets you with your network id. ... (more)

charts (by =?Utf-8?B?cmF3bGV5?= on 5 May 2004, 1 reply)
Is there an easy way to create charts from tables, forms, reports (or something else) in Access similar to how you create them in Excel? Any suggestions on how to do this would be appreciated! ... (more)

Re: Lots of Help needed, Please!!! (by =?Utf-8?B?cmVkaGVhZA==?= on 5 May 2004, no replies)
ok, I have a form that acts as the entry point for the data. I need to add a field that allows me to put in a percentage. In my report I need that percentage to be shown in terms of a stop light. I think we are going to need a lot more information about the database to be able to help you. It's easy enough to calculate the percentages you are ... (more)

capitals to title (by =?Utf-8?B?Q2hl?= on 5 May 2004, 1 reply)
I imported a database and it's in all caps. How can I change to title case. I'm new at this. Please make it simple. Thank you, ... (more)

can't add data to form (by =?Utf-8?B?cmF3bGV5?= on 5 May 2004, 2 replies)
I've created a form based off of a query (so that the form automatically performs calculations based-on values entered), but for some reason, I can't edit any of the data already entered (entered from a table), and I can't add any new data. I've verified that the queries are set to "Dynaset" and not "Snapshot". Anyone have any ideas? Thanks! ... (more)

Re: Link table in code doesn't "take" (by Douglas J. Steele on 5 May 2004, no replies)
I show one approach at http://members.rogers.com/douglas.j.steele/DSNLessLinks.html There are other (better) approaches. For instance, you could create a ... (more)

Hello (by Randy Charles Morin on 05 May 2004, no replies)
Goodbye ... (more)

Re: =Min(DateField), =Max(DateField) (by Wayne Morgan on 5 May 2004, no replies)
As John requested, please post your actually command line. Also, to refer to the controls on the form from within the report, set the control source of the report's controls to something like ... (more)

Sending an email message with an attachment (by BP on 5 May 2004, 2 replies)
HI, Using Access, Word and Outlook 2000. I'm using the "merge it with Word" option in Access. However, I can't find.... how do I add an attachment like I would in a "normal" email message. I need to attach a pdf file. ... (more)

Re: Access2002 crashes while changing from query design to SQL (by on 05 May 2004, no replies)
BerHav, I am also having the same problem. When I open a report or form, sometime I will get this error message. However I did notices it's ... (more)

Re: access vs visual basic 6.0 vs visual basic.net (by onedaywhen on 5 May 2004, no replies)
Excel and Word come with UserForms (MSForms class) and their own flavor of ActiveX controls. They are closest to the VB6 form; more limited but the controls are largely similar. They are most definitely not .NET Windows Forms. ... (more)

Re: access vs visual basic 6.0 vs visual basic.net (by onedaywhen on 5 May 2004, 26 replies)
That was ambiguous! I meant I recommend not using MS Access forms. ... (more)

Project locked error (by Les Matheson on 5 May 2004, 1 reply)
I'm building an Access 2003 application. Its been a while since I used Access much, and v2003 is pretty new to me -- but I have a lot of experience with Access 97. ... (more)

Viewing web pages in a form (by Dave on 5 May 2004, 1 reply)
Can i use A97 to act like a browser? I want to allow users to access certain internet sites without having to change from my Access DB to internet explorer ... (more)

detecting date style (by Dave on 5 May 2004, 2 replies)
How can i detect the date style that the users system is using. I have some customers that have dd/mm/yy and some that have dd/mm/yyyy ... (more)

Re: Records not containing condition (by flupp on 5 May 2004, 1 reply)
Ramesh, SELECT * FROM [Action Table] ORDER BY ActionDate ASC, JobID ... (more)

Re: Handhelds/PDA's (by Sam Goddard on 5 May 2004, 3 replies)
What is the best way of using a handheld device within a warehousing environment in order that it can make use of access databases? Is it best to create a web-based project that the devices can interact with or is there another way that I am as yet unaware of? ... (more)

Set Message box to appear at specific time each day (by Steve M on 5 May 2004, 1 reply)
Hi, Is it possible to set a message box to appear at a set time each day. I want it to appear at 1500 hrs to tell the user to print and fax a specific ... (more)

How to use Listview In MS Access form (by anand on 5 May 2004, 3 replies)
Hello Group, How can i use Listview control ( same as checklistBox in VB) in MS Access form.Any suggestion. Thanks ... (more)

Hello (by Randy Charles Morin on 05 May 2004, no replies)
Goodbye ... (more)

Re: Writing a query (probably using SQL) (by Rebecca on 5 May 2004, 1 reply)
tina- First off I want to thank you for taking so much time and explaining everything to me!!! and then to write the query and check to see if it works.. wow!! way beyond what I expected.. ... (more)

Re: Link table in code doesn't "take" (by Ron Hinds on 5 May 2004, 1 reply)
?CurrentDb.TableDefs("error_log").Connect I used the Connect string returned as a template. I will try your suggestion though which seems to dovetail nicely with Doug's (see earlier post). Is ... (more)

Re: Writing a query (probably using SQL) (by Dirk Goldgar on 5 May 2004, 2 replies)
"Pieter Wijnen" <mysurnameonly@online.no> wrote in message news:IQ_lc.153429$jf4.8202376@news000.worldonline.dk The SQL IIf() function does recognize "Is Null". The VBA IIF() function ... (more)

Re: Calling ALL Access gurus ... "Come and have a go if you think your smart enough" ! (by Tony Toews on 05 May 2004, no replies)
Sounds like a homework question to me. Tony ... (more)

Price and Volume Variables (by jagstirling on 5 May 2004, no replies)
I have a general question based around the fictitous scenario below; ************************************************** I am a confectioner selling candy and wishing to hold details of my customers in a table. ... (more)

Another Divide question (by RichK on 05 May 2004, 1 reply)
I posted earlier about dividing fields in a query. Thanks to all that responded! I am a newb and may not have described my dilemma correctly! ... (more)

Access 2002 Crash with opening forms or reports (by on 05 May 2004, no replies)
Hi I have Access 2002 (10.6501.6626) SP3, when I open a certain forms or reports, my Database would close and I would get the following error "Microsoft Access has encountered a problem and needs to close. We ... (more)

Opening a specific Word doc (by Chris on 5 May 2004, 3 replies)
I know this has probably been asked loads but I can't find any useful threads in a Google groups search. What would the code be to open a specific Word document, from a command button on a form. The document is situated in the same directory as my database. ... (more)

free ebook to learn ACCESS (by eXistenZ on 5 May 2004, 1 reply)
Hi NG. is someone here who can tell me a link to download a good, but free of costs, ACCESS 2000 Book to learn the Syntax and Commands of ACCESS VBA and ... (more)

Hello (by Randy Charles Morin on 05 May 2004, no replies)
Goodbye ... (more)

Hello (by Randy Charles Morin on 05 May 2004, no replies)
Goodbye ... (more)

Re: Turn Off AutFill in Datasheet (by Joan Wild on 5 May 2004, no replies)
Allen has provided you with a good workaround. If it's suitable for your situation, setting a default value on the field will stop the autofill. ... (more)

Re: Link table in code doesn't "take" (by Ron Hinds on 5 May 2004, 2 replies)
They are already ODBC-linked tables - I just want to point them to a different server. That would appear to be the problem. Unfortunately, no error is returned ... (more)

Strange problem (by Eric Caron on 6 May 2004, no replies)
Hi, Since a couple of days, I have been having problems opening tables and using the ADO objects to access data in Access databases. I am using Access 2000. ... (more)

Form and Subform Linkage (by Rafael Chemtob on 6 May 2004, 3 replies)
Hi, I have a form within a form (subform). on the main form, there is a list box reading from the products table (fields, id_product, product_name). on the subform, i have a list box reading from the orders table. the subform ... (more)

Re: =Min(DateField), =Max(DateField) (by DebbieG on 6 May 2004, no replies)
JMorrell, Did you get this figured out? If so, what worked? ... (more)

Description Filed (by piotr on 6 May 2004, 2 replies)
Hi, Is there any way to change value of 'description' field (column) in ms access tables using scirpts? I know you can read it using OpenSchema method of ADO Connetcion object but ... (more)

copy one excell sheet multiple times at once (by =?Utf-8?B?c3BlbGw=?= on 6 May 2004, 2 replies)
Is there a way to copy one sheet 52 times at once ? ... (more)

Dates in an expression (by anonymous on 6 May 2004, 1 reply)
Okay, I'm an idiot. Pretty new to Access. I need to create an expression that will give me a value of the date from one field + seven days. I have re-written this every which way with no luck. Could anyone offer me a tip? ... (more)

s_GUID listed in drop down list box (by =?Utf-8?B?QWxsaXNvbg==?= on 6 May 2004, no replies)
I have a database (my customer states the database is not replicated; I do not know if he uses the brief case feature). Regardless, on one of the forms there is a drop-down list box. If the information is for an existing record - the box shows appropriate information stored in the key field. But if I expand the list to see my options, the s_GUIDs are listed. I found a blip in some old article that replication fields were displayed back in Access 95 and this was fixed with Access 97. This is an Access 97 database recently converted to Access 2000. ... (more)

s_GUID listed in drop down list box (by =?Utf-8?B?QWxsaXNvbg==?= on 6 May 2004, no replies)

I have a database (my customer states the database is not replicated; I do not know if he uses the brief case feature). Regardless, on one of the forms there is a drop-down list box. If the information is for an existing record - the box shows appropriate information stored in the key field. But if I expand the list to see my options, the s_GUIDs are listed.

I found a blip in some old article that replication fields were displayed back in Access 95 and this was fixed with Access 97. This is an Access 97 database recently converted to Access 2000. ... (more)

Creating a new record from selected fields of existing record (by =?Utf-8?B?U3Vl?= on 6 May 2004, 5 replies)
Hi, What I need to do is to create a new record in the same database from an existing record - and I want to specify which fields' contents are copied across. There is a command I can add in the form which duplicates the record to a new record - this generates a new record incrementing my unique numbering, but it copies the contents of all the fields - I want to create a new record that take the content of most of the fields but not all of them - and ideally I would like to do this within the form view. Any ideas please?? ... (more)

Creating a new record from selected fields of existing record (by =?Utf-8?B?U3Vl?= on 6 May 2004, 5 replies)

Hi,

What I need to do is to create a new record in the same database from an existing record - and I want to specify which fields' contents are copied across. There is a command I can add in the form which duplicates the record to a new record - this generates a new record incrementing my unique numbering, but it copies the contents of all the fields - I want to create a new record that take the content of most of the fields but not all of them - and ideally I would like to do this within the form view. Any ideas please?? ... (more)

RE: Conversion toolkit (by =?Utf-8?B?SGVscA==?= on 6 May 2004, no replies)
TTT. ... (more)

Create Blank 2003 database results in different sizes (by =?Utf-8?B?am9l?= on 6 May 2004, 1 reply)
I created 2 blank 2002 (SP-1) databases (under Win 2k) to import my '97 FE and BE databases that were not converting successfully. I saved both 'blanks' without importing, accessing, or viewing any of the new database structure (no content was installed). I noticed the first database was 100K, and the second database was 104K! Before I created the 2nd database, Windows Installer popped-up and announced the installation of a "..Microsoft Access Feature.."; no other detail. I can recreate the problem (Why should Windows need to re-install a missing feature?), and tried to identify the Installation activity with InstCtl, but I am at a loss to identify the offending component. ... (more)

Create Blank 2003 database results in different sizes (by =?Utf-8?B?am9l?= on 6 May 2004, 1 reply)

I created 2 blank 2002 (SP-1) databases (under Win 2k) to import my '97 FE and BE databases that were not converting successfully. I saved both 'blanks' without importing, accessing, or viewing any of the new database structure (no content was installed). I noticed the first database was 100K, and the second database was 104K! Before I created the 2nd database, Windows Installer popped-up and announced the installation of a "..Microsoft Access Feature.."; no other detail.

I can recreate the problem (Why should Windows need to re-install a missing feature?), and tried to identify the Installation activity with InstCtl, but I am at a loss to identify the offending component. ... (more)

Query (by Akshay on 6 May 2004, 12 replies)
I want to build a parameter query assigning atleast three diffrent parameters. I want the query to return criteria as blank or "null" if a parameter box is left balnk by the user so that I get all the data if I leave a parameter blank for that field. Burnt around gazzlion ... (more)

Problems (by Curio Pederzolli on 6 May 2004, 1 reply)
I have some problems with two computers. 1) I'm using Win XP (Home) on both. On one after a while every thing freezes up. I press Ctrl, Alt and Delete and get up Task Manager and for a while I can work but I'd much prefer not using task manager . ... (more)

Locking (by sonta on 6 May 2004, no replies)
If I could ask another question relating to the locking. I'd like to create a macro button on the form where the user presses the button to unlock the current record (comprising of numerous fields eg. name, address etc) they are viewing (ie. to remove the date in the 'File ... (more)

[Repost] Form/Subform question (by Damien McBain on 6 May 2004, 4 replies)
Like this: Territories Customers Sales ProductHierarchy ... (more)

RE: Access 2000 problem (by =?Utf-8?B?Sm9l?= on 6 May 2004, no replies)
I believe Microsoft changed the (default) format for dates in Windows 2000. Check whether your table definitions and queries are specifying date formats. This may also be affected by the configuration defaults selected by the Windows user. Check that these configurations are all the same. ... (more)

Formula result into the table (by =?Utf-8?B?VGFyYQ==?= on 6 May 2004, 1 reply)
I am creating a new database where I need a calculation of two numbers to be a value in the table (similar to excel formula). A dditionally, I need that value to be used in an average calculation that is also a value in the table. It is my understanding that calculations can only be done on the form or report but they are never a part of the table. ... (more)

Problems with simple linking of tables I think --fidsgal (by fidsgal on 6 May 2004, 1 reply)
I have 3 tables that have the relationships as shown below. The 1st table is the Main form. The 2nd table is a subform of Table 1, and likewise table 3 is a sub of 2. ... (more)

Notify that recordset is already being edited (by =?Utf-8?B?RGFuaWVsIFA=?= on 6 May 2004, 2 replies)
Hello, I had a database that is used by numerous people on a network server. Is there a way to display a message when someone loads a recordset that another person also has open? ... (more)

Viewing users accessing DB (by anon@hp.com on 06 May 2004, 3 replies)
Hi There, I manage a few Access2000 databases over a corporate network and I was wondering if there was some sort of tool I could use to monitor who was ... (more)

Collate and print two reports - all pages (by Bonnie Conrad on 6 May 2004, no replies)
I used Microsoft KB 231805 to create a module which collates and prints two reports and created a macro to call that module. I need to make sure all pages of both reports print (both reports are the same size) so I set the parameters at 300 pages (larger than either report ... (more)

IIF with left(field,1) (by =?Utf-8?B?Sk1vcnJlbGw=?= on 6 May 2004, 7 replies)
Can someone tell me why =IIf(Left([c],1)="-",Left([c],1)="+","") ... (more)

ACCESS 97 (by RICK on 6 May 2004, 1 reply)
IS THERE A WAY TO SEND A REPORT OVER E-MAIL OPEN, NOT AS AN ATTACHMENT. IT IS BEING SENT TO A PHONE AS A TEXT MESSAAGE ... (more)

Title Case-Must Share With All (by Linda on 6 May 2004, 2 replies)
Hello everyone! Well with asking around, I finally got a simple version of an expression to convert many words in one field to Title ... (more)

Using a value in one table as the default value for another table (by Mark on 6 May 2004, 1 reply)
I am trying to setup a database to record production. I want to set different work factors in one table that will remain constant for the records but different based on the site using the database. I was hoping to set the ... (more)