Hurm. Still can't seem to find what you're talking about. My "Row Source" field >just< Says "Organizati on Name", and if I try to put anything else in there, it crashes the statement - I just get a statement saying something's wrong with that name.
It works right now >almost< the way I want, pulling up a name from the records I've done so far based on what I type in. It does not actually fill out the...
desperateloser
Last Activity: Mar 13 '07, 05:45 PM
Joined: Jan 29 '07
Location:
-
Still can't seem to puzzle out where the "Select Distinct" part should happen - when I'm done setting up the Statement I don't see "Recordsour ce" anywhere, just references to "Row source"....Leave a comment:
-
Hey! Am I understanding from the "Do you want to save and update" box that that is an SQL script???
I just made my very own
(painfully simple, ludicrously obviously brief, pathetically wizard-and-copious-online-help-guided)
SQL script???Leave a comment:
-
AHA!
I pretty sure I just figured out how that works...Leave a comment:
-
Now when I do that, 2 boxes come up.
- A small box labeled "Show Table" with 3 tabs - "Tables", "Queriries" , "Both", and options to "Add" or "Close"
- A long, wide box labeled "OrganizationNa me: Query Builder" split into 2 fields:
The upper one is blank.
The lower is some kind of grid with the labels "Field",...Leave a comment:
-
Anywhere in the properites box, I mean...also, if I understandit right, I'm creating a >new< combo box taking values from the >old< field - is there any way to turn the >original field< into a combo box with the properties I mentioned?Leave a comment:
-
Okay, I got the wizard to work...but I don't see the words you mention anywhere...Leave a comment:
-
And, as predicted, that would be Step 2 - how do I use the wizard???Leave a comment:
-
Alternately, can anyone give me an url for a site where this would be more appropriate to ask ("Access-for-the-Clueless.com")? ??Leave a comment:
-
Set Up a ComboBox
All I'm trying to do is this:
I have an existing database of prospective clients, and want to make a combo box out of the Organization Name so that it fills in any name currently in the database if you type in the first few letters. I'd also like to do the same with the Notes Box.
Can anyone describe how this would work on a step-by-step, "this person is a complete idiot who can't figure out ANYTHING on their own... -
I actually didn't name them at all - they're just "Field 1", "Field 2", etc. When I pull up the Label Wizard, I just indicate which fields I want.
I have since discovered:
1) Other people making labels actually just put the data in Excel, then imported it to Word using the Mail Merge Wizard; when I try the same thing, no dice.
2) Minor but fixable problems (backup files that get made...Leave a comment:
-
I moved the table I made of the mailing list into a desktop file. Subsequent iterations were saved to that file.
The error messages come up when I try and use the label wizard to make labels using the Access database. It allows me to set everything up, but when I try and execute, the noted messages come up, along with what looks like a garbled version of the file - it's blank with little dots all over it.
I have also...Leave a comment:
-
Okay, the actual messages are:
"The RunCommand action was canceled", then
"The expression refers to an object that is closed or does not exist".
Alternately, can anyone suggest a more appropriate site???Leave a comment:
-
Alternately, can anyone suggest a more appropriate site???Leave a comment:
-
Yes, but they've used it to make labels before, just last week in fact.
I suddenly realized I left out some things:
1) Before I get the "equation refers to an object that does not exist" message, I get a "RunCommand did not run" message, or something to that effect.
After saving the files, I moved them to a folder on the desktop. Is it possible this is because I moved them and Access...Leave a comment:
-
"Object does not exist" - what did I do wrong???
1st - This is likely pathetically simple and not at all what this site is for, being mostly a snafu using regular Acess stuff and not at all coding or scripting. Please be merciful - I'm really very desperate.
I'm trying to use Access 2002 to set up a simple mailing database, then make labels using it.
I created the database with all the fields and entered the data, saved it, and have tried to use the Label Wizard several...
No activity results to display
Leave a comment: