Cant Enter Date in Form

[ACarts]

Hello!! I am still new to access so I think this is me being careless. But I cant seem to enter a data on my Logindate, time in and timeout ,


View attachment Internet Cafe.zip

 

[plog]

You shouldn't base forms that you want to directly interact with data (add/edit/delete) on queries. Those forms should be based directly on the table you want to interact with.

With that said, you need to work on your relationships. Yours is a loop which is incorrect. There should only be one way to get from one table to another. For you, that means you need to eliminate a relationship.

If you could explain what each table holds, that would help us help you decide what the correct relationships should be. Amount is most likely the offender though--not even sure what it does.

 

[HiTechCoach]

FWIW: I base all my forms an a query.

They key is for data entry you only want ONE (1) table in the query.

I also never use multiple fields in the primary key. I only use an Auto number data type field as the primary key. I do make additional indexes based on multiple fields that are set to unique.

I updated your form to only use a single table.

Not sure what the design requirements are for thw project (or homework) but your design may have lots of issues.

 

[missinglinq]

FWIW: I base all my forms an a query.

It should be noted that this practice is not unique to HiTechCoach! Many experienced developers prefer to base Forms on single-table Queries, rather than directly Tables, as they feel it provides an extra layer of protection to the data.

Also, using Queries, one can create all Calculated Fields, for a Form, in a single spot, rather than scattering them throughout the Properties Pane.

For an explanation of why multi-tables Queries are Read-Only, have a look at Allen Browne's article

Why is my query read-only?

Linq ;0)>

 

[ACarts]

Thanks guys.....@HiTechCoach... Thanks I used the file and tinkered a little bit fit my teachers requirements and luckily she accepeted it... I'll look unto my file and see what went wrong... THANKS SO MUCH GUYS!!!!!

 

[HiTechCoach]

You're welcome.

Glad we could assist.