Search results

Hmm...sounds interesting. I like your idea instead. Do you have any step-by-step links similar to this?

So, how can I get them to now populate into a separate table? I don't want current/former employees on one form. I would like for them to get kicked out of the "Current" and dumped into a "Former." Make sense? Please excuse me.

Okay, I'm not sure what I want. Bear with me. I'm hoping you can point me in the right direction. Access 2003. I currently have two tables...one for Employees and one for Family. Both are related via a one-to-many. For every employee, there may be more than one family member hence the...

Anthony, How does it know which two text boxes to pull from? Do I have to create specific text boxes? I currently have three text boxes. One with the address, another with just the city, and the other with the province.

Access 2003. I have two tables (Employees & Family). In both tables, I have set a primary key for an EmployeeID & a FamilyID. I've also created a one to many relationship from the Employee table to the Family table. For each record in the Employee table, I have inserted a photo via an OLE...

I redid report ensuring the date was in ascending order. It was like that before, but now it works. Go figure.

Oh, one other thing. I currently have an "Event Procedure" set to maximize on open. FYI. Never mind. I just had to adjust the Event Procedure to "GoToNewRecord." Duhhhhhhh!!!

Access 2003. I've created a macro to open my form at a new record. Not working. Form opens to first record. I can click "Add Record", but this isn't what I want. Am I missing something somewhere? Please help!

Yes, the field's datatype is a DATE/TIME datatype.

Access 2003. I have a report based on a query. In the query, I have a date range criteria that is set to be in ascending order. Running the query gives me the date range in ascending order. Perfect! However, when running the report the dates are in descending order. In report design, I've...

So, I've just completed a successful split. I have the original file, the BE file, and the FE file. Which file should we be using now? Is the original file considered the master file?

Okay...I'm about to ask a really stupid question...please excuse me. So, the reason for the splitting is to prevent the doubling of the file size or is this also a protection of data remedy?

So are you saying a compact should suffice Simon? Splitting the database sounds scary to me.

Doc Man, Approximately doubling. Bob Larson - I'll be reading your article.

I'm using Access 2003. I've recently created a database that is currently being stored on a network. Our network consists of several drives. On the same drive is a "Backup" folder with a backup of the database. When utilizing the database (i.e. updating) I'm noticing the file automatically...

You're right...things are where they should be. My bad! Thanks!

I've updated my table with a new field name. The data type is in the same format as the others (just what I want). I then updated my form and added the new field name via the field list. In my table, I've set the default value to "0", but it's not showing up on the form. What am I missing?

Got it! I love this forum. You guys are always helpful.

Okay. Thank you.

83 fields in my main table. 58 for the query/report.