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?

Thanks to both. I was able to access both sources with only the confusion between seat & keyboard to delay obtaining the desired response. Delving through the container objects is somewhat more involved but yields a more compact set of information (suitable for the intent of this exercise)...

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

IF (note BIG IF) there is a period where there are no updates occurring ... Make sure all local "update records include a time stamp. Collect these at one location and process in time stamp order. There MIGHT be duplicate changes, but these do not affect the final record. Of course you have...

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

Thanks. A lot. This 'trick' works as you state. Give that my project might (need?) to create a number of modules, it seems reasonable to consider placing the necessary & sufficient instructions (as code) directly in the module. This appears to be a valid approach, DoCmd.RunCommand...

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