Search results

I have a unbound combobox that takes all dates fronm a table equal to or greater then today and lists them, choosing a date populates a subform on my form. In the after update event of the combo I have: Private Sub cboDateEntry_AfterUpdate() On Error GoTo cboDateEntry_AfterUpdate_Err...

I have this running in the before update event of a field on a subform Private Sub idEmpTbl_BeforeUpdate(Cancel As Integer) Dim strMsg As String Dim iResponse As Integer ' specify the message to display strMsg = "Do you wish to save the changes?" & Chr(10) strMsg = strMsg & "Click Yes to...

I have a form/subform based on a query. To search records and add new items from a combobox I placed an unbound combobox there then used the notinlist event to add new items, works fine. But once the new item is added it doesnt refresh the form/subform. So I was going to requery the form in...

Regarding 3 tables, A, B and C. If A is linked to B, and C is linked to B, does it mean A is linked to C and vice versa?

Could someone look at the jpeg below, is this what I am NOT supposed to do? I admit I am still confused between lookup tables and lookup fields. The dropdown row on that table gets its values from another table whose sole purpose is to feed that field information, the lookup table has a linked...

How can I make the value of form text box (txtUser) be evaluated as a integer? My problem is that idEmpTbl is my PK column in tblEmployee, so it must remain a number type. When txtUser is evaluated there is a type mismatch. I have tried declaring txtUser as a integer and that didn't work. It...

Overtime sign up database. So one DATE can have multiple blocks of overtime available (05-0700, 07-0900 etc) and each HOUR BLOCK can have multiple employees compete to work it. Who wins the overtime block on any particular day depends on their previous hours worked in the case of a tie...

I have a built some code behind a button on my form: Private Sub Command11_Click() Dim Ctrl As Control Set Ctrl = Screen.PreviousControl If Ctrl.Name = "singuptable Subform" Then Ctrl.SetFocus DoCmd.RunCommand acCmdDeleteRecord End If End Sub I capture the login ID of who logs into...

I have two subtables, tblHoursAvail and tblSignup. The HoursAvail table has a column called HoursAvail1 which is populated by a combox box based on a lookup table. Switching to my form now I can easily put a unbound text box in the subform based on tblHoursAvail and put its control source as...

See the screen shot, when the wizard builds this form the two linked subforms are stacked on top of each other and I can't figure out how to move them independently of each other. I can move both subforms to a blank form but then they dont synchronize with each other. Is there a way to make...

I have read this admonition against using lookups in tables but frankly it confuses me. I have a list of 2 hour blocks in their own table because I want to control what is specifically selected when someone wants to add these time blocks in. The table has two columns, the hourdescriptor and...

I am creating an overtinme sign up sheet. So I will have multiple dates each that has its own signup table. The signup table is a sub to the available overtime date. Problem is I can only show one day at a time, is there a way to show all the available days of overtime with a subform signup...

I am creating an overtime signup sheet database. The supervisor would enter the date of overtime and the time span (will use drop down box for the 2 hour increments). The employee's need to be able to look at the available overtime and signup for it if they want to work it. After a span of...