Search results

Hi, thanks for this. I think i understand it now. I will try and put this in and see if any issues occur. Makes a lot more sense than 1 hour ago :) Stupid question but in your code what are the .... about? dim Frm as access.form docmd.openForm "Frm_BatchInputEdit", .... set frm as...

SO for that I just change private sub to public sub?

Yep I did. Wasnt sure whether i needed to add more reference to it as i am typing this in the subform code so do i need to reference the full frm name im opening with the cmd_editpottingdataclick?

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

Your a star. Worked a treat.

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

How weird. I'll try on a pc at home and see if i get same result as you. I notice all your fonts are different on your screen also. Is this cos i have a setting that allows default font to be pciked up?

PLease see attached DB. THe form in question is Frn_batchresults. If you enter batch 5002 in top text box and click adjacent command button you will see the bold effect happen on some of the textboxes. Oddly it looks like only the textboxes that are left empty rather than populated. The...

Hi ya. NOt requering to save a record. It is set up to load 1 record so the database will search the number i enter in a txt box and that will bring back 1 record. I then enter the additional information and then click another command button that saves the data. I will upload database shortly

Quite hard to strip back the database to post as some sensitive docs on there. Will see what can do. It is odd becaue only certain controls change font to bold.

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. Excel is involved as the label software i am using doesnt support/recognise access databases for importing data into it. Annoying i have to go through excel but at mo company wont buy alternative label software. This software links to thermal toshiba tec printers so need (or at least i...

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

Fantastic. Worked a charm. Thank you so much for help on this one. Sometimes there is a ice easy solution (when u know how :) )

Hi DB So to be clear do i add that to my code above and remove the other stuff. Also for complete clarity on my mainformi have this structure: Mainform Called Hemingford, childform called Frm_Sub1Form (this has a sourceobject called Frm_VarietyMain) WIthin the Sub1Form there is another...

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, CJ. You were correct i had made a **** up in the query design and was referencing wrong table. Thanks for helping me problem search it

TO elaborate, please see images attached of what is happening. Hopefully that helps show my issue

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