Search results

recordsources are great for creating automation within your database. Say you have an excel file with a million records and you only wanted to import the names that match a set of names you had stored within a table then thats wat a recordsource is great for b/c you cant create a loop so that...

alternately you could create a SQL statement which captures the data from the form text boxes/ combos etc.. then refer this to your table and delete. Simple and effective.

use the Requery function refreshes the data without having to open/close a form. i.e say we are dealing with combo boxes then something like this: Private Sub Combo1_AfterUpdate() Combo2.Requery End Sub etc.. you get the idea use it in the form load or where'ever its hard to tell you...

you contradict yourself many to many relationships are bad hence having to create a junction table in order to make it into a one to many relationship.

sounds like school homework to me.. hehe plenty of places you can lookup and learn this info yourself as Yevs has posted, their is also this funny little website called google. its awsome....

Look up query's and how to create them. Once you worked out that press the totals button looks like this: ∑ Then change the drop down box to count where you want on the field you want it to count.

http://www.cs.jcu.edu.au/Subjects/cp1500/1998/Lecture_Notes/er_model/f2-2c.gif just google it there are plenty of examples. Just so you know many to many are bad & portrays bad db design.

work for the NHS... bahahahahaha! I've seen riots better organised than the NHS!

well the impression i got from his post is that he has a Db which contains all these parts & prices etc.. but he sed that some people request kits so these kits could be made by concatenation of strings. alternately the way he has explained it he could simply have a sort of shopping basket front...

well you dont really make it clear what you want.. but I have one word for you too look up: Concatenation. The process of adding strings together & you could also aggregate functions to add prices up aswell etc.. blah blah!

i find the site unbearable at 12 - 1:30pm UK time apart from that its pretty swish for me...

tru rich tru.. it has been a sucky sucky year... its volcano's actually bastard things attribute like 60+% then at the other end of the scale its humans. & remember alotta people get confuse with Global Warming and Pollution in general. But if stats man was just talking about humans then yes...

rubbish i wrote a nice big post for you duncan but it got deleted.. baisically im 99% sure you dont have a Requery statement for your gui. If I was you I'd create a nice little update button on that form using a UPDATE WHERE statement and requery everything after that.. you follow?

look at sample db's plenty examples of search features in their.. & how are the tables updated ? is it via a nubmer of link tables or wat? its probably a case of setting the data refresh time but its difficult to say without knowing how the update information is provided...

exactly instead of everyone raving about global warming just stfu and wait for the government to enact common sense policies such was wave / wind turbines etc..

depends where this information is stored.. if its all hand written then of course its gunna take a fair amount of labour to insert all these however if its all stored on excel spreadsheets, word files etc you can just create an import script to import the records and organise them how you need em...

Go for it m8 i've had my console for a year now its a premium edition one so its the original white one with all the mod cons on it... and it has crashed a couple times but that is purely due to the games that have been released. Being honest the only game that has crashed on me was Tom Clancy -...

human contribution to global warming is something like 5.38% ergo quit all this global warming crap and go with the flow its a natural cycle of the world & history proves this (Iceage's etc...) sure we're speeding it up a little but in the words of Agent Smith in the matrix & Hans Blix in Team...

By Tab im geussing you are refering to WorkSheet names in Excel. Thus this is how to do it in VBA, a Macro should be pretty much the same. DoCmd.TransferSpreadsheet acImport, , "Table name", ReturnResult, True, "TAB NAME"

mmm boobies :) .... dammit boss wat was i doing??