Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nayfeh
  • Order by date
  1. nayfeh

    Import Code

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

    Code not executing

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

    Code not executing

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

    Importing excel spreadsheet

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

    FTP File instead of Copy Command

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

    FTP File to Server

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

    Hi, Simple question...I hope. I

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

    Module needed to copy file

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

    Module needed to copy file

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

    Module needed to copy file

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

    Module needed to copy file

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

    Finding different records

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

    Simple Question

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

    Simple Question

    Thanks Beetee, YOUR advice was helpful. TN
  15. nayfeh

    Simple Question

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

    Maximum Function

    Thanks guys....worked like a charm!
  17. nayfeh

    Maximum Function

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

    Visible Labels

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

    Visible Labels

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

    Visible Labels

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

Part and Inventory Search

Back
Top