Recent content by asulliva

I have inherited an Access 2003 database and I don't know too much about MS Access. I need the db to back itself up, in the same folder it's in and also affix a date stamp to the end of the file name to avoid confusion. I need this all to happen when someone opens the DB. Can this be done...

I should start by saying I inherited this horrible problem ridden database. Anyhow the control source field already had a value in it which, when changed to your formatting line produced "#NAME?" in the fields.

I'm using MS Access 2003. I have a date field and I'd like to add an input mask and a default value to it. My "input mask wizard" errors out when I try to open it. Could someone please post the text I'd next to put into the input mask field to produce and input mask of "DD/MM/YY"? Also...

Hi I have an Access 2003 database and I need it to take a back up to a different folder than the one it is in each time it is opened. I have no idea how. I'm kind of a newb.

I should have mentioned that the default value in the text box is a decimal (0.00) and all values that will ever be in the box will more than likely be decimals. Currently everything looks to be working except it highlights only the numbers left of the decimal. I'd like it all highlighted if...

A little background... I'm an Access newbie and have inherited a pretty sloppy DB from whomever originally built it (the guy is no longer with the company). The database is in Access 2003 and has two forms and a table. The table is comprised of various projects that my company is working on...

Alright I'll give that code a shot. Thank you very much for all of your help. Also, thanks for the warning but it should fine since the only cells that are "enabled" on the form are ones that are updated very regularly.

The file I am opening is a .MDB I'll walk you through the process I take to open the form to where I'm editing it and maybe you can find a step where I would be able to somehow access these options... -double click .MDB file -MS Access Pop-Up: "Security Warning: Unsafe expressions are not...

Will this code work if the cell is tabbed to rather than clicked on? Also...my Tools/Options is grayed out. The guy who designed this DB/Form is no longer with the company and I wasn't around when he created it. I'm sort of an Access newb.

I'm using Access 2003.

How do I set a cell to auto-highlight the text inside of it when it gains focus? I don't want to have to highlight the text manually to delete/alter it each time as this is a fairly big form.

Alright I will try this out. Thanks a bunch for the help.

So I just make a label on the form and then put that code in the "On Load" event?

Hey guys, I have a form that is set up like a spreadsheet. I didn't create this form, it has been handed off to me and I'm not exactly an Access expert by any means. What I need to do is add a new row to the form for "totals" and pull numerical entries from a few different tables and get the...

Okay that makes sense. What's the code I need to put in the controls' open events?