Search results

If it complains that it can't find it, then its not lying to you! From the looks of that code you posted you've made the assumption that the current path will have TestAccess.csv in it. Now unless theres a 'chdir' line somewhere before this import that will not always be the case. You should...

I don't know of a way to do this using queries, I would say you would need to loop through records via code.

thanks for that, will add the index, and keep an eye on it...if it stays at the current speed I'll be ok I think

Right, The table structure is flowdate, amount, balance, balance7, balance30 and balance90. I did have a go at a single query, but balance7 is updated based on different flowdate to balance, so I got lost trying to write it. Yes the trialing # is in the date string var, because it was doing a...

I've got the following code, and its taking a while to run, so I was checking to see if there is anything I can change in the .execute's to help the speed. Or optimize the update queries in anyway, or maybe the tables? The connection is an access 97 database, and on 21000 rows this takes...

yep! just about to post:) For some reason on a single file it uses the explorer style, but with multi select it doesnt. The next problem was then that the mvps code used a borked trimnull function (it reached the first null and ditched the rest!), the old style dialog uses spaces to seperate...

Public Function SplitS(sString As String, sDel As String) As Variant Dim sLocal() As String Dim I As Integer Dim iBnd As Integer sString = Trim$(sString) If Right$(sString, 1) <> sDel Then sString = sString & sDel I = InStr(sString, sDel) Do Until I = 0 iBnd = iBnd + 1 ReDim Preserve...

Thats a start, but I'm going to have a unknown number of returns, so it would have to return an array.

Using A97...If HP get their act together we will be changing to xp and office 2003, but not any time soon.

For some reason I don't have the split function...has any one got some nice fast code to achive the same result?

I've decided that the hyperlink dialog isn't that friendly (esp for the way I'm using it which is more for files than proper hyperlinks). So I've gone back to use the common file select dialog, but I'd thought I'd mention for others: If you have a hyperlink field that you want to fill via code...

I'm using the code posted on the mvps to open a common file dialog, but I've come across a strange problem. When I use the multi select flag (ALLOWMULTISELECT = &H200) the dialog changes from the modern style (with the wide file select list and the iconic buttons) to the old two column style...

I started with mine in text fields, but the 255 character limit could have been a problem! So I checked the hyperlink field which can store a lot more characters, 4k if i remember right...which i think matches the OS's limitation. Thanks for the pointer though!

I've got a hyperlink field that is going to contain document locations. I would like to provide a button on the form that shows the edit hyperlink dialog box that access provides. Is this possible? If not what would I have to do to the result of the common dialog filename to make it a hyperlink?

I'm having a problem making reports behave nicely. My calling form can be any size or maximized, and my reports maximize (because that looks better), but I can't get them to close without them altering the form size. If the report is maximized the form is then maximized...if I had the restore...

Well that works...is there a better way though? Public Function WorkingDay(dDate As Date) As Integer Dim I As Integer For I = 1 To Day(dDate) If Weekday(I & Format(dDate, "/mm/yyyy")) > 1 And Weekday(I & Format(dDate, "/mm/yyyy")) < 7 Then WorkingDay = WorkingDay + 1 End If Next...

sorry if this is a stupid question, but how do I get the current working day number? ie starting from the first weekday and skipping weekends/holidays etc? Is there a nice simple way of getting this?

ah right, so I think I could have used that method then. my method works as well (even if its more steps) and as an advantage in that its just SQL and I can set the empty colums to something other than null.

does this work even if it only returns "Mon","Tue","Wed"?

Fixed it! You can insert the crosstab results into a table with as many fields as you like: INSERT INTO CrossTab SELECT EmpLevel_Crosstab.* FROM EmpLevel_Crosstab; As you can see the insert doesn't care how many fields the crosstab returns. The dependent queries can the reference the table...