Search results

I have been trying to do it by changing the query's .sql property but I can't seem to get it right... :confused:

Ok. Basically I have a contacts (membership) database used by a number of people all of whom have some knowledge of Access but not a lot. This is a club funtion not a commercial one. The main general-purpose viewing form for members' details usually shows all records, using a query that just...

How can I change the SQL of a saved query using VBA? (Basically, I want a button to reset a query that users might have modified to a "default" setting) Thanks, George

Is there a reason where if you are storing unique values, such as, say, county names, that will always be unique and you will never need in more than one format, that you should not have a one-field table?

My bible was/is "Beginning Access 95 VBA Programming" by Smith and Sussman, published by Wrox Press (www.wrox.com). I thought it was excellent, and I think they have published updated versions.

Thanks for the db. I shall have a peek at it this evening. I definitely think that MS have got the wrong attitude. I started off with a virgin copy of Access 95, a teach-yourself-access book and Northwind. No mention of normalisation. I then bought a VBA for beginners book, and then a more...

Hi. A few questions about normalising (and yes I did search first, but it's rather a general search term...) 1) If normalising is so important, why aren't Northwind and wizard-built dbs normalised? 2) Can anyone direct me towards a good idiot's guide to normalisation? 3) Can anyone point me...

In the "on format" event of the page footer, you could set the visible propterties of the various controls to only be true depending on the value of your [Page] control. Eg : If [Page] = 1 then ctlWhatever.visible = false Else ctlWhatever.visible = true End if...

I can't work put how to make that work yet. However, I have overcome the problem another way. I have a second copy of the txtManHours textbox in the taskID footer with it's running sum set to "Over Group". A text box in the date footer just reads this figure. I have another copy with running...

So I guess the question is, how can you, in one group footer, sum a field calculated in another?

Coming to think of it, =Sum([txtPeople]) * Sum([fldHours]) would not give the right answer any way. If I had 1 person for 1 hour, 1 person for 2 hours and 1 person for three hours, the total hours worked is 6. =Sum([txtPeople]) * Sum([fldHours]) would give 18.

Summing the calculated field does seem to be where I'm coming adrift. The problem with =Sum([txtPeople]) * Sum([fldHours]) is that it works out Sum([fldHours) as one lot of hours per record, whereas one record can in fact be equivalent to more than one worker. In otherwords, there is a number...

I have a report showing how many people are working at various tasks. The report has a group header for [Date] and beneath that a group header for TaskID, which has the [fldTaskName] and [fldHours], which is the number of hours that each task takes. The Detail section then contains the people...

I have already go a form that does what I want using forms like those contained in Northwind. I have a list box to select a Customer and a list box with all the Events. Double Click on an event and it creates a record in tblCustEvents with the CustID, the EventID and a field for number of...

Hmm. Not really following this. :confused: The three pieces of info that I need are the ID of the Person, the ID of the event and the Number of tickets. I'm no sure which of these you are proposing should be stored in which of the new tables (tblPurchase and tblLineItem). Also not sure...

Well I find it complicated. I have a table of people, each with an ID, and I have a table of events, each with an ID. I want to design a form in such a way that when you look at each person it gives a row of event fields, one for each event, into which you can put a Number for the number of...

Hmm, well I seem to have solved the problem - so far - by using one table based on a join query rather than a table and sub table each with it's own query. As I say, that's probably obvious to other people, but it's new to me (and whilst I can do lots of pretty things wih VBA, SQL is completely...

This is probably really basic stuff to most of you, but here goes. (In the past, I have always had tables with zillions of fields, rather than having linked tables, so I have never had to mess with this stuff before...) I have a db with 2 tables. A Main table with, say, contact names and...

Ye gods! That was quick! Works a treat. Thanks! George

Hi. The following code returns an "Item not found in this collection" error so I am obviously trying to use the wrong way to refer to one of three yes/no fields in my recordset, defined by an optiongroup on the main form. Can someone please tell me how I should be doing it. Thanks. George...