• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

Search results

  1. V

    IsNull - Switches

    Thanks John for the reply I'll Try It
  2. V

    IsNull - Switches

    I don't know how to use them in Conjunction :(
  3. V

    IsNull - Switches

    Hello John I'm really confused... I'll explain whole my problem.. I'm Building Sequential numbering (Product Codes) Based on this example http://www.techonthenet.com/access/modules/sequential_nbr2.php It uses only one form, but my problem is: My Category Combo is on the main form and the other...
  4. V

    IsNull - Switches

    Hello Mates need your help! I;m Using If IsNull(ItemCode) = True Then How can I specify other table Name and then Field name If IsNull(tableNamehere, fieldnamehere) = True Then Something Like That... Thank you!
  5. V

    Editing SubForm Data From Main Form!

    Hello vbaInet I did it and now opening the sub-form without any error Thanks a lot
  6. V

    Editing SubForm Data From Main Form!

    Hello vbaInet I noticed something strange: Everything is working perfectly, but when I'm opening the sub-form it says: Run-Time Error '2452' Expression you Entered has invalid reference to that parent property
  7. V

    Editing SubForm Data From Main Form!

    Greatest Thanks vbaInet Works perfectly :) You're Super
  8. V

    Editing SubForm Data From Main Form!

    On the sub-form it works perfectly, but I needed it on my Main form.. Is it difficult to solve that problem, I tried many variants,but none of them worked
  9. V

    Editing SubForm Data From Main Form!

    Because of My form design...... I did it (=[SForm].[Form]![PcInfo]) Displaying everything as needed, but can't edit the field
  10. V

    Editing SubForm Data From Main Form!

    Mu sub form is "Continuous Form" I'm adding it because it is very comfortable to edit pcinfo from main table, in the future i can show or hide it by a command button.
  11. V

    Editing SubForm Data From Main Form!

    Hello VbaInet I have a sub-form on the main form it is OK, but I needed that on my main form to be displayed one field from a sub-form "PcInfo" and that i could it edit (delete, add or edit values there: there are only PC component names) Then I created unbound text box, created a query, set it...
  12. V

    Editing SubForm Data From Main Form!

    I did this but saying error "#Name?"
  13. V

    Editing SubForm Data From Main Form!

    My Main form is based on Table not query, I created unbound-text box, i created a memo query, how to set that query to unbound text box as control source
  14. V

    Editing SubForm Data From Main Form!

    Hello Need your help. I want to edit, add, delete data of sub-form field (it Is a Memo Field) from main table... Please Help!
  15. V

    Building New Database!

    Hello Regina In "BsCodes" (I'll Rename It lately With meaningful name) table there are only Unique fields. For Example In Table "Assets" You Can see the fields such as: ProductCategory, Dealer, Brand, Product, Model, PartNumber, UnitPrice Quantity etc.... In "BsCodes" I have: ItemCode...
  16. V

    Building New Database!

    Hello Regina Here is the demo, I related the table, but it says: " You cannot add or change a record because a related record is required in table" Very Strange
  17. V

    Sequential Numbering Auto "Bar-Code"

    Hello Dairy Farmer Thanks For The Full Explanation about the Bar-codes I need Sequential Numbering, Which will be assigned to the products automatically (With Specific format, based on my products category 01, 02, 03, 04) I found a good example it does100% what I need, but i couldn't use it in...
  18. V

    Sequential Numbering Auto "Bar-Code"

    Please Help of Implementing Sequential Numbering Auto "Bar-Code" I need that Bar-code automatically assigned to a new record when registering. Here is the Standard Example: 5555-01-001 1. Barcode Must be only in Numbers (Minimum 9 digits) 2. First 4 digits are fixed numbers (Must not be...
  19. V

    Building New Database!

    Hi Regina I did something like: On my table BsCodes on field BscodesID (Autonumber) I related a table "tblparts" BsCode (Number) I think it is good variant, what do you think about this?
  20. V

    Building New Database!

    Hello ReginaGreatest thanks for your Suggestions I Removed AccNumberID from the Database, Renamed AccountID to meaningful name "RegCodes" (It is specific field that our company uses) I read the given instruction and will use Naming Conventions.... I have One Question, I have to Create one...
Top Bottom