Search results

Thanx anyways guys but I worked around it. cheers

The form that works is set to Dynaset. I never tried the Dynaset Inconsistent. WIll try after lunch.

That's just it. I did set it to dynaset and it still wouldn't edit. That's why I couldn't figure out why it wasn't allowing me to edit.

I might be missing something and this may be really stupid of me but how come I can't edit a query. I have another query I use which is aloowing me to add records and edit them but I created another one and it won't let me edit it in my form. The AllowEdits and Allow Additions is true in the...

If your using XP or 2000 which I am I used the file o9regfix.exe which can be found here Micro$oft . After I ran it the error went away.

You are awsome. cheers

Hey all, I'm fixing a database that someone has done so what I did was created a blnk database and imported everything out of it. Well now i get an error and can't figure out why. When I open the original I can't do nothing to it. Hitting F11 doesn't show the database window and the previous...

Nevermind figured it out.

Hello all, I get this error in my database all of a sudden. Db worked great before the weekend now when I try to link tables I get this error. Anyone know why and how to get rid of it. cheers,

nevermind now. i got it. Thanks anyway. cheers

using the me.controls does the same thing. Boxes are still showing when they have no value.

Hello, I have a form with various fields. I have it laid out like a chart. Also I want the field to be invisible if there is no value located in the query with that number. Here is my code to help you out. sqlPart = "SELECT * FROM tblParts WHERE Area='" & PArea & "' AND [Page]='" & PPage &...

You could also use the function BuildCriteria. Does the same thing

Works great, cheers

Now() + 7 also works but is there a way to find out what day of the week it is so I can add the right number of days to add for the next monday. I was thinking in an if statement if weekday =" Monday" then format(now() + 7, "Short Date") end if cheers

Anyone know a way to set the now function a week in advance. When the user uses a form I have a text box setting the current date. But I want the date to be the monday of the next week.

Figured out the problem. But now I want to automate it. I have automated the export of the data but when I try to import it into the other db with the a macro it say field F1 not in table. But if I do it manually throught the menu it works. Any ideas?

Hello, I have to database and I am exporting from one and putting it into another. Now I have made the tables equal so importing should word. Now my problem is taht when I export from the db into a txt file I use , as the delimiter. When the data gets exported and I open the txt file I...