Search results

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.

:o cheers JonK - i just figured it out as you sent me a post... my " was after the AND instead of in front of it. yeesh - i feel really embarrassed for such a silly mistake. my only excuse is that i'm still learning and i can only learn from my mistakes. as for the dates - the input fields...

no luck i'm afraid - thanks for the ongoing help! just tried leaving out the 'AND' and the error message showed that it was recognising the IDNumber and the OrderDate correctly to what I had entered as test values, but just missing an operator. So I put the 'AND' back in... I bet it's...

no luck. it works when i use DCount on: If (DCount("*", "tbl:OrderHistory", "[IDNumber] = " & Me.cmbIDNumber)> 0) Then or: If (DCount("*", "tbl:OrderHistory", "[OrderDate] = #" & _ Me.txtOrderDate & "#") > 0) Then I just can't get the option of both :mad:

It's still not working - I get Run Time Error 13, Type mismatch. I've looked to see I've spelt everything correctly and it all is. IDNumber is a number field. Yeh - i know it's the incorrect naming for the table but i'm taking over this db from some other perp so renaming everything would take...

hi there - i need to check that details of an order have not already been entered for the inputed IDNumber on the inputed OrderDate. in other words, i want to make sure that details of IDNumber 123456's order cannot be entered for 1/1/01 if an entry for that IDNumber with that date are already...