Recent content by callipygous

PaulF, Thanks for replying Yes it still jumps - i think its cos the form is quite large size (A4 just) because they don't jump when the form fits all on one screen. im not sure how to tell the form to remain fixed and just swap between controls? Thanks Callipygous

Hi there, Im using Access 2000, DAO database app. I have VBA code under some command button that does cmdResident2.Enabled = False DoCmd.GoToControl "apparent_cause" cmdToControl.Enabled = False cmdYesOtherPerson.Enabled = True on the GoToControl part the form...

Hi there, Yeah, i've stuck it into a temp table and it works fine - it just seems an inelegant way of doing it? But i'm not that fussed about aesthetics, as long as it works. Thanks for taking time to reply anyway. Thanks Callipygous

Hi GingerR Thanks for the tip, I'm ok with charts based on queries and tables etc What happens is that my VBA proceedure opens up a param. query and loops through the recordset calculating for each date whether a client has eaten or not, storing +0.1 if they have eaten and -0.1 if not. This...

Hi there, I am using Access 2000. I have a VBA public Sub that calculates various things and sticks them into a public array - i was hoping to be able to graph this data using the chart object in Access (ie I don't want to output to excel etc). However I am not too handy with the access chart...

pdBowling - i thank you a lot

Hi there, Im doing some stuff using Access 2000 and DAO, using access modules and VBA code under forms etc.. I have a parameter query that takes its text parameter from a combo box. I want to loop through the recordset of this query but don't know how to open it. Before, i've used Set rst =...

Yes, its pretty old - DAO etc in an access module - thanks for your help, I'll try that other forum Simon

Sorry, not getting it. This is in a Public Sub VBA procedure i was using set rst = db.OpenRecordset("qry",dbOpenDynaset) rst is recordset db is my database but now qry needs the text input to run.

Hi there, Would appreciate some help with a bit of code that will open the recordset of a parameter query that needs a text entry (persons name from combobox) to run. cheers Simon