Search results

Thanks vandewi, I'll give it a try.

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

Alrighty Then Thanks OpenGrave. It was the single quotes that did it. Appreciate the help!! Shine On, Grandy

Continued Thanks for the help Opengrave. varSearchData1 is defined as a Global Variable. Actually, when I run the sql (with the code I have presented), it prompts me for a parameter, however in the message box prompt, it gives the value of varSearchData1, instead of the variable name. What I...

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

Thanks Pat. I got it working. Thanks for the help.

The report footer. I need to sum the whole report. I put it in the page footer, but that gives me a value of #error.

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!

I use Access on a network drive, and it does not work when I specify the server name. It does work when I specify the letter assigned to that drive. Hope it works for you.

The code imports all the files, but it is in an infinate loop. I haven't been able to break it. Any thoughs?? Thanks

Thanks Mike. You have been extremely helpful. I appreciate your input.

There will be multiple numbers of files when the exporting takes place. It is not a set number, it could be anywhere from 30-60 files. What I need to do is import them into an Access db without having to specify a filename (wildcard), however I have not found a way for the wildcard to work...

Thanks Mike. I kinda figured it would have to happen that way. I was trying to avaoid any sharing of databases between multiple useres. I have had problems with that in the past.

Thanks for the reply. Actually I have several users exporting their data simultaneously into one central database. The trouble is that each person overwrites what the previous person exported. I was wondering if you can append additional records as opposed to overwritting the data over and...

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,