| OneSize |
I need your help!!
I have an access database with lots of fields and have set them all up on a form. First question is how do i get it so that i press a button and you can search the table (ie search for surname).
Second thing is, i also have a excel spreadsheet. I wanna do it so that when the access table is complete (each record takes 13 weeks to complete), i can press a button on access and it automatically inputs the data into specific excel cells and prints off the excel page.
I am pretty much novice so any deep explanation will be massively appreciated. |
|
|
| OneSize |
| Surely someone must have a suggestion? |
|
|
| Neil the Eagle |
The first one you should be able to solve by placing your cursor in the field in the form that you wish to search through and then pressing Crtl+F, this will bring up a Find box and you have various options within that.
The second one is beyond my ken, sorry fella, but I don't think you will get it to do it via 'one-button' solution. |
|
|
| Niceaction |
| Neil is right. The second option will involve some VBA macro code to be able to take the fields and put them into specific excel cells. It's not really the sort of thing someone can code for you without the access datatbase in front of them and full details of where in Excel you want the fields to go. |
|
|
| cantspell |
there is a query function on access, you have to establish criteria etc, use the help function to assist. Use help and type data query
There is an export facilty. Use help and export |
|
|
| Jer |
| Second one can be done with VBA (the Visual Basic behind MS Office), though I was only ever as good as the programmer sitting across the way |
|
|
| jempie |
If you go to Tools, I think there's an option to "Analyse with Excel" or something like that. It will output into Excel, albeit not in particular cells.
Then just three buttons away from printing....CTRL + P and then ENTER when the prompt comes up!!! :lux: :clown: |
|
|
| OneSize |
Ok i sorted this kinda. i have done it so that when i click a button i export a query (that only holds the record in the form) to excel. the only trouble is that this creates the excel file, but when i go to export a 2nd query, it wont update the existing file.
any suggestions? |
|
|
| OldPeanutSeller |
quote:
Originally posted by OneSize
Ok i sorted this kinda. i have done it so that when i click a button i export a query (that only holds the record in the form) to excel. the only trouble is that this creates the excel file, but when i go to export a 2nd query, it wont update the existing file.
any suggestions?
I'm only a self tuaght layman with Access, but i believe when exporting to Excel you can create a new file, or overwrite an old one. SFAIK, you can't update an exisiting file direct from access.
(I suppose if you're REALLY clever, you can import the old Excel file to Access, update it in Access, and then export the new file to Excel). |
|
|
| OneSize |
| I had it working at home where everything worked, and it updated the existing file. i bring the files to work and now nothing. |
|
|
|