Recent content by MrTibbs

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