Search results

Hi Micheal, yesterday I was completely braindead so the whole concept of setting up a command was completely beyond me. This morning I came in with a clear head and decided to look at your code one more time and it actually clicked. I just tried it and it works out! Thank you very, very much! I...

Michael, unfortunately, your suggestion went way over my head. I read the reference post carefully, but I didn't see how I could apply it to my situation. I could try to use the same method of creating parameters instead of creating the sql with the two sub-strings. But I am not sure if that...

Hi Michael, thank you for taking the time to look at this. I am sorry if I'm being dense, but I thought what you suggested was as simple as changing the first part of the sql statement to select nz(sum(budgetAmount), 0) as SumBudgeted from ...etc I thought that by doing that I would...

Hello, This is a long question- please read to the end. I really need help! Users want to see a simple form where for each vendor in the database, they can see the total budgeted amount, spent amount, and left over amount- per vendor, per budget code (BC), and per object code (OC). They need...

I am leaning towards creating a variable too. I will set the value in the gotfocus event of Control1. Thank you.

Hello, for the Change event of Control2 on my form, it is important to know whether the control that was last in focus was Control1. Based on this, Change of Control2 will do certain calculations. Will doing this: Dim prevCtl As Control Set prevCtl = Screen.PreviousControl If prevCtl.Name =...

Huh, just learned something new.

Didn't mean to offend anyone- just trying to make light of this potentially tricky topic.

Only for those who know .net The rest of us are on our own, it seems.

on error goto episcopalian

Yes, they pray for catholic access programmers on a loop.

Aha! That I didn't know. Thank you!

BUt isn't the very purpose of public variables to facilitate variable communication between class modules? If one class module can't read the variable that is declared as a public variable in another class module, then what is the purpose of declaring the variable as public? If only the first...

Hello, I am working in Access 2003, vba 6.5 In Form1, the user clicks one of two buttons, each button sets a different value to a public variable called manual_or_auto. In Form2, the procedure of the Save Record button does stuff based on the value of manual_or_auto. The only way I got...

They pray for the poor souls who are trying to learn Access.

That's nothing comapared to the St. Patrick's day parade!

I resolved this by making sure that the focus is lost from the Categroy and PercentperCategory fields. Before, the entry that was inserted into Transactions was identical to the last one because I would enter a new category and Percentpercategory and click ok on the external messagebox- and...

Hello, I think I found a way to insert the necessary lag into the loop to give the user a chance to update the Category and AmountperCategory and then re-enter the loop. What I did is create a messagebox that's not attached to any window using the user32.dll messagebox. This is how the last part...

Hi Rx, thanks for reading through that long, vague question. What I actually wanted was a check on whether the user has updated the unbound controls and is now ready to save the next piece of the invoice to the table. I looked at ways of doing this using Wait, but it was all too complicated. I...

Hello, I apologize if this is in the wrong section- I wasn't sure whether this belongs in Vba or Forms. My users use the AddInvoice form to add invoices to the Transactions table via unbound textboxes and listboxes. The user's job is to type in the invoice total amount, and allocate that whole...