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

Can I use the transferspreadsheet method if the fields are not in sequential order. i.e. data is in fields 1, 3, 4, 6, 7, etc.. If so, can someone help me with the code for this. Thanks in advance, TN

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

Sorry BeeTee...I overcome that problem. Thanks so much. Looks like it's working great!! Thanks, TN

Hi BeeTee, I'm getting a syntax error when I click the command button. Do I have to use brackets or quotations? I tried testing it from a file in my local C drive copied to the same destination folder. Couldn't get it to run. Thanks, TN

Hi Beetee, Thanks for your reply. I am very new to vba so I don't quite understand your code. Can I place this code within my form as a command button? The fields #SourceHandle, #DestHandle, SomeText. What values do I place for these fields? If you can provide further info, it would be...

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

Again, thanks for your advice. Very much appreciated and I will try to provide more helpful subject lines in the future. And also direct my question to the right forum. You guys have been very helpful, it is frustrating at times when I can't find the answer since my own knowledge is very...

Thanks Beetee, YOUR advice was helpful. TN

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

Thanks guys....worked like a charm!

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

For some reason, the DUPLICATE label is always showing on the report. Should this label be visible when I set it initially up on the report? If anyone can please help me with this problem, I'd appreciate it. Thanks, TN

I don't think this works. I would like the Duplicate label to appear if the value in the field Printed is > 0. Should this code go in the OnPrint event? I didn't know there was an event for Report_Active.

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