Search results

a little late to the party here but I just found a solution to this. As I typed the DCount function into my macro it prompted me for its parts: DCount(expression, domain, [criteria]) so I searched for more information on the function and found the format necessary to get it to work (DCount...

i swear i must have tried every combination of "Me.xxx.xxx.Value =" and never got it to work. you're my hero! so happy that i can finally close this project off my list and give it back to the user. thanks a million!!

all right, all data changed to to generic data so you can still see what reports are supposed to look like. On the "report center" tab the report choices are on the far right. the first one, "Project Tasks" is the one i'm working on, the other 3 tabs still work because there is no "build...

thanks JHB, i will try to strip out data, leave some shell data, and upload. got a bunch of meetings this morning so it will be afternoon (stateside) for me. thanks also, davestuart, i'm just not understanding your lingo at this early hour, but i'll try to answer that question this afternoon...

I have inherited maintenance of an Access DB that I did not design and I'm having trouble with their Navigation Form setup. I created a form with a list box and two date fields, and figured out how to build a filter for the form that would open a specified report on a button click. It worked...

i have built a query using access before, then viewed the sql and pasted into a module, but when it comes to editing more than just the contents of that part of the code i have no idea what i'm doing, and i just make changes and test them until i find something that works. that's why i hope my...

hey now there's an idea... if only i knew enough to put it into practice! right now i create a new table with every list i generate, and then use mail merge to put the data from that table into the word doc fields. i want to do away with creating tables, though, and just add the data to an...

i have searched all over and not yet found something that will work for me. i might be able to get "super easy mail merge" to work, but the problem is i want clicking the "merge" button to launch a file chooser box- so i can navigate to the word doc i want to use for the merge (destination doc...

have you tried setting the warnings to off?

WOO HOO! DoCmdCopyObject did it! you're my hero. not the final solution, but that gets me a step closer to full automation of this part of the process anyway, and that is a BIG help. thanks a MILLION!

that seems to do the trick if i want to save the table as a file outside the database, but i just want to save one table with another name within the same database. starting to switch gears on this and thinking maybe the better idea is to query my table containing all the records (to "filter"...

asked something similar a while back, got no replies, now i think maybe i've found the right terms to explain myself better. i'm using a form with an unbound text box to temporarily hold data that i want to use in several other places (all those functions work great). last step is to save the...

create a new macro with the name of the one your database is asking for, make it simply display a message box "this is where the macro should be". as long as you don't have your warnings turned off somewhere in the code, you should get the message box when your macro is initiated, and then you...

found a solution in another thread: http://www.access-programmers.co.uk/forums/showthread.php?p=1276838#post1276838 i had written the macro into VBA but i was still getting the error when the navigation pane was hidden, so adding me.setfocus on a separate line before the outputto command...

and THANK YOU for doing so because this solved a problem i posted but no one has offered a solution to yet. you're the best!

i have VBA that runs a bunch of commands, and one of those commands is to run a macro with other commands- to export a table to a file and then to import another excel file to another table (i know it's cumbersome but it's the only way i know around a display issue and i'm still teaching myself...

i have looked at many posts in this forum and others about this but haven't been able to find anything yet that i have been able to successfully apply to my situation. i have two forms, main form (F_AbMRB) is based on a table (tbl_AbMRB) and subform (T_ProductsCase_subform1) is based on a...

thanks for the link, tried it and i get a syntax error. so then i tried your code and i'm still getting the blank lines. i searched for "Chr(13) & Chr(10)" and found something similar and when i tried that i still get the blank lines too. i found a workaround where i make the last 3 fields...

* using access 2007 currently we build a customer list in access then use mail merge to put the fields into the letter in word. i'm having issues with the database being "in use" when i try to mail merge (it's in use by me, attempting to finish the mail merge) so i decided to try to create a...

you're welcome. glad we could help!