Search results

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

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:)

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

Hi all, I have developed an access db to track laboratory sample process times but am stuck with the following: I have a form (Job Tracker Form) which has a combobox [Task_Ref], the form also has the following text boxes which I need to use when performing a calculation:- [Start_time] [Cycle]...

Hi I have developed a database in Access 2007 to track laboratory work requests through a set process. My database currently logs a timestamp for each new record added, within the database is a list of "Tasks" with total task times recorded, as a task is added to a record the [txtCycle] time...

Hi, I am a fairly experienced Access user and have developed numerous databases in the past, however I have a new challenge and am struggling to figure out how to approach it! I am attempting to develop an order tracking database which I can use at work to ease the time it currently takes to...

Hi, I am wondering if anyone can assist with a problem I am having. I have an Access D/B with a table called "Breakdown Data", within this table are various fields called:- Downtime_Start (Short Time) Lost_Hours (Short Time) Downtime_End (Short Time) These fields are represented on a...

Hi I am wondering if anyone has a template for an estimating database or a database which has an ability to select an item on a form which looks up a table of operations and you can then select which ones you want? I am trying to establish a database from which i can have a table which...

Hi, I have a table in my access database called Pipeline Data, there are currently 82 records in the table. One of the fields is called Next Action Date, what I want to achieve is to have a text box in which I can enter a date eg 16/10/09 and click a command button which places this date...

Hi I am hoping someone can help me with the following. I have set up a Cmd Button on my Access Database which opens a main Excel Spreadsheet containing graphs (Pipeline Dashboard.xls). My problem is that I have 5 other excel spreadsheets which feed the main spreadsheet. How would I...

Hi I am trying to programme the "On Click" event on a command button to open an excel spreadsheet; unfortunately after many attempts I am still struggling to get the code to work. The spreadsheet is located in the following location:- W:\2007 Suggestion Scheme\2009 Suggestion Scheme The...

Hi Guys, I am struggling to find the correct VBA to allow me to refresh linked tables in my access database. I have two tables in access linked to excel, they are called :- Access Dump Access Cell Vs Cell I have a form which acts as a dashboard showing charts relating to these tables, upon...

Hi I am new to this forum but have a small amount of experience with Access. I am trying to simulate a Gantt chart on a form; I have 10 fields listed on the left hand side of the form (Task), each with a start date and end date next to them! The Gantt lines are made up of 52 text boxes (1...