Search results

Hello Guys, I have create the following file Path which looks for a document in the form LastnameFirstname.pdf strFolderPath = CurrentProject.Path strFilePath = strFolderPath & "\States\" & Me.cboState.Column(0) & "\" & Me.cboName.Column(2) & Me.cboName.Column(3) & ".pdf" However, I...

OK! Thank you.

Thank you Guys, all of your inputs help. I was off base of most. Here is the working statement strSQL = "SELECT [SupplyCateg], [Brand],[ItemNo],[Color], [Size], [LastOrdered] FROM QryEmailReminderList WHERE [LastOrdered] >= DATE() - 30 " BUT I have a question. What SQL language does Access uses...

Hello Guys, Why am I getting error 3061 with this code? I checked all fields name to ensure they match my query and they do. What is the problem? Dim strSQL As String strSQL = "SELECT [SupplyCateg], [Brand],[ItemNo],[Color], [Size], [LastOrdered] FROM QryEmailReminderList WHERE...

Thank you Guys. declaring my variable as variant and pre-checking worked.

Hello Guys, Why am I getting an error with this code? Some of the records do not have an image file path. How can I handle this? Dim strImageSQL As String Dim strImage As String strImageSQL = "SELECT [Image] FROM QrySuppliesDetails WHERE SupplyDetailID=" & Me.lstDetails.Column(0) &...

Thank you for the response, I will research this

Hello Guys, I was wondering if there was a way to auto-populate fields in a form from a webpage? For example, let's say I have a vendor webpage and want to grab certain information on an invoice to save in my database. Or maybe save it as a pdf and get the information that way? Is there any such...

Thank you so much guys.

Thank you. My concatenation was indeed off. It works.

I've placed the WHERE clause in it but something is still wrong. It is saying missing parameters for my strComments, strd, and strInput variables. I honestly don't know what I am doing wrong here Here is what I have now Private Sub cmdUpdateComments_Click() Dim strInput As String Dim...

Yes, that's what I thought. but what would I surround the variables with? I thought it was double quotes because shouldn't the query be: sqlUpdate = "UPDATE TblStateCorpLic SET [Comments]= '(String)'"

I do not. d is a Date variable so I thought I have to surround it by #

It says: compile error: Syntax error It is not printing the Debug.print. I also tried to remove the Else block and place it under an "If NOT IsNull(variable) Then" but still the same error

Hello Guys, My code block is meant to add comments to the current comments. Any idea why the "else" block would be red (Syntax error)? Private Sub cmdUpdateComments_Click() Dim strInput As String Dim strComments As String Dim sqlUpdate As String Dim d As Date...

WOW. Thank you for letting me know. I was in fact trying to save lines but this is good to know what thank you very much for the One liner. It actually saves me a whole lot of line

Ok one more question will this same code work under a Sub?

Yes Employee is a text I changed the concatenation in my function. But when I go to use the function, Is this the correct format to get column(0)? strControl = Me.cboFName.Column(0)

Which one of the String? The strControl is supposed to be the listbox

Hello Guys, I have a Function which is supposed to return a Select statement Here is the function Public Function sqlTaskFName(strControl As String) Dim sqlTask As String sqlTask = "SELECT FName,[State],RegistrationNo,DateExpires,Select1,OfficeID FROM QryPE WHERE [Employee]=strControl...