Search results for query: *

Question 1: can you set up a ODBC to connect to the tables?

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...

Excel has a 255-character limit check your field for its size.

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...

Didn't work for me. you may have to use two queries. first for criteria then the group by.

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...