Search results for query: *

Hello, Been a long time absent from any coding of any descript (do not know if that has been a good or bad thing =P I think probably bad). Anyway I have a xsl that looks at just mapping a cost code, based on an unrelated area field. However I only want to do this if the cost code in the...

Yup Duane, This is conclusion I came to. I have list of dates user enters the range and query selects each date within that range and then does all the necessary calculations. Means I have to maintain a table each cycle to add dates to, but only method I could figure of doing it =( Mark

Well had hoped for something more useful, like an idea how to do what was requested. The math as mentioned is simple, no matter the date format it is stored dd/mm/yyyy date functions will still work, count of days will work. Can't see any issues there.... Other then trying to get the data...

Error in my original scenario ie if user input 01/05/2011 to 07/08/2011 Wouldnt want it to show April as indicated. Instead lets say input 01/04/2011 to 07/08/2011 to get my made up "desired" result table. If put in 01/05/2011 to 07/08/2011 would be similar but minus any april rows. =(...

Have a somewhat convoluted requirement. I have a route mapping table (tbl_RouteMapping) Contains ProgDateFrom and ProgDateTo Unfortunately these can span month or number of months. IE Route RouteType ProgDateFrom ProgDateTo PerDayOutput F101 R002 04/04/2011 05/05/2011 100 F201 R002...

Nothing wrong with the original code using majp's format. However took alot of struggling with tweaking code syntax mainly to exactly to suit my table structure and source of variable feeds and again getting enough data extracted to give me the exact results required but finally got it working...

That is awesome. MajP suggestion is more along the lines I was originally envisaging, but will look into both to see what seems more robust method. Many thanks. And Merry Xmas. May the new year bring many more many to many relationships =)

Random selection isnt the issue so much as a dynamic Select Top variable. IE A field on a form is not going to be sufficient. The selection for the Select top needs to be able to be gleaned from a table for each record in the tbl_audits_stp2 and value for each records "AuditQuant" entered as...

I have been asked to create a list of sample data for auditing on a weekly basis. Random 5 Roads per district per week... Fine and done. Pulled from tbl_Insp based on input date criteria input on a form and a "Select Top 5" query run in individual make table and append tables to give me a...

Worked like a dream

Excellent will look at that now. Knew there should be a method but couldnt recall for some reason I was thinking of schemas.

First off Merry Xmas. But for those of you not yet on your hols, or who are suitably full of seasonal goodwill I have the following problem. I have a form function which imports csv files into a resultant table. DoCmd.TransferText acImportDelim, , "tbl_FlowlineImportCSVTemp", .FoundFiles(i)...

Redid the same query after update after replaceing xls back to dbf (ran batch to rename all the files) which wouldnt be ideal but would have allowed me to work with data to establish certain processes.... As I know the script worked for DBF I was surprised to find that when i did not enter...

Have a issue related to thread701-1551678 I am attempting to achieve a similar result, this time with excel files. code: Private Sub cmdImport_Click() DoCmd.SetWarnings False Dim i As Integer Dim SQL As String DoCmd.RunSQL "DELETE tbl_FlowlineImportGPS.* FROM tbl_FlowlineImportGPS;" With...

Anyone seen a Format like this. Latitude Longitude 5136.0770N 00035.5890E 5136.0814N 00035.5937E 5136.5631N 00034.8301E 5135.7585N 00034.4094E 5135.2930N 00033.3064E 5135.3990N 00031.5775E 5135.5574N 00029.8621E Does not seem to be any standard positive or negative.... assume it is Degrees...

After couple of weeks speaking to ESRI support (where they stated mobile 6.5 wasnt supported) I managed to resolve by forcing an update of runtime library.

Heyas, Seems this forum a bit light in comparison to the others but hopefully someone might have come across this issue. I have been using an Arcpad/Arcgis project for sometime now and have never had issues regardless of devices/OS the users are using. However have just recently purchased a...

Ummmm..... Your right I am so used to db format tables with field headers defined, there is no way of replacing A, B, C etc in Excel. One of my issues using the transferspreadsheet method of export is IF it exceeds the 65000ish rows it does not warn the user.... the dataset will just be cut...

DoCmd.OpenQuery "mktblqry_DetailsByRegime", acNormal, acEdit DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "mktbl_DetailsByRegime", "C:\Documents and Settings\" & NetworkUserName() & "\DetailsByRegimeExport" & Format(Now, "dd-mm-yyyy (hh-nn-ss)") & ".xls", True But despite...

But that would mean having to alter the query to a make table and then having to export resultant table? Anyway to cut out the make table and transfer the query results on a fly. Also I understand that transferspreadsheet is limited by the 65000ish restriction of excel. Is there anyway of...