Recent content by Jack Skeleton

I'd like it was so easy... If you use left, height, top or width you move only the bound of the option group, and the elements inside the bound act like an anchor (try it and you'll see). If you try to move first the controls inside the group... it's the bound which acts like an anchor. What I...

You know that viewing a form in design mode, when you select an option group, the selection includes automatically all group elements (bound, options, labels...). My question is, That can be done in VBA?. I mean to select a group of controls together (in my case, a whole option group) in order...

Hi again, Just a tip that could help: The error code for breaking a validation rule is 2279. You can catch it with an "on error" event in your form (if err.code = 2279 then... else...)

Hello, I've never tried to do something like this using the ValidationRule/ValidationText way. It's easier to create a validation macro an associate it to the afterupdate event. For instance: If isnumeric(me.yourfield.value) =false then msgbox "No, no, nooooo....", vbokonly+vbinformation...

Hi again Dave, "mergecells", "wraptext", "shrinktofit"... all these instructions concern to CELLS. You have selected a range (the first row) but when you write the instruction you don't mention it has to be applied to the selection, so you're trying to apply these instructions to the "Excel...

Hi Dave, Excel and Access have some common & some different VBA instructions. If you want to use an Excel code in Access you should create an Excel application from Access, something like Dim MyExcelSheet as object Set MyExcelSheet = CreateObject("Excel.Sheet")...

Hi again Kevin, I think the SQL way would be less complicated for you. A question, the "ATTENDANCE" table has a single row?. If not, you'll have the problem again if the concerning record is not active in your form. I mean that to update the table you will have to create first a recordset, what...

If you have the value stored with the inverted commas, your code would have to work. Maybe you lose it when taking the values from the field. Please make a little check: Dim strtmp(3) as string strtmp(0) = "DATA" strtmp(1) = """DATA""" strtmp(2) = "[DATA]" strtmp(3) = strtmp(0) & "," &...

In general, to refer to ComboBox values instead of the ".itemdata" property you use the ".value" one. That works when you have a single column in the ComboBox, or if you have more than one but the value is stored in the dependent one. "BUT" If you have two or more columns and the value you want...

Same for me (being confused, I mean). The problem seems to be located in the "(ABSENCE REASON)" value. Is that "ABSENCE REASON" a value form a field?. There are different ways to refer to it depending on this. Just an additional comment to Bat17 answer: if the value to update is a number, you...

Remember to put field names in brackets (WHERE [ABSENCE REASON]="H") A useful tip: Create a Query in "Design view" to do what you want to do, after that change to "SQL view" and copy the statement.

Hi, I'm sorry for being too late (I cannot dedicate too time to answer questions...). But you got a working solution yourself, that's great. Anyway, if you have to do this task frequently, I think that could help you: You can use SQL instructions also for protected databases. To copy a table...

Use the "UPDATE" option instead of the "INSERT INTO" one, so you can use "WHERE" options. Something like this: "UPDATE ATTENDANCE SET ATTENDANCE.[HOLIDAY HRS] = " & "(the value you want to add)" & " WHERE " & conditions...

You say you have 2 columns in your box.... If there are two columns and the value "H" is not in the dependent one, 1) change the check string for the corresponding value in the second column OR 2) change the comparison for "Me.ABSENCE_REASON.column(ColumnNumber)", where ColumnNumber is the...

What you want is possible but HARD an COMPLICATED to do... if you want to know my opinion, the easiest way to do it is this one: Dim mysql as string mysql = "SELECT * INTO [FIDM_Collections] IN _ 'J:\ocseuser\Public\Special Collections\MI Report Tool\Central Database\Central.mdb' _ FROM...