Search results

Correct, that is a fair synopsis. I have all of my one to many relationships in place already.

Thank you for the quick reply. I knew that Access has special words, I didn't realize that you couldn't expand on those words to change them. I will change the name. Thanks for the tip. As for the design and stuff, I have built some databases already and have learned quite a few things about...

How to explain my issue, I will try my best. I am building an Access 2010 Database for a business. I have learned that I have to try and not duplicate information so I have three main tables. The first table is a list of the Jobs linked to customer info and contact info, I call it JobsList...

OK thanks for the suggestion, I will give this a try.

This line number will serve as a reference point for the item when I get to shipping the products, so if I have multiple shipments for one line item, I can reference it this way. I guess it doesn't have to be 1, 2, 3, etc. but as you said, it would look nicer. Do you know how to program this?

I am trying to come up with automatic line numbers for each specific order. So for example, I have job number 123456 that has ordered 3 items, what I would like is that item 1 has a field with a 1 in it automatically, and item 2 has a 2 in the field and so on. But the trick is that when order...

Wow, so simple, Thanks

I am trying to make only one field required, but only for specific customers. So in the customers table, I made a check box to determine if this field (RefNo) will be required for this specific customer. In the Orders form, I have included the check box from the customers table so that when I...

I ran into this problem and used this in the criteria field and found that it worked. This will included the end date in the parameter. I know I am adding to a really old thread, but this might help someone when they search. Between [Enter Start Date] And ([Enter End Date] & " 11:59:59 PM")

I am not to sure how to explain my issue, but I will try my best. I am running a query for an apparel manufacturing facility. In my query I have a table called 'OrderForm' which is where the orders are put in. There are more than one type of fabric that can be a part of an apparel item, so as...

Is there anyway you can explain the DLookup() function to me

Wow, I was playing around with it and got it to work. Thank you very much. The "Holiday = " needed to me the name of the field that I put the expression in.

Syntax error with "Holiday = #". Can you possibly explain the different elements of the Dcount. What is "Holiday" represent? is that the field from "Holidays" table where the date is in? Same with "Holiday = #" is that the same name as the beginning of the Dcount statement?

Good Day, I have a rather interesting problem/question. I have been working in Access 2010 and by no means would I call myself an expert. I have two different tables, one is called 'JobsList' and the other one is called 'StatHolidays'. On the Jobslist form, I have a field that requires a...

Good Day, I have put together some Access 2010 Databases and I am about to embark on another soon. I have been given a request that I can't seem to solve yet so I am goint to ask it here as a good starting point. The goal is to build a database for a magazine. They want to be able to run a...

Thank you David, That was it, never would have guessed the "On Format" property. Thank you so much for sticking with me through this.

Does it matter if "AddPhoto" has the property of True/False or Yes/No?

It did not attach the first time, hopefully it works now.

I have uploaded a very "Dummy" version of what I am trying to do. It didn't work here either so I am hoping you can see my issue and help me with it.

I am not sure I know what you mean. PictureProof is in the query in which the report is based on, so it is directly on the report already. I am not sure what Build would show me. Also, there is no record source field only Control Source, which is PictureProof. As pictureproof is a list box...