Recent content by remorhaz

Some other specifics - *People enter in details of maintenance request on in house form (relevant details - who, what, when) saved *Email via Access -> gmail goes to stunningly beautiful lady who translates and forwards (via gmail) request to maintenance people That's the 20,000 mile view -...

Hi folks, I have an order from on high in my organization that all maintenance issues are to be tracked in an access database. This will have a form interface for a non-technical user whose first language is *not* English so it will need to be simple. The big complicating factor I...

THANK YOU!!! I am new to Access and the DoEvents is precisely what I needed. I am not new to programming but I am new to Access and I want to personally thank the members of this board which have made the development of this project go very smoothly. -Rem

I have a OnClick event on a button that changes the .Visible property on a few images then plays a sound. I notice that the sound always plays *first* no matter what I do THEN the image is updated. It seems as if the image update only occurs until AFTER the sub is finished. Here is a small...

Ugh... never mind..... just found the stupid problem. I was "helped" by Access in that the 'Order by' field in the properties section had a Expr.1000 sitting there. I never wrote that but as soon as I deleted it the query worked.

I should add this: SELECT * FROM Checkout WHERE Checkout.dateissued IN (SELECT MAX(Checkout.dateissued) FROM Checkout WHERE Checkout.computerID =16) AND Checkout.computerID = 16; When I run this in SQL mode I get a Enter parameter value popup labeled "Query1.Expr1000" asking for a value. No...

Hi there - working on a laptop checkout system. Three tables only named: Computers Checkout Checkin Primary key on computers is subkey on checkout and checkin, one to many relationship (because a single computer can be checked out and checked in multiple times). When doing a checkin I need...

Awesome! Thank you dbDamo you gave me the spark I needed to start the fire. Googling bookmarks, word, and Access scored me this link: http://www.tek-tips.com/viewthread.cfm?qid=1454687 Which has code to add Access form fields to word documents. Thank you sir!

Ghudson - even if I *do* output it to .pdf since we do not have Acrobat reader I can't ever display it.

We have a static controlled desktop configuration which does not include applications for generating .pdf files. Changing the pre-defined desktop image or trying to get something installed outside of the existing image would be like moving the rock of Gibraltar. I have to use MS Word 2003/2007...

Oh and I did try to post this in the VBA section but for whatever reason the forum would not allow it (kept throwing errors). If this is in the wrong section I apologize.

Hello, I am new to Access 2007 and I am trying to import some dynamic data into WORD 2007 using an Access form. I have a "submit" button on an Access form that (drum roll please) submits several fields to the database. I would like to have the submit button also: Open a word document...