Search results

You would probably need to move the "concat" textbox into the query (RowSource) as a calcuated field instead. As a textbox in a continuous form, you cannot individually reference each textbox, only the currently selected one. Hope this helps, Brian

The expression in Calculated fields are stored as a property to the field. you can use the Field object to get it. Dimension a field object and a String variable to store the espression: Dim fld as DAO.Field Dim strFldExpression as String After: For j = 0 To db.QueryDefs(i).Fields.Count - 1...

Public Sub Button1_Click() If Me.Dirty = True Then MsgBox "The Form will be closed without saving", vbOkOnly DoCmd.Undo DoCmd.Close acForm, Me.Name End If End Sub

Try using acSpreadsheetTypeExcel12Xml instead of acSpreadsheetTypeExcel9?

What type of module is being used for the line? public gblusername as string Is it the Form's Module, a stand-alone module (i.e. "Module 1"), or a class module? If you're looking to store a variable globally as long as Accessis running or until you change it, try using TempVars...

Is [Asset Number] coming from a field in a continuous form? Keep in mind a continuous form will return it's [Asset Number] value of the currently selected record What returns if you add: MsgBox Me.AssetNumber After "Set rst..." Are you getting the Asset Number you're expecting to?

That's what I was looking for. Thanks, Mark! Small correction on the first code snippet for those that come across this thread: Instead of: Raise ScanProgress(Me.PercentComplete) Use: RaiseEvent ScanProgress(Me.PercentComplete)

So, I've created a custom class to scan a folder for new files, open them, scrap the text and add the data to a table. The directory has several files so the process can take 5+ minutes. I am trying to have a procedure in the class to provide a status report, ultimately do so something like...

I would have thought my solution would eliminate your need for the counting textbox. Since each report is its own subform, you could just put a static label above each one. Perhaps I don't fully understand what you're trying to do there. In any case, multiuser FE/BE should not be a problem.

If you replace the line: with Is the result the same?

Why not create a new blank report and add your "PURCH VB Query" report as two subforms to it? Above each subform control you can add a label for "Original Buyer Copy" and "Duplicate File Copy" Then just print that "Master" Report in triplicate.

Hi AirCounsel, You code is triggered on an event. In this case you probably have this code executed each time the checkbox is clicked. It then checks to see if the checkbox was checked or unchecked and opens or closes the subform accordingly. When your Main form first loads that even hasn't...

Sounds like he created event handlers in Access for a class object? Without seeing the code it's hard to tell. I see this in .NET often but never seen a purpose in Access VBA.

Assuming you're using a text box to display the description, you can the "CanGrow" property (=True) and it will make the textbox larger for records with long descriptions.

Hi Kurt, You can do something like this. Just use a button on the main form or use the AfterUpdate event on the main form if you want to do this every time the mainform record is saved. Dim rs As DAO.Recordset Dim rsCount As Integer Dim i As Integer 'replace "Subform" with the name of...

This question has been asked before. Refer to the post below which contains a few solutions you can explore. http://www.access-programmers.co.uk/forums/showthread.php?t=57429

In either the Header or Footer of the form you should be able to just put "=Sum[SalaryIncrease])" Two things to note: [SalaryIncrease] should be the name of the field in the recordset and not the name of the control (textbox) that displays it on the form/report. If you are performing a...

You could try opening you accdb in 2007 and saving it as a 2007 accde.

Sounds like you need to use a Do..While or a Do..Until loop. But without more details as to what your waiting for I can't be more specific.

I believe declaring it as "Single" is more efficient and requires much less memory to store. Dim vbresponse as Single