Recent content by CTAdmin

chlasg, Did you ever find the component causing the problem? I am running into the exact same situation. CTAdmin

I appreciate this forum VERY, VERY much!!! I was tasked with building a query based on 28 user input variables or lack thereof (i.e. They may or may not use all 28!). My supervisor then asked to be able to choose any combination of 24 fields to be included in the report when the results were...

Glad to help!

Sorry, can't really speak for 97. Never used it. However, I think I missed part of the point. Are you editing existing records or entering new records. If you are editing, then it makes since that you are at the end of a recordset. If you are adding new records, switch the following code...

Thanks for the additional info, FancyPrairie. I neglected to mention the fact.

What version of Access are you using? I tried it in XP and it worked finel.

Splitting the database does not prevent you from making edits. The forms, queries, etc. are modified the same as you would have prior to splitting. The only big change is table structures. To edit table structures, you must open the backend and edit the table properties, etc. If you want to add...

OK. I was able to recreate your situation. 1. Got to the design view of the form. 2. View the form properties 3. Go to the "Data tab" 4. Set "Data Entry" = No Even though you are telling the switchboard to open in Edit mode, the form value can override it and put the form...

Have you verified that you chose the option to open the form in edit mode rather than add mode? Based on the info you gave originally, it appears that the form is opening in Add mode.

How are you loading the Preference Form? with code on Switchboard load, etc? or via a Switchboard command button?

Private Sub View_Patient_Comments_Click() Dim Picture As Image Dim ImagePath As String ImagePath = "c:\images\" & [Forms]![Main Form]![CommentName] ImageArea.Picture = ImagePath ImageArea.Refresh Exit_View_Patient_Comments_Click: Exit Sub Err_View_Patient_Comments_Click...

OK. So the user selects an incident number from a combo box, which produces a value in a list box(?), the user then clicks the list box, and finally clicks the command button to see the photo. I will be honest. I don't quite understand what you have going on? Would you please post some code so...

djmurphy58, OK. I am going to get a little analytical here. I think JeremyNYC is correct. These are two pieces of information. I also agree with 930driver regarding the autonumber. Leave it to do its own thing. The RFI should not be an autonumber. Here's how I would approach the situation...

OK. I think I understand what you are trying to do. Couple of Questions: 1. What version of Access are you using? 2. You are wanting a summary box. Do you mean a text box that displays a total value based on what is displayed in the subform?

I have created a form that does email verification. I control the verification by not letting the user proceed until they click a verify button. The button is coded as follows. If [Email_Address] Like "*@*.*" = True Then Control1.Visible = True Label1.Visible = True Exit...