Search results

I am bored.

Can someone give me an idea how to accomplish this task? I have a html page with links to 10+ database, as a user interface, but when the user selects a database, access will ask open or save? Course I don't want users to save it, just open them. How does the rest of the world handle this? An...

I have a html document which contains links to many Access 97 database. As there are several databases w/links, this is the best way to display it to the various users. Problem is when the link is clicked, Access prompt, Open or Save. Its just a matter of time before someone Saves the database...

So how would you write it that way?

HElp, I've searched all thought this board, looking for an idea of what I'm doing wrong. I have a text field [test] on a report. This is often empty, null. I want the report to show "Data not entered" instead of the blank the report is showing. I've tried: =IIf(IsNull([test]),"Data not...

Nevermind, I had an extra docmd.close in there. Thank you! I would have never guessed run DoCmd.Close acForm, "Switchboard" then a DoCmd.OpenForm stDocName, , , stLinkCriteria. I suspected there was some special way to refer to the different levels of the switchboard.

I tried this and it closes all switchboards & form I'm in

I put it on the beforeupdate in the form. It does work, but the record will still save if F1 contains a value and F2 doesn't. Any other suggestions?

I guess my brain is locked up....as I can't get the validation code to work correctly. I have a text field txtquantity which if contains a value then txtdesc must too contain a value. BUt if txtquantity is null then txtdesc should be null too. Help would be greatly appreciated

That's not an option for me (security is in the switchboard table). I'm sure there is someway to refer to it via code

That was the first thing I tried. All it does is put a docmd.close, which close and returns to the last switchboard, or switch A - not the main one.

Help! I'm sure this is something stupid, but I can't figure it out. (usine 97 / xp) I have a main switchboard, which calls switchboard A, which has form A on it. I have a command button which closes form A and returns the user back to switchboard A, but I need it to go back to the main...

Any ideas how this can be accomplished or if? I'm running Access 97 (w/XP) and I have many reports which get emailed as a RTF, which is fine, but can this be done with Adobe? I own Adobe 6.0 professional. Currently the code I'm using is tDocName = "InterimStatus" 'DoCmd.SendObject...

How is the easiest / best way to accomplish this, I have a database w/many reports. These reports all have a time frame range on them. ="Covers Awarded from " & [Forms]![TimeFrame]![tBeginDate] & " to " & [Forms]![TimeFrame]![tEndDate]. Problem is if the user doesn't select a time frame. How...

Found some great code, else where that perhaps someone else can use. Each required fields tag property - change to required Dim blnContinue As Boolean Dim ctl As Control blnContinue = True For Each ctl In Me.Controls If ctl.Tag = "Required" Then If IsNull(ctl) Then...

Thanks, how would I incorporate this into the existing code? At each if statement or would I some how comingle it in?

I've read numerous posts and I'm still not getting this. I have a form with 3 required fields: Supplier, name and PartNumber. I want the code to let the user be able to go back and fill in the field so I put the setfocus there - but instead the access message interupts and doesn't allow the...

I have a form with a command button which sends a message containing information from fields on the form. This works fine. Problem is, the user can use the "Email Button", when there are fields not filled in. Is there a way to stop the email message from being sent?

I have a form with a combo box. If the supplier(s) name is not in the combo box, it asks do you want to add that supplier address? If yes, a popup form displays, where the name and address are entered. THis updates the table. But the problem is the combobox doesn't refresh so the user isn't...

I have a combo box w/about 20 items or more in it. Is there a way to get it to open to a specific records? I'm using the Me!Program.Dropdown & I was wondering if there is another command to use?