Recent content by CuriousGeorge

thank u very much

Is there an easy way to insert an autonumber field into a table? Just so every row gets indexed from 1 to n so that i can use that field to sort my queries? My first idea was to add an extra field in the import specification but i cant find the datatype 'autonumber' there. ANy help is...

Cheers mate

Hello, Im having some trouble figuring out how to solve following: I want to be able to set a search path for my external program which uses the shell function. And similarly also a path from where my browse procedure should start from. I have written the following in the after update...

normally i have (further down in code) .InitialFileName = C:\Users\SSS787\exjobb\Database\Readlog_update\imports\ but with .InitialFileName = s nothing happens, doesnt seem to work at all. (s=Me.TextPath.Text where Me.TextPath.Text shows...

thanks, no errors are reported now but it doesnt seem to work properly. If using nothing as path it seems as if windows is using some standard search path i.e C:\. If, afterwards, i set the path to the folder i want it doesnt use that string as a path. It still uses the previous one...

If i want to be able to set the search path (in browse procedure) by entering the path manually from my form; how would i go on doing that? If i, for example, want the second part of this code fragment below to be set from a text box on the form. Shell...

Yeah it worked, even with my old query1 :) Seemed to be the setting of the rowsource type. Gonna try tweaking that string a bit now to also display the file type. I really appreciate all the help. Thank you. /CG

yeah i agree on that. I just added the whole string name 00000001-D00 as a selection when i had = instead of LIKE in the code. Just to test the code. At the moment i have *D00, *D01 etc as options in the comboType box. So the debug string currently returns; SomeDate Between...

Yeah i got a field in query1 called SomeDate and a second field called BananaType. The BananaType field contains names such as 0000001-D00, 0000001-D02, 0000001-D01 etc. My comboType box contains the extension names D00,D01...D04 so that i can filter the BananaField in Query1 on the types...

Sure, here it comes, thanks

still doesn't work, nuttin happening when pressing the button :confused::( debug looks like this: SomeDate Between #2011-03-03# AND #2011-04-01# AND BananaField LIKE '00000001-D00'

Yeah, ive created a query which contains filetype "BananaField" and SomeDate which calls the function and AbsTime from the tabledata. allthough now i get the following error; Object required and following line is highlighted: ListBox.RowSource = "SELECT " & Query1.BananaField &...

yeah i know, u managed to reply before i had time to edit my comment above. Ive changed that field. The reason for using ReturnDate(abstime) is that abstime is given in seconds and im using the returndate function to change those to dates. So Abstime is the actual field so that has to...

Maybe u are wondering why the type combo is showing D00,D01 etc, but its suppose to ident filetypes with those extensions so usage of LIKE rather than '='. Cheers ----edit---- I noticed that ive forgot to change TypeOfFile to TableData.Banafield which is the actual name of that very...