Search results

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

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

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

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

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

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

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

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

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