In the Customer Notes form for example, the bound column for the "By" field is EmployeeID (the name of the field is "By"). In the Customer Notes table, "by" is a straight up, plain old text field (at the moment). The combo-box row source in the form is:
SELECT Employees.EmployeeID...
Good morning - I have numerous combo boxes throughout my program forms that users can choose the Employee's Name for various reasons. The Employees Name information comes from the Employees table obviously. I also have criteria set: "terminationdate=null", so that only current employees can be...
I am so confused. I have a couple of list boxes where users choose an employee name. The criteria of the list box will not allow former employees to show up:
"SELECT Employees.EmployeeID, Employees.FirstName, Employees.LastName, [firstname] & " " & [lastname] AS Expr1...
Good morning. The following code creates certain sentences in a mail merge document depending on the choices made by the user. Clients get 3 options for a new bid: Whole Deck, Horizontal Only, or a price for both. I am also posting the paragraph I am having trouble with (it's in the Two Option...
I thought I knew how to do this, but apparently I've forgotten.
=(IIf([status2]="Failure","Failure",Null Or IIf([status2]="Success","Success",Null Or IIf([status2]="Illegal","Illegal",Null))))
What am I forgetting?
TIA!
topdesk
Hello All!
I use the following code in time cards when someone tries to change an existing time card:
Private Sub EmployeeID_Change()
On Error GoTo EmployeeID_Change_Err
Dim intAnswer As Integer
If Not IsNull(Me![EmployeeID]) And Not Me.NewRecord Then
intAnswer = MsgBox("You are about to...
I don't know why it didn't work. I've reworked the procedure though because I can't take anymore time trying to figure it out. Thank you PHV for you input!! ;-)
Good morning!
I have been racking my brain on this. I have a form that consists of a tab control, some tabs contain subforms based on other tables. I have a procedure that calculates totals and sets the value of the ID (key) field in a subform equal to the ID field in the main form. When...
Hello everyone,
I am performing some updates on a program I wrote - and need to send 6 new queries. The problem is when my user gets them, all of the relationships (joins) no longer exist. I assume this is because there are no tables in the little db I'm sending - but how do I prevent this...
Good morning!
In the Time Card form, users can choose an employee from a drop down box and enter theri time card details. I have the following code setup in case a user accidentally begins to overwrite an exiting record:
Private Sub EmployeeID_Change()
On Error GoTo EmployeeID_Change_Err
If...
Thank you Jim - you confirmed what I was thinking (I think : ) ) I'm doing mental gymnastics about how to go about this but hopefully it will click after some more coffee.
Have a great weekend!!
Gina
Good morning!
I have a table: EmployeePayRates - which consists of the EmployeeID; WorkCode; PayRate. The supplies a subform in the Employees form and supplies the information for time cards. It all works great UNTIL an employee gets a raise and their rate changes - then all previous time...
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.