Hello, I am currently working on a project for work. In this project I need to be able to push a button and open a map to the address I selected. Then I need...
Thanks Bill and Jim, I was beginning to thing that it might be the Pavillion, because it was only happening on my desktop, but not on my laptop or another...
That's good to hear, David. One bit of advice...When you import a large number of objects, you'll have less chance of something going wrong if you do one type...
Bill, Thanks for the info on the RunCmds. It seems I need to poke around the group a little more. Joe D. ... the RunCmds ... development. ... idealgasvb ... ...
Toukey I looked at the doc file you uploaded. That's not going to do me any good in helping you. Your error appears to be with how the forms are designed. I...
I currently use the following function Private Sub Report_Activate() DoCmd.OutputTo acOutputReport, "rptInvoice", "Snapshot", "C:\Snapshots\" & Reports! ...
You could try this sort of code to capture the returned html and place in a .html file. Note the map is returned in an internal Ie frame. You might also do it...
A.D., So sorry, I guess I was taking liberties. Thank you, again. I will no longer take liberties. Irene ... me was meant to rename files, not human beings. ...
Thanks for hte advice Bill, After receiving it, I decided to import the data into another database according to your advice. I didn't want to take any chances....
martyconnelly, Thanks for the help, the code you posted seems to work good for saving shortcuts to the maps the problem is I need something I can look at...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Jan 2, 2007 3:06 am
44832
Bill, I uploaded a sample database called "subreport_db" with the tables, queries, report and subreport. Should you require any additional info, please let me...
I use the after update event on my form that checks that value is already in the DB. If Not IsNull(DLookup("QuoteNo", "tblOrder", " QuoteNo = '" & Me. QuoteNo...
Fabulous. We're talking about moving to an sql back end, and I've been using DAO like the dickens and really wasn't wanting to convert the code. Respectfully,...
Joe, The DLookup function will only return the first occurrence that meets the criteria. If you want to return all the order numbers that contain the QuoteNo,...
Hi All, I have a simple form and subform. I placed a command button on the form to run a query using the wizard to link the query to the button. Problem is, it...
Bill, (The table and querynames are just shorter examples of my actual table name) I have a query called query1. It contains the information I need pulled from...
Hello, I was wondering if Access can accomodate a link to photos. Example: I have a database of fossils and would like to have a link a user could click on to...
I don't see anything wrong. Does your project compile cleanly? You may be executing some old code if the project isn't compiled. That's about all I can think...
Happy New Year to all, I am attempting to create a mail merge from Access using an Access Query as my data source. The VBA code takes me to Word from Access...
It might inflate your db pretty badly. I've used knowledge base article 210100 Respectfully, Liz, Data Base Administrator, Methods Engineering "fsslhntr" ...
Hi Tina, Liz, It only inflates the DB if you embed the photos. Storing a link takes very little space. I checked the article and it looks like a good place to ...
I'm thinking of creating a query. Once the after update event detects that there is another one, the user will open the query with a button. What do you say? ...
Bill, I am a little confused (not too hard to do!). Let me expound on my situation a little more, and maybe you can tell me if there is any hope for me. I...
Richard, So long as the relevant controls are actually available on the main as well as subform and their names correctly match the entries in "Link Master...
Depending on what the purpose is, I would probably create a form based on a query with the necessary information. Then I would do something similar to the...
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.
