Search results

Hi, I have an access database concerning transportation issues. I also have a library of MSDS sheets in .PDF format in a directory in my computer. How can I build a command that when chosen in access will open the MSDS directory and show my list of .pdf files so I can print various .pdf files...

Hi, How can I use a button on a form to open up a directory in Windows? What I want to do is open up this directory c:\inform\msds this will allow me to choose MSDS files that are in this directory. Basically what I would like to do is open a directory with windows explorer through my access...

Thanks a bunch. I messed around with it and it worked. Thanks

Thanks for the info, but, I'm still a little confused. I tried as your example stated but it still does not work. could you please explain it a little simpler. I'm sorta new at this. trackmedic

Hi, I have a form that has input points for a name, address, state, zip. I have made a combo box for the name that gets information from a table called vendors. How can I fill in the address, state and zip automatically when I choose a name in the combo box. Any help would be appreciated...

I'm sorry, I was not clear enough. When I'm on the form, I press the print button and it runs a query to print a report. The report comes out blank unless I close the form, then open it up again and hit print. The query looks for the autonumber id, thats how my records are chosen on the form.

I made up this form that has a print button on it. this button uses a macro to print the form by choosing the form number. The form number is generated in the table using the autonumber feature. When I press the button, the query prompts me for a form number. i input the current number and...

OK, Lets see if I can explain this. I have a form call material transfer. On this form, I have a ship from and ship to entry point. I have made these into combo boxes that pull a companies name from the address table. Like this it works great. I made the form off of a query. Well I now...

HELP, I need to append information from one address table to another address table. I built an append query and ran it the first time. It worked great. What I want to do is whewn I put a new address in table one, I want it to append the new information into table 2. What its doing is...

Hey guys (and gals), I have a form with a ship to area and a ship from area. I am having problems. The addresses that are used come from a table called addresses. I have made a combo box to pull this information. The ship from works fine but the ship to don't work. Basically can I have two...

How can I send a report via email and have it look like the original report? When I try the file send command, i only get certian choices such as excel, html, rt or dos. Can anyone help me with this?? thanks

Ok, I want to be able to pick a record from table1 and place it on a form. Once the record from table one is placed on the form, I want to automatically delete that record from the original form. I have a table named inventory. When I open my form called manifest, I can pick the item to...

Thanks braindead, I put the string in but had a problem as you typed it. So I played around with it. It works!!!! Thanks to everyone who has helped, Access is a challenge for the biginner but with avenues like you, it really helps out. [This message has been edited by trackmedic (edited...

Thanks, I tried to look up like in help but it will not find anything. Could you give me a little further?

I'm having trouble with a query. I want a query that looks at a table and retrieves records according to a user defined input. Ex. I have a table with cargo items. out of all these items, i want my query to look up a user input. Such as, the user would input the word "pump". How can I get...