Search results

On my form, I currently have a combo box that updates text box data with each new selection. However, after these text boxes for FirstName, LastName, etc. are updated, they cannot be edited. Here is the error message that appears in the status bar: Control can't be edited; it's bound to the...

I currently have a form with a drop-down combo box that is used as a tool for selecting an employee's last name. After selecting a name, the text boxes below the combo box are updated to match up with the selected name. However, I am trying to get the employee images to do the same thing, but...

Is it possible to utilize the code from an Excel macro as the OnClick() code for a command button in an Access form? If not, is there a way to adapt the macro code somehow?

I've got a command button named "Output2" which is SUPPOSED TO add entries onto an open Excel worksheet; however, it just overwrites everything on Row1 and downwards. Anyone have suggestions on how to fix this? Any help would be greatly appreciated :) Private Sub Output2_Click() On Error...

I've currently got a form w/ a listbox where entries can be selected for export to Excel. However, the code for the command button's OnClick() returns "run-time error '13': type mismatch" and highlights this line: Row = .Cells(1, 27) + 1 Here is the complete code: Private Sub...

I currently have a listbox where selected entries are exported to a brand-NEW Excel worksheet (each time) after the user clicks a command button to run the following VBA code. However, I'd like it to create just ONE new Excel worksheet initially and then append later selections onto that same...

I currently have a form that has an OLE Object on it that was created by copy-and-pasting from a Microsoft Word document. The problem is that it only allows me to edit the text when I double-click the Object in Design View. In normal Form view, double-clicking does nothing. Is there any way to...