Search results

I tried as suggested above but was still getting the "you have entered an expression that has no value" error. I took the "if NoOfSubmissions is null" out of the equation with an if statement which exited sub and setfocus to noofsubmissions. So basically you couldnt go to this tab if...

sorry no it doesnt. i still get the error "the expression you have entered has no value" and when i debug the error it tells me NoofSubmission=Null

I put in the break point as suggested and the error is because NoOfSubmission=Null So I amended code as below but still get same error If (Not IsNull(txtSubtotal)) And (Not IsNull(NoOfSubmissions)) And (Me.txtSubtotal <> Me.NoOfSubmissions) Then MsgBox "You must enter all Stage 1 before...

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

that worked lovely for me! thank you. I just had to put in acToolbarno command in the onclose event of the report to hide the ribbon again. thank you very much for your help

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

ah I was navigating to all forms, and selecting my subform in the form list, rather than selecting it from within the loaded forms sorted now, thanks very much for you help

thanks, no luck Im afraid. I tried that when I doubted my own syntax and since your post Ive tried it again I get =[Forms]![frmScore]![txtCountScore] using the ellipses but when i view the form I still see #Name in the text box on frmMain, when I can see data in the txtCountScore text box on...

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

Ive attached a sample db of what i am trying to achieve I have three users 1.jsmith password = test1 2.jbloggs password = test1 3.admin password = admin user 1&2 are in two different departments and you can see when you open enquiries based on who is logged in you get different results. I want...

I think that this has the opposite effect of what I want. If I add usergroup with criteria of <>"super" to my query and log in as user from "super" group I dont see any departments in my query, when i actually want to see ALL My select/From is very long so ive cropped the sql SELECT blah...

I use forms![frmlogon]![txtdept] as criteria for the department in the query the form is based on. This displays records for that users department only I want a some users to have access to all departments not just one. But i do not want to have an event to lookup user and if in dept All then...

thanks for your reply. I dont think it is really what Im looking for. I do have usergroup rights on some forms if user has read only rights etc they cant open or amend. That element of it works fine. My problem is that I want to filter data within forms so that users only see data relevant...

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

thanks Alan, that worked great for me. I did a bit of tweaking as my form was based on query rather than table but im happy with the results much obliged

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

I worked out the numbering on the form using a previous post from ajetrumpet rownumber: DCount("orderid","orders","orderid <=" & [tempHOLDER]) & "." tempHOLDER: orderid His version using rownumber and tempholder in the query worked with some tweaking. When I inserted these columns into my...

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

how embarrassingly simple when you know how:rolleyes: that sorted me, thanks very much