I am working on a schedule program and am having trouble getting the program to schedule all employees at once. I created a form based on a schedule set table which has the fields: ID, PostID, PositionID, TourID, EmpID. I also have a subfrom based on the legs table- fields: TourID, Sequence...
I have used the setwarnings in the following manner.
Dim stDocName As String
DoCmd.SetWarnings (False)
stDocName = "qry Emp update"
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.SetWarnings (True)
the query used is an append query
This code works fine in both the original .MDB...
I have used the Dim dbs as Database in my code in '95, '97 but I am not getting that option in '2000. I get Compile error: User-defined type not defined. The Help sections use database as a valid parameter. Why is it not working for me?
Code example:
Dim dbsmds as database, rst as recordset...
I have used the setwarnings in the following manner.
Dim stDocName As String
DoCmd.SetWarnings (False)
stDocName = "qry Emp update"
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.SetWarnings (True)
the query used is an append query
This code works fine in both the original .MDB...
I have 28+ toggle buttons that when 'clicked' will change color and update an unbound field by adding 1, (if its value is "-1") else it will revert to the original color and update the unbound field by subtracting 1. Is there a way I can write this code once in a public area and use...
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.