Search results for query: *

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...

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...

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...

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...

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?

In my query I need to include only those who have been in the program longer than 60 days, off a field called IntakeDate

I have a column that provides me age based on the following Age: Int(DateDiff("d",[DateOfBirth],Date())/365.25) What I need is an AGE RANGE, for example people between age 50 and 60

I am using ACCESS 2000 and I have a simple table with the following fields: HCHV_PROGRAM/DateIn/DateOut/TimeInProgram. Within a Query I can create a DateDiff function that will give me TimeInProgram based on DateIn minus DateOut Or DateIn minus the Current Date. But what I need is a...

I find when I populate a text type field with a date such as "11/28/1946", I can use the following function in my Query to calculate age => DateDiff("y",[BirthDate],Date())\365.25 But the problem is when I place an input mask on my BirthDate, text type field, I get a bogus...