Recent content by MicroZealous

We use Key 4 to define "employee size". Some imported records have numbers that are stored as text. We want to convert these strings to number format and populate another user defined field. How can this be done within GM, or if not, with an external SQL query? GMPE 8.03.80716 SQL Server...

Thanks for your help. I really did try the Help file, etc. What I needed was the syntax: "SET myField = '" & VariableName & "' " Mike R

Is Windows Defender also a suspect? Before I Disabled this Service, the disk was manic for about ten minutes after startup. This Just In: Soon after disabling Defender, my machine caught MalWareAlarm. Coincidence.... or Satan? Those &%$#@*() ! Defender service now starts automatically, and...

Here's my design: tblSettings holds public variables to survive program closing. When access starts, I use DLOOKUP to populate the public variables, always from tblSettings.ID = 1. This is working. VBA code may update any of variables as needed. OK. Now I want to save the variables as...

I just learned how to use DLOOKUP to set a public variable. Now I want to write that variables value back into the table. I have looked in help files, but don't know the words I'm searching for! Just a hint or a simple example. TIA.

This reminds me of a related problem I had once, when importing a text file into a payroll application. The root cause was obvious when I realized the import failed when it reached "John Smith, Jr." !

PHV: Thanks so much for your reply - I appreciate the help a lot. I've been offline recovering from the URI that's going around. Yes, I did try your solution, and it works fine. Doing some more research on this problem, I discovered that this is a common and complex problem. See...

I AM feeling better, thanks. I'll be even better once this puzzle gets solved. I can't imagine that it's very difficult, but I've looked at it so long I can see it anymore, ya know?

See if this makes sense: Here’s a sample: UNIT table ID NextLevelUp A B A C B D B BUDGET table UNIT AMOUNT C 2 C 3 B 1 B 4 A 6 A 5 D 9 Sum AMOUNT for each level, and levels below. Results should be: D 9 C 5 (2+3) B 19 (1+4) + C level + D level A 30 (6+5) + B level

I have a simple Budget database, with expense line items that relate to Organization Units. The Organization Units are in a tree structure, with each Unit relating to one Unit that is higher up the tree. Currently, there are three levels, but I need to provide for four or five in the future...

Good Evening; I have about 250 Word documents, and have created an Excel sheet as an index. One row per Word doc, with a hyperlink to the actual document. Now: How can I retrieve Word doc Properties (Title, Subject, Keywords, number of pages, last saved date etc) into cells in the spreadsheet...

Hi Kids! (Using Word/Excel 2002) I have about 250 Word documents, and have created an Excel sheet as an index. One row per Word doc, with a hyperlink to the actual document. Now: How can I retrieve the Word doc Properties (Title, Subject, Keywords, number of pages, last saved date etc) into...

Maven Bacis Teaches Typing" (groans) . . .

Given cjelec's definition from the Stanford dictionary, the US Presidential campaign qualifies as a sport, if we define the US voter as "a solid, inanimate object". Plus, we have screaming, rabid fans. Discuss.

Some of my favorites(not). Adding the word 'not' into a question. Using 'we' instead of 'you'. Example: "Did we not get this fixed?" (snarl)