Search results

Hi, If you are trying to multiply an Integer with a decimal or fraction, you can't. Dim the variable to Single or Double.

Create a bound form, the record can be edited. Then, on the form create a button from the wizard, just follow the instruction. And it's the same for both "Delete" and "Insert" button.

Hi Bill, Glad to hear from you. Yes, if you have parameters in your query within a query.

Hi, Where is this code located, Form's module or a Standard module?

Hi Curtis, Looking at the Form’s control and AuditTrail, my thoughts were the control’s old value might be the problem there. Did the changes work for you?

Hi Tim, There are many possible cause of this problem. For Example, corrupted files or the file in memory and being in use. (Have you installed any “.Net” applications lately?) And (You sure that “MSO.DLL” is the correct file? Should it be “MSO12.DLL” or "MSOUTL12.OLB"? I don’t have Access...

Hi, There is a sample in the Sample Forum. Do a search for "ToolTip Control - No OCX - c/w example".

Hi Dana, If you want to select all records at random... SELECT Rnd([ID]) AS Q1 FROM tblQuestions ORDER BY Rnd([ID]);

Hi Tim, Maybe you need to re-register the "dll" or "ocx" again. Click "Start", "Run", in the field... Regsvr32.exe "C:\SomewhereFolderofDLL\YourDLL.dll"

Hi mithani, Not an easy task, but here's a start from Help. CreateControl, CreateReportControl Methods Example The following example first creates a new form based on an Orders table. It then uses the CreateControl method to create a text box control and an attached label control on the form...

Hi Bill, Not sure about this, but if the Report Record Source is using the same query as in the code, the report will close the query. This might be your problem? An alternative is to open a recordset using SQL syntax. Dim l_Database as DAO.Database Dim l_Query as DAO.Querydef Dim lr_Data as...

Hi Bill, Just a guess, is your report "rptMemberProfile" and "qryRptDuesExpireLetter" share the same query source or table? (or something similar?) Sometimes, sharing opened tables or queries can cause the recordset to close.

Hi Bill, Try removing the "DoEvents" and see if it works. I suspect there might be more than just your code.

Hi Tim, You sure that the referances is correct? Look at it again, does it the word "Missing" just after the check box? You might have to get a copy of that file from another working PC and put it into the correct folder.

Brian, The original code from OP was DoCmd.Undo That does not work at all. The correct code is, DoCmd.RunCommand AcCmdUndo Sometimes DoCmd has problems understanding which record or what to “Undo”. Worst cases are usually changing of the form’s properties in an event control. The code...

RG, The "stLinkCriteria" should be on top of the "DoCmd", else the criteria is blank.

Hi, One missing "&" ampersand from the Dlookup. = DLookup("[SupDoc]", "[tbl SupDoc]", "KeyId = " & Me!keyID & " AND " & "Var = 'A'")

Hi, As you have said it yourself, “I know for text boxes, there's a property: can shrink = yes”. Now the question is “How to use the textbox “Can Shrink” property to reduce empty space? Let’s take an example…pseudo code. Private Sub Report_Open(Cancel As Integer) ‘assume nothing in text box...

Hi Dave, Great! Good to hear that it works for you.

Hi Dave, If you're still around, try MS site Here the Help file error