Anyone know why now in Access 2010 LngEmployeeID = 0 doesn't work? (1 Viewer)

[RainLover]

First of all you need a Main Form Sub Form situation and both of these should be bound to their respective Tables.

You have a hidden table, why? Unhide it.

Do you understand what a bound form is?

Read up on Naming Conventions. your Tables should be named tbl******
.

 

[YNWA]

First of all you need a Main Form Sub Form situation and both of these should be bound to their respective Tables.

You have a hidden table, why? Unhide it.

Do you understand what a bound form is?

Read up on Naming Conventions. your Tables should be named tbl******
.

Its an old DB, the naming conventions are un-important at this stage. The table was hidden to easily stop people using it, again unimportant at this stage.

Yes I do know what a bound form is. There were 2 other forms which I deleted as I thought they could interfere with what I was trying to fix.

1 form was a bound form to enter employee info and save it into the gp table.

 

[RainLover]

It is good to hear your confidence has grown and that you have a firm grasp on what is important and what is not.

Sounds as though you are well on the way to solving your problems.

Good luck with all that.

 

[YNWA]

It is good to hear your confidence has grown and that you have a firm grasp on what is important and what is not.

Sounds as though you are well on the way to solving your problems.

Good luck with all that.

is this sarcasm?

if they are important let me know as I didn't think they were?

 

[YNWA]

I have entered to the top of my code:

Option Compare Database
Option Explicit
Dim LngEmployeeID As Long

Seems to do the job, is that it?

 

[RainLover]

is this sarcasm?

if they are important let me know as I didn't think they were?

Do you actually think that I would sit here, read your entire thread then post something that is not important? No wonder you are having problems.

The Database Design (Tables etc) is the most important part of your project. Especially Normalisation and Naming Conventions. What makes you think you can hide a table anyway. Anyone who knows how to damage your database would certainly know how to unhide a table.

Suggest you fix your tables before proceeding to the construction of your bound Forms.

 

[YNWA]

As I said its an old DB, all dbs now follow a naming convention of tbl, frm, qry etc...

The db posted is old and all I want to do is get the Submitting of payments to work, then transfer that process to a new DB.

The reason I hid the table was because when I first stated it was an easy way for me and the only way I knew of stopping a user from editing the tables without needing permissions, groups, log ins etc... The user would often be a nurse or similar so although they wouldn't set out to damage the DB, they might try to add, edit or delete from tables if they thought they were doing the correct things.

 

[YNWA]

And no I wouldn't think that, and I am grateful for all the help I get on here. I just thought the naming conventions, hidden tables etc.. are least of my problems at this moment as its the submitting of invlice I am after first.