Search results for query: *

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

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

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

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

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

Good morning, I use the following function for calculating regular time and over time in time cards: RunTot: (DSum("acttime","time card hours","[TimeCardDetailID]<=" & [TimeCardDetailID] & "And [timecardid] = " & [timecardid] & "")) "ACTTIME" is actually time elapsed. My problem is, when...

Hello everyone and Happy Friday!! I have a main form, Time Cards, and a subform, Time Card Hours (multi-row). The linked fields are TimeCardID and EmployeeID. Everytime I close the form though, the EmployeeID link disappears! Only the TimeCardID link is still there. Has anyone experienced...

Hello everyone, Can someone help me with the following code - I use it to check for duplicate phone numbers upon data entry - it works great EXCEPT for the Undo function, which I can't figure out how to get to work correctly. After the phone number is entered, if it's a duplicate, a message...

Hi! I posted this on the office forum too - but I think it's going to take more coding - which Access could be a part of. Possibly some kind of loop statement? I have a form template that will be merged with data from an Excel spreadsheet. I need to save each form with a separate specific...

Hi! I have a form template that will be merged with data from an Excel spreadsheet. I need to save each form with a separate specific name based on the data (ie. [Agency Name]_Agency Administrator_Add Removal_Form.doc). The form also has form controls that become inactive when I merge. Can...

Hello! I am using conditional formatting in a continuous form to highlight items that have been scheduled. There are 2 processes - cleaning and sealing, each is scheduled separately (sealing happens after cleaning). I have a field titled Scheduled - which updates to yes or no via update...

Hello all! This is a sample of the code I'm using to produce a sentence that includes the items that customer's order. The first line will change depending on the order as well. I just need to know how to keep it from inserting a comma before the first item. My thanks to Cajun Centurion for...

I use the following code to open and merge customer letters. Dim objWord As Word.Document Set objWord = GetObject("C:\client\customer bid letter.doc", "Word.Document") ' Make Word visible. objWord.Application.Visible = True ' Set the mail merge data source...

Good morning! I have a main form with two sub-forms, Subform1 updates the information in Subform2 and the Main Form using the requery event after the record is updated. Unfortunately, after each requery the cursor goes to the first field in the Main Form. I need it to stay in Subform1 because...