By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,130 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

little problem.

P: n/a
Hi there, this is my problem.

I have to build a DB to manage the repair of HandHeld computer (HHC)

I have 2 tbls (tblRepair, tblNotice) link with ID. I have a Qry sorting
info that i need. such as.

company, adress, name client, ... in tbl Repair and
company, adress, name client, cost, problem... in tbl Notice
what i want to do: When i fill up the repair form with, the form
generate a ID number. (always add 1 when i enter the form)

Now when the company who repairs the HHC, they guys open the form
Notice, i have a criterias asking wich ID number he want to do a Notice
for. Lets say he type 1, hit enter, and now the info's from the tbl
Repair fills the company, adress, name client in tbl Notice.

And he just add the price and what he did on it.

But when i enter data like Date in the Notice form, it changes the ID
number back to 0 (probably cuz 0 is not use) I wonder why it changes
it? IS it because it cannot be use again? Cuz when i enter it manually
there is no problem.

Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
No***********@hotmail.com wrote:
Hi there, this is my problem.

I have to build a DB to manage the repair of HandHeld computer (HHC)

I have 2 tbls (tblRepair, tblNotice) link with ID. I have a Qry sorting
info that i need. such as.

company, adress, name client, ... in tbl Repair and
company, adress, name client, cost, problem... in tbl Notice
what i want to do: When i fill up the repair form with, the form
generate a ID number. (always add 1 when i enter the form)

Now when the company who repairs the HHC, they guys open the form
Notice, i have a criterias asking wich ID number he want to do a Notice
for. Lets say he type 1, hit enter, and now the info's from the tbl
Repair fills the company, adress, name client in tbl Notice.

And he just add the price and what he did on it.

But when i enter data like Date in the Notice form, it changes the ID
number back to 0 (probably cuz 0 is not use) I wonder why it changes
it? IS it because it cannot be use again? Cuz when i enter it manually
there is no problem.

Is it possible that it goes to zero because it is a new record? If so,
open up the form's property sheet, click on the Other tab, and set Cycle
to CurrentRecord, not AllRecords. The default for the ID field may be
0...that's why I suspect a new record is coming into play.
Nov 13 '05 #2

P: n/a
It was not set to the right cycle but even after doing what wou said its
not working.

You r right when you say that it creates a new record.

I'm out of ideas right now.Do u have any other ideas for me??

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3

P: n/a
I found that the problem is when i enter data on tne form and it Tab,
that is goes back to 0. I can cycle with Tab throught the fields without
problems, and i stay on the ID i choose but the problem is when i enter
data.

do u have any idea.

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #4

P: n/a

found it, there was a default value set to 0 in tbl.

now it seems to works good.

thx

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #5

P: n/a
Ugo Lavoie wrote:
found it, there was a default value set to 0 in tbl.

now it seems to works good.

thx

Glad you found it. I thought it might be a default value issue. Ain't
debugging fun?
*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #6

P: n/a


hehehe, most of the time,well, only when you find it.

but i dont mind if it works the first time.

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.