Search results

Thanks for your reply! I had tried using echo on/off and was still have the issue. I finally found out what was happening when I stepped through each query on the macro - I had put in a select query (which obviously wasn't needed) and thats what was causing it to show up.

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 -...

thank you, thank you, thank you Jon K!!!!!!!! now it's margarita time ;)

thanks for the info - I realized after I sent the post that just formatting the dates will not work because of the way the fiscal months are setup - March's fiscal month is 2/28 - 4/3 - if I used the formatting that would return February, March, or April

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...

What happens when a new sales rep joins the company? Would you not have to create a new button on the form? Answer: Yes, I would but this is where it gets complicated. The reason I have separate buttons for each sales rep is the code behind the button runs 4 or 5 queries and then exports them...

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...

that's what I needed Thanks!

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...

thanks very much-worked like a charm!!!

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?

Thanks so much Kevin - I'm finally done with this project!!!! :D

error trapping before submit Help! The last thing I need to complete this.... When the user selects yes on the check box and hits tab it goes to the physician_name and all of the other fields needed(thanks to Kevin!). Apparently if they click yes on the check box and go and click on the...

Thanks for your quick response Kevin 1 question reg the onclick event. When I select the yes response I would like to make the physician_name a required entry (but only if they answered yes in the check box). Also, when I answer no to the check box and it greys the text box out, the labels also...

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...

Hi Jon - thanks for the response. I tried using the transfer text method - but it seems you can only use those on select queries - I am doing a (sql) union query. Any other thoughts or suggestions?

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?