Recent content by IHeartA2K

This is the best access forum out there. I thought after busting my brain trying to figure this out, maybe somebody here could provide some input. I have a form that consists of 4 subforms. I am able to output 1 of the forms using "DoCmd.OutputTo acForm, "formname", acFormatXLS". My problem is...

Peter, That works great. I can tweak the code from here. I appreciate your help!

I am a little confused. The OutputTo opens up the "Output To" dialog box. Right now, if they type in any other name than "FormG037GMth.xls" the .Workbooks.Open CurrentProject.Path & "\FormG037GMth.xls" line of code will not reference the new filename they typed, and they will get an error.

Thanks for the help guys and sorry I wasn't more clear (long day). I have a good grasp on how to edit excel from access. What I would like to have happen is when a user clicks on the excel form button he/she is able to name the workbook whatever they want. My problem is that in my code I have...

I am a total VBA noobie and have been forced to learn it this week. I love the challenge, but am at a point where my brain is fried and I am totally stumped. I have my form that outputs to excel. The spreadsheet is then formatted within access using some excel automation stuff. The logic I am...

All, I am a total access newbie and have a quick question. I found the following reply to a post and was hoping someone could elaborate on this a little more for me. "Since I am not all that comfortable with the Excel object model, I would start with an Excel sheet that contains the data only...

Thanks for the help guys. This forum has been the best Access resource that I have come across.

Here is the code for the combo box: Private Sub cboDiv_AfterUpdate() Me!cbodate = Null Me!cbodate.Requery DoCmd.RunCommand acCmdRefresh End Sub Private Sub cboDiv_Change() Me.cboDiv.Dropdown End Sub

That is the thing. I am not too sure why it requeries every time I hit the drop down box. It seems like there should be on query run to populate the combo box the first time I click on it and that should be it. What will the "requery" do that you are speaking of?

So, I am a total newbie with a question that probably has an easy solution. I have a combo box on a form that is populated from a query. The issue is everytime I click on the combo box, it runs the query to populate it. This wouldn't be so bad if it wasn't querying like 500 employee numbers...