Search results for query: *

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

Hey guys- I have 2 tables I am working with. The first one is the raw data I am importing (tbImport)- it includes records that are NEW, as well as records that are existing in the 2nd table. Some of the existing records will have updated info in this table, and will need the corresponding...

Because there's existing records in there that need to be updated and kept- not deleted...

Hey guys- I have 2 identical tables. I want to update the data from Table1 to go into Table2. Each table has well over 70+ fields in them. Instead of handwriting out each [Table].[Field] in either SQL or the Designer- is there a shortcut to tell Access to grab all the fields from Table1 and...

ok- so I can throw a position field into the junction table- and then use append queries to write that realtor's code, propertyID and position into the table? Well- actually, the Realtors code will go into it's own table, and property ID will as well. Position goes into the junction table...

ok- so what determines the Realtor's position on the property (ie- 1, 2 or 3?) Right now- it comes in from a flat file, where IF there are multiple realtors on a property- it is designated by their code being in the Realtor1, Realtor2, or Realtor3 fields (otherwise they're null). So do I...