Using Access for daily data entry

[Justchris]

Hi, I'm new to databases, I'm new to access, apparently very new...

I want to use access to input numbers on a daily basis, in a whole I need everything related to the date. I want the user to input a date, or access to figure what day it is then, minus a day for them, then I want that to be the ground works for everything else.

After the user inputs the numbers I need that information brought over to excel, I only want that days info to be brought over... then from there i can use vba to to put it where it goes.


Any help would be awesome
Thanks
Crhis

 

[M8KWR]

So i take it one table should be enough.

Its quite easy to use default value in access, and your would be date(), for todays date, and if you wanted yesterdays date then it would be date()-1.

When you say "minus a day for them", a bit unsure why you would want to do this, but i'm sure you have your reason.

But if a user enters information on a Monday, and you code it to minus a day then it would have Sundays date. But would you want it to have the previous Fridays date, it you do it still farely easy to do (i have the code somewhere).

You can create a button to export a selection of this table to excel, with a filename of your choice if you wish.

When you have exported it to excel, what exactly are you doing with the information from there. The reason for this questions, you never know access may be able to bypass excel altogether, and it would save you a process.

I hope all of this makes sense, if you require any additional help please say.

 

[Justchris]

We'll, I'm making this for a night audit procedure. I Need it for yesterdays date because the info isnt printed untill after 12. I've been working on this project for 6 months so the excel file is pretty advanced. Every day, i print out reports, then I use those reports to input data into excel, excel then takes those numbers and figures taxes, sum's totals and does other calculations.

Now though, I have to change everything im doing because I have to keep updated records, yesterdays stuff + todays stuff + tomorrows stuff and so on... hence me moving to access. So, Im going to use access forms to input the numbers, then transfer em to excel use some vba to transfer to the correct cells (because it has to be printed a certain way excel needs to be used) then print and update access with the new calculated numbers

 

[WayneRyan]

JustChris,

This might help you with the export to specific cells:

http://www.access-programmers.co.uk/forums/showthread.php?t=75986&highlight=excel+wayne

Wayne

 

[Crilen007]

"because it has to be printed a certain way excel needs to be used"


??

Sounds like a lot of extra work, you sure access can't do it?

 

[Justchris]

Honestly, no... Im not really sure, im pretty new to access. I have a nice excel file already set up though. Can I make my report look excatly like an excel sheet with collum widths, borders and cell colors?

 

[Crilen007]

Yea you can.

 

[Justchris]

Awesome, that'll save me some time for sure. How do I go about doing that?

 

[Crilen007]

There is a report wizard you can use, or you can do them manually.

Should be able to find a report tutorial on the web somewhere.