Recent content by eyal8r

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...

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...

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-...

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...

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

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...

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...

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...

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...

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.

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...

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

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...

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

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