Search results

hey all. heres a bit of a challenge: i have 6 forms with about 100 controls(a mix of checkboxs, textbox, and group controls, and combo boxes as well as labels and each form varies in the number of controls) on each on. each control, that im concerned with, is named in this manner: Q000...

cool ill take a look at it. thanks all

hi everyone. im trying to create a string builder and ran into a problem. i have a form with 185 controls on it. i want to create an automated sql insert statement using a for loop. (ie. insert into MyTable (q000,q001...q185) values...

woot well, finally got it: the keydown event for the form: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) HandleKeys KeyCode, Shift End Sub call this function: Public Sub HandleKeys(KeyCode As Integer, Shift As Integer) Dim ShiftDown As Integer Const KEY_j = 74 Const...

will this work: On Error GoTo errorhandler Dim intCurrentRow As Integer 'counter Dim strItems As String ' string to make new rowsource If Me.List1.ItemsSelected.Count > 0 Then 'check to make sure something was selected For intCurrentRow = 0 To List1.ListCount - 1 If...

anyone know a way to capture multiple key strokes when a form is open? when a form is open and the user presses a combination of keys at the same time (ie cntrl+j) i want an event to fire. (much like when you hit cntrl+alt+del in windows) microsoft access 2003

hey everyone. im trying to create a control that, when the report is opened, will change text according to a condition. example: on my report i have a group header. if the group header's text equalls "11" i want the text/caption to be changed to "Lobatse District". ive seen that you can...

these are some form formats you can change: open the form in design view. in the blank area arround the form, double click to get to the forms properties. 1. changing record navigator to off will remove that arrow 2. change auto resize to yes (that might fix your resize issue) 3. border...

if i understand your question right, you can change the form size either by clicking and dragging it to the right size or open up the forms properties sheet and goto width or height (open form in design view. in the grey area outside the forms layout area, double click. the properties sheet...

in access 2003 i have created a form with a custom toolbar. on the toolbar is a menu with three choices. i want to create an immage by one of the items. when the user selects another item, i want that once to recieve the immage (and the last one chose to loose it). i know i can do this in...

cool. thanks

hey everyone. can anyone look at my code and tell me what im doing wrong? im trying to open up a recordset with all rows from a table but when i do, it just has the first row. i know the sql string is correct because when i run it in the querry builder, it has all rows Option Compare...

yeah, ive tried that. it doesnt seem to work

one more thing. in the query design window, for an update query, you can enter criterias. what if your criteria is an empty (or null) value. i tried just using Is Null but it doesnt replace the old values. (ie, if value = "N/A" or null value, change to 99)

genius. thanks it worked like a charm

hey everyone, i need some quick help if anyone has time. i need to create a procedure that will go through a table and change all values that meet a criteria (ie. if a value is "N/A" then change it to "99"). does anyone know any good vba procedures for this? or can the actual access db this on...

its not working because your splitting the date up into months and years. for the date add to work in the way that you want (as far as is know) it has to be in this format (mm/dd/yyyy). if you want to split the numbers up on your form, on the onclick event concat all the fields into the above...

im not sure, but i thought access has an error log table already, theyre just hidden

look at the same code i gave you in your last post. add this months = Format(newdate, "mm")

you must be doing something wrong with the dateadd. make sure all your variables are being filled. heres a quick example that works Private Sub button1_Click() Dim newdate As String newdate = DateAdd("m", 1, Me.Text1.Value) Me.Text1.Value = newdate Me.Text1.Requery End Sub this is for a...