Search results

Does your Recordsource only return one line of data? If it does not than that is your Null error. The other issue is it could EMPTY which is not the same as NULL. You might consider adding... Or strSite <> ""

Maybe this will help... https://www.access-diva.com/c3.html

Hmm, since each User should have a Front-end to work on not sure I see the problem? Are you saying you want to make updates the Front-end? If so then make the changes on the Master Front-end and redistribute to your Users.

Okay good, just didn't want you thinking we forgot about you.

Have you figured this out with the examples provided?

This might help... http://allenbrowne.com/ser-62.html

It cannot be done in a query. Not sure why you think this. Here's an example of how it would work... https://regina-whipp.com/blog/?p=704

Only at AWF.

Well, I'm backing out because I do this in module and store the values in a table.

I was right there with you.

Hmm, so a little confused. Your sample is an Excel spreadsheet. You posted this the Access (database) area. Are you wanting to do this in Access?

I was JUST going to ask that question. So, I guess the answer would be... no, you are not the only one.

In post #14 @arnelgp posted a sample you could build on. In post #20 I posted an example you could build on. You can also have a look at... http://allenbrowne.com/AppInventory.html

Hmm, what is the Primary Key? Because that is what you should be filtering on. If you made the field that holds the Name the Primary Key then that's the problem. There needs to a separate one and you can use Autonumber as the Data Type.

Not with that tables you have. That is what everyone has been trying to explain. You can't put a 3,000 sq. ft. house on a 2,000 sq. ft. foundation.

I'm not seeing how that query is going to give you quantity-on-hand. Is that the problem?

So a Client gives you a Sales Order and you use that for the Purchase Order for the Supplier? How? You may want to order more than just the one Client ordered. If you change the quantity on the Order than it also changes it for the Client. You also have to consider trying to to...

Will each Order only be one line? Is tblPOfolio the Orders? Will the Orders only have one line?

Hmm, that layout is not going to work out well as you are finding out, perhaps this will help... https://www.access-diva.com/dm12.html

Hmm, not that I have had this happen but the first I would try is an Office Repair.