Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CTAdmin

    RAS 9 and Oracle driver dll error

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

    Multiple List box to a query

    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...
  3. CTAdmin

    Check box on Preference form

    Glad to help!
  4. CTAdmin

    ERROR MESSAGE

    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...
  5. CTAdmin

    Modifications of database sturcture after splitting

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

    ERROR MESSAGE

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

    Modifications of database sturcture after splitting

    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...
  8. CTAdmin

    Check box on Preference form

    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...
  9. CTAdmin

    Check box on Preference 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.
  10. CTAdmin

    Check box on Preference form

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

    Updating values

    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...
  12. CTAdmin

    Updating values

    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...
  13. CTAdmin

    Question about Autonum

    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...
  14. CTAdmin

    creating a summary box

    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?
  15. CTAdmin

    email validation in MS ACCESS

    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...
  16. CTAdmin

    Lists in Access Reports

    Does your table have a field that identifies "Super" and "employee", etc.?
  17. CTAdmin

    Need to reverse Appended query, true Access skills to figure this one

    Your original post leads me to believe that you track the last updated date of each record? If so, run a delete query that combines SSN number and updated date as criteria. Good Luck.

Part and Inventory Search

Back
Top