Recent content by gwendon

I'm creating an MDE MS-Access db (tools=>Database Utilities=>Make MDE file...), but once the MDE file is created I can still close the main form and get to all the objects to modify them in my MDE db. This isn't supposed to happen. I'm overlooking something, do you have any ideas about what I'm...

My RowSourceType is Table/Query. I set the LimitToList property from No to Yes. But in the Visual Basic I couldn’t quite follow your instructions. If you were to send me a actual copy (a pattern) of the VB code, then perhaps I could change my Code accordingly: Private Sub Combo254_AfterUpdate()...

I'm using a combox with a unique identifer, Social Security Number, (along with the associated Last Name and First Name). This works great for locating records, but if I input an SSN in my combo box that does not exist in my table I get some un-associated record. My question is: Is there away...

The way I was taught in a multi-user environment, was to setup a single MS-Access dB on the fileserver, then recreate as needed separate MS-Access dB's on each persons PC, linked back to the One MS-Access database on the fileserver. But I find it works just fine, to eliminate these front-end...

Thank you very much for your help!! My problem is now solved. Don

I have to track the date Doctor's special pay agreements expire. The formula I'm using in my query is very simple, but it does not account for Leap Years unless I go in and manually change the days from 365 to 364. Is there a way to calculate the leap year into my formula? SpecPayExp1Yr...

Can anyone explain to me why a second ms-access db becomes smaller in size, after importing everything from the first db?

I just found two wonderful examples via an all forum search, on how to change my Match from Whole field to Any Part of Field, and it works very well. But, the Look In is defaulting to 03Enter/Editfrm: Form, instead of the field I selected to do the search. Once you select the current field via...

First you create a query using your two tables. Then in the field, under completed, in the criteria, type in yes for all completed, or no for all that are not completed. Then create your report off your query. This does work on yes/no data types that are set in the table as such. Also you may...

Yes, there is a way. I often times create forms that have command buttons on them that launch specific reports, and those reports are based on query's. If I want only records say in a given field that contain an "A", along with some numeric value: In the query, within the specific...

I would like the bounded ole to display the content of the image when I link the image file. I have unclicked "display as an icon" and it still does this.

I'm trying to use a SendKey {F6} to place data into a dialog box. I read the following in Access Help: "Because the dialog box suspends the macro, you must put the SendKey action before the action that causes the dialog box to open." The question I have is where and how do I place...

I'm not quite sure how to do this? On the query I have a field called HCHV, and there are several HCHV. In the criteria I have [Enter HCHV] To lessen the number of keystrokes I simply want the client to be able to press one or two keys to input their HCHV. I thought macros/autokeys/keystrokes...

The parameter window I'm using on my query won't accept my SendKey Keystrokes. Is there away to make this [Enter Parameter] on my query accept my SendKey Keystrokes?

I managed through trial and error to eventually solve my problem. I create a field in my query: Days: DateDiff("d",[IntakeDate],Date())>59 Then I set the criteria to -1 And no show on the field