Recent content by mca2k4

Thanks for all your help ansentry. I think I'm going to do some more work on digging out a way to leave the bitmaps embedded and somehow access them from within the database itself. Thanks again! :)

I tried going w/ the linked way and adapted the sample db's code to look like this: Option Compare Database Option Explicit Private strSQL As String Private Sub Form_Current() Dim strPath As String Dim strDir As String If Nz(Len(Me.EmpLogo), 0) > 0 Then strPath = CurrentProject.Path &...

I've only got a couple very small bitmaps (~160x160 pixels). Therefore I'd still prefer to keep them embedded in the database; is there way to change the code posted earlier to make it work w/ embedded instead of linked bitmaps?

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 looked at the Northwind.mdb database and that one has pictures linked to records that must be gone through using the nav buttons on the bottom nav bar. Thanks ansentry, what you attached is exactly what I'm talking about. The only problem is that my bitmaps are already embedded into 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?

Would it be possible to have the command button run code to ADD LINES to the top of the spreadsheet when exporting selected listbox entries? If so, what would this code look like?

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...

Thx anyway for trying. (btw, nice avatar :cool: )

Thx for the responses RuralGuy, but it still gives me the same error. At this point, however, I'm thinking I might just want to scrap the code altogther and start from scratch. Basically I've got a listbox where users make selections and then output the selectino data to a new Excel worksheet...

Row is declared at the beginning of the code with the line: Dim Row As Integer Option Explicit is also turned on towards the beginning of the code.

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 pasted the text in design view. The OLE object is not bound to any field in a table. The problem is, it's a big bunch of text that I copy-and-pasted from a Word document into this OLE object. I want the user to be able to just double-click and be able to start editing text that way. Is...