Search results

I have attached a pic of the tables. tblTrainList = is the master list of all training required. tbltrainReqPerson = list of persons (duty positions) that req. training tbltrainReq = is a junction table that list section, training req id, and person requiring training. tblTrainingNew = is a...

Not sure if its a dynamic query i need or not. I need to track training for personnel. Each person belongs to a different department and each department has different training requirements. I have the personnel table, a training list table that list classes required, a table that has personnel...

The row source command is in vba code on a popup form that gets hidden and not closed to later.

I would like to have a combo box that populates with data, here is the code i have that don't work: forms!frmdbxSortCriteria!cbxFindSort.rowsource = "qryAddcbxFindSort" now the qry has several colums that i will set in the propertys to show 2 colums and bound to colum 1. I have a IF THEN that...

Thanks! that was it.

does everyone see it or just me.. if you posted something i don't see your black dot right?

whats the black dot on the envelope mean

Hi, I have a popup form that ask do you want to print all departments or selected departments? the user enters the beg dept (10) and then the end dept. (30)then they click on the preview button. Which should open a report with the the beg dept Thru the end dept displayed But i get the...

The date is in a popup dialog box, i input the date and then click on a open form button. heres the code for the popup open form button: -------------------------- Private Sub Open_Form_Click() On Error GoTo Err_Open_Form_Click Dim stDocName As String Dim stCriteria As String Dim...

Thanks Rob! I have created the update query but when i put it in the afterupdate for the combo box (i have to use the combo box to make the first selection) i get a cant use find or update now error. is there a way to have the popup the opens the form to select the section?

where the form is based on a qry do i make that qry and update qry or make a new qry for the update part? also would i put in the stDrillDate criteria: =forms!frmAttenPay!DrillDate -- which is the unbound field with the date i want

I have a popup dialog box that ask for a date, once the date is entered a form opens up with the date just entered in an unbound box(DrillDate). The form is based on a tbl which has the name, section, and times that a person was present for work. The form is a contiuous form, and the size varies...

Figured it out, the form was refreshing all the time. The field that i was looking at was a combo box. I redid the subform and before i changed the field to a combo box, i tried it again and it worked several times, then changed it to a combo box and used the following code...

Thank you for all your help rob.

were it works 1 time and not 2 in a row is there a problem with the button that adds the new record? heres the code: DoCmd.GoToRecord , , acNewRec Me![BTNumber].SetFocus do i need to have the button requery or do something else when clicked again. (if i enter a new record then goto...

just tried the following code: DoCmd.OpenQuery "qryAppendtblParent" DoCmd.OpenQuery "qryAppendtblShipToAddresses" Me.Refresh Me![subfrmCustomerParent].Form.Requery and tab 2 has data and tab 3 is now showing data (because of the me.refresh) but if i go to add another record...

the main form rec souc is tblbillto tab 2- subfrmparent rec souc is a qry with fields from tblbillto and tblparent with the criteria of Forms!Frmcustomer![BTNumber] on the BTNumber and Parentno fields tab 3 -subfrmcustomershipto rec souc is a qry with fields from tblshipto the 3 tables are...

Thats good if i can make someones day a happy one. I am no expert in programing access as you can see, and some of the problem is me trying to communicate the info correctly. The way its setup would be hard to email to you, The tables are linked to the gui side, and some of the tables data is...

tab 3 subform is the ship to addresses, yes it needs to be requeryed also so i added another line and used the same command but changed the form name after the Me! but now only tab 3 is requeryed and tab 2 is blank again. Also i noticed if i add 2 new customers in a row using the Me![Parent...

tried Me![Parent Subform].Form.Requery and removed the me.refresh it works now for tab 2 but now tab 3 info does not show only