Search results

When the excel file opens, it automatically pops up with a "do you want to refresh" prompt. I would like the code to go ahead and say yes to that prompt when opening.

This is the code I am using. It opens the excel file just fine but the prompt to update still shows up and I need the code to update the file as well. Thanks in advance! Bryan Dim xl As Object Dim xlWrkBk As Object Dim xlSht As Object Set xl =...

Thanks for your help. I re-wrote the query and it works fine. Don't know what happened. I guess it was corrupt in some way. Thanks again for your help. You guys never let me down!

Yes I have a lot of -1's but what is the right function to turn that into a date. If DateValue isn't working, what should I use?

I have a text string that starts with a date. I am attempting to extract the date portion and then have the query see that text as a date in order to perform a calculation. This was working a week ago so I am not sure what happened. Left([SRS_Degrees],10) gives me 12/15/2001 Field 1...

I am importing values from an excel spreadsheet after running regression analysis. I bring the numbers over using the code below. However, the numbers come in and automatically round to the nearest whole number. I need them out to the second decimal point. I have tried using "general number"...

Awesome! Thanks!!!

OK I am working hard to give you guys a juicy one this morning! So this is what I have. I have a button on a form that runs a query and saves it in excel for me to then go out and run multiple regression analysis on the data that file generated by the query. The query is fully formatting the...

I have input box called KNOWLEDGE1 where I put in a value of 1 to 12. Then I have a another box with the following code: If KNOWLEDGE1 = 1 Then KF1 = "30" ElseIf KNOWLEDGE1 = 2 Then KF1 = "53" ElseIf KNOWLEDGE1 = 3 Then KF1 = "75" ElseIf KNOWLEDGE1 = 4 Then KF1 = "98" ElseIf KNOWLEDGE1 = 5...

I have a form with a number of input fields. Once the data is input, other fields calculate based on the value of the input. Every time I close the form and re-open, I have to click in the calculating field in order for the values to come back. I know I should be using a different event type...

Thanks to you all! Got it!

Can someone tell me what I am doing wrong? POSITION_RR_AMOUNT has to be between 2 values as well as POSITION_RR_LEVEL has to =A in order for RRCALC to = the number listed. I am only getting "0" no matter the value of POSITION_RR_AMOUNT. Thanks in advance!! Private Sub RRCALC_Click() If...

The email is sending fine but no attachment. Can anyone help? Private Sub Command219_Click() Dim objAttachment As Object Dim objMailDb As Object Dim objMailDocument As Object Dim objEmbedObject As Object Dim objNotesSession As Object Dim strMailDbName As String On Error Resume Next Set...

Only 1 - I did find a work around to get me through this design but I would love to know what to do when I get this in the future. I really appreciate your time!

OK but it will still not allow me to place things where I want them. They snap back to wherever the program wants to put it although the snap to grid is off.

What if the "Remove Layout" is greyed out?

This is what I have. I have a list of all previous employers for a job applicant. I can enter up to 10 but I only want the boxes to show if there is a previous position for that box. So, if there are 3 previous positions, I want to see 3 lines. If there are 10, I want to see 10. I have...