Search results

I am trying to count the amount of records that have been updated from an update query.. ss = "UPDATE flights SET flights.departairport = [Forms]![flights]![txt_depart], flights.arriveairport = [Forms]![flights]![txt_arrive], flights.duration = [Forms]![flights]![txt_duration]...

I'll help if you want - email me directly by clicking on the little 'mail envelope' above this message

If you run a query, looking for all info. In my example i am looking for all flight details between txt_date and txt_dateto - which are 2 fields on my form - so i enter the dates and it finds all the info between these dates (for flights belonging to the resort ) SELECT [flights].[flightid]...

Jack - thanks for your input.....BUT All it seems to do is crash ACCESS 2K MSACCESS caused an invalid page fault in module MSJET40.DLL at 0257:1b04117a. Registers: EAX=ffffffff CS=0257 EIP=1b04117a EFLGS=00010246 EBX=00000000 SS=025f ESP=0062e628 EBP=0062e6ac ECX=02dd52fc DS=025f ESI=02dd5454...

hi, i keep getting type mismatch on the following code whilst trying to set a recordset as a query... is this possible or have i just got the wrong syntax ?? Dim rst As DAO.Recordset '(DAO.Recordset for 2000) On Error Resume Next Set rst = "SELECT ([flights].[departairport]...

OK ok ok.... So at the moment the code loops through from BETWEEN txt_date and txt_dateto, adding the rows and filling the data in. What i need to do though is UPDATE the data if it already exists with that date and that flightsresortid. My previous attempt looked at performing a query to see...

thanks Rich - it's funny when you get caught up in things, you miss the obvious !! Cheers again Phil.

Hi Rich ( or anyone ) can you please see previous message.. http://www.access-programmers.co.uk/ubb/Forum3/HTML/002304.html I was wondering if you could help again.

is it possible to do a similar looping process as you have mentioned, but by using 'Insert into ....' instead of all this rst.blah ?? It has to loop through the rates field BETWEEN txt_date AND txt_date_to, inserting the same data with the only change is the date= date + 1 ( day ) The reason i...

hi, i am using the between function to pull records from my rates table between txt_date and txt_date_to. It therefore finds all those records ok and displays them on a form, with "warning, you are about to overwrite exisiting data below". Hit the Proceed button and i run a delete query based on...

What if the dates entered in the text box don't exist? i.e. 29th Feb 2001 does not exist. how do you check to see if the date is valid ?

I have seen Pam Hartman's excellent advice in pointing towards the Microsoft website. I now realise that you cannot update and append if the table has it's index as an Autonumber - i'm stuck then !! A work around i am going to try is run a query before the data entry, which looks to see if...

Hi, i am filling data between dates on a form. i.e. enter date from, date to, other data => fills table with 1/1/01 other data 2/1/01 other data 3/1/01 other data etc etc Someone ( Rich ) kindly showed me the best way of doing this with the following code. My problem is that if data already...

unfortunately i think you are right... damn ! Thanks again

Hi steve, problem solved from another Steve Thanks for you input though

Hi i have a dataset of Counrties, Resorts in country, Hotels in resort. I have multiple entries for hotels in resort as each hotels' prices on a particular day are stored ( hotelname, date, price ) i.e. Alicante hotel 01/01/01 £99 Alicante hotel 02/01/01 £89 Alicante hotel 03/01/01 £59 When i...

have since read through the whole ocnversation and i now understand where the comment came from. Did you per chance take offence 'cos i said "(for those of you who want the correct code...)" If so, i mearly meant 'correct' in the contaxt of what i had previously dicussing which was issues with...

I'm afraid you've got me there.... I don't know enough about Access to know if oyu are being serious or sarcastic. Either way are you trying to make a point? as to be honest i wouldn't know which version is better than the other, so not really sure where your response sprang from ? Thanks for...

?? if you want

figured....ADO 3.6 not installed, so i installed that. I then had a problem with the Dim rst = Recordset etc etc. I had to Dim rst as ADO.Recordset then it all worked fine. Thanks very much for that Rich - really appreciated. I'm now not quite as bald as i thought i'd be from pulling my hair...