Recent content by Callum

Hi guys, searched around for awhile with this one but none of the 'solutions' seemed to work for me, the situation is i have two forms, looking at the same table, but the main table shows more records, i would like to select a record in the datasheet subform and have the main form flick...

ok tryed your example CazB works perfectly, looks like i thought it was more awkward than it should have :banghead:

hello, as stated in the title i would like to sum up 5 fields and save (or just show it in the form view is enough really) in a seperate field, i have managed to sum the 5 fields, but it summed up all 5 fields in all records, i'd like to have my form show the sum for the record, not the table...

hi all, i have nocked up a button to send an email with the information gatherd from the record. is it possible to set the emails flag date-due for the person while the email is sent? the email is sent using the SendObject command. thanks for any help.

would you care to expand on the Dlookup? thank you for the tips

hi, heres what i want to do. i want field 2 (Address) to be based off field 1 (Names) so, name = John address must be = Street1 is this possible? ive tryed to put in the afterupdate part this: If Me.name = "john" then me.Address = "Street1" doesnt work, but no error, help requested, thanks

i need it to be automatic, i can have querys bound to open when the database is opened, or maybe when a form is closed. can i make a table out of a query if the table it will be replacing is opened in another linked database? i have already done the selecting and then just making a table out of...

but then i would need to make the query into a table, im using access in conjunction with a GIS so i need a table to upload, not a query. this is the dilemma. thanks.

Hi all, never made one, never used one, but now i think i need one. a delete query. what my setup is at the moment is a table has had a make query table used on it to produce a very similar setup table, containing the same information using an append query, but less fields due to not wanting...

i haved used the Form dataentry to populate an Id automatically as best as needed, thanks to all that helped.

i'm currently using Access 2000 , MapInfo cannot use queries for layers which is really the dilemma. mapinfo fits into my activity when i plot the X and Y columns into mapinfo have 3 seprate tables, so when interogated for information the object on the map has the same data as the record it...

you cannot concatenate within MapInfo, THAT is my problem, i want both to be in the same field within MapInfo. and to do that they need to be within access

NDE123 will be NDE123 indefinatly, all the records in the NDE table will be NDE(number) there is other tables with other three letter codes hence why just having number is NOT unique, the reason is after they are put into mapinfo, there shall be more than just one record with the number 123 etc.

Hi guys, first post my problem is quite simple (as far as i can tell) but none-the-less i'm stumped. what i want to do is merge 2 fields into a separate field with the first field being Unique_Id (autonumber, indexed and no dupes) merge with the second field Type (3 letter field) so it...

Hi guys, first post my problem is quite simple (as far as i can tell) but none-the-less i'm stumped. what i want to do is merge 2 fields into a separate field with the first field being Unique_Id (autonumber, indexed and no dupes) merge with the second field Type (3 letter field) so it...