Recent content by McWhorter

Wow... Thanks Zack. That is exactly what I need. Works like a charm....

"You are looking to print the browser page that is brought up when the links are clicked?" Yes. I'm looking to print them from an Excel VBA script. I would prefer the browser page not even be opened. The links currently open in IE6. I have messed around with checkboxs (embedded and on a...

We have an Excel sheet that has 100s of hyperlinks that (when clicked) open up in IE6. I have a checkbox next to each one. I want the users to be able to check several hyperlinks they want to print, then click a command button to print them all (preferably without opening them all up in IE)...

If the form is a data entry form. You could have an invisible field that is required. That way all the fields won't be entered and it wont go to the next record. After all the data is entered, set a command box up to "continue" or "enter" the data. Put some code in the...

I got it to work finally after alot of searching around on this website. Here was the code if anyone is interested. Dim wrk As Workspace Dim dbProtected As Database Dim objAccess As Access.Application Set wrk = DBEngine.Workspaces(0) Set dbProtected = wrk.OpenDatabase...

I have a table that has 3 check boxes(A, B, C) along with a few other fields. The records could have any combination of A,B, or C checked or none at all. I have created a form that has 3 unbound check boxes labeled (A, B, C). Here is what I want to do. A command box needs to be created that...

I have a command box on a form that when clicked, does several tasks, one of which runs an append query to copy records to another database. It WORKS great. Well, now we have to put a database password on the other database so the append query wont work. Anyone have some code that I can use...

That may work but by then the data that is transeferred has already been lost... One column is a list of phone numbers. Access is labeling them as a "Number" but since the phone number has a "-" between them (123-4567), it reports the number incorrectly (#num!). So doing a...

When I link an Excel worksheet into access97 the data types are automatically set. How can change them to what I want since it says you cant edit the link table? Lets say to change it from a "Number" to "Text"

When I link an Excel worksheet into access97 the data types are automatically set. How can change them to what I want since it says you cant edit the link table? Lets say to change it from a "Number" to "Text"

Excellent, I knew there had to be a simple way. It worked perfectly on the first try. Thanks.

I have a database that needs to run a few action queries. On my PC, I have "Unchecked" box in the Tools/Options/Edit menu for Action queries (Access97). That way it doesnt ask for comfirmation that running an action query is OK. The problem is that all the users PC's have the...

Has anyone created an access database that is completely Part 11 compliant? electronic signatures electronic records audit trails data security Just curious.

Was thinking about this scroll wheel issue. I mainly setup data entry forms, so I think this would work. If a required field on a form is left blank, the scroll wheel won't goto the next record. It'll give you an error saying that you cant leave a required field blank. So could we: Set up a...

Anyone tried this with Access 97?