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...

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...

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...

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)...

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...

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...

I have an issue exporting the results of a query to xls file. Seems to occur when query exceeds 17000ish lines otherwise functions fine. DoCmd.OutputTo acOutputQuery, "qry_DetailsByRegime", acFormatXLS, "C:\Documents and Settings\" & NetworkUserName() & "\DetailsByRegimeExport" & Format(Now...

Long winded subject title I know, but was hoping would attract someones attention that might think hey I know how to do that was trying just the same thing recently. Anyway I have a back up folder of files including relevant .dbf files. These files are ALWAYS the same filename but reside in...

I have the query: SELECT TOP 10 PERCENT Rnd(tbl_InspectionAudit1_1.COMPKEY) AS Expr1, Now() AS Expr2, fOSUserName() AS Expr3, tbl_InspectionAudit1_1.COMPKEY, tbl_InspectionAudit1_1.COMPBY, tbl_InspectionAudit1_1.AGENT, tbl_InspectionAudit1_1.REGIME, tbl_InspectionAudit1_1.INITIATION...

I have a shell command to open regular non secured db using: Call Shell("W:\Program Files\Microsoft Office\OFFICE11\MSACCESS.exe " & MyDb & Addit & dbName, 1) However I have another db in the mix that I need to open which is secured I can force it open from a normal desktop shortcut...

Heyas all, Long time no see. Don't know whether that is because I have been able to do the things I need to without assistance.... or whether I just haven't been all the things I need to at all and sit sharpening my pencils instead. *cough* Anyway Happy Xmas And to celebrate the new year I...

I have a table which is used as a selection criteria Where the value is null this is represented as "UNKNOWN" What I want to do is then pass this back to another table as a query. This is as far as I have got. SELECT IIf(tbl_AllSLMastr!Town Is Null Or...

I have a program of works that are done as part of various regimes ISF1 = Monthly ISC1 = Monthly ISF3 = Quarterly ISC3 = Quarterly ISF6 = Six Monthly ISFA = Annually I query another database against my programs SELECT IMSV7_INLAI.STARTDTTM, IMSV7_INLAI.COMPKEY, WholeNetwork_Regime_3.COMPKEY...

All, A brief question before I make an fumbled attempt of my own at trying to resolve this. I currently have a MS Access database sitting on a Citrix box. Users connects via logging on through citrix without any interface with any desktop. Instead the connection opens up the MS Access database...

I have created a query that gives me a count of all records by a particular person per day and ordered it by date by formatting a year month and day field and ordering by that progressively. SELECT tbl_AnnualServInsp.Date, tbl_AnnualServInsp.DBName, Format(Tbl_AnnualServInsp!Date,"dd/mm/yyyy")...

Heyas all, Me again =( As there is a means of formatting a Date field result, is there an equivalent function for edditing text. IE I have a link to a table that has a compkey as its unique identifier, and a UnitID as an asset identifier. The compkey can be expired but the UnitID has to be...

I have a problem (so my pshychiatrist tells me) that I have been looking at recently which is, of course, causing me some problems. What I am looking to do is a report based on a data selection and report a 10% (or other percentage) of the result. I am trying to use the random statement...

All I have run into an issue with my database. My DB is running on a Citrix box and I have recently found that I am getting records slip through duplicate record trap. Private Sub Date_AfterUpdate() If Not IsNull(DLookup("[UNITID]", "[tbl_BCCInspection]", "[UNITID]='" &...

New saga in the database from hell. For a long time I haven't had to hinder you with my trials and tribulations..... but now I have a new humdinger on my plate. I have need to create a form that performs multiple functions. 1)Allows the user to select a .csv or .txt file by browsing to a...