Search results

I have code that runs and upon completion an excel spreadsheet is opened. What I would like to do before the code runs is to check to see if the spreadsheet is already open. If the spreadsheet is open it will give the user a msgbox telling them to close the spreadsheet first. If the...

Don't know how many people use Crystal Reports . . . but what I am trying to do is pass a parameter to a Crystal report thus bypassing the Crystal Report's parameter page. Hopefully, someone out there has been able to do this. Thanks!

I am using SQL Server 2000 and Access 2000. Does anyone have the code to run a DTS package via a command button on an Access form. Also, if the package runs successfully I would like it to open up an Excel file. Thanks!

I couldn't find the global option either. Yea, I was hoping I wouldn't have to set the property on every field on every form.

Does anyone have the code to turn off auto-correct spelling. I know you can go into the db options and turn it off. The problem is that it seems to be machine specific rather than application specific. For example, I turned off the option and when I copied the db to another user's computer...

Hey, I found a great db that you can type in the path of the db you are trying to disable the allowbypass or visa versa enable the allowbypass. Member who posted it was Hayley Baxter . . . thanks Hayley . . . great db!

How do you set AllowBypassKey to false in Access 2000. Thanks!

I finally got it to work. I am using the PK and FK values so Type = 1 as opposed to 'Type A' Thanks for your help!!

I think I am now using the correct field for FKID. However, I keep getting the following error: Run-time error 2001 You canceled the previous operation.

What table and field should FKID refer to.

I have a continuous subform with 2 fields: Company and CompanyType which relates back to the client. The CompanyType can either be TypeA or TypeB. A client can have multiple Companies listed but only one company can be designated as TypeA. All other companies choosen will either be...

Got it! Code was correct . . . logic was wrong. I was putting the code on the wrong field. Should have put the code on txtExample2 event property.

Sorry, I started out with text boxes and then switched them to combo boxes so there is no On Current Event. The space is a result of the code being copied and pasted to the newsgroup. Any other suggestions?

I have 2 fields txtExample1 txtExample2. If a user enters data in txtExample1 field txtExample2.enabled = false and and visa versa. I added the code to the On Change Event: If IsNull(Me!txtExample2) Or Me!txtExample2= "" Then txtExample1 .Enabled = True Else txtExample1 .Enabled =...

I have a query with ID, lastname, firstname, partnerlastname, and orders. The user can search on any field. The problem is that say for instance the user searches on partnerlastname = Test it returns 3 records for lastname = Doe and firstname = John because John Doe has 3 order records. The...

I got it . . . Property Data Validation: Is Null OR <=Now() I had tried this earlier but didn't notice that I kept typing IsNull instead of Is Null. IsNull is Crystal reports syntax . . . oops.

I have a function which calculates the age based on the DOB. I am trying to add data validation. 1. I tried adding <=Now() to the property data validation rule but if a valide DOB is entered and the user tries to go back and delete the DOB it won't let them . . . the message box with the...

Try this website. There are 2 AuditTrail db that I have referenced to track the users and the changes they made. Will need to make a few changes to get it to work, but this should at least get you on your way. http://www.rogersaccesslibrary.com/TableOfContents2k.asp

I just got a response from another newsgroup that I posted the question to. Here is the code: If intctrl And KeyCode = vbKeyR Then KeyCode = 0 rest of the code . . .

No problem with the response time . . . I know people are busy . . . appreciate your help. I tried your code and nothing happens. Here is my code with the change: If KeyAscii = 18 Then If IsNull(Forms!frm_Summary!Hospitalized) Or Forms!frm_Summary!Hospitalized = "" Then MsgBox...