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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ERROR CHECKING
I am trying to see if a customer ID is already in the table before adding a new one... This is what I have so far... Set dbs = CurrentDb() Set rst = dbs.OpenRecordset("Customer Data") If Me![CustAcctID] = rst![CustAcctID] Then MsgBox "This Customer...- bdavey
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
How do you use a select case statem
Thank you so much!!!! It worked! You have been a big help!- bdavey
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
How do you use a select case statem
We are on the right track, however,we are no longer getting an error message (it is compiling properly). However, it is not updating the fields in the table? What step are we missing? Thanks!- bdavey
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
How do you use a select case statem
How do you use a select case statement when using a recordset or is this possible? We are getting a data type mismatch error and are unsure why? This is the code we have thus far: Private Sub Product_Update() Dim dbs As DAO.Database Dim rstCD As DAO.Recordset Dim strsql As String 'Select...- bdavey
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
DISTINCT Question
We are trying to write a query that will give us just one instance of an order,however, the other fields associated with this order and not the same. Ex. We have multiple sales orders and each of these sales orders has a different engineering order. How do we show just one instance of the...- bdavey
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
