Search results

Thanks David for your reply, I have literally this minute just managed to fix the issue: The problem was that for some unknown reason the destination workbook was protected in some way so I could not add another worksheet to it! I converted this from a .xls to a .xlsm macro enabled excel file...

Hi all I am currently trying to copy a tab from one workbook ("List.xls") to another ("IGEN_QC.xls") but I keep getting an error which I hoped somebody would be able to take a quick glance at my code to see if there is anything immediately wrong with it. Error: I keep getting an error that...

Hi Pat Thanks for your reply, I have a few questions if you wouldnt mind answering please? The separate picture control that you speak about is this not just a picture box that I set and then the code in the AfterUpdate event does something along the lines of: Me.imgPic.Picture =...

Hi All I am currently creating a database which can be used at my company to store clients addresses logos and contact information. I have used one of the templates that came with access 2010 and it works perfectly so far but I am having a problem with the logo part. I would like it so that...

Hi Thanks to you both, I managed to fix this by when the cancel button is pressed I just make the .value is set to null by the code. Thanks Again.

Hi I used your code which enables and disables record selector buttons and displays how many records in the database and this works fine however when I add a record it seems to go a bit bonkers and say that its record 6 of 5 and all the buttons are disabled. I have attached screenshot for...

Thanks That works perfectly, I need to have a similar function for the cancel button but reversed so if the user clicks cancel and there is something in the text box it wont let them close the form as they want to cancel rather then enter a value.

Hi all I have another problem which I was hoping another set of eyes could possibly help me out with! I have attached a screen shot of my form and the following code is linked to the on click event on the cmdOK button: Private Sub cmdOK_Click() If tbEnter.Value = Null Then MsgBox...

It obviously was a case of Friday afternoon madness! :banghead: Thanks Again.

Hi thanks For this, Just to let you know I got it to work. I made the form type modal and on the combo box that I wanted to control the prompt I put the following in the AfterUpdate command: Public Sub cboStatus_AfterUpdate() If Me.cboStatus = "INACTIVE" Then DoCmd.OpenForm...

Hi All I wondered if anybody has any good advice out there regarding forms. I am currently designing a bespoke database entry form and have come up to a point where I need to be able to flag a record if it is "INACTIVE" or "ACTIVE" I would like it so that if the user selects "INACTIVE"...

Hi All I am relatively new to forms and Access but I know a few things about VB so I am sure this isnt too difficult a task. I have a form in access currently being populated by people with job information and the request for a cell breakdown has been made, What I want to do is based on a...