Search results

Thanks Minty. It was actually the strEmail = Me!CompanyEmail that was messing everything up. I looked at the code over and over and missed that "!" instead of a "." Thanks for finding the problem. I left the first one as is since it seems to be working fine without any error. Any reason to...

This code sends an email using Outlook. The email is in the text box called "CompanyEmail" This works fine when there is an email in that textbox but gives me an runtime error 94 "Invalid use of null" when the field is empty. Any help would be appreciated. Private Sub...

OK - I've got it working. But it sure does look like a lot of steps to produce an itinerary type report in chronological order. Maybe I'm missing something. I created 3 Append Queries to a report table called "TranReportTABLE" One for the hotel INSERT INTO TranReportTABLE ( TAID, TranDate...

It's in the first post

So correct me if I'm wrong. But since the information is coming from different tables, I would have to make three different append queries, call them the fields the same name and then run the three append queries to append to the one report table so I can view that table in a report. Is that...

The problem with that is that the names of the fields are different. In the Meeting table, the event would be [mtgDate] and [mtgTime]. In the Transportation Table, the departure events are [tDeptDate] and [tDeptTime]. So I would have to someone put those fields (ie mtgDate and tDeptDate)...

Hello, I'm trying to make a simple Customer Meeting Travel Itinerary database. I've attached a screenshot of the relationships to get an idea. It's pretty simple where you create meeting, flight, hotel, taxi dates and times. The form with the subform is working very well. The problem I'm...

So I'm not really sure what you mean with this. After one of the buttons is pressed in the first form, the first form is still left open in the background. So I suppose the user can leave the second form opened, go back to the first form, and then select a different button. I tried this and...

Thanks Uncle Gizmo. I can see how this would be the "correct" way to do this and looks a whole lot more professional. For me though, modifying two lines of code to my OpenArgs is a whole lot easier than all this Function and VBA. I'll keep this in mind though the next time I have to do...

WOW - that was easy. Thank you so much. This works exactly the way I want it to work.

Thanks but how do I get the different fields in the second form to insert those words in the appropriate fields? Here is what I have: On the first form, command button to open second form with the contactID DoCmd.OpenForm "frmNewCall", , , , acFormAdd, , Me.ContactID On load of 2nd form...

I have a command button on a form that open a second form and use OpenArgs to pass the ID that was in the first form. Is it possible to have multiple command buttons on the first form that will open the second form as before, but insert predetermined text (not parameters from first form) in...

WOW - if the previous If...End If block was a Jedi Mind Trick, this one is even more mind blowing. :confused: Thanks for that. As for the other tip to make the single form a popup. I was using the acDialog switch for new records, but unfortunately after some changes to the single form and...

I have a continuous form where when a user double clicks on the subject, another (single) form opens to be able to edit that particular record. The continuous form is still left open in the background. But since the user can also change the words in the subject line while in the continuous...

This looks interesting, but I don't really need to find out what file is opened or who has it opened. The database is installed locally on each user's computer. So I know exactly who has it opened. And since it's the same file name that is being overwritten, I know exactly what file it is...

Well after thinking about this a little, I also came to the same conclusion that I would probably end up with disgruntled users no matter what I do. So maybe I'll just forget about the whole thing and let the normal warnings guide the user. If the file is closed, they get the replace warning...

OK - this looks like what I'm looking to do. Problem is, I can't figure out a way to enter this in the macro. Usually, in Access 2003, I would click the three little dots in the On Click procedure to open the VBA editor. But this is the first time using Access 2010 and when clicking the three...

Thanks Pat, The problem with trying to delete the file, is that it may still be opened. If the file is closed, then no problem. The user gets a warning that the file already exists and if they want to replace the existing file. That's fine and works well. What doesn't work is if the user...

It's an embedded macro that saves a report to the same PDF name going to the same location. I have autostart selected, so Acrobat launches and opens the PDF after Access saves it. But I have a similar type VBA that outputs an excel file which closes excel first before trying to save the...

New to Access 2010 and just trying the output to PDF. Very nice, but I get an error if the PDF is still left open. Is there any VBA that can close the PDF if it's still open before saving the new report to PDF?