Search results

That worked a treat, Many thanks, you're a star theDBguy :). I'm sure I tried something like that but it failed so I obviously had some sort of syntax error. :o

thank you Colin. Using the "BrowseImge_button_Click()" command I'm able to select an image to populate the "Image_Source_TXT" which gets stored in a field on a table which then loads the selected image into an image holder on the form, so I know the code for the "BrowseImge_button" works...

I've ditched the new code and gone back to my original code for now which works but doesn't navigate to the report related folder. I put it where you suggested (.AllowMultiselect) and made sure to include the "f.", but I think there probably needs to be extra code. Based on my initial codes...

I tried your suggestion without any success - not sure what I'm missing :confused:

hi theDBguy thanks for the suggestion :) - where would that code go. Sorry, I'm a bit of cut and paste guy when it comes to VBA lol

I have a database that has a button on the record form that will create folder using the record number using the following code: Private Sub CreateFolder_Click() ' In Microsoft Windows: ' Specifying 1 as the second argument opens the application in ' normal size and gives it the focus. Dim...

Not entirely sure Gasman but adding the "If" code above to the Form_Current seems to have solved the problem without causing any conflicts so far :)

Quick update... Hi Colin, I seem to have solved the problem by copying the If statement from the Media_Delivered_Method_AfterUpdate() private sub and duplicating it into the Form_Current() private sub. It seems to be working but, in your valued opinion, is this likely to cause any problems...

Hi Colin, Unfortunately, the database is on a secure server so I can't copy any part of the Db without incurring the wrath of the powers that be :(

Hi isladogs, thanks for the quick and polite response :D I added the the Me.Requery code and removed the other code in the Form_current as suggested, but it seems to cause a loop or something so, when I click onto the next record, the form flickers randomly and returns to the record I'm trying...

I've been tasked to add some new fields to an existing form in an old Access database for a design request Form and I've hit a bit of a snag! Basically I've added a checkbox to indicate whether or not the customer has supplied their own media to include in an artwork design process. When the...

Thanks again for the assistance arnelgp and ridders. Unfortunately the database has been completed by several people some of whom have not been as rigorous as others in adding the info so for now I'm going to have to go manual. :banghead: I've added another field with a dropdown box and made it...

Thanks for the speedy response:) I fear I might have to do it manually as some of the names have been misspelt in some of the records :(

Hi, I hope someone out there can shed some light :) I have a database which has a field for employees names but I've now been asked to provide an extra field to show which of 6 departments the employees fall into. What's the best way to go about doing this to automatically assign new and...

I think I've solved the problem - it had nothing to do with the button VBA code. When opening the db I was getting an error saying Basically the database was looking for a calendar control which doesn't exist in Office 2010. I went into Visual Basic Editor, selected tools/references and cleared...

I've got a database which worked in Access 2007 but opening it up in 2010 throws up a couple of compile errors. I have a "Jobs" form which I use to book work into and within the form I use two buttons for folder creation and folder viewing. When I click the "CreateFolder" button a new folder is...

Thank you arnelgp, your solution worked atreat :)

Hi, I have a database which is run across a network where some users are running 32bit machines and others are on 64bit machines. In the database form I have a button which is used to launch Adobe Bridge. This works fine for the 64 bit machines using following code: Private Sub...

This solution by cyanidem works perfectly, thank you all for your help :D

Cheers Minty... Any ideas how I go about writing that?