Recent content by sargentrs

Sorry, I should have said.......Access 2007 but running an Access2000 database because it's also shared with other users running Office 2000. How do you get to the event log in 2007? There is no About MS Access menu selection. The error just says it's encountered an error and must close...

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

Here's what I wound up doing: Make Excel spreadsheet from text file generated from Manufacturing System. Store on local drive. Serves multiple databases and work stations. Make table in FE database from spreadsheet. Make new BE database and store on network server. Built form to display open...

Duh! Another one of those little quirks, huh? I'll tackle it from a macro standpoint. I can design those fairly well. Thanks!

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

Yes. Which brings up an interesting scenario. Excel spreadsheet is Excel2000. Database is Access2007 (this example). Open spreadsheet on station1 (server). Share workbook set to no. Open database on station2. Try to preview report. Says can't because it's already open. Close workbook...

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

After reviewing your code with my actual data, I realized I left out some additional information and criteria: I'm using Office 2007 Professional. If lngReqd = 0, then lngAlloc = 0 If strWONum is Null, then strWONum = "None" and lngQty = 0 and lngAlloc = 0. The goal is to produce a list of...

Thank you, I'll try it out. However, when I tried to open your sample database I got a "missing or broken reference" error to "dao2535.tlb version 3.5". Do I really need that?

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

DUH! Now I feel like an idiot. Couldn't see the forest for the trees, I guess. Declared lngRun and it works like a charm. Thanks!

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

Get anywhere with this?

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

Great! and thanks. No rush. I've been developing this database for 6 years so another day or two won't hurt.:D