Search results

Hi, I've had this "vision" for a while. I want to create a query through VB by using the user-defined fields. In a form, I'll have several combo boxes with the available field names, the user will select several names from as many boxes as he wants and then at the click of a button create the...

Thanks guys, both look good and I'll implement the code as soon as I have the time. Thanks again. George

Hello all, With code, I want to search several tables for a specific field name. If the field name doesn't exist in a table move on to the next. Is this possible? If so, what would the code look like? Thanks, George

WayneRyan, can you please repost that link. There seems to be something wrong with it. Thanks, George

Hello All, I have some questions regarding automation with Access 97. First of all, thanks to http://www.candace.tripp.net/ I have a sample database which automatically creates tables and forms. Now, my question is about code. Is it possible to add code to an already existing form automatically...

I forgot, I have set all warnings off but this one still manages to pop up.

Now, is it posible to make the message just not show up and be taken as a "yes"? Thanks, George

Now, IMO, that's more like it... ;) Thanks a lot, that works wonderfully. Regards, George

Thanks IMO, the field used to check for dups allows me to be 100% sure that these are dup records. Now, since we import heavily, we get several tables like "Import_err1", "Import_err2", etc. How do I make the code delete all these tables? Or will it just look at the "Import_err" part of the name...

Hello all, We import heavily into our database, basically it's just the same type of data over and over. The database has a protection where it won't let duplicate records into the tables. This process creates several "error" tables which contain the duplicated records. I would like to delete...

Yes, same one...Sorry but I thought to keep Access and Excel separate (some times it's the best thing to do to prevent headaches ;) )

Hi all, I have a database that exports some data to an Excel workbook which is generated from a template that contains some formulas. My problem is that when the data is exported the formulas don't recalculate the values entered until the data is entered manually which defeats the purpose of...

My two cents... This is a fraction of the the code that I use which was taken from various sources in this forum. Hope it helps. ************************************************ 'Open and populate Excel File 'File name strFilePathName = Me.txtPath & Me.txtProject & " - COA" strFileToOpen =...

Thanks man, that worked! :D

I have these statements which load the appropriate subform depending on the entry selected in a combo box. The problem is that the function finds both strings to be the same and loads the wrong subform for the second statement. How can I make the function "see" the difference b't both...

Can anyone tell why is this code asking me to enter parameter values twice? Isn't supposed to get the values from the combo boxes? (this code is in the after_update event in the last of 3 combo boxes that filter the records). *********************************************** Dim strSQLSF As...

Thanks Mile-O-Phile, Now, why do I need to link these fields? See, I am working on a form where different combo boxes filter down the records but the last combo box won't work. I dowloaded the form and code from Candace Tripp's MS Access Downloads, what I noticed is that his/hers application...

Can anyone tell me what these lines do: Me.subfrmQuery.LinkChildFields = "Complaint_Information;Customer;Location" Me.subfrmQuery.LinkMasterFields = "Complaint_Information;Customer;Location" or do you need the whole code? Thanks, George

I have tried the format route left and right but I still don't get the desired output, in this case 1899. What I've been getting is this number 5.34911917837529E-05 which complicates things even more. Thanks for your help guys, George

Rich, I have no problem regarding existing records, all I want is a blank field when the form is open in view only, and the actual date when the form is open in data entry. That's why I wanted to do it through code. Now, regarding Pat's contention, I haven't given it a format. There isn't an...