Search results

I have seen this done with tokens I have seen this done, fairly effectively. Every piece of text was replaced with a token e.g. "Data Entry" was expressed as token1. Take care because: Variable text lengths can affect screen design / report output etc. Currency and date formats change...

what is the LMS? Tell us what LMS means. Land Mobile Service Loop Management System Please do not assume we all interpret Three Letter Acronyms (TLA) the same way. From a man who read RIP :eek: on a project brief this week and was relieved to discover it meant "Raster Image Processing"...

Access db for patient records? What decides how many labels are required? The size of medicine bottle used? Number of pills? It may be more useful to specify the package size and allow the system to record: For Mr Blogs 200 of X in 4 off 'small' bottles. This may improve traceability and would...

My thanks to Workmad3 for suggesting recursion. I just generalised the solution to work with variable length find and replace strings (I used it to replace "$" with ""). How may your 'while based' function be generalised to support variable length strings?

I liked the solution but had a slightly different problem so generalised it ... Using Access '97 on Win2K My problem was just to remove all instances of character $ from a string Sub testsub Dim strFormula As String Windows("TempManagementHours.xls").Activate...

Use date / time functions to build report name strNow = Year(Now()) & Month(Now()) & Day(Now()) & Left(Time$, 2) & mid(time$,4,2) strFilename = "c:\myfiles\myreport" & strNow & ".rpt"

I'd buy a CD .. depending on price At $10 or less the archive on CD would be attractive but I do wonder how many people would be away from the internet but keep a CD collection handy? It may even be worth considering zipping up the archive and allowing downloads. Some care should be taken to...

Limits .. found it! and other answers Found Limits in Acc 97 help: There are many but they will not be hit any time soon! Thank you The_Doc_Man for the required search term. :) It has taken 3 years to reach those record numbers. All the back-end tables totals 150Mb and have zero churn ...

Thank you. KB 208789 works access '97 security documented Pat, I did look for an earlier version but disregarded KB 208789 because it said it was for Access 2000 :mad: Copy / Paste as suggested .. write a wrapper around the function because I have never found the immediate window on...

I have a couple of tables that exceed 200,000 and 500,000 records respectively. What views does anyone have .. is the number of records excessive for an Access '97 split database? Performance is adequate [defined as no complaints from users] so I wonder whether it is worth worrying about .. is...

access 97 security documenting / documentation MSDN has documentation on ADO and .NET .. nothing found on DAO as used in Access '97. Access '97 Documenter, for this project, takes over 8 hours to run and keeps stopping to tell me about missing queries it cannot analyse due to missing...

default value is pre- data entry .. not post Default value is the value before any data is entered. Look at the field properties for the various exit or 'lose focus' events and write a function to append .pdf if required.

built-in documenter vs SQL extract ... The documenter takes several hours to run on my database where the query and SQL code extractions ran in less than 5 seconds each. My background includes various Unix's so a small tool that does the job required, quickly, is much appreciated. I wanted...

Use form variables on export .. parameters on select I eventually used form variables on my export queries and parameters on my select queries. The function approach does shield the queries from the variables required but I prefer to see the variables being used. Thank you for your...

Access '97 I have googled, searced M$ and these forums but have not found an answer to my question. Given the vintage of the software being used the problem must have been solved .. I just need to track down the solution. How can I review and document security in my split database? I have...

Link posted .. but you already google #1 http://www.tibbenham.ukfsn.org/links.html Links to both helpcentre and recovery posted as requested. Having been mentioned on the Langa List (www.langa.com) my site, above, ranks #1 if you google for Tibbenham (as at 2004-Sep-14) .. fame at last :D If...

SJ's code .. export SQL worked beautifully SJ The function EXportQueries to export SQL statements worked well and very quickly. The file was created by the code and is overwritten if the file already exists .. exactly the behaviour I wanted. BJackson, Your code also worked but I have so...

Works .. but not quite what I am looking for The suggested code exports the query as a text file but not in SQL view. I am looking for the code as SQL (as seen in design / view as SQL) rather than the output given by the code above. Any further suggestions? e.g. Wanted: PARAMETERS LowDate...

Access '97 I have hundreds of queries that I would like to export the actual query (not the resulting records) into a simple text file. How may I programatically extract the SQL code? What I would end up with query1_example SELECT tbl_temp_crosstab.* FROM tbl_temp_crosstab WHERE...

Parameters in crosstab column headers are tricky .... Which version of Access? Because the crosstab column headings are derived from the parameter it cannot work the way you describe. I have provided 'hard-coded' column headers to a cross-tab query before now but it is a rather messy way of...