Search results

please help... :(

crumbs - figured out what i needed to do...i think. initially: Public qn As Integer, check As String, category As String, variable As String, crita As String, critb As String, _ critc As String, op As String then: Public Sub CheckBox(ByVal qn) check = "check" & CStr(qn) category =...

they are unbound for now (it will eventually/hopefully form the front end of a generic query engine) i was gonna get onto that later...

i must apologise - my wording/explanation is confusing even me i hope this will make sense and you may be able to help me. i have a form with many rows of unbound fields (each row being a mixture of check/combo/textboxes) for row 1 i have fields called check1, category1 ... op1 for row 2 i...

I need to call on this "Public Sub check" routine several times and in each case it will refer to a new set of fields: for example, in the code above, it must operate for Me.check1, Me.category1 ... Me.op1 then later, I would like it to work on Me.check2, Me.category2 ... Me.op2 and so on...

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

anyone got any clues???

you guys rock! :D this is exactly what i needed.

gracias amigos! cheers guys - much appreciated :) i haven't implemented the code yet, but will it cause windows to momentarily flash open and close or is it so quick that you won't see anything?

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

crap - sorry - i explained myself badly! i meant objects within a form like text/combo boxes. not the form itself. sorry again.

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 -

thanks to both dcx and vince - can i ask is there a difference between using max and last?

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

cheers RichO - i'll try it out first thing tomorrow

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

d'oh - just figured it out using: DoCmd.GoToRecord , , acNext Me.firsttxtbox.SetFocus sorry - still learning! :D

anyone got any clues??? mars-bar for the winner!

sorry - i wasn't very clear the first time... i'd like to use an IF clause to check if data has been entered into the current continuous form row (say check IsNull(firsttxtbox)). if it's null, i've got a setfocus command to take the user to another subform. but, if he has entered data in, i'd...

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.