Search results

Hi all I am trying to define a Public Variable for the first time and having a few issues. I have declared the variable as Public AdminUser As String. When the user logs in AdminUser = Me.cbo_user.Column(1) Doing a step into hovering the mouse over 'AdminUser' does indeed show the...

Bob You are an absolute genius, complete and utter genius Thanks again Gareth

Thanks both for replying I sorted it now, yesterday was not a good day for common sense for me. DOH! Gareth

Thanks Bob, I'll give it a try tomorrow.

I have two bound forms both associated with separate tables. When a Check Box has been selected in Form 1 (frmPMSReq), I would like a button on Form 2 (frmContractHeader) to become visible when Form 2 is loaded. I have tried - On Form Loaded If [Forms]![frmPMSReq]![SelectionRequired] = True...

Hi everyone, Currently working on a DB, and would like some advice and guidance if poss. I am using Tabs and on 1 particular tab there are 4 Sub Forms. All these subforms are hidden. On a previous form there is a check box setup that if the user wants to see these 4 subforms he has too...

Sorted it now, thanks anyway

Hi Dave Thanks for responding. The main form (frmAddPermit) has 4 subforms. One of the subforms has an option that when pressed a hidden form appears. When this 'hidden' form is closed I am then trying to lock a button back on the frmAddPermit, which should still be open. But I just cannot...

Hi everyone. I have a masterform and a subform. In the subform if the user selects the save and exit button, I am trying to get the subform to close, which it does, but lock the Exit no save button on the MasterForm which is already open. But I cannot get this button on the MasterForm to...

Hi All I have a Combo Box at the top right hand of a form. When selected options come up as they should, but because the Combo is top right, sometimes the results go off the page. Is there a way to keep the Combo Box in it's current position but to move the drop down selection across to the...

Hi All On a form I have a Combo Box which lists SupplierName and SupplierID The user selects SupplierName. On an unbound TextBox I want to record the SupplierID, using =SupplierName.Column(2). However when I enter this, Access immedatley puts [] around SupplierName and Column, and thus...

Yes it works fine on another DB, which was built from scratch in 2007. The one it won't work on was originally 2003 so i'm thinking that could be the issue

Office Ribbon 2007 I have recently converted a db from 2003 to 2007. Made some amendments as required tried to hide the Ribbon via On Load DoCmd.ShowToolbar "Ribbon", acToolbarNo But the ribbon does not go. I believe it is because the ribbon isn't called 'Ribbon' Anyone got any ideas...

SELECT ([ReasonLu]) AS Reason1, DCount("Ratings","tblRatings","Ratings= 1 and LuReason = " & [Forms]![frmChartInput]![cmbReason] & " and Dept = " & [Forms]![frmChartInput]![cmbDept] & " and Category = " & [Forms]![frmChartInput]![cmbCat]) AS Poor, DCount("Ratings","tblRatings","Ratings= 2 and...

Hi Thanks for replying. I got around this by simply placing a button on the form name 'Click to view Chart' once clicked the chart is displayed, but I will try your solution. I have attached the database thus far, as they now want to be date specific. eg Just see results from 01/01/2011 to...

vbaInet I thought it best to place the Chart onto another form rather than direct to the Report, then allow the user to print the report if required, or do other things within the Database. It all works ok apart from when the new form fires up I have to either to right click or maximise the...

vbaInet I made an early start this morning, got to work early with renewed vigour! And it only chuffing worked!!! Chuffing chuffing chuff chuff I'm well chuffed Many Many Thanks vbaInet Gareth

I didn't ignore your advice, I tried and I tried and I tried, I huffed and I puffed but alas I failed!!!! Just thought a more experienced eye having the DB in front of them may help. I never ignore the advice this forum gives. GW

Try this one

Yes it does help frmMain Thanks