Search results

Hi, What you want is a combobox to autofill the textboxes. However, you have only one table. You need another table, if you want to bound the recordsource to that form. In the combobox RowSource, create a query to select Table1 of the fields needed. i.e ID, Apples, Bananas. In the combobox...

Hi, RunSQL is Action Query. Example "DELETE", "UPDATE", "INSERT" Your SELECT query will not work. Thus, the error message. What you want to do with this record? P.S. What was the result in the Immediate Window of your SQL Syntax?

Hi Dudley, The "Me." refers to the current object that is in focus. i.e. the the form is open and is running. However, "Me." cannot work with a form that is not in focus. So what if the second form that is not in focus? That's where "Docmd.RunComand acCmdUndo" come in.

Hi, You still having trouble? I had no problems creating tables with Roy's code but the Cascade Delete and Update were not successful. Maybe you need "Alter Table"?

Hi Walter, 'path to folder in which the New Form should be saved strFileNameCopy = "C:\Documents and Settings\" & Format$(Nz(Environ("username")) & "\Desktop" & strFileNameCopy) Set fileObj = CreateObject("scripting.filesystemobject") fileObj.copyfile strFileName, strFileNameCopy, True 'Dim...

Hi, Try adding a backslash on & "\Desktop\".

Hi Pete, So far most of the ActiveX control aren't free, you may have to google it or buy it. snip

Hi Pete, Well, you can adjust the image size by using the properties "Height" and "Width". Set the "Size Mode" to "Stretch" and for positioning of the image you can use "Top" and "Left". That's a very large image, almost covering a 19" monitor. Must be a very big file size Tiff/Jpg.

Hi Tony, Sometimes it is cause by AutoCorrect, missing name queries, missing tables and host of others. You might want to look at allenbrowne site. Link Link snip

Hi Moniker, Here is a Link to a similar problem with combobox. This might give an idea of what is the problem. snip

Hi, Try without the brackets, Me.OrderBy = "[Input Date] DESC"

Hi, Look at the code again. "Parts" is the field you orderby "DESC" is the order by descending If you want to order by ascending just use "Parts" without "DESC" Got it? PS. "Date" is a reserved name in Access, avoid using it. If possible rename it.

hi, If you want to use the form's filtering, you need to include these lines. Me.OrderBy = "Parts DESC" Me.OrderByOn = True

Hi, Your question is generic, it's difficult to quess want you want to do. A simple one would be, say...... strField = len(table.column,-3) if table.column1 <> strField then field1 = field2 end if or a subroutine or function to loop thru the record and compare. I suggest a sample code...

Hi, How was your pictures stored? In a Folder or in the tables? Try Here snip

Hi, Try Here Hope that's what you're looking for. snip

Hi, It’s very unlikely that the design change due to a checkbox, unless you have a function that changes the look and the form’s recordsource. The changes you see is most likely the recordsource SQL syntax that will determine the data retrieved from the tables you have selected. I believe you...

Hi, Not sure what you want to do. My guess is that you want to change the form's Recordsource. That's the easiest solution. Here's what i think. Create or copy "qryaddNewTransaction". With the new query, add the WHERE condition. In the checkbox on click event,change the RecordSource to the...

Hi, Is this code in the current database? Is this code in a form's module or a standard module?

Hi, Change your code to this. Private Function FilterIt() As Variant Dim varFam As Variant Select Case Me.cboGroup Case "(All)" varFam = "[Group Name] LIKE '*'" Case Else varFam = "[Group Name] = '" & Me.cboGroup & "'" End Select FilterIt = "WHERE " & varFam End Function