Search results for query: *

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?

After some more testing, I have it working. I could not get any functions with the word "Null" to work at any time. Dont quite know why. But, the IF/Then statement checks to see if anything was entered. The field is set to "Required" so if spaces are entered, they still...

I have a form set up for data entry. I want one of the numeric fields to have a default value of a field in another query. I've tried to set it in the "properties" box of that field with no luck. I then tried to set it in the "On Load" event of the form. I used the following...

By adding the default value of "" makes it work. The problem now is that if you put a space in that field it continues on. There is still no data present, but a single space ruins it. Any more thoughts. Jeff

All I was missing was to set the default value to "" Now it works beautifully. I'll have to remember that the next time I need to use it. Thanks for all of your quick responses and help. Jeff

OK, I kind of got the IF-THEN statement to work. It works if I put a concrete statement like IF [fieldname] = "7" , but it wont work if i say IF [fieldname] = "" or Null. Not sure why. Here is the code I'm using. If [FieldName] = "" Then MsgBox...