Recent content by thewiseguy

many thanks jon k - yr a legend - works a dream

i have a query that provides data like so: IDNumber - Units - WeekNo 55643 - 180 - 1 55643 - (Null) - 2 55643 - (Null) - 3 55643 - 135 - 4 55643 - (Null) - 5 55643 - 0 - 6 55643 - (Null) - 7 is there a way of adding something to the SQL to make it fill in the Null...

ahhhh - i see my defence is that someone told me that i could do that... :rolleyes: just to double check - i went into tools and references and checked DAO Library 3.6 is that all i need to do...?

something really odd happened and i have no idea why... i had some vba with some public recordsets: Public rststore, rsttemp, rstfinal As Recordset later on i have: Set rstfinal = CurrentDb.OpenRecordset("tblSTOREFINAL") everything works fine, but then one day my db went corrupt - crapola! i...

hi there, i have a continuous form called [subfrmDIAGNOSIS] with one of the fields called [ProtocolNo]. Now i'm trying to use a bit of VBA that will change [ProtocolNo] to a different value if requested by the user and this works fine for the current row. However, if there are rows already...

much appreciated - i'll get right on it...

hello there, just curious if it was possible to populate an empty tables' fields from a recordset that had been defined earlier in VBA under the criteria of a bit of sql code? cheers.

jeez-louise! i can't believe i'm making such basic errors... i stupidly closed rsttemp earlier on which doesn't help when i want to work on rstfinal! my apologies for clogging the boards - i appreciate all the time people have taken to read my problems and think about what's wrong. i can only...

thank you EMP but i think i have not made myself clear... using AND, OR and NOT on queries is fine but i'm trying to do it with recordsets that have already been based on a bit of sql code. eg: strsql1 = "SELECT [IDNumber] FROM [tblACCOUNTS] WHERE [IDNumber]<" & Me.txtIDNumber & ";" Set rst1...

my code includes the following: If rstfinal.RecordCount = 0 Then Me.autoSampleSize = "0" Else rstfinal.MoveLast Me.autoSampleSize = rstfinal.RecordCount End If It's exactly the same as I have used earlier with different recordsets but it won't work here. The...

i have three recordsets rst1, rst2 and rstfinal, all with [IDNumber] as a common field. i would like to somehow merge rst1 and rst2 into rstfinal using the following three fashions: 1) AND merge - find all IDNumber's common in both rst1 & rst2 and place in rstfinal. i.e. if rst1 and rst2 both...

recordset question hey there - there is probably a very easy answer to this but i just can't figure it out and can't find it, or maybe i have and don't understand it... i have Public rsttemp As Recordset, rstfinal As Recordset at some point in a Private Sub, i wish to set rstfinal to that of...

cheers sj - that was just what i was about to check with you... :D

just experimenting...

hi there - just wondering if this is possible... firstly i have: Public Dim rstRQ As Recordset, intRN As Integer then later, could i do something like: rstRQ.Rename = "rstRQ1" or: rstRQ.Rename = "rstRQ" & CStr(intRN) thanks in advance.