Search results

Just tried to lock it using the forms On Current event. That works fine when the form is first opened but after closing paint and going back to the form that was open when I launched the ole object it doesn't got through the oncurrent event.

Ah, get round it by using the following code... With Forms.Item("Invoices").Controls.Item("Signature") .Locked = False .Enabled = True .Action = acOLEActivate .Verb = acOLEVerbOpen .Locked = True .Enabled = False End With The code executes when I click on a button...

If I edit a bitmap image that's embedded directly within a table all works fine. I can double click on it, paint opens and any changes are saved within the table. When using a form to edit records all changes to records save fine except if I've edited the embedded bitmap. It just doesn't...

I know discover it only happens when I've already had VBA open. Just coincidence that I've not opened it without first having done some VBA. Thanks for shedding light on that one.

I'm using a tablet pc to create invoices and capture input. When I'm in a form and I click on the link on my desktop to pop-up the on-screen keyboard,for some reason access launches VBA and switches to that. Has anyone got any idea how to stop this? Last thing I need is a user creating an...

Maybe this should have been in the VBA code section since the solution I found uses code. Will post it anyway as I've read loads of requests on how to do this but not seen any answers... On Click event procedure for the button that will activate the object... With...

Hi All, I have a form with an OLE object that contains an embedded bitmap image. When I double click on the object the image opens in paint, which is exactly what I need it to do. What I'd like to do is have a button on the form that, when clicked, copies a template bitmap image to the ole...

My mistake, the database is already split and using linked tables. I just need to work out how to hide the database window and create an executable front end. Hope it's not the case that Access 2010 will need to be installed on each machine.

Hi, i'm using Access 2010. The last time I used Access was the first version ever released so I've got a lot of learning to do. If I hide the datbase window is it easy to show it again? This is a very simplistic database as far as the user is concerned... All they see is a single form to...

Hi I'm ready to look at distributing my database to a couple of people but need pointing in the right direction with regard to setting the database up so user can only enter data via a form. How do I stop user having visibility of my tables and put the database into a distributable package...

Dmax worked perfectly as every year I start the invoice numbers with the year (eg 20110001, 20110002, etc.) I can change the first invoice number of the year and the rest of the year now carries on from there. Thank you for that.

How do i take a value from a field in the previous record and increment it then put it to the same field in the current record? Cheers.

Thats got rid ofthe error message i was getting but now i'm stuck on the new record and when i try to move to the previous record nothing happens.

Got as far as this but still get the error that the access database cannot find a matching record in the other table. Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.customer = Null Then Cancel = True End If End Sub

Anyone know how I can make access delete a record if i select a certain value from a dropdown list. I have a database which upon opening a new record automatically populates certain fields with default data. The problem is that if I decide I want to go back to the previous record without...

Solved. Used a workaround of copying in an image from a default first record.

Worked perfectly thankyou.

Hi, I have a table that contains various records with default values in them, table is called Defaults. I have a table called Invoices which is completed using a form. Each time I start a new record I want various fields on the form to be populated with data from the Defaults table, using...

I'm capturing the signature from customers on-site. I create the invoice for work completed and customer signs the job off. Don't think the uploading of signatures will work. I want the signature embedded, and using an ole object this works... I just want to automate the process. Instead of...

Hi I'm using a database in access 2007 that has a field which is an embedded bitmap image. At the bottom of the main form is a signature field which on getting focus runs the event procedure... Sub Signature_GotFocus() DoCmd.RunCommand acCmdInsertObject End Sub I then have to select the...