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 Chriss Miller 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: mastro78
  • Content: Threads
  • Order by date
  1. mastro78

    Capturing the Excel File name in a cell in the same workbook

    What I'd like to do is have the file name of the Excel worksheet/workbook I'm using to capture the name of itself in a cell in a hidden worksheet. Please advise, thank you!
  2. mastro78

    Code to call Excel spreadsheet in a function

    I know how to call/set CurrentDb and open the table I'm working with. Just curious as to how to do the same thing with an Excel worksheet and the associated cell data. Thanks.
  3. mastro78

    Grabbing a value from a cell in Excel and storing it in Access

    I currently have a table that stores the Excel file name(field:Spreadsheet) as well as the DateLastModified(field:DateModified). Now what I'd like to do is pull in the value from a single cell(cell:CntrlNm) in one of the worksheets(worksheet:Details$) into that same table(table:Spreadsheets)...
  4. mastro78

    Posted in wrong forum - Excel link dump into Access table

    Here is the code that creates the links (I call it in the OnOpen event of my switchboard): Function ImportFromExcel() Dim fs, f, s Dim ExcelFileName As String Dim PathToExcelFiles As String Set fs = CreateObject("Scripting.FileSystemObject") PathToExcelFiles = MyLocation ExcelFileName =...
  5. mastro78

    Importing Excel into Access (have working code) need spec wrksht

    Function ImportFromExcel() Dim fs, f, s Dim ExcelFileName As String Dim PathToExcelFiles As String Set fs = CreateObject("Scripting.FileSystemObject") PathToExcelFiles = MyLocation ExcelFileName = Dir(PathToExcelFiles, vbDirectory) Do While ExcelFileName <> "" If ExcelFileName <> "." And...
  6. mastro78

    Post revisited - date last modified

    I'm not sure if I'm clear on this, so let me re-phrase. tblLocation, tblSpreadsheets tblLocation - full location of excel spreadsheets (fields are Location1, Location2) tblSpreadsheets - name of excel spreadsheets (fields are Spreadsheet, DateMod) I currently have code where the user selects...
  7. mastro78

    vXP Grabbing and storing the date modified on a file

    I currently have a database that pulls in Excel data from various Excel spreadsheets based on if various unfilled cells are then filled. What I'm looking to do now is write a code that will remove all the data in an Access table associated to any/all Excel files where the name of the file is...
  8. mastro78

    vXP - creating a report that has the same format but can be filtered

    I have a single report that has everything as it should. However, my user wants it available based on various dates (by quarter, by month, by year), and/or based on status (open, closed, on-going), and/or by manager, and/or by assistant manager, and/or by depart. With all those being able to...
  9. mastro78

    v.XP creating a directory setup form

    I currently have a database that will check excel files in a given location. I want to create a form that will point the database to that location. I have a dir function that will pull from a location table once i have this form set up. But this type of function I am really not familiar with...
  10. mastro78

    Query that updates a record

    Two tables table1, table2. Table1 is constantly updated and is created from Excel. Table2 is where the Excel data is stored (an Excel import/link in Access). When the database opens, code is run that imports data from various Excel files into table1. It also runs an append query to update...
  11. mastro78

    XP - append query to pull data based only on a couple fields

    I have an append query that is going to append data constantly. And the records it will append will be a mix of new and existing information. What I want is for it to append only data that is different from the records in the table it will be appending to. Like if fields 1-5 are the same but...
  12. mastro78

    XP - Automated Excel Link Table using OnOpen Event

    I need to create a function that will link all the Excel files in the folder where my database is located (however, that path could change). The common spreadsheet in all these possible Excel files will be named Details (range A2:BE2) and that is the only one I want linked to my Access database...
  13. mastro78

    Access XP - best way to pull in Excel worksheet in automatically

    I currently have a bunch of Excel spreadsheets (more to come) that reside in the same directory as my database. However, I want to run a function on the OnOpen event in my switchboard to pull the data into the specified table. Now, I'm wondering what is the easiest way to go about this...
  14. mastro78

    Excel XP - pulling cell data from one worksheet to another

    I'm currently trying to pull data from cell B3 on worksheet Test to a cell on worksheet Test2. I'm using the formula =Test!B3 in the cell on worksheet Test2 and it isn't working consistently. Please advise and thank you for your help.
  15. mastro78

    XP - user's network login to handle permissions in Access?

    How can you do this? I've seen it done on numerous databases before but never tried it out. Any suggestions? Thanks.
  16. mastro78

    XP - retrieving data from excel using VBA

    What would be the easiest way to retrieve data from various cells in an Excel spreadsheet? Especially when the Excel spreadsheet name could change.
  17. mastro78

    XP - query that prompts a user for a name

    Now that I have you here, not that simple. I have a field ATTENTION, there is various other criteria limiting the data. The cherry on the sundae would be that when the user opens the query (datasheet) that it asks for a name (driven by the ATTENTION field) but if they aren't sure on the exact...
  18. mastro78

    vXP - query criteria to ask for less than date range

    Is there a way, like using a normal date range set Between [date] And [date], to create a way to ask for less than this [date]? I'm pretty well versed in Access and I've never tried this before. Wondering if I could get some pointers on how to go about this. Thanks in advance!!
  19. mastro78

    R5 - How to avoid duplicate data entries

    I'm fairly new to lotus script. I have one field that is Type and the other field that is Week. Type data would be Group and Single and the Week would be 5/21/2007 or 5/28/2007, etc. How can i prevent a user from entering in data in the Type field (ie) Group more than once per week? Like...
  20. mastro78

    v5 - onChange help to update form based on field and current date

    Ok, I have a form that reports information from various views based on a week ending date and the current date. For example, this report form is made up of @dblookups that pull from a view that compare the week ending date (this weeks is 4/28/2007) to today's date to see the information only...

Part and Inventory Search

Back
Top