Just a bit more info. I have some code (see below), but the listbox has 2 columns and it doesn't seem to be working. Thanks again for any help. Sean Private...
Shreeja, I guess there are several ways to do this. Do you want to do this on existing records or just on new records ? Is there just a few different Field...
If you have two fields in a table that mean the same thing (one a code, and the other a description of the code), then you don't have a normalized table ...
Hi all, What an incredible amount of collective knowledge in this group! WOW!!! I've learned so much in the short time I've been a member. I haven't yet seen...
First, the second list box must have a Row Source Type of Value List. When you use AddItem, you must provide the entire row, including column delimiters if...
That's what I'm using now. =Trim([FirstName] & " " & [MiddleName] & " " & [LastName] & " " & [Suffix] The problem is, if there is no middle name, the extra...
i haven't seen a post prior to this one regarding this issue, so I'm not sure where you are trying to use this or how, but I concatenate a name for two unbound...
Ah. You can use this little trick: =[FirstName] & " " & ([MiddleName] + " ") & [LastName] & (" " + [Suffix]) When you use the + operator to concatenate, if...
David- Hmmm. You basically need to open the file in Acrobat reader and then command the reader to print the file. You might check on the Adobe website - I...
This thread appears broken as Beth mentioned. Maybe this is what you want... Use an implicite If statement to test for a null middle name. If it is null, use...
Thank you, that pointed me in the right direction. I chose option 2: Include ALL records from B and only those records from C where the joined fields are...
Beth- You could greatly simplify this by taking advantage of Null propagation using the + operator: FormalName = (rs!sc + " ") & (rs!firstname + " ") & _ ...
Dave, I know what you mean. I have been a member of this group for about 3 years, and all the members continue to provide top notch help when needed. Enjoy! ...
I have a client who would like the ability to print out a map of property locations. Basically I'm thinking a two page/sided printout where side one shows the...
S.P., You need to add another column to your table you are using for this SelectedFlag and make it a yes/no data type The first list box would be selected "No"...
Well John, thanks, but I'm thinking I might be in over my head! It's been too long since I've used my VBA so the stuff below looks familiar, but I don't...
John, I've got a demo on my website that may help you out. It's labeled "Incremental Number." http://propertychampion.com/Developer_Tools/Addins/Addins.html ...
Grrrrrrr!!! My problem was the file name! I messed up the path. Okay, so I still don't know what any of that other stuff means, but at least it's working...
I have a question for the group. I currently have a database that has several procedures in which recordsets are created by dim a string variable then set the...
James I don't see any problem with using a saved query instead of an SQL statement. This is how I usually do it: Dim db As DAO.Database Dim rs As DAO.Recordset...
I suggest searching the internet for map software. There are lots of them out there. But I haven't seen any that are Access Add-ins. Bill Mosca Founder ... and...
But of course! The only trouble with posting it as a TOW is that you already posted it...and that would mean a double-post :O( Most of the replies made here...
David- Did the website tell you to load a reference to the Acrobat library? If so, VB should show you a list of known properties and methods when you type ...
let me rephrase this: on my time/pay sheets i have "TotalHours", "PayRate", and "Pay". Total hours sums up the hours for each employee by week. PayRate is, of...
That's cool, but where did you find the Acrobat typelib? John Viescas, author "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
