Search results

Hi, Not sure if this is possible at all but I have a table with the following structure; 01DAY | 01NIGHT | 02DAY | 02NIGHT | 03DAY | 03NIGHT |Etc etc. up to 31. These are either filled with null values OR D or N I am wanting to build an update query which will look at a form where a FROM...

Hi, I am producing a form for a rota system, within the rota I want it to look at staff on the day/night shift and check their skills and count them, the counts then populate a footer item with numbers so we can work out where and what cover is needed, this is probably me being a novice and...

Basically I have my DB file which users connect to via a F/E form. I'm happy to load the data once and then if the number of items in the query changes then the recordset/array is recreated rather than pulling all the time. Bascially what will happen is Managers will input any ongoing service...

Hi, I've added a link to a sharepoint list and am able to add info to all columns except one (this is a required field) this appears to be a multivalue field as when I look at the table it shows the value for old items as this: ;#ITEM1;#ITEM2;# etc etc. Does anyone know how I can...

Hi, I have the current setup: TBLAPPLINKS ID AppName AppLink 1 Google http://google.co.uk tblWorker ID loginID 1 12345678 I want to take these two tables and have an auto building table that will add each login ID from tblWorker to a new form as a Field name alongside those from...

Hi, I have created a form with "notifications" I am wanting to create a table which contains different types of notifications that will automate (some are manually input too) I have tried this with the following but it seems to just hang when the form runs. Basically I want it to look at all...

Hi, I am currently putting together an "administration tool" for an access form I have built and I am looking to have it so users would log in to the admin tool and have options (command buttons) visible based on a 1 & 0 system. I have used to following to create the login form but I wanted...

I'm looking for a search function that will allow someone to search from a main form which contains 3 subforms that all are of combo boxes with different parts of information from a query. For Example: Main_FORM Service_SUBFORM Callout_SUBFORM Contacts_SUBFORM I want to have a...

I have an access form which has a list box of applications which people click to quickly launch, I want to be able to track the number of times each of these is clicked to create a top 10 frequently used applications - is there a way that if I create a column for clickcount in my applications...

I have a form "Handover" on this form I have a button that enables edit functionality once clicked, I now have a subform on this form named "Bdown". The Bdown subform allows edits without having to click the "btn_Edit" on the main form "Handover". Is is possible to make the edit button on...

Hi, I have a form where I need a button that will export the current record being viewed to a TXT file and attach to email, I want to specify the To, CC, Subject and Body of the email, if possible putting a flag on it also. I'm not doing very well, so far I have Private Sub...

I need a script to run a report "executive incidents" pulling data for only the current record you are viewing. This needs to be emailed as a RTF with one person in the TO field, one in the CC field and a small body of text. Ideally I would like the RTF to output in landscape if possible...

I have a form with a list box on it that has 4 teams (Team1-4) Below this list box I have a text box: "People on shift tonight" I want to be able to select a team from the listbox and this prepopulate the people on shift box with the names of the colleagues from the team specified, is...

I currently have a form for a handover process and am looking to have a button to ideally take a section of inputted information from the form and place this into an email. IncidentReferenceNumberName1 DescriptionSignificant1 ActionTakenSignificant1 CurrentStatusSignificant1...

Hi all, I'm new to access programing and have been working on a handover form for shift workers, as part of the handover we have to include call volumes forcast and actual calls received over a period. I have a form which links to my table (Handover) the two fields are named, "239 Forcast...