Recent content by chaddiesel

One of the managers has requested to set up a form to enter the date at the top of the form and then enter in data for all the plants below for that day. I thought I could just use a form/subform combo with the date (and any other information repeated to all the plants), but the catch is, he...

Each user has their own database with forms and queries that is also on the server (not the local machine) that is linked to a shared database containing the tables. -Chad

We use an Access database to issue purchase orders. I split the tables into a separate database that is on a shared network drive as well as individual databases for each user which contains the Forms and Queries (also on the network). We have had no problems with multiple users being in the...

Solution Found I figured out what the problem was. FYI to anyone that sees this problem: The problem was that Outlook has a hidden folder that it uses for temporary attachment storage. I found that Outlook has trouble when there are 100 temporary files with the same name. Since we always...

I'm using the following macro on a button on a spreadsheet to mail the workbook to multiple people: ActiveWorkbook.SendMail Recipients:=Array("user1@isp.com", "user2@isp.com", "user3@isp.com") Subject:="Production Report", ReturnReceipt:=False I have about 19 address in the Array() part...

Hello Everyone, I'm using the following on a form in my database: =(-Int(-Sum((IIf([LineTaxExempt]=Yes,(([Qty]*[Price])+([ShippingHandling])), ((([Qty]*[Price])+[ShippingHandling])*1.06))*100))))/100 In this case, I want to calculate a total for an order. If the LineTaxExempt field is...

The files will always be stored in the same folder, but I only want to print the list of files starting with cell b2 on down and not the whole folder. I inserted my data into your spreadsheet and clicked print, selected the folder, and received this message. Method 'PrintOut' of object...

The files will always be stored in the same folder, but I only want to print the list of files starting with cell b2 on down and not the whole folder. I inserted my data into your spreadsheet and clicked print, selected the folder, and received this message. Method 'PrintOut' of object...

Hello Everyone, I have a spreadsheet that containts 2 columns-Part Number and Drawing Location. The sheet looks something like this: ---A------------------------B------------------------- Part#-----------Drawing Location Part 1----------c:\drawings\part1.xls Part...

I have a table with a hyperlink field pointing to an Excel file that I would like to automatically print out on a report form. For example, I have a table: Part--------Drawing(hyperlink field) ---------------------------------------------------------------------------*------------...

Hello Everyone, Let me explain my problem. I have included 2 dashes between each pair of records to make it easier to see what goes together. In reality, it is just a long list of results from my query. Contract--------QTY--------COMPONENT--------LENGTH-------PCS 11111111 2...

Hello, I have a form that users type in a part number and a due date. I then run a report that prints the part number, the components needed and the processes needed. For example: ------User Form------- Part 1 6/25/05 Part 2 6/28/05 Part 3 7/1/05 ---------Report--------...

Is it possible to do page breaks in a subreport?--I want to have a report that prints page 1 of the main report followed by multiple subreport pages, followed by page 2 of the main report and so on. I want a page break on the main form before the subreport so it starts on page 2, and then...

Hello Everyone, I have a field set up in a table that is an OLE object with a link to an external Excel spreadsheet. My question is whether you can use a file path that contains wildcards. Each Excel file has a filename something like this: Company Name Part Number Revision 05-31-05.xls Is...

I have a report that shows all the parts used in the previous week. It looks something like this: ------------------------------------ Part Group AAA Part Number QTY ------------ ----- Part 1 23 Part 2 35 Part 3 48 Part 4 16...