Search results

Hopefully I can explain my problem well enough for someone to help me out, if you need more info let me know. In my program, the user accesses a popup window where he can input revision reasons, and I have a bunch of reasons and he can put a 1 next to the correct reason. Now, I just added a...

Lol, I was actually thinking about adding a print button, that I could set to the printer I want, with the correct settings and everything. Does that sound better?

This might be a tricky question, but I thought maybe someone out there might know how to do this. So the way my program works is it creates an excel file with multiple tabs, and where each tab contains columns of data with a graph of that data next to it. Now what I would love to do would be...

Can anyone help me out with this??

Does anyone have any idea?

As the title says, I'd like to know what I need to change to make my excel document open maximized when I call it. Here's my code: Private Sub Project_Summary_Click() On Error GoTo Err_Project_Summary_Click Dim oXL As Object Dim sFullPath As String DoCmd.SetWarnings False...

That worked thank you, quick question for whomever, what would my condition be in an IF statement if I want to check for whether or not a certain column, called first_val, contains any values? iow, I don't want to go into the IF statement if the column does not contain any values. Thank you...

Didn't know I had to... I have no idea where I would place it though, this is the beginning of the Report Form code: Option Compare Database Private Sub Done_Button_Click() On Error GoTo Err_Done_Button_Click DoCmd.Close Exit_Done_Button_Click: Exit Sub Err_Done_Button_Click...

Nothing happens it's weird, My window pops up, I select one of 3 reports I have listed, the report pops up, and the selection window stays open. I just tried DoCmd.Close acForm, Me.OnClick since I want the window to close after the user clicks on a button, idk, but again, it's the same as if I...

Just said that doesn't work... Here's my entire code Private Sub Data_Form_Report_Request_Click() On Error GoTo Err_Data_Form_Report_Request_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Select Report Form" DoCmd.OpenForm stDocName, , ...

These aren't working for me, I am fairly new to coding (2 days), so bare with me! For the first option I tried it as is and got nothing, so I changed the form name to one of the 3 form names I have and still got nothing. For the second option, am I supposed to replace the 'me'? I also tried it...

I have a form that opens and prompts user to select a report type, upon clicking on the desired button, it opens the report in a new window. What I want is for the window to close after the user clicks on a report type, can anyone help me? Here is the code for the request window Dim stDocName...

I am creating an excel file using the following commands (with lots of code before it) DoCmd.TransferSpreadsheet acExport, , "First Pass Yield Chart Query", "W:\edsplus\applications\0cmad\cmad_chart_spreadsh eet.xls", True, "First_Pass_Yield_Data" DoCmd.TransferSpreadsheet acExport, , "Average...