Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: xqzme
  • Order by date
  1. xqzme

    Frustration with DLookup

    I have yet to sort this one out. I, too, have been tied up with other matters the last several days. I was looking at a related database belonging to another inidividual and I noted that this same problem arose with this individual's database system. Any guidance would be appreciated.
  2. xqzme

    How can I get a value from a table into a variable

    On 10/15/02 I asked a question about DLookup as I was having problems using this function. In responding to my question Paul Bricker explained how to use a combo box query for the purpose of populating form controls based upon related tables. You may find this to be useful as well.
  3. xqzme

    Frustration with DLookup

    Patient Table includes PatientID, PatientLastName,PatientFirstName,SurgeonID. SurgeonTable includes SurgeonID, SurgeonLastName, SurgeonFirstName, Address, SurgeonULI. (My model for this approach was based upon the Northwinds example included in Access 2002) There is a one-to-many relationship...
  4. xqzme

    Frustration with DLookup

    Thanks Paul. This is indeed the solution I was looking for on the first matter. I continue to suffer from the latter problem. The form data now inputs appropriately. As I make my entries on the form, the Surgeon table is also updated with a new sequential SurgeonID and a numeric entry (e.g...
  5. xqzme

    Frustration with DLookup

    I am new to VB coding and am having two problems with DLookup function which I am unable to solve. I have two tables, Patient and Surgeons, linked by SurgeonID. On a Patients form I have a combo box which populates the surgeons last name. I am trying to populate text boxes for a surgeon...

Part and Inventory Search

Back
Top