Search results for query: *

I'm not sure if this works for Oracle but I had this issue in the past with linking via ODBC to SQL tables and if they contained a bit field (if I remember correctly) then one solution was to add a timestamp data field to the relevant SQL table. This always worked for my issues - not sure if...

http://support.microsoft.com/kb/2687441 Microsoft broke it in their recent Security Updates.

Is the data for State, Clients held in a table (with this structure)? Is it updated, or deleted and created fresh every day? Can you change the structure if required? Got a couple of ideas how to do this but need to know a little more info.

mbtransport We have many front end / back end access applications and I use some functionality and code which allows for auto updating of users' front end versions. I've covered it to a certain extent in this thread: http://www.tek-tips.com/viewthread.cfm?qid=1646138 But if you want any more...

Cheers mate - that looks perfect. I need to just check one at a time as on the Form, I have some functionality which needs to run or not, depending on the format of this particular string. Cheers!!

Got it thanks - Me.ActiveControl.Name Cheers

Is there anyway of capturing the name of the button just clicked in its OnClick event? Obviously I know the name and so could 'hard code' it in, but I'd like to call a particular function from many different buttons within my app and I need to pass the name of the control used to that Function...

So can I just do it as I would in a query as in Like "###-#####"

I have a field on a form which displays the values from a text field from a table. There are numerous formats (i.e. combinations of alpha and numeric characters) that the values can be in but I need to test if the value matches a specific format, e.g. nnn-nnnnn (where n is any numeric character...

Could you post some sample code of where it breaks?

I did something similar in a database which manages individual documents which are combined into controlled hard copies. The way I did it was to have a list box which lists the Documents in a particular dossier. I then select from the list box where I want my new document to appear after, so...

Well, I do a lot of Document Management DB work. What I usually have is a unique ID for each 'Document Record' and then this unique ID can be related to the filename (to be honest, I don't normally save the filename into a table but use the unique identifier to create a filename so I can create...

Hi I have a large approx. 400,000 records which have a text field of up to 250 characters in length. I would like to search for a text string of a particular format, for example, LLL-NNNNN where L is any letter and N is any number and if found, I would like to extract the particular string from...

Well blow me I've found it :) The link is here: http://www.databasejournal.com/features/msaccess/article.php/3286111/Automatically-Deploy-a-New-Access-Client.htm The guy's name is Danny Lesandrini. I remember emailing him when I came across this link and he got back to me within a day and...

My version 'overwrites' the current front end version by copying across the new master version, overwriting the existing file, so it always opens in the same location. The basis of my code I received from someone else a long time ago and I have modified to suit. Wish I could find the original...

No worries - if you have any issues let me know. I have rolled this out in about 10 systems here at work. Once you get it right for the first time, it's so easy to include it in all systems. If you get stuck, I'll help out.

There is a way of checking for a new version and automatically updating it if it is out of date. It is something we use on virtually all of our 'Front End' Access applications. For this to work (as we do it, you can probably modify slightly if required), you need a central location to store the...

Excellent list!! Loving number 17. Superb.

To add to the list of redundant duplication, I deal with Document and Records Management systems a lot, usually referred to with the acronyms EDMS and ERMS and I very often see people talking about an EDMS System. Surely just an EDM System?

And so it's Friday I rejoice for the freedom The weekend gives us