Search results

Thanks John for the reply I'll Try It

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

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

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!

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

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

Greatest Thanks vbaInet Works perfectly :) You're Super

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

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

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.

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

I did this but saying error "#Name?"

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

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!

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

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

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

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

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?

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