Search results

sorry, didn't read the whole question... you can join the table with itself and in the join select the values smaller than Date Something like this: select t1.date, t2.date as PrevDate from Table t1 join Table t2 on t1.date < t2.date There should also be a group by involved. This is not a...

or try this: cdate(split([FieldName]," ")(0)) Doesn't work in a query. Create a function which does this and return a date. HTH:D

There is a function called DateDiff which you can use for this purpose HTH:D

Weekday(#01-01-1980#,vbMonday) Tell weekday that monday is your first day of the week. The default is vbSunday HTH:D

In the end your query will look like this: SELECT MachineName, Dateof, NotesShift1, NotesShift2 FROM Minutes WHERE Dateof = Date() Access will have no trouble executing that query for you! Read the normalisation link from minty! HTH:D

Nice one Moosa! Perhaps you can also explain how you made that video, the tools you use and how much time it took to complete. I don't think this was your first time. Thanks!

The record length can vary from 50 to 400 characters. Which is not very fixed.

What @The_Doc_Man said is very true. Speed is relative. If you are waiting for it to happen, it takes a lot of time. The solution needs to run once a month. So that is not very often. This is a record in the output file...

I need to write about a million records to a text file. There are several ways to accomplish this. I need the fastest ofcourse. Method #1 Set fs = CreateObject("Scripting.FileSystemObject") Set a = fs.CreateTextFile("c:\testfile.txt", True) a.WriteLine("This is a test.") a.Close Method #2...

The scope of variables in a batch file is restricted to that batch file. @Gasman "Set it as an environment variable" how do i do that?

How can i use a batch file to set a variable so that it doesn't vanish after the script is done? rem File1.bat set variable1=foo rem File2.bat echo %variable1% When i run File2 after File1 variable1 is not recognised. So the scope of variable1 is only within File1.bat present. How can i...

Thanks for all the responses. I tried both solutions. With Importspecification (sql INSERT statement) and using the FileSystemObject (Open Filename For Input) I made an import specification and used the SQL Insert statement using the import specification and imported 10 files with a total of...

Here are a few sample input files. Still can't find some help page about [Text;FMT=Delimited(;);HDR=No;ACCDB=YES;DATABASE=N:\Mijn documenten\].[bestand1#csv] Any help is welcome! Thanks!

My csv inputfile looks more or less like this: 1;aap;noot;mies 2;wim;teun;vuur 3;gijs;kees;bok When i use any of the proposed code solutions above, only the first field is filled with the complete record. This is what i tried: insert into Tabel1 ([Id], [Veld1],[Veld2],[Veld3]) select...

Thanks for the input. This is great stuff! Thanks everyone!

Thanks for your reply both! @Docman you have a few valid points i haven't thought about. Size matters! No, this question and the one in April are not related. But perhaps i can combine both answers from then and now. I forgot about the IN clause of MS Access SQL. That might come in handy...

Wat is the fastest way to import 2300 similar csv files into an Access table? There is a number of ways to accomplish this. I need the fastest. Thanks for your time!

i don't want to bloat my frontend with a temporary table. I can link the csv file to my frontend but then i can't add a primary key. (Not sure if i can set an index on a linked table) In one of the two csv files i need a PK to be used as a linenumber. First csv is a reference, the second is the...

1. see post #4: Compact & Repair, I am assuming you have already tried that. 2. copy all objects to a new database hoping the error goes away 3. post a sample database describing the problem... HTH:D

This is what i type in QBF: TestOut : Replace([Field1];"ing";"s") and this is what i get when viewing SQL code: SELECT Replace([Field1],"ing","s") AS TestOut FROM tabTesting Your output is more or less the same. Try to put square brackets around the field name.