Search results

I have this formula in one of my field's control scource. =IIf([Reports]![RptMaster]![ChkBxs]="1",[dateFiledGriev],[dateDiaryAll]) But this isn't working... I am recieveing #Error. Any assistance is greatly appreciated!! Thanks in advance :D.

I need assitance with my IIF statement. IIf([Reports]![RptMaster]![ChkBxs]="1",True,IIf([Reports]![RptMaster]![ChkBxs]="2",False,IIf([Reports]![RptMaster]![ChkBxs]="3",,))) I have a column in my table that stores values from a check box in my form. I have a form that has a option group in...

I have 3 tables (tblMain,tblEmpsBal,tblEmpsCurBal). Table tblMain is the main data table. Table tblEmpsBal contains individuals names/balance. Table tblEmpsCurBal contains the individuals updated balances. Currently I am updating tblEmpsCurBal by manually udding the entries in tblMain...

I have 2 tables that contains 2 fields each (ID, and StartNumber) and (ID, SubtractNum). I have tried creating a qry to clone the StartNumber field then the subtratnum is subtracted from the StartNumber an entry is made that links with the correct ID; next, the qry updates the calculated balance...

Is there a way to create certain math equations from Excel into Acces VBA??? If so, is there any links with examples... Any assitance with this is greatly appreciate. :D

I have a subform inside a form that is linked to a single table. Everytime I enter a record, the subform isn't showing the recorded entered unless I navigate back to the record entered; even then it only shows one record. I would like the subform to show the records that has been entered. Can...

I am trying to utilize an If, Else statement in my on Current event in the form. I am attempting to accomplish a serious of checks so when a record is selected, the stored record will display the selected check boxes properly and the none selected checkboxes are disabled. Any assistance is...

I am using Access 2000, on Windows XP SP4. Microsoft Date and Time Picker Control 6.0 (SP4). I used the ActiveX properties and turned the checkbox on. Below is the Private Sub I am trying to modify. I realized that I had to keep the checkbox option checked to get rid of the msg. I would like to...

My form finds the record, but when I click the button to load the information into another form, the info does not transfer from the search. Can any help? Here is my code: Private Sub Command8_Click() On Error GoTo handler Dim strID As String strID = InputBox("Enter ID...

I have a form with 26 questions. Next to each question I have a drop down menu that has: YES, NO, N/A My form pulls the ID from the main form, also the date does the same. My problem is kind of complicated. I tried to create a Append qry for each drop down and a master qry to run all of them...

Through out this last year I have learned a great deal about VBA, but I am still a novice.:confused: Does anyone have a handy vba module that has the controls to create a graph from VBA?? I would be extremely greatful if you could share with me. Thanks in advance for your time in helping me. :D

I am some what fimiliar with VBA. I adapted a code from Mr. Allen Browne's Search form. but When do a search from 10/01/2009 - 02/28/09, the form doesn't work. I checked all my quieries and they work fine. I was wondering if someone could take a look at this code and maybe offer some advise in...