Search results

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

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

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

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

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