Search results for query: *

I want to add some graphics to my comboboxes so I would have a description and then a symbol after it. AutoCAD uses it in its layer and colour combos and I would like to mimic that same behaviour. Any advice would be great Thanks Murray Johnson

That is actually what I am doing. However, the standard new contact window from outlook always opens up nonmodally and therefore allows the remaining vba code to run, before I get a chance to enter any information into the new contact window.

I am in the process of making a word fax transmittal using my outlook contacts in a userform combobox. I want to give the user the ability when selecting recipients, to add a new contact. I can bring up the new contact window, but I need to capture the close event of this window to update my...

Duh, what a fool I am. I tried it with activedocument and it didn't work. Here's a star.

I am trying to get the users full name to insert into a word document, similar to what the username field would return. I have tried Environ("username"), but that returns the login name. I dont want to use fields because they cant be changed in a protected document. Anyone have any ideas?

Thank you Gol4, you're answer is exactly what I was looking for. Thank you everyone else for your very quick responses. I will look into your suggestions as well

I have several reports that I need to compare a selection of records for. To do this, I have created a multiselect listbox and populated it with records from a database (100 records). What I want to do is select some or all of the records and open a report based on the selection. I have created...

Actually, I figured it out, I used CreateItemFromTemplate and it allowed me to input a path.

I have been trying to figure out how to post a message to a Public Folder in Outlook 2002. Everytime I create the post object and post it, the post ends up in my inbox. Does anybdy know how to get this to the public folder of my choosing? Eg. \\Public Folders\All\Bob

Nevermind, I figured out my problem, I am using AutoCad VBA and so for some reason it doesn't work. Thanks for your help

I have now. It seems like it should work, but it does not seem to. Do you have a working example of this?

I have written a sub (sub1)that will then run batch routine that will open a series of files, then do one of my other subroutines based on what sub1 has stored for a Sub name in a variable (routine). Does anyone have any ideas? Eg Sub test() routine = "acad.dvb!Startup.ImportPS"...

The table I have has about 50 some odd columns that I guess I'm too lazy to put into the query. But I guess in the time I took to try figuring this out I would have it fixed.

This is probably a very simple question, but here it is. I have a report with [Table_A] as its record source. I have a query that is based on values in [Table_A] that I wish to include in this report as well. What is the proper way to include this query in my report?

I figured it out, I was doing it right to begin, just missing some double quotes in my sql. I didn't figure it out until I tried the docmd then, Access told me my sql was wrong. thanks for the help

I guess my question is, how do I use the SQL statement to do this? I know what the statement should be, I dont know how to use it. How do I execute the statement?

I have a routine that I copied off of the Autodesk NG from a few years back. I have tweaked it to work almost exactly as I need. One problem I have is if I delete an object from the acad drawing, it is still referenced in the access database. What I want to do is delete all the records in the...

When I try your method I get an error, Either BOF or EOF is true or the current record is deleted. I'm sure I'm doing something stupid, could anyone offer any solutions. Here is a piece of my code. oStyleName = oSpace.StyleName oArea = oSpace.Area oAECObjectID = oSpace.ObjectID...

I am using ADO to update a database from autocad. I've been able to update existing records and create new records but I haven't figured out how to find if a record exists, update, if not addnew. Does anyone have any ideas on this?

I was actually looking for #4 in the set. Where he refers to SQL.