Search results for query: *

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...

Nope, I made sure of that! :-D

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...

You are my hero Leslie! Thanks so much!! Have a great day!

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

Thank you Remou! That works perfectly! Have a great evening! 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!! ;-)

Thanks, but they're linked......

Just a quick addition to my question - when I close the main form and reopen it - the key fields are updated correctly.

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...

Thank you both for your answers!! I will keep the relationships in the back end. Have a great day! topdesk123

Good morning - Should relationships be stored in the front end or back end of the database? Thanks in advance. topdesk123

Close! This worked: If Not IsNull(Me![EmployeeID]) And Not Me.NewRecord Then Thanks so much!! : )

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...