allright thank you,
think i came up with an idea.
Cheers
Higgs
Last Activity: May 2 '11, 07:04 AM
Joined: Mar 20 '11
Location:
-
Grouping files
i have a combo box that looks something like this:
Date: 2010-10-10 1:19:22 TypeOfFile: 0000001-D00
Date: 2010-10-10 1:19:55 TypeOfFile: 0000001-D00
Date: 2010-10-12 4:14:12 TypeOfFile: 0000002-D01
Date: 2010-10-12 4:15:11 TypeOfFile: 0000002-D01
Date: 2010-10-14 2:22:10 TypeOfFile: 0000001-D00
Date: 2010-10-14 2:28:15 TypeOfFile: 0000001-D00
** Multiply every TypeOfFile with 1000 to... -
Yes, i will try to clarify;
Assume i have a folder containing 1000 files of a certain type i.e 000001-D00. After reading those into my table i get the next folder which might contain files of type 000002-D00. After that i might have a third folder that contains an identical file type which already have been read into the table, so the file type 000001-D00 may occur again.
The field with file types may look something...Leave a comment:
-
DISTINCT different files
Hello,
I have the following table:
U I AbsTime TypeOfFile
2 0.01 0000001 000001-D00
3 0.01 0000002 000001-D00
4 0.01 0000003 000002-D00
7 0.02 0000004 000003-D00
5 0.03 0000005 000001-D04
6 0.01 0000006 000002-D04
8 0.01 0000008 000001-D00
9 0.02 0000010 000001-D00
On my form i have a combo box which uses the following SQL code:
...Code:SELECT
-
Thank you,
Thats a good start. As i have progressed and need to ask a new question ill start a new thread to avoid any confusions.
ThanksLeave a comment:
-
sorry my mistake, it should be listbox and not textbox.
ThanksLeave a comment:
-
populate textbox from two combo boxes
Hello,
If i have a table like this:
U I AbsTime TypeOfFile
2 0.01 0000001 000001-D00
3 0.01 0000002 000001-D00
4 0.01 0000003 000002-D00
7 0.02 0000004 000003-D00
5 0.03 0000005 000001-D04
6 0.01 0000006 000002-D04
And i have made two combo boxes (on a form)... -
amazing, thank u so much!
If u only knew how much time i have spent trying figuring this out.
So simple yet so hard.
Thanks a millionLeave a comment:
-
Currentdb.execute using string variable
Hello,
I have a function "ParseFileN ame" which removes the ".txt" in the file name which is stored in the variable varItem:
...Code:Public Function ParseFileName(varItem As String) As String x = InStrRev(varItem, "\") sFile = Mid(varItem, x + 1) sFile = Left(sFile, Len(sFile) - 4) ParseFileName = sFile End Function
-
i managed to get it to work,
added
to the code which seemed to do the trick =)Code:CurrentDb.Execute "UPDATE TableData SET BananaField = 0 WHERE BananaField Is Null;"
I still got one more thing i would need to fix though, maybe u can help me;
One of the columns in the data file contains an absolute time which meassures the time from when the data logging starts until it ends. This...Leave a comment:
-
Thanks for ur reply NeoPa.
Sorry if expressing a bit unclear. I'll try explain more in detail what i mean;
The actual files that are imported are txt files containing 14 columns (or fields as named in access). What ive done is to define the 'specname' in the DoCmd transferText so that the table that all the data will be imported into is setup with 15 fields, where ive named all the fields depending on parameter names...Leave a comment:
-
inserting values into table
Hi,
I need help with following:
Currently i have a browse and read file procedure where the user can select files which are read into a table. Each file contains 14 columns but after read into table each table contains 15 fields. I want field #15 to contain an integer value which identifies each file type that is read into the table.
How would i go on doing that and how and where do i implement that into my...Last edited by NeoPa; Mar 20 '11, 10:09 PM. Reason: Reformatted indenting of code to make it legible
No activity results to display
Leave a comment: