Search results

I saw a thread once that explained how to format a date or phone number field after you've entered the data, but I can't find it again. You do it so that you don't have the __/__/__ or the ___-___-____ pop up in the field and don't have to worry about inadvertently starting typing the data in...

Is there some code that I could attach to a button that would insert certain text wherever the cursor might be? So I could have a button that says "First Name" that when clicked, would enter {First_Name} wherever the cursor is at.

Thanks! I'll give those ideas a try.

I want to pick everyone's brain on this one, because I'm not sure what I want to do can be done very easily. I have a database that tracks client information for insurance policies. I'm going to be giving it to other agents, many who are very computer illiterate. One of the requested...

I have a line of code that I'm trying to use to back up my backend database. FileCopy CurrentProject.path & "\Tracking_be.mdb", CurrentProject.path & "\Backup\Tracking_be_backup.mdb" If I attach that code to a command button, it works great. If I attach it to the Form_Open event of a form, it...

Thanks for the direction (even with the rude tone of the response). Once you pointed out the terms Dir() and filesystemobject, I was able to search and came up with this simple line of code. FileCopy CurrentProject.path & "\Tracking_be.mdb", CurrentProject.path &...

So I assume I can choose any table I want in place of "Name of your table you want to use for this", right? And then when I put that code in, would I do somthing like: copy Con ..\Backup If I'm thinking correctly on that, then what's the VBA equivalent of that copy line?

That's a very nice solution, but it seems like it's a little more complicated than I'm really looking for. I'm hoping to find a simple way to just copy the backend from one location to another. But I can't use static path names because the database will not always be in the same directory name...

I'm having trouble with some code to backup my database. I thought I'd just have some code call a batch file that copies the backend to a new location. The problem is that when I call the batch file, it opens and runs from c:\documents and settings\%username%\, so the relative paths in my batch...

Good point. Thanks.

That worked just fine. But now I'm having trouble with the backup script. I thought I'd just have the code call a batch file that copies the backend to a new location. The problem is that when I call the batch file, it opens and runs from c:\my documents\%username%\, so the relative paths in...

That looks good. But that appears to be code that I can attach to a command button. What if I want the code to run no matter how the program is closed, whether it be a command button, or clicking the X, or doing File/Exit? I would like all those options to run the Quit code. How can I do that?

Where would I access the event properties for when the entire database closes? Something like the On_Close event for a form, but for the whole database. I want to have Access prompt to back up the database upon exit, so when someone clicks the close button, a dialog box opens and asks "Do you...

Perfect! That was easy. I knew there had to be some fairly simple answer. Thanks.

I've searched the forums for days and I can't find exactly what I need to know, even though this is a very common topic, so if it's already been answered, I apologize. My problem is simple. I have a database that tracks clients for me. I have a front end and back end in the same folder...

Is there a way to only display the first part of a field's contents in a report? For example, let's say I had a database keeping track of cars, and the field in question had data like this: Chevrolet Camaro (1985) Ford Mustang (1994) Honda Accord (2001) Could I take that data, and in my...

I have a report that lists a person's name and their shirt size. How can I show totals of each shirt size on the report? I'm thinking it has something to do with the count function, but I can't figure it out. For example: M=27 L=30 XL=10

Looks good. Thanks a lot!

I didn't know about that built in function. I figured out how to get that to work with one field. But what I actually want to do is highlight all the fields in that row if the one field has a value in it. From the look of it, conditional formatting can only do one field at a time. So it...

I've searched the forums and found what SHOULD be the answer to my problem, but it's not working for me. I have a continuous form that lists information about individual insurance policies. One of the fields is called CancellationDate, and I want to check to see if there is a value in that...