Search results

What is the 'OpenArgs' option about?????, I will give the above a try first though.

Not really the client would be most un happy. I think what it is, is that when you open a form from a form then the relationship works. I don't think it likes the idea of opening a form to open another form to open a form. I'm trying to think of VBA that would when you click on a...

Hi Sorry how do you mean?

I'm pretty sure its something to do with the Bank Details password form??

I've tried everything. All I want to do is have click a button called bank details on the admin form and then a small form will appear asking for a password, then click the arrow button which then brings up the student bank details. The admin form is related to TblAdmin and so is the bank...

Hi Guys I have a form with a set of combo filters which filter one after the other. now I need a date filter button. I have the following code which works fine, however when I filter the dates it will filter every employee's dates.... So an employee logs on filters their name, status...

The company I work for would not allow me to post the DB. Thanks anyway

Cheers, would really appreciate it if you could as I have tried numerous other ways. :D:D

Hi Can I use the below method to filter dates from and to, I have comboboxes that filter one after the other using the afterupdate even?? Private Sub cboCity_AfterUpdate() If Nz(Me.cboCity.Text) = "" Then Me.Form.Filter = "" Me.FilterOn = False ElseIf...

Well when you hit the enter button after entering the password, it will bring up 'FrmBankDetails' which is great, however moving through records and then checking someone else's bank details the from pops up but always with the 1st record details. The code is correct in effect, but its not...

This now works.. DoCmd.OpenForm "FrmBankDetails", , ,"StudentName ='" & Me.StudentName & "'" However it doesn't work with 'Text Password Login in VBA code' If I just create a normal command button and put the above line of code in it works just fine, example.. Private Sub...

On this line, DoCmd.OpenForm "FrmBankDetails", , , "StudentName = " & Me.StudentName Now I'm getting a syntax error (missing operation) in query expression

Hi Paul I just keep getting a runtime error 438 - object doesn't support of this property or method I can't think what I'm doing Regards

Hi Guys I have created a button called 'Bank Details' when clicked it opens a small form asking you to enter a 'password' Once this operation has been done and clicked the enter button I want FrmBankDetails to open to a specific record that relates to a record from FrmAdmin. The...

I use this currently if that's what you mean. Private Sub cboCity_AfterUpdate() If Nz(Me.cboCity.Text) = "" Then Me.Form.Filter = "" Me.FilterOn = False ElseIf Me.cboCity.ListIndex <> -1 Then Me.Form.Filter = Me.Form.Filter & " and [City] = '" & _...

Hi guys, I am trying to set a date filter that filters between two dates (Start/End) after I have selected filters from other combo boxes. This is what I Have so far and is a bit of a mess. I have two text boxes - txtStartDate and txtEndDate If Nz(Me.txtStartDate.Text) = "" Then...

Hi Fella, I have followed your advise code regarding Public filters and have set up a module as advised, however when I put the code in.. If Not IsNull(Me.NameFilterBox) Then If Me.Form.Filter="" Then Me.Form.Filter="Name ='" & Me.NameFilterBox & "'" Else Me.Form.Filter = Me.Form.Filter & "...

Hi Fella, I have followed your advise code regarding Public filters and have set up a module as advised, however when I put the code in.. If Not IsNull(Me.NameFilterBox) Then If Me.Form.Filter="" Then Me.Form.Filter="Name ='" & Me.NameFilterBox & "'" Else Me.Form.Filter =...

OK this is what it looks like so far. Public Sub ApplyFilters() If Not IsNull(Me.cboOPOwner) Then If Me.Form.Filter = "" Then Me.Form.Filter = "OPOwner ='" & Me.cboOPOwner & "'" Else Me.Form.Filter = Me.Form.Filter & " and OPOwner = '" & Me.cboOPOwner & "'" End If End If If Not...

OK, What I can do is this - In the VBA editor, click Insert, then module. This starts a new public module. (What I can't) do is this - """"Then with the module selected click Insert and Procedure, then a menu comes up from which pick public sub. Then that sub.""" What i did do is manually put a...