Search results for query: *

Since MS has Abandoned The product, Where have the adherents moved to? Since there are probably several choices, is there any discussion of the relative merits &/or demerits of the possibilities?

...of information (suitable for the intent of this exercise). MSysObjects yields a much richer data set and is of course also more easily access - as long as operator is comfortable with SQL. Then, MSysObjects also includes some data which is not readily understood (e.g. the LV* fields)...

I would like to be able to access the "update date" of the various MS Access objects ... Forms, modules, tables, Reports Databases, ... et al as well as the sub entities. I can easily(?) get the various objects via the containers, but do not see any data properties associated with rather the...

Logging in/out doesn't work when error exiting - unless you include extensive error reporting in ALL of your code (every procedure / module). Even then, some crashes / errors in the logging may occur You mention "Your" front end. I generally utilize a separate development version of BOTH FE &...

...of the results and error checking. Alternatively, just advise the "powers that be" that the current schema is entirely unsuitable to the process. What *(&^$*(&#$E^( dreamed up the concept of maintaining a database with multiple users without the proper structure and band width? MichaelRed

There are numerous FAQs re date calculations. The better ones utilize a table of HOLIDAYS. Please look up one (and use) or more of these. Many experienced programmers utilize a comprehensive date table which include one or more holidays fields to accommodate the difference in the celebrated...

Thanks, Phil (aka vacunita). The Win + R box does what I needed. MichaelRed

Thanks for the explanations? At the end of it, however, I'm just looking for a way to have a way to start an OLD app from the "command line" (e.g. "start Menu") interface to activate a start up command. Can this even be done in Win 8? MichaelRed

See faq702-4019 MichaelRed

see faq702-4019 for ONE example of a member contributed solution to ROUINDING. Not necessarily my favorite. The issue, for me, in your posting is that it IS incomplete. I might be searching for a solution to this - or a similar problem, but am missing a number of the pieces as posted. Thank...

Karen, Thanks for your response. An issue w/ posting partial solutions is that anyone responding cannot know what is missing. I recognize this "procedure" needs to be called from a Form {e.g. the Key Word "Me"}. When I mention the "roundup" procedure, I should, perhaps, have elaborated to...

There is an ANCIENT fortran program called "Linear". This function would provide you with the (again) ARCHAIC code which easily forms the basis of such a project. This was "once upon a time ... in a land far away ... available from Oak Ridge National Laboratory under contract # W-7405.eng-26...

I do not know what data type will accept the "string" in the first code box. So to begin, I would want to know how to deal with getting programmatic access to the thinnngggggyyyyyy. I suppose there could be an array of strings or several arrays with different issues? I made a BRIEF attempt to...

Not really my kind of thing, so please have some patience? varbookmark doesn't seem to ever be assigned a value? numStrings = -Int(-1 * myCharCount) / (2000) ' SEEMS to be overly complex, while insufficient? from debug: myCharCount = 13000 numStrings = -Int(-1 * myCharCount) / (2000) ...

After reviewing numerous threads numerous small clues in several allowing the turtle like speed of my 'brain' ... The last and apparently most necessary: you MUST [COLOR=red] save AND compile all modules /[color] before creating one! Compile does NOT (as was pointed out) save the module (it...

...get there. ? err, error(err) 2046 The command or action 'SaveAllModules' isn't available now. The 'documentation' mentions the acCmd* group is available as the Menu items. I admit I cannot find this on any of the 'standard' menus. Alas, alack & awry perhaps a clearer head will...

Thread 705-153380 provided the function code below. I know it worked when posted for Ms. A. 2K. I am trying to use it I Ms. A 2003 and get a failure on the line indicated (to SAVE the newly created object). The error is : Debug.Print err, Error(Err) 29068 Microsoft Office Access...

This was an issue a long while ago. Access 2003? Supposedly fixed ... The Autonumber field could be corrupted on multiuse networks due to the timing issue between users traffic. A workaround was posted hese (Tek-Tips fora) however I do not rercall its' propper name. Basic premise was to have...

Somewhat dated? But there still exist a fq (181-261) which provided a soloution ... MichaelRed

There is no need to print blank lines. Count the real record lines per the page number ("N" from Page N of M) When the necessary number is reached, cause the process to unhide a page break symbol (hoperfully in the page footer?) and stop printing the 'section' (presumably the detail?). The...