Search results for query: *

Have you tried the active X calander control that comes with access ? Depending on your installation, you may have to go back and add it. Dave gallagherd1@rcn.com

John makes a good point about the overlap. And I defer to his wisdom regarding the daily entries. :-) Dave gallagherd1@rcn.com

Sherry, First I must say that reading your description made me kind of sad as I know there are probably tragic stories behind the data here. Anyway ... You have a many to many relationship between victims and offenders which in database design is represented by (2) 1 to many relationships. I...

thirty4d, Could you clarify a couple of points? Are you just trying to establish a link to the files in the various subdirrectories ? Or are you actually trying to extract data from the word files ? Do you want to open the files in word from access ? Do you want to view the document on your...

1- What is the record source of the order form ? 2- What is the record source of the form that displays the scanned invoice? (are they the same) If not how are the underlying tables related ? Dave gallagherd@earthlink.net

Oh BTW, your comment regarding not being able to use the NO Duplicates index is true with your current structure. However if you had a record for each reserved day ... Table Reservations: ID PropertyID Date you could set up a composite index using PropertyID and date with no duplicates...

If you have a form with fields: PropertyID Checkindate CheckOutdate And a reservations table with fields PripertyID Checkindate CheckOutdate You can put the following code in the click event of a command button. Private Sub Command8_Click() Dim sql As String Dim rst As Recordset...

John, Verry cool ! Im just curious... did you stumble on this by accident ? Dave gallagherd@earthlink.net

Perhaps I dont fully understand what you need to do, but... Can you make use of the Office Links button on the toolbar of the report preview screen ? This will output your report dirrectly to MS Word. In Word, if you want the text in tables you can select the text and choose "convert...

You can certainly do it the way you describe, but I think you may want to consider the following. Its just asuggestion based on the description of your database. Im assuming you have a table named Classes that contains the fields ClassID and ClassName. Use a combo box. You can use the combo...

I am posting this question in multiple forums due to the various issues involved. I am looking for any experiences and or suggestions to help me make decisions. I currently have an Acess mdb for document control in our engineering group running at 2 different sites. One in PA and one in AZ...

I am posting this question in multiple forums due to the various issues involved. I am looking for any experiences and or suggestions to help me make decisions. I currently have an Acess mdb for document control in our engineering group running at 2 different sites. One in PA and one in AZ...

I am posting this question in multiple forums due to the various issues involved. I am looking for any experiences and or suggestions to help me make decisions. I currently have an Acess mdb for document control in our engineering group running at 2 different sites. One in PA and one in AZ...

Ah ... I got ya. Thanks Dave gallagherd@earthlink.net

By definition a dialog box does not have scroll bars. Just curious (Im sure you have good reason), but why not open in another mode ? Could you accomplish your goal using the using the popup or modal properties ? Dave gallagherd@earthlink.net

To create a button that will allow users to link and display an image or other (type of file) on a form and allow you to open the file for editing. 1) Create a field with type OLE in your table called "document". 2) On your form create a bound OLE frame called "OLEBound1&quot...

See if this helps. faq181-432 Dave gallagherd@earthlink.net

There are 3rd party products that do this. Im not sure if your goal is to write your own code, or just perform the task. If its the latter, you may be interested in a freeware program called mdb task. It is an agent program that performs scheduled maintenence on access mdb's. You can use...

Sounds like a many to many relationship between events and people I would use one table for all names. GuestID - PK Name Address Another Table for events EventID - PK EventName Location Time Date Dirrections And another for events and names ID - PK EventID GuestID Then have an...

I am not aware of how to size the message box either. You could open a form designed as a custom message box. This would allow you to make the warning as LOUD as you want. Ie. Flashibng Red Lights, Pictures, Skulls and Crossbones whatever. Dave gallagherd@earthlink.net