Search results

  1. K

    Required fields in Access 2010 - VBA

    Bingo. Firefox downloaded it w/o issues.
  2. K

    Required fields in Access 2010 - VBA

    When I try to download it, it comes down as attachment.php?
  3. K

    Required fields in Access 2010 - VBA

    ARG! no change...:(
  4. K

    Required fields in Access 2010 - VBA

    Okay, so it appears that "Label3" is the issue. See attached picture with a red box around label 3. (that is if I know how to make an attachment here!) From there it exits and then returns to the rest of his code to the section that next displays: "Form not complete. Please complete all...
  5. K

    Required fields in Access 2010 - VBA

    Yes, from Allen Browne's code, I replaced it with: txtFindAsUTypeValue
  6. K

    Required fields in Access 2010 - VBA

    Yes, but it still goes to the piece of code that says the form has incomplete fields even tho that unbound control is now blank and being skipped (yeah)
  7. K

    Required fields in Access 2010 - VBA

    Unfortunately it still acts the same :(
  8. K

    Required fields in Access 2010 - VBA

    It looks like it's close to working with what you posted as well as using pbaldy's tag property suggestion. It now appears to skip that control but still says the form is not complete? Here's the other part of code for the form validation which I forgot to post(doh!): Private Sub...
  9. K

    Required fields in Access 2010 - VBA

    Thanks for the reply but alas I'm not skilled enough to know how. :confused:
  10. K

    Required fields in Access 2010 - VBA

    I found some code to check if all the fields in a form are complete, and if not, highlight and not allow Save until all fields are complete. The issue I'm having is with another piece of code from Allen Browne (ajbFindAsUType) that finds records as you type. The code that checks for the...
  11. K

    Importing Excel data

    I think I'll look into this one too! Thanks!
  12. K

    Importing Excel data

    I will c what I can do with that. Thanks!
  13. K

    Importing Excel data

    I have an Excel spreadsheet that doesn't have any type of index, so I add one after the import. I don't understand why Import routine #1 doesn't bring in *all* the data, only some of it. I looked over the spreadsheet dozens of times but can't see why (I'd include it but it's confidential...
  14. K

    Subforms

    Still not working correctly. When I enter data in the subform, it's not saving it...arg:banghead:
  15. K

    Subforms

    Im not sure if this changes things at all but the credit card (or folder as a better example) is not unique as \personA can have a folder 1234, and personB can also have folder, 1234
  16. K

    Subforms

    I have a db with 2 tables. Main table has ID (autonum, primary), Last, First, Email, Folder 2nd table has ID(number) Last, First, Folder I have set ID as the relationship between both tables (one to many). I just noticed the ID on the second table has no number in any of those records. I...
  17. K

    Random records

    That did the trick, thanks so much!:):)
  18. K

    Random records

    Thanks for your reply, very appreciated!
  19. K

    Random records

    Please forgive my somewhat "sloppy" coding as I'm not too good at it as you might see. I've got an issue with retrieving random records which is puzzling me. When i run the code below, it only pulls 1/2 of the total # in the select statement SELECT TOP 10 * FROM SM_Import ORDER BY...
  20. K

    Access 2010 - Excel data import issue

    Sadly, it didn't make any difference, arg....Oh well, your input is greatly appreciated!:o
Back
Top Bottom