Search results

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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

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...

I couldn't do it, it returns a huge amount of records when I do it that way. Could you explain a little more?

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...

Hello, forum. I'm missing some query knowledge right now. I have two tables like this: tbProjects: ProjectID*, ProjectName tbActivities: ActivityID*, ActivityName, Unit, UnitPrice, ProjectID (fk) Now, let's say I have 4 projects, from 1 to 4, and each project has some ActivityNames that...

Hahaha nice, thank you for translating my nonsense into a clear path, man. Now I can see it was easier than I thought. :D

Hello everyone and good day to you. Please help me figure out an efficient table structure for this. Let's say I have a list of contractors who will get paid a certain amount of money each week. The amount of money changes each week by measuring the amount of work done, giving it a price and...

I think I do, when I was testing the code (the one I posted) with the double click event, I was using a msgbox to see if it returned the text I tried to select like this: msgbox (me.text1.seltext)But I noticed that it triggered the msgbox first, without any text, and upon closing the msgbox...

When you double click a word in a textbox, it selects the word by shading? it. I'm not a native english speaker, please forgive me.