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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by eyal8r

  1. eyal8r

    Combinging Individual Forms into One

    Hey guys- I have a number of scanned in pages that I want to turn into a fillable form 'template'. I am using Acrobat Pro 8. First- I scanned in the page(s). Then I created a form using LiveCycle Designer. I saved the individual form as separate files (for editing later, etc). So at this...
  2. eyal8r

    Help w/ Query

    Thank you! Now- if I am going to find the MATCH in the 'master list (Table1), and take a field from Table1 of the matching records and insert it into a specific field in Table2- how do I do that? ie- Of the ones that match (as stated above), take Table1.Name and insert it into Table2.Name Can...
  3. eyal8r

    Help w/ Query

    Hey guys- I have 2 tables- and need to find the record matches between them via their product code. Table 1 has the code as follows (and is considered 'the Master List')- xxx-xx-xxx Where x is an integer. Table 2 has split the 3 sections of the code out to 3 individual fields, like this-...
  4. eyal8r

    Form for Search Query?

    huh. How do I put code into this form? I assume I need code for every listbox I have on here? This form was just a quick sample one I was using for this instance. I have a better naming convention for my REAL forms/Queries...
  5. eyal8r

    Form for Search Query?

    See above- and yes, I mean a listbox- sorry.
  6. eyal8r

    Form for Search Query?

    Here you go- SQL to the Query- SELECT tbListing.Status, tbListing.MLS, tbListing.Address FROM tbListing WHERE (((tbListing.Status)=[Forms]![Form1]![Status])); Code to the Form- not sure which Sub it is- here's 2 that come up- Option Compare Database Private Sub Command3_Click() On Error...
  7. eyal8r

    Form for Search Query?

    I thought this was a simple task- but it's proving otherwise. I have a form with a number of combo boxes on it. I want to pass the values selected in the combo boxes to the query, and return the results. Basically, it's a 'search' form. However, it's not returning anything. I used the expression...
  8. eyal8r

    Help! Complex Query w/ Junction Table?

    Well, now you have me thinking about it... I guess I COULD break out the Agent's contact info (office, phone, email, etc) into a separate table- then leave their AgentCode in the specific position in the Property Table... So, no need to a junction table at all doing it this way. Right? Man, this...
  9. eyal8r

    Help! Complex Query w/ Junction Table?

    huh. So- if I ran a query on that property table- and one agent has 20 properties, a buyer's agent has 45 properties, and a specific office has 230+ Agents all represented in the table... won't you see the Agent's contact info repeated x amount of times, over and over- as well as the Office...
  10. eyal8r

    Uggh! Update Query Won't Work!

    Actually, I got the update working late last night. I was putting together the query wrong in access- and had to do a left join with the data- worked perfectly.
  11. eyal8r

    Help! Complex Query w/ Junction Table?

    Leslie- I apologize for not responding previously- I must've missed it somehow... Huh- you raise an interesting point. Yes, I've read those documents- but I was under the impression that this is part of normalizing the database. I figure that since I will be repeating the realtor info over and...
  12. eyal8r

    Help! Complex Query w/ Junction Table?

    ok- let's try this link and see if it will show the picture... http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=18665&d=1189474533 OR THIS- http://tinyurl.com/2hkquf
  13. eyal8r

    Help! Complex Query w/ Junction Table?

    ok- I'm REALLY stuck on a complex Query using a Junction Table. Here's what I have- A flat file being imported (tbImport), with a unique property ID (MLS), information on 3 different agents, all in different fields. I am trying to normallize the DB by assigning every Agent to a separate table...
  14. eyal8r

    Uggh! Update Query Won't Work!

    ok- Just tried to run the query- and it says it didn't update all 28,000+ records due to Key Violations. What's the problem here? Thanks
  15. eyal8r

    Uggh! Update Query Won't Work!

    ok- Just changed the SQL to a LEFT Join, and it seems to work. However- it doesn't make sense to me. Can someone explain it to a struggling newbie? Thanks
See more

Part and Inventory Search

Back
Top