Recent content by hawkingsright

thank you for the suggestion. i am not seeing an error though. i have to run the query twice to get it to complete the operation. small issue, but annoying non the less.

good morning! i have an update query that looks for a product number, updates the cost, and re-calculates the price in two columns based on the salesman's margins. the problem i am having is that it seems to be hit and miss on the first run. if you run it again, it runs the calculations on all...

Here is what I ended up doing. Instead of using a dump to Word, I switched to Excel to make this a whole lot easier and less complicated. I hope it helps someone else looking for a solution. Code is inserted in a button on the main form in Access: Private Sub Command18584_Click() On Error...

thank you both for your suggestions.

I have a problem with passing data to a word form for quoting customers. This works fine, but the Item Description and Pricing values won't transfer past the first entry. Any help would be greatly appreciated. Here's the code: Dim appWord As Word.Application Dim doc As Word.Document Dim rst...

hello! i am having trouble with a list box in my sub form. i am able to select an item from it (items are linked to a table), but when i try to use it again on the next line, it will not select a new item, instead showing only the previously selected item from the line line above. how can i...