Search results

Hi All. Been pulling my hair out today and just cant see what doing wrong. I have a mainfomr with a subform. THe subform is populated once i click a command button in the mainform and the subform is based on a qry that looks at an input in a textbox on the mainform. SO far so good. I open...

Hi. I have a main form with the name Frm_PottingInput. WIthin that form is a subform called Frm_Sub_Potting. The source object of that form is called Frm_BatchInputSubform. I have a option button on the frm_pottinginput form that when i click i want to change the recordsource of...

Hi. WIthin a form i have a command button. As part of the code I want to update a table that is not bound to the form. THe update qry i have tried to code states the following: CurrentDb.Execute "UPDATE Tbl_SalesOrderDetails SET Delivered_Qty = delivered_qty +" & Me.Txt_QtySupplied & "WHERE...

Hoping you guys can help. Currently pulling hair out as last 4 hours of work has suddnely glitched (ive done something) and i dont know how to fix it. I have a form (image attached) I choose from a supplier from a combobox and based on the supplier chosen a list of sales orders is populated in...

Hi. I'm not sure if this is possible as I cant find away but I thouhgt before i give up i will ask on here. I have a form with 2 subforms on it. The first subform lists all my sales orders and the data is presented as a continuous form. On the subform is a command button to click to edit the...

Hi. I currentyl have an edit form in my database. I enter a batch no in a textbox and then click the edit command button and it loads all the data that im allowed to edit, makes comboxes eanbled etc. This works great. I also have another form with a subform in it that is showing a summary of...

Hi All Having an issue with a form and an update query. I have one update query that and make in query design (Image attached (update query working). I click a command button and run the following vba and it work: Dim dbs As DAO.Database Set dbs = CurrentDb dbs.Execute...

Hi All I have a form whereby a user inputs into unbound textboxes/comboboxes. On clicking thge cmd button these inputs get transferred to bound textboxes. This all works great other than a textbox whereby I have the format set as a percentage. The unbound txt box is txt_YieldPer and the...

HI. I have a userform that when it opens all looks good and all my labels on form are not bold. I enter a batch number at the topand then click a command button to pull in the data to the form relating to the batch number. On clicking this command button numerous of my controls labels turn...

Hi. I have a database with an input form. I also have an excel file that i have conneted to a qry form the database. Thisexcel file is used to connect to some label software software for printing labels. When i complete an input on my input form i click a cmd button. What i need this cmd...

Hi. I have a mainform for my database. WIthin that I have an add variety button and below that in a subform a list of all current varieties. When i click add variety a new form opens and i create a new variety. What i want to be able to do is when i close the add variety form that the...

Hi i have a tbl called Tbl_PottingData. This table is made up of unique ids of various other tables and pulls together a lot of data. I then create a qry from the table that pulls in other tables linked to the unique ids. THe problem is i then add another table that is linked to the data and...

Hi I have a main form which has a subform. As i choose from combo boxes in main form the subform is filtered to less inputs based on my selection. The criteria i am using in the query design is "Like "*" & [forms]![Frm_genusAdd]![Cbo_Tier1]" Works great most the time, however the combobox...

Hi. I have spent a long time painfully creating a database with "pretty" forms. Recently upgraded to windows 11 and now my subtle check boxes are bright blue. On my windows 10 machine at home they are still grey. Has anyone else encountered this change and is there a workaround? Cheers in...

Hi all. I have a form with 2 textboxes. The first textbox is txt_newtier1 and second is txt_confirmtier1. Basically you enter a new name in first text box and then reenter it in second textbox to ensure inputter has entered it correctly. After inputting the data in the first textbox I run a...

Hi, I am creating mulitple forms with multiple textboxes. At times when i click an update cmd button I like to check all fields are correctly filled in and not left empty. For a textbox I always use the following code: If Nz(Me.Txt_Box1, "") = "" Then Else End IF is this the best way to...

Hi. Its been a while!!!!! I have multiple forms in my database. Overtime i may choose to change the color scheme or alternatively just to save me choosing colors for command buttons when building forms i'm looking for a way of setting the command buttons backcolor and forecolor on the load...

Hi. I have connected one of my qry from my access database to an excel file via the get data button in excel ribbon. Data came through fine but it appears to be refreshing the data constantly. About every 3 seconds. SO while i am using the spreadsheet i get the curser change to the refresh...

HI I have a form with 2 comboboxes on it. I have a query that filters the results based on the 2 selections from the combobxes. However when i filter the results do not appear as expected. For example if i choose a categoryid = 1 product and a potsize with id 3 i get results for items that...

Hi I am creating an edit form whereby i can change the volume of compost a pot can hold. What i am trying to do is stop the person editing a pot size by by putting in the existing pot volume. I have the following code: If Me.Txt_NewVolume = Me.Txt_CurrentVolume.Value Then...