Recent content by asmodius

You are a genious... That worked beautifully.. Thank you.

A little confused by that... O.k. so i want to do that because it seems to make sense. However I want to make sure that I understand it before I proceed. You are saying that I should create a form that runs the report based on dates you put into a dialog box. Then I can also pull the same...

Including Parameter in Report... Hello all, I have a report that runs off a paramater based query. The parameter is a date range. The query has Between [Starting Date] and [Finishing Date] as a filter. I would like to know if there is a way to have the paramaters the user manually inputs when...

O.k. Here it goes again... Your issue: Access database runs on your machine, calls up word and prints out neat report. On other machines same database runs, but does not call up word and does not print reports right. Possible Causes: 1. Network permissions to the file shares 2. Local...

by the way.... By the way, are you absolutely sure its o.k. to use the ' charachter to point out lines that are just for explanation and not your code. Usually I see people use #. I'm not a very good programmer and just want to know. Thanks, Andy

sorry.. The link was a chached google search for the words msword.olb that lead me to this site.. http://www.visualbasicforum.com/t117796.html Really I just wanted to show you that msword.olb is a required file to run visual basic for applications tie in to word. If you install the visual...

An outside of Access perspective.. I see that the word doc being opened is on a mapped network drive. F. Did you make sure that all other users have the same permissions as you to that drive and that file? I am not that great with access, but your code looks very uniform. I would think that...

Hello All, I have a problem that I don't know how to solve. Most likely this has been solved a hundred times around here so I just need to know what to search for and Ill do the work myself. Here goes: I have a customer service database. In each record customer service personel can...

thank you sir. Thanks. Ill post if there are any problems. Cheers, Andy

O.k. So heres one for the ages. I need to know if something is possible again, If this question is already done I'm a big boy and can go find the answer myself. I just don't know what I'm looking for. I have a customer service form, working beautifully thank you Access world forum, that I need...

Much appreciated.... Thanks. Ill let you know how it goes.

some help... I can't say I am very good at this stuff at all so take what I say with a grain of salt, but I believe you coud set a criteria for your report that would only list it if the dates fall within the date range. Listing it more than once should be no problem you should just be able...

So lets say I have a report that I want to run once a day at 4 p.m. Is it possible to set the report to run itself every day at 4 and print the output to a certain printer? Just tell me what to search for and Ill try to figure out the rest. cheers, Andy

Corrupted Record Fix....... So I had to do a weird little set of procedures to get that to work and I thought I would list them here for future newbies. To remove a corrupted record that cannot be removed any way this is what you do. I am assuming here you know which record is the corrupted...

failed... JetComp fails too. I like your query idea though. You're saying use a query to export all the records except the bad one to another database right? by linking the table? Let me know if thats what you're thinking, although I am going to try that anyway. thanks, andy