Search results

In simple terms I'm writing code in "MyCode.mdb", and want to execute a Utility where the utility code lives in "Utility.mdb". Sort of like - Call "C:|Access|Utility.mdb(SomeUtility(param1, param2))" The more I look at it, the more unlikely it seems, unless I can sort of compile the utility...

Thanks David, I've already got the code (and yes I do use the Split function!), but my question is how to "Call" it from an unrelated Project?

Hi guys.... When I used to be a proper programmer - i.e. on a real Computer (a Mainframe :eek: (is anyone else old enough to remember them???)), I used to build up a variety of general purpose subroutines which could be called from other programs. Is there an equivalent methodology in VBA...

OK guys, I guess it's one of those "back to the drawing board" times. :o Thanks anyway for trying to help!

Hi Brian.... I'm not sure how else I can explain it, but here goes - In other languages with which I am (much more) familiar there is the concept of "variable substitution". When executing variable substitution, the value of a variable is the name of another variable. What I'm trying to...

Hi guys.... What I'd like to achieve is to have a calling module (let's call it FROMModule), and a called module (lets call it TOModule), and in FROMModule to set up the name of a Public Variable, and call TOModule with the name of the variable, and have TOModule determine the value of the...

Bob - I'm really impressed by your site. The Database Reset utility works like a dream. I'm just not sure that coding so powerful should be freely available to inquisitive little erks like me. :D Now, I've just got to figure out a way to disable the "Run Sub/UserForm" function (for my own...

Sorry guys, I just found out about "Compact and Repair" - please ignore this thread.

I have a module which adds records to a Table. The Primary Key for the Table is defined as Autonumber. As I'm in the testing phase, I've some code which deletes each record in the Table, to clear it down prior to my next effort. However, the Autonumber field (as you would expect) just keeps...

Thanks again Paul! I've also been investigating other avenues (i.e. learning by my mistakes in a trial and error sort of way). If I've read it correctly, if I open a recordset as a dbOpenDynaset, (instead of dbOpenTable) then issue a FindFirst with an operand holding some sort of criteria, and...

Many thanks to pbaldy and Bob Larsen. I know that putting a count in the Authors Table is a silly idea for when the project goes live - I'm an old programmer, but new to Access VBA, so it was more of a challenge than a requirement! Especially when I found out I couldn't do it!!! I'll look at...

Hi guys, time for another newbie question. I'm "improving" an existing Table It's a table of books where the author is unfortunately specified in one of two ways - "Joe Soap", or "Soap, Joe" (it's a historical thing!). I decided to tidy up the Book Table by running down the table extracting the...

Hi guys, it's that irritating Newbie again! In the following code I would like to define 'pkWorks' as the Primaru Key for a newly created 'Works' Table. There doesn't seem to be an "Autonumber" type, or a "Set as Primary Key" function. I know I'm missing something basic and obvious - can anyone...

Hi guys! Once more, sorry for the Newbie type query. I'm trying to write some Access 2003 code in an Access Module to create a new (i.e it doesn't already exist) database. The code is shown below. As usual, I've fallen at the first hurdle :( On execution of the "Set db = OpenDatabase....."...

Thanks lagbolt - all info is worth having, but in this case I don't think it answers my problem. I wanted a Sub rather than a Function, 'cos what I'm trying to do from the calling ("TopLevel"") Sub is call another Sub ("PopulateIt") in order to populate an array defined in the calling Sub...

Hi guys, it's that thick old Newbie again. I'd like to achieve the following (syntactically incorrect) task of populating an array in a subroutine. I'm not bothered about the "invente" task, but I'm going a bit weird trying to find the syntax to pass an array definition to a subroutine, so...

Thanks Bob, I've bookmarked the FunctionX sites, and will plod through them, trying to avoid those annoying :mad: "roll-over me for an advert" words! Steve

lagbolt.... You're certainly saving me a lot of "I wonder if you can....?" searches :). I think I should have been more forthcoming about my level of Access code experience - to date somewhat less than 12 hours, so things in your replies are only just starting to make sense (like references...

Thanks lagbolt - some interesting concepts, but I can't help thinking that the approach misses the "select by genre" option, which, coupled with the arrival of new books, is why I think that the "stored seach" approach may be the eventual answer. Sadly, :( I've got a lot of learning to do before...

Sorry for this ridiculously amateurish query – I’m a recently made redundant ex-mainframe programmer with a smattering of Microsoft VBA code , doing voluntary work for a charity for the blind. The Background We send out “Talking Books” to Borrowers. We use Access 2003 to keep track of what’s...