This has worked for me in the past.
Put your sql in code and ref. everything their. I have had to generate many tables this way and it works almost every time.
Hope this helps
When you use sql server for your back end you should be able to have up to 200 - 2000 concurrent usurers.
Sometimes this just isn't so.
Depending on the size, location, and the amount of objects in you database...
I can't remember were i found the following code. I have made some changes to get it to work the way I wanted. let me know if this works. This code checks to see if a file exist at a specific location.
'_____________________________start_____________________...
two ways to get this done.
one. write in VBA on load to add a new record then add a value to a txtbox or another object. **remember this will only work on open of the form. you may need to reference this again when anytime you go to a new record.
example(frmcool, one autonumber field, and one...
dbguy is write on but it may not work in Access 2000. Because of libraries.
Try this. If MS Office 2000
On click (or another event).
'_____________________code start_______________________
Dim rst as object: Set rst = currentdb.openrecordset ("YourTable")
Dim strVar as string...
I don't think that access tables actually have a record limit. they only have a size limit.
Here is the specs: (from the help files)
Microsoft Access database table specifications
Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of...
The best way around this is to not link the form directly to your table or query.
change the form so that when your are done with entering the infromation it runs a series of checks on the data.
Then enters that data into the table.
Here is the code. Found it on the web some time back. I have lost the actual writer of this.
on your Autoexec. open your form.
on your form. open Call Set Window. ****MAKE SURE THAT ON YOUR FORM YOU HAVE THE POP UP AND MODEL ON**** if not you will hide the entire db and have to go to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.