Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problems with FindFirst function
Further to above, the findfirst is only looking at the first record then stopping, I have tried adding .movelast before the .findfirst command, but this has not made any difference. So the criteria is working but the search is not covering more than the first record, any suggestions?- AdamJ
- Post #4
- Forum: Microsoft: Access Other topics
-
Problems with FindFirst function
Terry, When i changed the format to what you stated i got the following err msg. 3464 Data type Mismatch in criteria expression. Incidently when i use the method detailed in my first post if there is only one record in the table it will return a matching record, though it will not just match...- AdamJ
- Post #3
- Forum: Microsoft: Access Other topics
-
Problems with FindFirst function
I have created a find first function, that will ask the user to input a series of criteria to search by, use this criteria to find the specific record and then use the final user input to update part of the record. I have written thusly: Private Sub cmdFrame_Click() Dim fra, occ, car, cat...- AdamJ
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
-
Copy DB to remote server(security issues)
Hello, What's the best way to copy a database to a different server without Microsoft Networking ports being opened. Walk the backup over? FTP? Server's are connected by a DSL Pipe. As far as linking and all that other stuff that would make this easy, out of the question(Big Time Security)...- AdamJ
- Thread
- Replies: 11
- Forum: Microsoft SQL Server: Programming
