Date problems

[joce]

Hi,

I am trying to produce a database which will be used for auditing.

I have a main form and several forms within a tab control on the main form.

On the main form I am able to select which customer it is I am dealing with, and everything which is then filled in in the forms in the tab control, is entered as that customer infomation.

The problem is, I would also like to have the date of entry also in the main form, positioned beside the Customer ID selection box.

I dont know how to do this correctly though. Where the field for date should be positioned in my tables which I have, or if it should be involved in any relationships.

Im a newbie so any help would be greatly appreciated!

Joce

 

[YNWA]

Hi,

I am trying to produce a database which will be used for auditing.

I have a main form and several forms within a tab control on the main form.

On the main form I am able to select which customer it is I am dealing with, and everything which is then filled in in the forms in the tab control, is entered as that customer infomation.

The problem is, I would also like to have the date of entry also in the main form, positioned beside the Customer ID selection box.

I dont know how to do this correctly though. Where the field for date should be positioned in my tables which I have, or if it should be involved in any relationships.

Im a newbie so any help would be greatly appreciated!

Joce

I think you just need to put a field in your table called EntryDate or similar, then set the data type to Date/Time.

Then on form, create a text field and set the control source to thefield in your table (EntryDate ).

If you have used the table as your forms record source the field should be there. If you have selected fields and formed an SQL string in the record source, you may need to manual go in and add the EntryDate field to the query builder.

The EntryDate field doesn't need to be in any order within the table but if you want to put it somewhere else in table, add the field to the bottom of table and drag and drop were you like.

EntryDate field I think won't need to be linked to anything within the relationships.

You could set it to madatory, meaning you HAVE to fill that field in, this reducing the risk of you forgetting to fill it in and next time you see it you can't remember the correct date.

Hope this helps.

 

[joce]

Hi thanks for trying to help me out, but with referance to:

"If you have used the table as your forms record source the field should be there. If you have selected fields and formed an SQL string in the record source, you may need to manual go in and add the EntryDate field to the query builder."

How do I make a table a forms record source??

Also, I told you I already have my Cyustomer ID selection area in the main form. But I dont know that I have done this correctly. My customer ID, is made up of 2 fields from the customers table (1 field saying the customers full name and the second field is the first part of their address). So, I made this relationship with all my tables, and made an extra table, called my linker table which has the same relationship, so it is just a table showing the customer ID, WHICH i then use this field for the Customer ID entry in the main form. To me, I have a feeling this deffinatly isnt the way you are ment to do this, but I couldnt make it work any other way, as I have combined information from two fields int he customers tabel to produce a Customers ID. (If you wondered why I combined the full name and first part of the address together was so that I wouldnt have future problems with people who have the same names).

Dont know if what I have said to you will make sense or not.

Joce