Search results for query: *

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!

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.

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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