Search results

Sorry for my late reply to close out this thread. What i had was a textbox in front of the cbo that was populated by the selection from the cbo in order to then run a query to insert the selection into a new table 'OnSite' which finally all worked a treat. Thank you

Hey guys, I think i am nearly there with this but not quite sure about how to run this:- Sub Main_Routine() Dim groupAdmin As String = "12025550108" ''' TODO: Specify the WhatsApp number of the group creator, including the country code Dim groupName As String = "Happy Club" ''' TODO...

Right, i managed to solve this by overlaying the box that says 'Angled Finishing Nails' over the combobox that says 'Finishing Nails', leaving the selection drop down arrow clear as in the attachment. This gives the impression of it being hidden but still enables the new record to be selected.

Hi and thank you, I dont know how i would do that as it is a combo with three columns within it to ensure the user selects the correct item ?

Hi, its all on the same subform on a tabbed form as in the attachment

Ok, well i am using a combobox to to select an item but once the selection is made i hide that and make the data that was selected visible and hide the original combobox but i need to display the selected data in each row of the form. Hope that makes sense?

Quick question that i can't seem to find an answer to - is it possible to create a conditional format to make fields in a continuous form visible if a field has data in it? Thank you in advance

Awesome! silly me. Thank you arnel

Hi Everyone, I am trying to update the quantity (TotalQuantity) of a field in a table (Aerosols) by selecting the quantity to subtract (NumberSelect) on the form (AerosolQuantityChange). I am trying to use the SQL below but i am getting the error message that the queries name is not a valid...

I've got it! It was an error on my references. =Nz([TotalAerosolsSubform].[Form]![AeroValue],0)+Nz([TotalBoltsSubform].[Form]![BoltValue],0)+Nz([TotalNutsSubform].[Form]![NutValue],0)+Nz([TotalWashersSubform].[Form]![WasherValue],0) Thank you all for your help once again

Thanks Arnel i will play about and see how it goes

Hmmm, i got a rather bizarre result of £8.91 rather than the real value of over £1000 Thank you for replying. I wonder if it might better referring to each page by its Tab value?

Is this possible? I have a form with a tabbed form with 25 pages of stock. Each one has a total field in the footer and i want to display the total value of all the stock held in the header of the main form. At the moment i have tried this but i am just getting an error...

Thats it! At last. Thank you SO much

Hi again, I implemented changes where your comments are but this one could be where the issue is:- DoCmd.GoToRecord Record:=acNewRec 'Vlad: if you are on any other record than last open a new record on SelectedAffected form as that is the one with the focus I want to go to the next record on...

Hi Vlad, Based on your version i now have it fully working apart from the doubleclick from the subform on the form 'HazardList' which works but i keep getting the message - "You cant go to the specified record" I have tried so many things and different fixes online but still the same message...

Thank you Vlad, i will take a look. I am slowly learning with the help of you guys on the forums

Thank you for trying. Yes, just upgraded to 2019 recently

I have changed it slightly recently. This is the full version but i recently logicalised it better than it was. You have to use the Shift key to bypass. From the main form it is fine (i think) until step three and after where i seem to have problems which is ultimately affecting the report (Main...

Oh well, there is something wrong somewhere?