Search results

Ok.. I've tried renaming my subforms to kill spaces and stuff and I still the a "#Name?" on the textbox I've managed to somehow get the sum([LineTotal]) to work. I dont even know how that happened, but the point is that it shows the right value now. However, I'm unable to get this value on...

:( seems mine is that one that wont work Will keep trying

Ok.. I tried this, but I guess that wont work for me My [Line Total] field is a calculated field that depends on other things. This is how my field is calculated It takes Qty, Price, U/M to get it's value. Where U/M is either EA, C or M. so on my U/M field's afterupdate event I have a case...

I also second this request... I need the same functionality for an ordering database. I have a subform with details which contain a calculated field that shows the result of [PRICE] * [Quantity] But I want to display a sum of these lines on the main form and not in the subform. EDIT: FWIW, I...

Nice.. Seems that will work... I'll try that

Anyone know if it's possible to generate a PDF from a report? or some other type of read-only document? I'd prefer PDF, but I'd settle for a read-only spreadsheet or word document

Any ideas?

I have a table that has a bunch of data. I'm already using this data on forms and my database is turning out great (thanks to the help I got here) Now I have this situation... where this table will get rediculously long. This is the table that contains information about the things I buy with...

Thanks... That helped.

I'm working on a database similar to a sales databse (except this is for buying stuff). There are transactions, and each transaction has a lot of items in it. Think of this as an invoice... You have one invoice, and several line items in each invoice. I've designed a query that groups can...

Re: Event-driven record locking... help please SOLVED That worked... Thank you

I just tried this and it works... but I guess i need to extend it's functionality a bit This locks the top (header) of my form but I also have a subform embedded into it (called "PoItems Subform") I also need it to lock that form to prevent any edition/deletion there too How do I accomplish...

So... just to make sure I get this right... You lock the form while that one record is being displayed... then when you move on to another record, you run the same check again at lock / unlock the form again.

But only need that one record locked... there will me many other records to be added and edited

I have a field in a form that I need help with. I want to set a default value for it depending on the time of the day the record is being entered. If the current time is 11:00 am or earlier, I want it to default to today otherwise, I want it to default to tomorrow's date any suggestions?

Well, there will be a button to click when the invoice is paid. Could you elaborate on how to set the allow / edits property for a certain record?

I need a way to do some conditional record locking. I'll try to explain. I'll be using this database that I'm building to order stuff from different vendors. The vendor will then issue an invoice to me. When this invoice arrives, I'll be checking for price discrepancies and that sort of things...

I'm making this database and need to make it so that multiple users can access it simultaneosly and enter data into it sort of like ordering software where multiple users are entering orders at the same time... Anyone have an idea if this is at all possible? and how to do it?

Thank you... I'm reading the link you pointed me to..

Ok... I may have definitely explained this the wrong way. I see what you did in your sample. Makes sense. But in my situation, my form has a subform embedded into it. It really just looks like a table. So I guess if there is a way to make the same functionality you just did work on a table, I...