Question Copy and paste a list of IDs -> Generate a spreadsheet with relative data

[RogueJD]

Hey all.

Sorry if this is a newbie request, but this is the first time I have created a database for a warehouse from scratch.

I have my data tables set up so that each "Customer" has an ID, and each ID has a list of relative data - including the location of their property in the warehouse.

I have forms set up. Everything is working the way I'd like (For the most part...) but I need a form, report, or whatever that will allow me to copy / paste a list of IDs into a search field that will generate a spreadsheet of where that property is located in the warehouse.

Ideally, I'd like to automatically open up and populate an Excel Document, pasting the data on in some pre-defined fields; sort it by property location (A numerical Value); and be able to save the Excel sheet in a seperate folder.

Populating an Excel sheet sounds like it would be very difficult, but at the very least, I'd need it to generate something with ID numbers and their relative location so that I can manually take that data and copy / paste it to an Excel sheet.

Thanks all!

 

[Rabbie]

If you can write a query to show the data you want, it is very easy to export the output from the query to Excel using database Tools

 

[RogueJD]

Unfortunately, I'm very new to Access.

Would you mind posting a walkthrough to do so? I'm sorry if that's asking too much.

Of course, I don't expect you to write the query for me, but could you explain where I would go to start this off?

Is this going to involve a lot of VB coding? Will wizards be able to get me what I want? Do I need to generate seperate forms, tables, etc...

Thanks again.

 

[Rabbie]

Unfortunately, I'm very new to Access.

Would you mind posting a walkthrough to do so? I'm sorry if that's asking too much.

Of course, I don't expect you to write the query for me, but could you explain where I would go to start this off?

Is this going to involve a lot of VB coding? Will wizards be able to get me what I want? Do I need to generate seperate forms, tables, etc...

Thanks again.

Got to Queries and select New. I can't give you any more detailed advice since I dont know your DB and I dont know what you want.

Try to work out what you want to do on paper first because if you can't do it on paper you can't do it in Access