Search results

Did you try the FollowHyperlink method? http://msdn.microsoft.com/en-us/library/aa221236(v=office.11).aspx

You're welcome!

Popping in and out to answer a few quick questions when time permits for me is almost impossible with the amount of time each page takes to load all the advertisements. I am using IE 8 (and no I cannot change that). Users like myself (5,000+ postings) who enjoy helping the forum members by...

I noticed the same thing and I also like to pop in and out and answer a few quick questions when time permits but that is almost impossible with the amount of time each page takes to load all the advertisements.

Maybe this sample will help you... Browse [Find a directory or file]

Do not use the DoCmd.SendObject method. Search for CreateObject("Outlook.Application") and you should find some examples on how to send emails that avoid the outlook security warnings.

With a simple google searched I found plenty of options >>> access vba count fields in table I prefer this option... CurrentDb.TableDefs("MyTableName").Fields.Count

Set the HasFieldNames option to True DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblFromExcel", strPath, True

What about the users with over 5,000 posts? I see 1 advert at the top of the thread, 1 advert at the bottom of the post at the top of the page (which looks like it is a part of the posters signature), 2 adverts on the right side of the page and 1 advert at the very bottom of the page. It would...

Thanks Vassago, I will check that one out! One question. After I use the Eraser program to wipe the drive... Do I have to use a DOS command to format the drive before I can insert and run the "restore" dvd's that I created to reinstall the original OS XP and software that came with my computer?

"For every tool out there to erase a drive there's another to bring that data back." Sad but probably true. I do have too much personal stuff on that drive to allow an unscrupulous buyer to get their paws on. Thanks!

I want to sell one of my old computers. I know deleting and reformatting the hard drive will not actually remove my personal data files. I have been googling but I do not trust a lot of the stuff I have found. Can you recommend any freeware programs that will thoroughly erase the data on...

Ensure all date fields in your table are already formatted as a date field or use an import specification to specify the imported fields data type.

Check out the programming for saving, undo and testing if a record is dirty [has been modified but not saved] in my old A Better Mouse Trap? sample which should help your quest.

Thanks for answering again Bob. When I added the rs.OpenRecordset(sRecordSource) line to the end of my code [I commented out the re.Close line] I get a runtime error # 3421 Data type conversion error on the rs.OpenRecordset(sRecordSource) line. How can I simply replace the Set rst =...

See if this helps... Hide all Access Toolbars and Menubars for these techniques are database specific.

You only need to add the one Yes/No field to the table to mark a record Yes/No if it gets a Christmas card. Create a user GUI form to allow adding/editing/deleting the contacts address info. The user just needs to select a check box bound to the Yes/No field to determine if an address gets a...

I would suggest that you continue to store and update you contact listing in Access [forget Excel and Word]. Add a Yes/No field to your contacts table that designates if the contact is on your Christmas card list. Then adjust the criteria to your query to only pull in the contacts that have a...

Sorry for the late response, it's been a bad day. The record source of the sub form is simply a select SQL of the table to display everything. The code I listed in the original post above is what I use to hide the fields the user did not select in another form to display only the fields they...

Forgive my naivety, but what would an additional SELECT look like in a SQL? Here is the simple select SQL... SELECT tblMyTable.* FROM tblMyTable; Here is the SQL I can build with a few of the selected fields that I want in the subforms record source... SELECT Field1, Field3, Field5 FROM...