Recent content by jendendav

Before you use the extension number for the primary key ask yourself if anyone ever changes from one extension to another, as in when someone moves to a new office.

Like Quehay, I think Larry was on the right track the first time. I had a database with a similar problem and it was because I either based a query on a query or was using something like a one to many.

If you don't mind my asking, why would anyone scroll through 65,000 records looking for one specific entry? If I had to scroll through that much just to find one entry I'm afraid I would revolt and refuse to use the database but surely I'm just not grasping the application. Thank you for the...

Thanks. Sorry for the late reply. Was on a business trip. Jen

Well shoot, fire. Now that I have, with your help, successfully done this what you are saying makes so much sense. I knew SQL refered to query but never used SQL view because I didn't know what to do with it. I hadn't built the update query because I didn't think it would update both tables...

Way cool. If you check on this again I want to check my understanding of what happened here. Does setting DoCmd.SetWarnings False tell tstPdt that the value for SOH is no longer true? Then after update DoCmd.SetWarnings True tells tstPdt that the new value is true? Udate tells it which table...

Have been following several threads on this subject. Lack of coding experience is hampering me. I have: Table tstPdt ProductID ProductDescription ReorderLevel LeadTime SOH (stock on hand) Table tstInvTra TransactionID...

I'm not really qualified to help but it seems many of our advisors are busy or on vacation. If you already have a monthly query, why can't you just modify it to return a week's worth of data. Or maybe the quarterly would be more helpful if it has calculations. Use the same logic as what already...

Is it possible to take the number of units entered into a data entry form based on one table and in events write code to update the stock on hand field of another table? Would the event be "after update" and how complicated is the code? The table the form is based on is strictly to...

Am using Access 97. Have special Edition Using Access 97 with a section on advanced VBA progamming topics. It went right over my head. I need to start much further back. Where is a good place to start? I need to do more than is possible with wizards and such. Thanks.

Thanks imlost2. Now some questions. Using your language strsql is the update query, yes? Is unitsform based on the update query? Because mine is based on the transactions table. This meant that it had fields from the transactions table only. But the code you sent me looks as though it...

Is it possible to take the number of units entered into a data entry form based on one table and in events write code to update the stock on hand field of another table? Would the event be "after update" and how complicated is the code? The table the form is based on is strictly to...

Thanks Bill. This makes more sense to me and should make my forms much simpler.

Expressions are not my strong point. I'm hoping someone else will jump on this or that you have figured this out by now. Good luck. jen

I'm printing a copy of this so I mull it over. Thank you for confirming my problem with my form. Clarity issues. You use the term unbound form. I went to my books to look up unbound forms. Did you mean unbound controls in forms? On hand qty is data that changes. That was why I questioned...