Search results

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 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...

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...

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...

* 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...

posted in forms because i think the answer *might* involve using a form to pass the parameter, but point me in another direction if you think i'm in the wrong place- is it possible to have one parameter prompt for entry do two things? i have a db that creates a table whose data will...

Need advice on the best way to display a “notes” field that gets updated/added to multiple times, in a form. (Access 2007) I’ve got a DB to track information about product changes. Each month we have a meeting and discuss problem products. I’m concerned with a notes/comments section...

I borrowed code from the thread titled "Inactive names dont show on old records" in this forum, and it works GREAT! (one post away from being able to add links, sorry!) But one tiny problem: we have a form that will have one combo box for Associates (like Employee in the OPs DB) which I've got...

I would like to know if anyone knows of a way to automatically choose next in sequence via form entry in Access 2007. We currently have an excel spreadsheet tracking who attends review meetings for new products. There are 12 people who are eligible to attend the meeting, and the next person in...

I know a lot about working with existing Access databases, but I’ve never been through a class (well a 2-day class 15 years ago doesn’t count) so I need suggestions on “normalizing” my data. I think I'm just not seeing the relationships because all I can see is the original table. :banghead...

I am compiling a mailing list from an ordering system file that is imported into Access from a comma separated text file. I may have 15 or more "unique" records for one customer/mailing address. We don't want to send them 15 letters, so I need to combine certain fields and separate data by a...

I'm new here. I took an Access class offered through work on the basics about 13 years ago. It did me little good, until I found myself in a position of having to work on (read: usually fix) a db created by a coworker who shortly thereafter would leave the company and become completely unable...