Search results for query: *

I have found this code to use when exporting from Excel to Access. Silly questions, but I want to include this in a form, with a text box where users can specify the path and name of the excel file being imported. How can I add this to the code? I have text box txtPath and the command button...

Hi, I'm trying to use this code to import data from an excel spreadsheet directly into a table in my database. I've copied and pasted most of this code so I'm sure I'm missing something. As well, the OpenAsTextStream(strPath, ForReading, 0)....does this not work for excel files???? Can you...

Hi all, New to programming in access. I would like to import data from an excel spreadsheet into an access table. The file is e-mailed to us on a weekly basis and is in the same format each week. Ideally I would like to have a form with a text field for the path and filename and an...

I have a module (see below) that appends to a file if it exisits and creates a new one if it does not. Since the file is sent to a different server, we're having a lot of issues with regards to user permissions. I would like to copy the file to a local drive, then FTP to that server instead of...

Hi there, I have a module that is used to append to a file. I'm having problems due to the permissions created when the file is created. I would like change this code, to have the file FTP'd to the server instead. Can you please show me if and how this can be done. Thanks in advance. TN...

Hi, Simple question...I hope. I have a function below that's used to copy data to a file if a file exists, otherwise it creates it. I now need to delete the file from the source location once the copy/create has completed. Only if it successfully copied. Here's the function: Sub...

Hi, I have a function already setup the creates a text file of orders. I need a function that copies this file to a particluar location on our server if it doesn't already exist, and if it does, then it appends to the existing file. Will this be hard to do? I can use a form to do this, I...

Hi, Have a simple question...i think :) I have 2 tables, each with the fields CustNbr, LtrRate, StopRate. Now, I've joined these 2 tables in a 1-1 relationship. What I would like to do is have 2 queries: (1) To find the all customers where LtrRate isn't the same from one table to the next...

Hi, I have a text box in a report that has the following formula: Int([QtyOrdered]/108)*108. I need this value to print only if this calculated value is greater than 0. How can I do this? It is in the DETAIL section of the report. Thanks in advance! TN

Hi, I have a function called RMax that obtains the MAXIMUM value of several fields in a table. I use this value in a query then a report is based on this query. The formula for one field is: [Total]/[RMax]. Since the maximum value is sometimes 0 :-), the total becomes a # ERROR in the...

I have a label that I want to make visible only is a field in my report has certain values in it. The field is named Printed in the underlying table (tbl_NOHeader). The label is called lblDuplicate. I would like this field to be visible on the report only is the values in Printed is > 0. If...

Hi, I have a label called "Duplicate". I would like my report to print this label only if necessary. It's based on a field called "Printed" in my underlying table. If the value in this field is greater than or equal to 1 then DUPLICATE should print, otherwise nothing. I...

Hi, Can someone tell me why I can't get this code to run through a command button. For some reason, I get a "Data Type Mismatch in criteria expression" error. I think it has to do with UPDATE line in my code. I think I have all my def'n set up. I've already declared my connection...

I have a report that is generated through a form. The form is named frm_PickingList. It has text boxes for StartDate and EndDate. The main table (tbl_NOHeader) has a Printed field. It's default is set to 0 (False). I would like to update this field to -1 (True) when the report gets printed...

Hi, I have a major problem that I need help with. I have setup a form that generates a report with a command button. The code is below: ******** strSql = "sp_NOPickList " & "'" & strStartDate & "', '" & strEndDate & "'" ******* This reports calls...

Hi, I have a major problem that I need help with. I have setup a form that generates a report with a command button. This reports calls information for a stored procedure in SQL. There is one main table that the infomation is from (tbl_Headers). I can link this table up to my database if...

Hi, I desperately need some help with this function. I had set it up to export orders to a text file. Now the user wants the file exported to an excel spreadsheet. I changed the extension in the filename to .xls but when I open it up it in excel it still have to be formatted from...

Hi, I have a report that gets data from a sql stored procedure. There are two fields in the underlying table that I need updated when the report gets printed. One is "Printed" (int) the other "Duplicate" (int). So, when this report gets printed for the first time...

Hi, I have a report that gathers data from a stored SQL procedure. One of the fields is "QtyOrderd". This lists the units ordered for each "ProductNbr". I need to have a field that calculates the "TotalSkids" value. What this is, is OtyOrdered divided by 108 ...

Hi, Is there a function that round values up? So, in the example below I'd like the variable lngTotPallets rounded up to the nearest "1". So, now if there a total that's less that 0.5 it would round to 0 instead of 1. lngTotPallets = Round((intTotalQty / 108), 0) Thanks in advance. TN