Search results

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...

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...

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.

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...

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.

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...

i'm new to VBA so please go easy on me... what am i doing wrong with the below code? it keeps bringing up an error message saying "Invalid use of Null". Private Sub check1_BeforeUpdate(Cancel As Integer) Call CheckBox(Me.check1, Me.category1, Me.variable1, Me.crit1a, _ Me.crit1b, Me.crit1c...

hey all - i've come across something quite odd and i don't know how to fix it... after placing a new listbox on a form and sourcing from a query, i decided to change its font colour. all the columns and column headers changed to this new colour except one column of data which remains black...

Is it possible to rename a form object in code...? I've tried using .Name but an error message will pop up saying this is only possible in Desgin mode... ...and .Rename does not operate on Form objects. Cheers -

hi - sorry if this has been answered before but i couldn't find it exactly... i have a table with data similar to so: ID number Date Area Region 26784 14/2/03 Lower 2 37772 27/8/03 Upper 1 37772 1/3/04 Upper 3 50101 12/12/03...

hi there, in a contiunous form i have the following fields: cmbstockitem - bound to list of 5 txtrequestedamount - a number field represently quantity to be ordered autostockunit - unbound but automatically set to the appropriate unit as soon as cmbstockitem has been selected (eg litres, kg...

hi there, is there a way of allowing the user to press the tabkey at the end of a row on a contiuous form and shift the focus to the beginning of the row on the same form? i was hoping to use SetFocus in vba but i had no idea what expr. to write to identify the next row... ta very much.

hullo there - i'm using the following code for a 'clear & exit' button If MsgBox("Are you sure you wish to clear the current record?", vbQuestion + vbYesNo, "Clear Record Verifification") = vbYes Then Me.Undo DoCmd.Close DoCmd.OpenForm "frm: MAIN MENU" GoTo Exit_IVClearExitButton_Click this...

i'm using dcount for the first time to make sure that an ID Number cannot be repeated. however, after it occurs once, it will stop any further valid ID Numbers being entered. i'm guessing that i have to reset Dcount, but i am unsure as to how. i'm sure it's really easy to do but i'm a bit new to...

I've got a button at the bottom of my form that checks that certain fields are filled in correctly, and if they are, opens up a new record. However, upon a new record opening, the tabform part always sets itself to page 6 instead of 0 (i.e. first page). What the...? Cheers :D

After doing a bit of cleaning up I found that every time I tried to use a form, I'd get an error message saying that it could not find Macro16 (an old one that didn't have anything in it so I deleted it). After searching every field, I can't find where it references to this macro. Is there a...