Search results

Thanks, but that article doesn't address my basic question of how I can subtract the sales volume for a particular item if that item had zero sales, since the query for that item reports back a blank field.

I have an inventory table with fields of item number, description, etc. One field is "BeginningInventory". I also have a table populated with line items of invoice sales, against which I wrote a query that gives me a sum of the number of sales, "SalesQuantity", by item number. I want to...

After reading up, I find that to be a viable solution. Unfortunately, I use VBA in Access, but the closest I have come to VB in Excel is writing a few macros. Looks like I have some self-education to do. Thanks.

Hello all. I am trying to find a way of writing a formula that will find the last space character in a 26-character section of the text of a single cell. Specifically, I want the formula to give me the position of the last space in characters 1-26, 27-52, etc. I can get the first one, of...

Thanks. I took a look at it, and was able to glean a couple new ideas. I think this job will be tedious regardless, as the internal client is insisting on certain features that will require significant maintenance. I'm linking the text through an XML interface so I can update the contract...

Bob: Thanks very much for the excellent idea. I was thinking that the text should be in a table and could be selected by some sort of title... and I like the combo box idea. Unfortunately, my internal customer here has been pretty adamant that he "Just want to be able to push a button to add...

I attempted to search on this, but didn't find anything. THANKS for any help! I want to be able to add modules of contract text by selecting buttons. There are about 150-200 individual text entries I need to be concerned about, and the inclusion and order varies with each contract. For...

OK... here goes, everyone. Cascading combos... I THINK I can figure out again even though its been a while. Although, I see some using VB code that seems a LOT simpler than the awkward queries and REQUERY command I use. What I want to be able to do is query on names (in a form called...

dkinley: You're right... I should definitely use the correct terminology. Yes... my form control is bound to the table field and is of the same name. Tried your link, but it gives an error. I'm pretty sure I can fill in the appropriate arguments with the names of the controls... but...

Thanks, I have that already... it shows on the screen as I type in the code. But, I need help with each entry that should go into each argument, and especially the beginning and ending syntax and punctuation of the SendObject command. THANKS.

Hi all. New ID, but not new to the forums. Need some help on syntax. Have read through a number of searches and just can't seem to get this to work. I have a form called "NamesForm" On that form, I have fields called "SalesRep", "RepEmail", "OfficeMgr", "MgrEmail". I also have a button...