Search results

Hi all I have a count text box on one tab in my form. In english I want to check that all records required are entered before moving on to the next tab, by looking up a control total e.g number in batch is 10, user must enter 10 records before moving onto next tab. In the onenter event of...

Hi Ive read and tried many post on showtoolbar and customising ribbons in Access 2007 but I am not able to get what I want to work. I want to use DoCmd.ShowToolbar "ribbon", acToolbarNo in the onload event of my login page. Combined with the different Access options like hiding the...

Hi I have access 2007 database with tabbed forms. On my pc the forms appear pale/white background, the back stlye is set to normal. When I open the database on a different pc, the back stlye is normal but it appears as dark grey. I have the same problem with command buttons - completing...

Hi I have: 1 main form called frmMain 1 subform called frmScore 1 unbound text box called txtcountScore in footer of subform txtcountscore =count(*) to count records entered in subform 1 unbound text box on frmMain called txtchkTotal I want to reference this count in the main form so that when...

Hi I have Access 2007 db with tblusers, tbldept, tblrecord I want most users to only see records pretaining to their department in forms and reports. That much I have sorted - based on queries that lookup user department. However i want some to have superuser access. i want them to see...

Hi all I have a continuous form with check box. I have created two buttons. one to select all and one to unselect all. I have button SelectAll with following onclick event With Me.RecordsetClone Do Until .EOF .Edit !ShortList = True .Update .MoveNext...

Hi I have a query that returns total scores in descending order. I present that on a form but i want my form to show the scoring position eg 1. ABC Company 100 2. DEF Company 90 3. GHI Company 80 How can i number each line on the form WITHOUT writing the results of the query to a temporary...

Hello I have an beforeupdate event on a date field (tenderclosingdate) to check some criteria. If the date entered does not meet that criteria then it should give error msg and cancel the update. The probelm is with one of the conditions. It is a currency field. I want to give a message...

Hello there I have a report that functions as a letter to suppliers. I have fields in the letter that maybe be 0 or zero due to data entry rules (filling all fields/ locking records after all fields entered/creating totals.) I dont want these to be displayed and have code in the onload event if...

Hello there I have a form in ms access 2007, with multiple tabs. Some of these tabs have subforms. I want to update one subform from another but am having no joy. I cannot requery the second subform. ive read alot of threads about requery, referencing the main form and then subform2, the...

Hi This is probably a really fundamental basic but I just am not seeing the wood for the trees at the moment. I am using access2007 with SQL backend to record tender details. I have a main table called tbltenders, pk in this table is tenderid. I have another table called tbltype, with typeid...