Recent content by cpc

  1. C

    SQL or VBA?

    CJ, You made that look so easy! You're awesome!THANK YOU!:cool:
  2. C

    SQL or VBA?

    Good day, I have a simple table (or so I thought) attached. It has 5 columns (Ref, Revision,Name, Description, Data). I want to create a query where the duplicate records (defined as rows with identical [Reference] AND [Description]) are compared, and the older (the record with older [Data])...
  3. C

    Vba?

    Brilliant in its simplicity!! Always learn something new with you guys! THANK YOU!:D
  4. C

    Vba?

    Thanks for the reminder on the # in column names. Changed it to Ref. Also great idea not to delete records. Unfortunately I am unfamiliar with the Max([Ref]) Last Ref function. Would you have an example of this? Again, Thanks. :cool:
  5. C

    Vba?

    Thanks for the quick turn around! This query deletes all records with duplicate Ref#s. I would like to keep the Ref# that has the most recent revision. Example: Keep 99e delete 99c
  6. C

    Vba?

    Hi, Looks pretty basic but I seem to be drawing a blank here. I havae a simple spreadsheet: Ref# Rev 97 b 98 c 99 c 99 e 100 c 100 b 101 a 102 b I need to create a simple report but remove the duplicates (ex. Ref# 99,100). I need to delete the older Rev's (Ex Ref# 99 Rev C, Ref# 100 Rev B)...
  7. C

    Combobox default on form load

    Have you tried to set the Default Value of the combo box property to blank? (Property Sheet- Data - Default Value)
  8. C

    Question Should I use Access for this?

    Hi, I can't help but notice that you are already using Excel but apparently feel that it is missing something and not doing the job for you. Based on the brief descritpion of your needs, Access might be the logical next step.
  9. C

    Create a password for a button

    Just your basic text boxes for the user to enter a UserName and Password and a button to execute the event.
  10. C

    if you post your db I can give it a shot

    if you post your db I can give it a shot
    • cpc
    • Profile post
  11. C

    "After Update" to recognise blanks

    Try the Nz(Me.iOperatorsCode.Column(1),"") instead of " " for your me.iOperatorsName
  12. C

    Table transfer between databases

    There is a great post on "Access Naming Conventions" (of course in this Forum). When you get a chance check it out!!
  13. C

    Create a password for a button

    I assume you have fields for UserName and Password. If that is the case, create a Password Button and on the events code insert the code attached replacing Username, Password, and Form with your dbases' names. Private Sub PasswordButton_Click() Me!UserName.SetFocus...
  14. C

    Using Variables in SQL

    Appreciate the reply guys. Variables in SQL seems more involved than it looks!
  15. C

    Using Variables in SQL

    Good day, I'm stupmed on this one, hope someone can help. I am attemptin to use Form entrees as Variables for my SQL FROM and WHERE clause. For some reason the SQL does not accept variables. Looks too simple but I guess it isn't. Form has:TrainingType, TableName, Date, EmpName My sql looks...
    • cpc
    • Thread
    • Replies: 3
    • Forum: Queries
See more
Back
Top Bottom