Search results

Hi Does anyone know how to set up Auto dialler in Access or know of a link where I can be pointed to. (I assume this will help me set it up with a modem dialler?) I know you can use the wizard to set in up, however when clicking the button it doesn't pick up the number form the number...

And I get a message saying "Invalid data value for parameter"

I have now sorted it out. I just need to know how to select certain fields from my Access form into excel?

Ok That's Fine and thanks for the code, however I have a button on a form called Sales form that comes from SalesTbl. On the form I have a button called export to excel, what code do I need to put in the click event?

Hi I have put this code into a Module. Therefore I would imagine in need to call the function from a private sub?

Hi Thanks for that, however stupid question - how do I call the module from a Private Sub cmdExportExcel_Click() Thanks for your help. :D

Hi Does anyone know VBA for a click button that extracts specific fields in an Access DB in to an Excel spread sheet. I've researched endlessly, appreciate any help. :D:D :banghead:

Hi I've tried and it still doesn't work, that said my combo box's are in the form header and not in the form, would this makes a difference? silly question I know.....

Hi As in like this ?

Hi I have this on the Form - On Current Event to show how many records I have on the Form, However when the employee filters the combo box's I want the record count to show the current records when they finish each filter. At the moment it just shows random numbers. Please help if you...

I know in Access that you can filter your work load criteria for each employee which is fine using Como boxes to filter down specific criteria for that employee, however I'm trying to achieve it with date filters between certain dates, and it works but ends up filtering the dates for every...

Hi That's OK which I have used before, however it just filters all dates for every employee as opposed to filtering that specific date range for that specific employee. What I was hoping to do is once that employee has filtered down what criteria they want to work with, they can then...

Hi How does that work with the code that I am currently using, and would that vba be used for 2 fields on the after_update event? Thanks :D

Hi guys I have a set of combo filters that filter one after the other as follows – 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 =...

I was only asking for a little help, you didn't have to reply! Again thanks for your help but it hasn't helped with my issue.

Ok cool, so how would I place ( #" & format(Yourdatefield,"MM/DD/YYYY") & "#" ) that in the above vba? (:

As in I need to filter User - Status - City - Sector and then Next Call Date, but I need to filter between dates for Next Call Date so that the user can select a certain date range, therefore I have 2 text boxes one is startdate & enddate, so I was hoping the above vba could be used to filter dates.

Sorry I meant this method changing city to startdate 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] = '" & _...

Just simply Me.CboEmployee seemed to not work as Me.cboEmployee did, funny old world Access.

Hi guys I have a set of combo filters that filter one after the other as follows - If Not IsNull(Me.NameFilterBox) Then If Me.Form.Filter="" Then Me.Form.Filter="Name ='" & Me.NameFilterBox & "'" Else Me.Form.Filter = Me.Form.Filter & " and Name = '" & Me.NameFilterBox &...