Search results

Curious to know if anyone had some suggestions on how to create a form that would import an excel spreadsheet (that was in the same format of columns as the main table in the database) and append/attach it to the existing main table. i have attached an abbreviated version of my database for...

incredible... i really cant thank you enough for all of your help. i took yoru thoughts and built form that allows you to query with multiple parameters.. nothing too fancy. and the way that i have it structured right now i get an error that tells me that the SQL query is structured...

couldnt i write in code portion #1 to replace portion #2 that is currently there so that when the user clicked the form button the query data would be exported to excel? #1 DoCmd.TransferSpreadsheet acExport, "Microsoft Excel", "Commodity", "c:/query_data.xls", True Application.FollowHyperlink...

wow, cant thank you enough... and just one other question, how easy would it be to change the component pulldown menu to a text entry where the user is able to enter in a portion of the component name and it will look up based on the text they enter... thanks again so much

i have attached an abbreviated version of my database that i am looking to edit in case that helps at all...

thanks jon.. i looked at the code and such from your example and given my newbie status am having a slight bit of trouble understanding the various elements of the code and getting it implemented in to my database. perhaps if you could just explain the various stages of the code and how they...

I have a parameter query built and am curious if anyone knows of a good way to allow the user to define which fields are displayed in the query results. i tried looking for other threads discussing this without any luck.. not sure if it was my search terms or what. thanks so much for any help..

Im totally new at all this stuff, so any help is appreciated. i have a database with one table that has many different attributes and almost 3000 records. this is all i have done, i have simply been loading in all of the data to the table, now that that is done i need to allow users to...

I have a single table created in access with different supplier information (supplier name, address, item supplied, etc) -- about 1500 records. i need to create a form of some sort that will allow users to extract data on either the specifc supplier name (from a pulldown menu) and the items...

really appreciating the feedback-- thank you. so lets back up a few steps and let me describe what needs to be done... basically a supplier database needs to be created charting all of the past performance with regard to projects that were executed which included specific items that were...

other suggestions first off, thanks for the response. second, do you have a suggestion for an efficient way of being able to extract the data in a "user friendly" type of way after hte database has been populated? thanks again

i am creating a database that will house some supplier information. once designed, the db will be populated with all the data and then it will be used as a reference tool for future projects. it was requested that an "excel front end" be used for lookup and ease of use to access the data...