Search results

I'm sure there is a simple solution - but everything I have tried hasn't worked. I have a command button on my main form that opens up a popup form. On the popup form the user makes various selections and clicks on another command button(on the popup form). That button is linked to a macro -...

I have been trying this off and on for the past week and can't seem to get it . I have a table called tblFiscal which has a start date, end date and month name. I have another table that shows invoices with PostingWEDate field. I am trying to get the month name according to where the posting we...

I have a combo box in a form that lists out sales reps and several command buttons that are hidden. Depending on which sales rep is selected in the combo box I would like to display the command button that I have created for them. I'm sure it's easy - I just can't think of how to do it :confused:

I have a table for our sales reps that lists their name,initials,and 20 different accounts (they define which accounts). The problem is some of these codes have 5 letters and some have 8. If they have 5 letters that means that the next 3 could be anything example of table: Name=Jan Smith...

I am having difficulty with a parameter query. I am trying to get my form (frmExcelMTDConsolidate) to prompt for dates just like the query (qrySelectMTDConsolidateDivisions) does. Since the above query is based off another query I'm not sure how to pass the variables in the select statement...

The error is occurring on RsSQL_1 line GROUP is highlighted and the error is "Expected end of statement" I'm sure it's a simple thing - I just can't find it... Any suggestions? Private Sub Command7_Click() Dim DB As DAO.Database, Rs1 As DAO.Recordset, Rs2 As DAO.Recordset Dim i As Integer, j...

I am trying to automate transferring some data to excel. In frmExcelMTDAllDepts I would like to select the start date and end date - but I keep running in to Run-Time error 13. Any suggestions?

I have a option group setup with 2 checkboxes inside(yes, designate or No, do not designate) . What I want to do is if the user has checked yes designate, it requires 2 fields to be filled out(physician_name, city), if they select no, do not designate, I want it to go directly to my submit...

I am trying to export the result of my sql query to a ;delimited format. I already know how to do it manually (File-Export) - is there a way to automate it?