Recent content by sts023

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