Search results

I needed to get moving on this problem, so in good old "skin a cat" mode, I've switched to writing the details to external files, which I then subsequently process in even more VBA. I'll examine the suggested site with pleasure - more later....

Hi guys.... I'm new to Access reports, so please be patient if I'm a little indistinct or use the wrong terms. I have some SQL which creates a recordset. The data in the recordset will change based on criteria supplied by the User. I'd like to create a Report which prints that recordset...

I decided I was going about this whole thing the wrong way - the generated SQL just looked SO unwieldy. Anyway, Ii had another go, and now, having got some expert help, I've got some much simpler code which WORKS. I'm therefore abandoning this thread, but not without offering my sincerest thanks...

Hi jdraw - How do I get jpeg diagrams 1) out of Access, and 2) on to this site? Meanwhile, I'll have a look at the site you recommended.... Steve

Hi guys…. I’m using Access 2003 to develop a Book lending system for a local Charity. I’ve been using Access for about six months now, so I guess the “newbie” tag is still applicable! Relevant to my question, I have the following Tables and Fields Book Table – Book Id Loan Table – Book Id...

Hi guys.... Does anyone know of a function similar to INSTR, but which will take multiple delimiters? I'd like to search for various possible substrings within a given string using something like Dim intPtr As Integer Dim strSource As String strSource = "This is a silly...

Thanks David - once I figured out the AS means Alias, and realised I could join data together, and droped the properties column count to 2 it worked like a dream! Thanks again.... Steve

Thanks David, but where is this definition (in the Properties or VBA?), and how do I use FullName? Steve.

Hi guys.... I know this is (or should be) possible, and I've spent a few hours looking around, but I suspect the answer is so obvious and simple that it's escaping me! I have a list box populated with some reference codes. When a User clicks on one of the codes, I want to display data from two...

Hi guys, and a big thanks to all responders, especially lagbolt. Yes, I’d also slipped in some simple code to Exit Access, but got the declaration wrong! That was what was throwing up the error message :o! I guess I still tend to think that whatever I’m trying to run is causing the problem...

Hi guys.... I'm trying to achieve a form displayed at startup which has several command buttons, one of which is "Display Database Window". I looked at the example in the Northwind database. Sub DisplayDatabaseWindow_Click() ' This code created in part by Command Button Wizard. On Error GoTo...

I don't want to sound popmpous, but I know it's called relational database design! In my 35 years as a professional programmer, I came to realise that opting for the best possible performance, whilst sacrificing clarity of purpose and ease of understanding is not always A Good Thing...

Hi GalaxiomAtHome... Sorry to be dim, but I don't see how your suggestion helps. Unless I've misunderstood, all you've done is shifted an individual criteria group out to another table, which doesn't seem to address the base problem of holding a variable number of repeating groups...

I know, it's probably the millionth time some newbie has asked this, so I'm sorry if this is a patience tester, but here goes anyway. I'm trying to set up a sort of "Criteria Table" for blind Users of a Talking Book library. I have a Table of "Borrowers", into which I'd like to put a...

Hi guys, it's that irritating Newbie again! :eek: Does anyone know how I can generate a Report (or a Query for that matter) which will list the name(s) of the Objects (Reports, Queries, Tables etc.) present in a database? I'd like to be able to generate, say, a list of Modules within the...

Thanks, Doc Man. I've already recoded using a version of your "Case" example (thanks). I suspect that this form of "indirect addressing" is probably a feature of very few languages, although even now through the mists of time I can still hear my ICL PLAN tutor in the late 60's intoning "Never...

Thanks for your support and advice to all those helpful people who have contributed to this thread. I now have lots of entries in my CodeSamples database (both actual code and textual notes). If I can't progress after all your posts, I need shooting! :eek:

OK David, I give in! When I was a REAL Programmer (see previous posts) we backed up nightly, and had an Operations Support Group to restore after crashes. (Trouble is, OSG took regular backups, but rarely tested restores, "with hilarious consequences"). and Dave/Gemma If I knew enough to be...

Thanks to all contributors! It would seem that code duplication is the optimum way (I can't believe I said that!). However, I've already written some code (translation - found someone else's code and butchered it) to export a Module to another mdb, so perhaps the best way is to have my...

Q - Why separate? A - I would like such utilities to be in their own mdb ('cos I'm perverse, and HATE duplicated code). Q - Which has the Tables etc. A - In the earlier example, MyCode.mdb The only "data" available to the Utilities would be that which is passed to it, either directly via a...