Search results

Hi all, I am trying to write some code to populate a table with the nearest 65 working days from a starting point. However since the code ignores Saturdays and Sundays it does not populate the table with 65 days only with 65 days -(minus) Saturdays and Sundays... Does anyone know how to get...

Hi if you have a text file you could just manipulate it by choosing what positions you want read... and how you want to read them...hard to help you without the actual txt file.. See below for an example of reading in a txt file: Sub Txtrd s As String Dim rs As Recordset Dim i...

Ok that sounds like a plan! Cheers :)

Hi, We're talking about 6 listboxes. I have tried just to pass one listbox (it works) and after that I get stuck I am afraid..:( /Rob

Hi all! I wonder if there is someone who knows how I can pass several listbox multiselects from a form to a query. I have some code that already passes one listbox with multiselects...can this code be adjusted to fit several listbox multiselects? 'Declare variables Dim db As DAO.Database...

Hi instead of acSpreadsheetTypeExcel12 use 10 ie. FileName = "MyFileName (" & Format([Today], "MMYYYY") & ").xlsx" Path = "C: \" VarSQL = "MyTbl" DoCmd.TransferSpreadsheet acExport, 10, VarSQL, Path & FileName Hope this helps Bob

Yep that did it. Thanks alot!!

Hi all, I have some code that I found on the net for searching on a form using a listbox. I also have in my form a text box that I would like to use in conjunction with the list box. I have the following code: Private Sub Command26_Click() 'Declare variables Dim db As DAO.Database...

Bad example I guess. Thanks for an alternative solution.

Hi all, I am reading in some files from excel into access. I am using the path name and the file name as input factors. Both the path and the file name are static, the only thing that changes is the date ie the the file name is called for example abc_02-08-2011.xlsx The problem is that these...

Ok, So this is not possible to do this without code I guess, thanks anyhow! Cheers Rob

Hum the problem is that I am trying to incorporate a (>) sign in the criteria field together with the value. For ex. I am trying to do this: >365 Both values come from a form. Doing the above yields nothing I am afraid. Cheers Rob

Hi all, I am running a query with data from a form. The conditions that I am using is date, > argument (greater than) and a numerical value. Ok running only the date and the numerical values works dandy. But when I add the > argument to the same column condition as the numerical values, it...

Hi all, I have a massive excel sheet (350 000 rows 40 columns) that I am trying to get into Access. But before I write code for this, does anyone know which way is the fastest to get in data from Excel to Access? :confused: I have always defined excel as an object and from there got all the...

Hi, It is opened with VBA, it is a normal tab seperated text file. Sure I could use a timing event but that will not tell me who is locking the file and who I should send a message to, to ask them to exit from the file. Cheers Bob

Hi all, I have a database which imports text files. But if someone is locking a file the code fails. Is there a way to see who is locking the file?:confused: Cheers Bob

Hi all :)! I'm exporting a csv file with transfer text macro (see below) DoCmd.TransferText acExportDelim, "FinalQ Export ", "FinalQ", "C:\Temp\Final.csv" It works like a charm, but I have field in this export that when I bring it up in notepad it shows 2 decimals. The field itself in the...

I guess I was not clear about the problem. The weekly database deletes all the tables that are moved over to the historical database as soon as user enters a new date in the weekly database. Each week approximately 4500 records are added to the historical database. I did not make this database...

Hi all, I am running a database on a weekly basis and I want to store the historical data in a seperate database. Transferring the data to the historical database is no problem, however there is no control if the data already exist in the historical database. Is there a way I can say check if...

Hi Scott, It was not I who did the loandb97 but Raskew... However, what did you have in mind? What functionality? What table(s) or query(ies) would you like to use as a starting point? Is it the Account Survey Query? Bob