Recent content by jonnywakey

Thanks arnelgp, you've solved my problem, much appreciated. Jonny

Hi All. I'm trying to put together a few lines of VBA code to export a report called "Rework Label Report" to a specific network location in PDF Format, I have already achieved this level of code and it works fine (code below); however each report has a unique number in the database [ID] which...

Hi I have a form which contains a textbox called Expire_Date. When the form is running, the contents of the [Expire_Date] txt box triggers some vba to populate another textbox [Flag] with "Valid" or "Expired" based on the date in [Expire_Date]. Textbox [Flag] is conditionally formatted...

Hi Im looking for some guidance on what may be a simple task but I cant seem to get it to function correctly within my database. I have a table which has a primary key field called ID, this table called tblTop_Lvl contains project top level data. When data is entered into the table via...

Hi I have a checkbox [e1]on a form which I want users to be able to tick; however once ticked I would like the tickbox to be locked. To un-check the checkbox I would like a msgbox to appear asking for a password, once correct password entered the tickbox is unticked. Example: an on click...

pr2-eugin, thanks for the reply, Yes this is run on the AfterUpdate() event of the combobox. TJPoorman, thanks also to you for the reply, ideally if any selected value in the selection contains "test"? Thanks to you both for the support. Jonny

Hi All I'm wondering if anyone can help me with some VBA? I have a form which has a combobox called Task_Ref which looks up values in a table column. I would like to be able to set the tickbox value of tickbox called P1 to True if the combobox contains the word "test", each entry on the...

Hi All Wondering if anyone can offer a solution to the following, may be simple but I'm struggling with this one! I have 2 queries 1 called [Prod Performance] the second query is called [Shifts] Field within [Prod Perf] which I want to use is called [Prod Date] & [Hrs] Field within...

Hi all Is anyone aware of any VBA which would change the format of a textbox from UK £'s to US $'s and applying a set conversion rate on click of a toggle button? Thanks in advance for any ideas. Jonny:)

Result! pr2-eugin you are a star, many thanks!!:D:D:D:D:D:D:D:D

Hi All I have a Form [frmLogon] which opens on db open to allow users to logon, once they have entered their username and password they click a cmdbutton which then minimises [frmLogon] and opens form [Navigation Menu]. On close of form [Navigation Menu] how can I get [frmLogon] to restore to...

Hi All I have a form "Disposition" which has a field called "JobID", the format of the JobID field is prefixed with "XXX-XXX-"000 and is an autonumber field resulting in XXX-XXX-001 in the field. I am trying to use the OpenArgs function to pass this value to a field on a form called...

Re: DateAdd in VBA - UPDATE Guys I would like to thank you all for your support with my access project, I have taken heed of the advice and stripped the database back to basics and planned my requirements and relationships in a more structured way. PROGRESS.........at last! Thanks again Jonny:)

namliam Thanks for the post, I will try your suggestion and let you know how i get on! Thanks again Jonny

pr2-eugin Stripped out DB attached, appreciate your support.