Search results

I have a page that is filtered by applying a SQL statement to the RecordSource of the page. I want to query that recordsource again with a different variable (essentially using two variables to limit the search). I was thinking the following: If varSearch2 = "prod" Then...

Hi all. The best way to explain this is to show an example: Me.RecordSource = "SELECT tblMain.ProductCode, tblMain.Name, tblMain.[NLGI Grade], tblMain.Color FROM tblMain WHERE (((tblMain.ProductCode)=" & varSearchData1 & "));" The key to this is the "varSearchData1" variable. I have...

Hi there. I have a field called Qty on a report that contains some numeric value. I want to sum that value on the footer of the report. I have put a text box in the footer and for the Control Source I put "=Sum([Qty])" (without the quotes). When I try to run the report it keeps prompting me...

I think this is an easy one, but I'm just not familiar with the code. I need to make a recordset using an SQL statement. Just that easy. Any takers? Thanks, Pete

I need a specific field to have the BackColor changed depending on the value that that field has. Example: If txtbox1 = 3 Then txtbox1.Backcolor = Red If txtbox1 = 2 Then txtbox1.Backcolor = Yellow Thanks!!

What I'm looking for is to import a .csv file into a table excluding varioous rows that don't meet my criteria. Example: -Row's 1-5 have text which I do not want to import -Rows 6-30 have three columns of data to import -Rows 30-35 have text which I do not want to import. The rows are not...

Great stuff. Anyone who uses Access for anything will find this code invaluable. Kudos!

Is there a way to utilize the TransferDatabase command as an Append instead of an overwrite? Thanks

Is it possible to rename files within in a directory with sequential filenames form within Access? Example: rename all files in a directory to- file1.csv file2.csv file3.csv etc... Thanks,