Search results

Hi Everyone, I have a data entry form where one of the fields where info is entered is called Weight. I need to have a text box on the form which adds up the weights as they are entered into the table (it's just a visual aid for the User). However, i also need a command button beside the text...

Hi All, I have a form in a database which has been working without any issues for several years. The form contains a text box and a list box which i use to perform a keyword search. When i type into the textbox, a set of results appear in the list box and i can then double click on the one i...

Hi Everyone, I have a command button which i need to open an image. Is there a way i can get the attached image to open and display just the image itself without the black border area ?. I've tried cropping it but makes no difference. The code i'm using in the OnClick event of the command...

Hi All, I've used the code in this thread for searching my databases quite a bit and find it excellent. https://www.access-programmers.co.uk/forums/threads/dynamically-search-multiple-fields.188663/ I was wondering if anyone is familiar with it, could you tell me is it possible to add a...

Hi All, I have a main form called frm_AddNewShift and a related subform called SubRecords. I want to be able to verify that the four controls on the main form have been populated before i allow access to the subform. I added the following code to the GotFocus event of the first control on the...

Hi All, Would it be possible to have a Main Form with the properties set to Data Entry = Yes and a linked Subform to display records with Data Entry set to No ?

Hi Guys, I've been asked to create a database which allows Users to scan barcodes on various raw materials being used on site here. I'm not sure if it's a problem but each item has two barcodes which i would like to be able to scan as one record. I was thinking maybe have two fields on a main...

Hi All, I have a form with five Txt Box controls and an Image Control. I've also got five images (Pic1, Pic2, Pic3, Pic4 and Pic5). Is it possible to make Pic1 appear in the Image Control when i click into Txt Box 1 and Pic2 appear when i click in Txt Box 2 etc ? So i need Pic1 to appear when...

Hi All, I'm trying to create a formula in Excel to display information. Basically there are 10 cells and you can select from 3 options the text you'd like to appear in that cell. I'd like a value to appear to the right, displaying what percentage of each option has been selected (You'll see...

Hi All, I've Googled this to death and found one or two solution suggestions but they don't work for me. If i have a parent form called frm_Main and a SubForm called frmDetails, is it possible to keep frmDetails locked until the four fields on the parent form are filled in ?. By locked i mean...

Hi All, I've got a database for entering maintenance information about various machinery. On the data entry form, i have a combo box which has several columns and i've used some code in the OnChange event of the combo box to populate other text boxes on the form when i make a selection to...

Hi again all......i'm a little disappointed i couldn't work this one out. I've got a form with a combo box (cboPaper) and a text box (txtPaperValue). The combo box allows you to either select Yes or No. If the User selects Yes i'd like the value 0 to appear in the txt box...but if the User...

Hi All, I have a database which deals with various chemicals. I want to print a report listing all the chemicals in the database but need to put the chemicals with the lowest melting point at the top of the report. My problem is that some chemicals have no melting point and the field is just...

Hi Everyone, I've got a really old database (customers and orders) which only has one table, but it works so i'm going to leave it as it is. I've been asked to add a query which counts how many times each customer hasn't paid for an item on time. The table is roughly as follows RecordID...

Hi Everyone, I've got a main form (frm_AddEdit), a related subform (frm_subCalRecords) and a second subform (frm_subStds) The main form is related to both subforms using the PK field 'EquipID' I want to put a 'Print' command button on the main form which will print the contents of that main...

Hi All, I'm using Excel and Access 2016. Is there a way i can add a command button to Excel which opens an Access database at the switchboard ?. I've seen a few threads which have offered a solution but i can't get it to work. Is it a matter of adding a macro to the command button ? Thanks

Hi Everyone, I'm using a main form which contains 3 subforms. I have no conditional formatting on the main form itself but i've been trying to use CF on the subforms but it doesn't work for some reason. I know it needs to be done at the control level but that's not working either. All i...

Hi All, I've got a main form called frm_Add/Edit and a subform called frmsub_CalRecords. The main form provides info about a certain instrument and the subform records every time it is calibrated. On the subform, when i move to a new record i'd like the value from the previous record to appear...

Hi Everyone, I've got a report which is based on a risk assessment. The assessment contains various tasks and each task has several hazards. The report works fine but would it be possible to have a summary at the start of the report eg: a list of each task and the hazards contained within it...

Hi again......i've been working on a small database which has been frustrating the hell out of me. I thought we had it done but now another small issue has popped up. If you look at the order form in the attached file, the Cost txt box in the subform will not display the cents part of the price...