Search results

Hi All, I've been using some code in the OnClick event of a command button to make the last entered record appear in the text boxes of a new record. The txt boxes record the operators name and two other items and rather than getting them to keep selecting the same things they can just press...

Hi All......i'm back a bit sooner than i thought I'm updating a database which records the dispensing of safety equipment to employees. I have a main form which records the person's name, ID number etc and then a subform where you use combo boxes to list the equipment given to that person. My...

Hi Everyone.....i have a quick question regarding cascading combos. I have two of these on a subform and i'm trying to make a selection in the first which controls what's visible in the second. I have the Rowsource of the second combo set as below but i think i need to reference the parent form...

Hi Everyone, Could someone have a look at this function and tell me why it's not working ? =SUMIFS(MainData!N2:N30747,MainData!C2:C30747,"Section A",MainData!,L2:L30747,"Late",MainData!,P2:30747,"2025-01") Some background info The formula i'm working on is in the same workbook as MainData...

Hi Everyone, I'm using a data entry form and i'd like to restrict what data users can enter based on a previous combo box selection. For example, if my combo box has the options A, B, C or D, then if the user selects option A i'd like to prevent them from entering a certain product number...

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