Search results

I don't know why, but exporting just exports the file without pulling up the wizard. Only importing gets the wizard up for me so I can see these specifications! Any idea why? Is there any setting anywhere?

I have an access database on a server. Everyone the data and front end are both on the server. Problem: I need ODBC drivers to get to data on a SQL server. When link to the data on one machine, it works fine. But some machines the ODBC connection doesn't work! I have to update using the...

What do you want to do? Have a textbox on a form that shows the latest ID number? If it is an autonumber function, as Jack suggested, don't put this in code, but his code DMax("[Mini ID]","tblcar") use it as the Control Source. Then it will always show the latest ID number. What is the...

Do you by chance, have the same name for the textbox as one of the fields in the box?

Do the same thing you did on the main form, but do it on the On Current event of the subform. See how that works. I also like the suggestion of having a sort order set up of either Date descending, or Order Number descending (assuming your order numbers increase)

In the Phone number field, after update, use the code: Me!Name = Dlookup("Name","Other Table", "[Phone number] = """ & me![Phone Number] & """") Repeat for each field you want to add...

Or, use a field CreatedBy with a default value (set in properties) of CurrentUser(), and don't change it.

Use the CurrentUser() function. That is the login name of the current user. Lets say you have two fields: TimeUpdated UpdatedBy In the Before Update for the form: Me![TimeUpdated] = Date Me![UpdatedBy] = CurrentUser That should do it. Make sure you don't put this stuff in After Update or...

Is it a calculated field? Try iif(Sum([Field4) = 0, Null, Sum([field4)) Make sure there is no default of 0 on the form. Also check the table to make sure there is no default of zero on the table.

1. Maybe there is no Contact ID on the new form. 2. Maybe the form contact is not open. 3. Maybe on the form you are opening in the dataset there is the criteria (=forms.contact.contact id) and 2. as well. Try that, if no go, write again.

Once you're a little more advanced, try Getz et al "Access 2000 Developer's Handbook" (in 2 vols.) Best I've found yet.

I had to call Microsoft. So far two engineers there are "throwing darts at it", having never heard of this sort of problem. It probably has to do with conflicts in References, but haven't solved it yet. Ugly.

more info - the error only occurs when filters are on, and the code gets stuck on DoCmd commands. The program then works, but gets stuck on every DoCmd and needs to be shut down to start over again. Help!

The mysterious error message "You can't perform that action at this time", number 2486 is appearing and ruining my life. The debug takes me to loads of different spots, such as commands to save, commands to print, etc. Code just seems to break down. Now, the thing is, it only happens when...

The problem did not go away. It appears on different people's computer at different times. Often when trying to save the record. Then it gets stuck, needs to be shut off, and restarted. This is not highly productive. Any experience, anyone, anything?

How to turn on debugging: go to tools->startup->advanced-> and check the box. Why doesn't help or anywhere else mention this?

I had problems with save, too. Try this code: DoCmd.DoMenuItem AcToolBar, AcFile AcSaveRecord that always works. If you have a security system that does not allow all users full priveledges, you will definitately run into problems with DoCmd.Save, because that saves the form as well, and they...

I had been tearing my hair out over the same issue. Check on the Tools -> startup menu -> advanced that that little thing is checked Use special keys. That should do it.

Well, I worked it out. It seems this error is caused when you try to run a query that cannot be run at that time. I had a set of tab pages, various types of order and registration tables, all held together by the table containing the customers. I had some queries to be double sure the orders...

If you are going from the form itself, rather than DoCmd.OpenReport "rptDataComp", acPreview, , "[MixID]=[Forms]![frmDataComp]![MixID]" try DoCmd.OpenReport "rptDataComp", acPreview, , "[MixID] = " & [Forms]![frmDataComp]![MixID] or just "[MixID] = " & me![MixID]