Search results

I've check references on users machines I have checked the references. Could one be missing even though none say "MISSING"?

I have a form that has a date field. When a new record is added I had the default on the date field to be the current date. This worked fine on my pc (Windows2000 op sys), but on the users pc (NT), the #NAME came in the date field, but they were able to enter a date in the field. So I made a...

Why would #NAME show up on a date field (default value = Date()) on several machines, but on my machine where the program was developed, I get today's date, the correct display. HELP!

I am running a report and get the error: There isn't enough memory to perform this operation. Close unneeded programs and try the operation again. It has err number 2004 on the msgbox. I have no other programs open. There appears to be enough memory on the machine. HELP.

I have 2 custom menu bars in my database. One I have as the menu bar for most forms and I have that one named as my menubar in the startup. The other custom menu bar I want on my reports when they are previewed. Even though I have in the Menubar property of my form I want Menubar#1 to come...

It worked, DOC_MAN!! I put in the domenuitem undo command and I am not getting the message now. Thanks for your response!

I have a form set up. The user can decide to cancel the add to the table that is updated. When the user gets out via the menubar on the Exit, the add is cancelled, but the following message appears, which I would like to suppress since I have a message already that lets them know they are not...

I have been developing an access db that uses autonumbers in every table (about 10 tables). Now that it is going into production next week, I want to start all tables out with 1 as the first autonumber for the first record. How do I do that? Thanks in advance.

I have reports set up for the users. A few reports use the same filter form, but depending on report I want to move controls on the form to different positions, ie, combo boxes, move them up on the form on the OnOpen event. How do I do this?

Printing 3 copies of labels I have a label report, but need to print 3 copies of each label. I have to do it in this order: label 001 (3 times), THEN label 002 3 times, THEN label 003 3 times, and so on. I do not want to print the first sheet, then the second sheet, etc. Is there a report...

To Full_Williams Sounds good. I'll give it a try. Thanks!!

I have a report set up and on the criteria selection form the user can select the clients he wants the report run for, ie, Gas, Electric, Other, etc, which are displayed via a combo box. In my query I reference the form field in the criteria so the report will just get the client asked for...

Reply to Rich again I'm a semi-novice, where is the microsoft qrySamp located for me to download?

Reply to Rich Rich, So how do I approach the cross tab option? A cross tab query? Please explain.

Anyone have any code for printing a variable number of columns on a report, ie., at least 2 cols up to 31 columns?

Reply to Rich The query that my report runs off has 31 columns, Day1, Day2 (I use DateAdd to determine Day2-Day???). If the user requests from 5/1/2002 to 5/10/2002, then from 5/11/2002 thru 5/31/2002 has zeros in them, I don't put the totals in the query. So the report has a field for each...

I have a report that prints where the user gets to enter a start date and an end date, but the end date can be up to 31 days beyond the start date. So the most info printed will be 31 days of totals. If they only ask for 10 days, I don't want the other 21 days to print (they are printing as...

I have an option button on a form. When I select it it works properly, which means it allows users to select from a list of names below it. When I deselect the button, I get a message that says I am being prevented from saving data in that field. In the event BeforeUpdate is where I have my...

Date problem: On a form I have a text box defined as a date field. When the cursor is on the field, the time is displayed rather than the short date format specified in the properties for that field. Does anyone know what could be wrong?

I have a list box on a form with the multi-select property set to extended. When I attempt to select an item in the middle of the list, it hightlights everything from the middle up to the top of the list. What am I doing wrong?