Recent content by edgaro
-
E
Insert Requisition Details into multiple Purchase Orders
Oh, thanks for the explanation! I couldn't have thought of that myself but it makes a lot of sense now. By the way, did you get the database to work by chance? Please just open frmMain, it's a navigation form with tabs, the "Compras" tab has frmRequisiciones in it. It shouldn't give you any... -
E
Insert Requisition Details into multiple Purchase Orders
OK, I already checked and it first gave me the error on the Dlookup, I added a NZ before the lookup and it stopped telling me anything about the invalid use of Null. Then, it gave me an error telling me that it can't add an order detail record if it still doesn't have the record from the... -
E
Insert Requisition Details into multiple Purchase Orders
Hi again. I understood your explanation and was able to correct my SQL inserts based on that. Took me a while, though, sorry about that. Just a little last question. I'm really liking the Transaction method, but I don't seem to make it work. I still keep getting an "Invalid use of Null" error... -
E
Insert Requisition Details into multiple Purchase Orders
I tried the transaction method you mentioned but all I got is "Invalid Use of Null". For some reason, that I wanted to inspect, anyway. And so, to see what was going on I added a few debug.print instructions before the currentdb.execute instructions and I couldn't get the application to return... -
E
Insert Requisition Details into multiple Purchase Orders
I think I've covered the basics with the code. Here's my rendition of your code in my database. I added an UPDATE statement to change the status of my items to "sent to purchase order" and I also added another WHERE clause to avoid sending those items with a "Sent" status. I already tested it... -
E
Insert Requisition Details into multiple Purchase Orders
Oh, wow :o That's just so wonderful and beautiful. Uhm. With your permission, I will adapt this to my database right now. It does EXACTLY what I need. That's what I meant by "one move", just a button click. Wow. They're gonna love this. I don't know how to thank you more. I'll post back with... -
E
Insert Requisition Details into multiple Purchase Orders
There's only one person filling the orders right now. The way I'm assingning the order number is by looking at the maximum number in the tbOrders. If you think that way of doing it can create a problem, I completely understand, I could modify it, no problem. -
E
Insert Requisition Details into multiple Purchase Orders
Dear sneugberg, you've been very attentive and I'm sorry I didn't reply before. You are completely right, I forgot to mention a couple of things. These are the corrected tables: tbProviders(ProviderID, ProviderName), tbProducts(ProductID, ProductName), tbRequisitions(RequisitionID... -
E
Insert Requisition Details into multiple Purchase Orders
Hi, forum. Good day to you all. I'm having some issues regarding the insertion of a Requisition details table into an Order details table. For me, a requisition is an internal move of my company, where you send a document to someone in another team who's meant to authorize the purchase of... -
E
Pull value from main form and write it in a subform inside a navigation control
Thanks. I already tried with those two sites before asking here, but they don't really deal with the problem, I was refering to the control the right way and I wasn't getting the value. Anyway, I didn't quite solve it the way I wanted, but I guess that I can live with my solution; I created an... -
E
Pull value from main form and write it in a subform inside a navigation control
Hi, forum. I'm struggling to figure out how to refer to a control without using VBA. Here's the scenario: I have a main form with a navigation control inside, it also has a few comboboxes. The navigation control has a subform. When I'm entering a new record in this subform, I'd like it to pull... -
E
Query to compare one list of records with matching records from other lists
The problem I have with these crosstab queries is that it would list all of the products from all of the groceries. Is there a way to limit it to only display the products that belong to grocery store B? Thanks again -
E
Query to compare one list of records with matching records from other lists
Ok, so let's say I have three grocery stores, named A, B and C. In grocery store A, I have: Oranges $6 Apples $9 Grapes $12 Celery $2 Radish $3 In grocery store B, I have: Oranges $6 Apples $13 Celery $2 Radish $1 Cucumber $4 Onion $5 In grocery store C, I have: Apples $9 Celery $2 Radish $3... -
E
Query to compare one list of records with matching records from other lists
I couldn't do it, it returns a huge amount of records when I do it that way. Could you explain a little more? -
E
Query to compare one list of records with matching records from other lists
Select Z.ActivityName, Z.UnitPrice, (Select UnitPrice From tblActivities As Table1 Where Table1.ActivityName = Z.ActivityName And Table1.ProjectID=1) As [Project 1-UnitPrice], (Select UnitPrice From tblActivities As Table2 Where Table2.ActivityName = Z.ActivityName And Table2.ProjectID=2) As...