Search results

No. With the default value of 0, I could not add an Order

So, is it true to say: "In order to avoid Orders without a customer, it is not enough to check referential integrity. I must also set the Required property to Yes, Or I must leave that default value to 0." ?

I know we can add customers. but why can we add orders without relating the order to a customer?

I have two simple tables: Tcustomers and Torders. I have related the CustomerID of Tcustomers to CustomerID in Torders. A one-to many relationship with Enforce Referential Integrity checked. And cascade update and cascade delete both checked. Now I should be unable to enter a new Order in...

In fact you have created 6 select queries in total, plus 3 update queries?

In reality there are much more products to be introduced to the Products table. So the last (single) product waits for its partner to come and then your module will be run again and they both gets packed. After I received your code I have been reading it over and over to learn what you have...

That would be great! I had used vba in excel but i didnt know how to manipulate databases in vba. Your code helped me to get started using vba in access. thanks a lot. I will try to change your code so that whenever packs are full a new pack gets created. I hope I can do it, otherwise I will...

Thank You. It is a different and I believe a better way to keep record of products and packs. let me go deep through your file and reply back.

By manully, I meant I add small packs records in the SmallPacks table, and I add large pack records in LargePacks table. The right way is that when each pack is full a new pack gets created automatically. in particular you say Yes I have a single product with different serial numbers. Yes. My...

Thank you everyone for trying to help me. I spent hours on this with the aid of your comments and internet, but I couldn't go beyond this step of this work. I think the concept of database is not correctly established in my mind. But I am very interested to learn. I could not realize where to...

Here is my file.

Thank you. I am starting to learn something important in databases and such advice is really helpful. about my question, to complete the picture: the packages I mentioned in my first post are themselves to be packed in larger packages. each large package contains 10 of small packages. In my...

I have a table of Products and a table of Packages. Each product has a serial number. Each 4 products are packed in 1 package. My product table has a Package field where I tell the database that each product goes to which package. There is a Yes/No field in Packages table that must be set...

sorry for confusion. squared and uppercase were two separate examples I made trying to describe my question. Next time I will exactly describe the actual problem.

Thank you. Where should I store the calculated data? in a Select query?

Capitalization was an example. what if combo box values are numbers, and based on selected number, I want to save "square of that number" in my table. If I do it in the afterupdate event, the result of the afterupdate event will be shown in the form. but I dont want that to be shown in the form.

Hello everyone, I am new to access. I have a table with some fields. I created a form for that table in Add mode so that I can add records to the table. in the form I have a combo box with values I manually entered. suppose the values are "a" , "b", "c". I have set the control source of the...