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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
UPDATE SQL
I cannot get the update to work. I have tried several different entries but I cannot get the table to be updated to fld. What am I doing wrong?<br> <br> Thanks<br> <br> Dim db As DATABASE, rs As Recordset, fld As String, strsql As String<br> Set db = CurrentDb<br> Set rs =...- abacus9
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
using SQL to update a field
I am trying to update a field based on an input from the user. I get the date but the update sql will not accept the 'strdate' as a value. The basic process is to check to see if the date entered is a valid date and if so update the Activity_Date field withe that date. Is there someting else...- abacus9
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
filtering in a compiled executible program
"Filter by form" is disengaged when the Access program is compiled for distribution. I was told that I would need to write VB code to simulate the "filter by form" function. I have a form with 22 fields. The user can filter on any combination of these fields. I would like...- abacus9
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Multiple users filtering
I have a program with multple users. It is in the share mode. However, when more than both persons are filtering and one wants to exit the screen an error message is displayed the states another user has admin control and the save has failed. The user has to wait to exit the screen. How can...- abacus9
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
