Search results

I don't even know where to begin or how to describe what's happening. It's random and unpredictable. I hope I'm not violating etiquette with my problem but I'm at the end of my rope. I have designed many databases for multiple applications where I work. The one I'm having issues with is for...

I've created a database to print "package labels" based on a input form for sales orders. The operator decides which sales order line to print labels for then clicks the "Labels" button. A dialog box prompts them for number of packages. They input the quantity, i.e. 5 packages. I want the...

I apologize for the newbie questions in advance: I have an Excel spreadsheet on my hard drive shared to the network: \\TOOLSApps\c_drive\SalesOrders\sornew.xls This is an "open sales order report" for our company. I won't go into details as to why it's Excel, how it's updated, etc. Suffice...

I'm new to modules/VBA so please forgive any stupid questions :) I'm trying to write a function in a query to allocate material from work orders to fill sales order demand. It's currently a many to many relationship so I'm getting multiple records per sales order for each work order for the...

When I try to utilize this function in a query, I get a syntax error. I've looked and I can't pinpoint it. Can somebody point it out? In the query: RunBal: fncRunBal([ITEM_ID],[QTY],[PierceBal]) Function fncRunBal(strItemId As String, lngQty As Long, lngPierceBal As Long) As Long...

I have a report based on a crosstab query where the column headings come from a field named DueDate. The column headings are dynamic and change depending on the dates. Code behind the report is as follows: Private Sub Report_Open(Cancel As Integer) ' You didn't know how many columns, or...

Hate to beat a dead horse but I've searched every thread and can't figure out one which fits my application. I'm wanting to use a DSum function in a query to calculate a running sum field. Purpose is to consume inventory until it's exhausted and starts going negative. i.e. Fields...