Search results

Hi ChrisMore To limit the combo to list only the shipment number associated with each order, you need to but a "criteria" in the query of the combo box, in the form design view, Property Sheet, Row Source of the combo box. - Remove the "Shipments" table "or whatever it's" from the Row Source. -...

I hope so, and as I said, most of my search for answers, I found it very short and not complete. I shall keep searching. Thanks and apologize for The_Doc_Man

Sorry Mr. The_Doc_Man, (in my opinion) I assume your entries as negative energy and confusing instead of adding a positive result to the helpers and learners.

Thank you very much Mr. MajP, You know you revived hope in us after I upset from must of answers I found in this forum, because they just give a very short answer for the one who ask a question, but they don't show him the write steps of using it, and kept him ask again and trial many ways to...

ISA "In Shaa Allah" I will step back and redo the tables, the way that you suggest to me. That is fine and easy way. Thanks a lot.

I am building the database on that way. However, here I tried to keep a basic reference ready for future use when collecting the data from all the communities who used the software. Then have it with a unique code for each city and district, which can be link easily into one system. That system...

Auto number is perfect, if the distribution of this database for "One City, One District and One Squire" or an Internet shared database or on a local area network, but it will be distribute for each community and work separately. Alright, In this case, I cannot distribute it to the non-entered...

Excellent, you are a fan

Thanks a lot for your time and help. Really, I started with unique names without codes, but in Arabic Language we have one character can be written into different ways which is create a duplicate. It is big problem for us, so that I re-structure the tables with unique code numbers. Example...

Test of Address Code. in the 2nd. sub form, Record 1 correct 100% Record 2 not completed (wrong)

Ok, After changed the old Sudan government (The thieves government), most of neighborhood communities are trying to serve their population to obtain the necessary services. which include a repeated data, and miss some information, so that, we build this database to organize the data and have...

Thanks a lot. I searched for it and found the attached below text, but not solved my problem, because I already used the multi-field unique index (see the pic below). My problem is with "how to update the data code "already saved" when I change one of the two fields data?" In this case my...

Realy, :LOL: Thanks

Thanks for replay, But I need this code as a unique key in the table, NO DUPLICATE, or not just unbound field. that is because this code3 the same procedure shall be applied for the Code4 in another sub form with 18Digits.

Hi, Can you help me? I have main form and sub form "one-to-many" in the sub form have three key fields:- Code1 reading from the main form "Index Duplicate Ok". 12Digits "123-456-789-012" Code2 Field "Index Duplicate Ok" 3Digits "000". If code1 changed then can use the same code2 again. Code3...

Dears, I am new member from Sudan. I studied Basic Programing Language in 1987 before windows come, then used without study Database 3, 3+ and Database 4, and Access since 1994. I am working in accounts field, in which "Access" help me a lot, I do some accounting programs and data management...