search form

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I have a single table data base 55 columns by one row per day worked

I have a tab form to populate my data day by day

If I miss a day because I am out of the city which has happened for up
to 21 working days its a mess to fill in from my shoe box file

what I want is a text box in a control tab to input the next date or
search date

date is a text box because I prefer my own format

I can tie this to a date field of the table but when I change to another
tab the values visible in that tab before I enter search date move to
the new date row. I have had my data base so corrupted much will have to
redo the data for the past 8 months

how to do refresh each tab after each search?
the date field is the only common field in each tab

thanks
 
date is a text box because I prefer my own format
Access can format a DateTime datatype to any format you want, it is best to
use a datetime field instead of text field.
This tells me you are running a spreadsheet and not using Access as a
relational database. You really do need to change you table structure.

You could use a union query to move your data to the new structure.
 
KARL said:
Access can format a DateTime datatype to any format you want, it is best to
use a datetime field instead of text field.

This tells me you are running a spreadsheet and not using Access as a
relational database. You really do need to change you table structure.

You could use a union query to move your data to the new structure.
Click to expand...
how do you stop date from adding year
 
It is not ADDING year but DISPLAYING year.
Format([YourDateTimeField], "d mmmm") will give you 5 January.

Format([YourDateTimeField], "d mmm") will give you 5 JAN.

Format([YourDateTimeField], "d mm") will give you 5 01.

Format([YourDateTimeField], "mm/dd") will give you 01/05.
 
Back
Top