Search results

Hi Everyone, Ok, I know this seems to be an easy one but im not figuring out what im doing wrong.... I have a mail merge doc from access to word and the merge runs perfect but I want it to leave you with the mailings tab open or visible and it will not do this... below is my code Private Sub...

Boblarson Thanks so much for all your help! everything you've helped me with has worked beautifully!!! Im learning alot from you and hopefully I can pick up a whole lot more! Again Thanks and I hope you have a great day! I hope its not as hot today!!:):):)

Again, it worked beautifully, Thank You Thank You!!! Now to go a bit further... how can I modify the msgbox so that I can have the following statement: If results are less than 0 then msgbox "your date gave no results:" else msgbox "You have _ records" again I was trying to use the previous...

Awesome! Again Boblarson Thanks a million for your help it worked perfectly! I also have another post in the queries side of the forum and here is another problem im having: I was trying to use the dcount function (below, not modified version) If DCount("*", "[MasterTable]", "[Property...

Ok im trying to make this work but im a little stuck.... here are some more specifics: I hava a macro running two queries one to delete a temp table and one to append to that temp table. I have converted the macro to vb and im trying to insert the dcount function but im not sure how to make it...

Thanks guys! i'll be giving this a shot right now and i'll post and let you know how it goes... Again Thanks for your input!:)

Hi Everyone, I Have a query that appends data to another table. the criteria is the date field and it prompts for a parameter value dialog box. after I enter the date, I would like for a msgbox to appear and tell me how many records it will be appending. Im running a few queries simultaneously...

Hi Everyone, I Have an annoying problem. I have a macro thats running a query in which it prompts for a "enter parameter dialog box." Lets say I hit the macro by mistake and I hit the cancel button on the dialog box I get the "Action Failed" dialog box for the macro. Ive tried the onerror...

Boblarson COMPLETE GENIUS!!!!!! Again worked like a charm. Thank you very much for helping with 12 hours of frustration!!! Have an awesome day! :D:D:D

Boblarson you're Awesome worked like a charm!!! my only other issue is that if i have a duplicate and I want to close the form without entering another record it won't let me because i'm in data entry mode. so it keeps giving the message from access that i have a duplicate record, so i need to...

Hi Boblarson, Thanks so much for your lightning fast response. Below are my specs: Table: Master Table Text Box Name: Property Address Address Field Name : ? im assuming its the same as the textbox? Below is the modified code you gave me.... im getting a runtime error '2465' that it cant...

Requery TextBox on Lost Focus- SOLVED Hi Everyone, I have a property management db and I need to know if I have a duplicate before entering all the data on the property. I have a text box (Property Address) and on the lost focus event I want to put a function where it can do the following: -...