Search results

Re: List Box based on query:mad: No thats not exactly what I mean I'll try to explain better. I have a table called tblSolutionPartners with lots of field in but the ones I have in my query are: SolutionPartnerID - Autonumber SolutionPartner -Text PrincipleExpertise - Which is a Lookup to...

Argghh.. I can't get this to work! I have a list box based on a query. The query is based on tblSolutionPartner which has partnerID, PartnerName,Expertise, additionalexpertise1,additionalexpertise2,additionalexpertise3. The Four Expertise fields are lookups from tblSolutionMainCategory. The...

Me being stupid!! Forget it it was a stupid mistake on my behalf.. I was looking at the wrong field and had one of them as text not number

I have two really simple tables which both have a field called BP which are both number long integral fields. I simply wanted to create a query that looked at tblBPWithShipToPrimary and linked the BP To the table tblZDEL and then provided me a list of matching BP numbers from TBLZDEL. Really...

Okay I know i've been incredibily stupid and made a tremendous mistake but what i need is the best solution to the problem i have right now... I have a database its msaccess with SQL Tables at the moment. There were an expected 40 wireless users expected but after horrendous crash on day one and...

Help!! I cant get it to work and its doing my head in!! I am talking about Menubars yes i have tried this code behind the main form: Private Sub Form_Load() If CurrentUser = "staff" Or CurrentUser = "STAFF" Then DoCmd.ShowToolbar "The College High School Menubar", acToolbarNo Else...

I have created my own menus to navigate round the database. However I'm a little stuck as different user groups can only have access to certain menus.. Is it possible that you can hide menus dependant on the user logged in the database. I.e. Leadership get full menus General Staff only get...

that worked perfectly, easy when you know how learn a new thing every day :)

brilliant thanks ever so much for the quick response will get started right away on it and report back thanks a million

Is this possible I want to have a msgbox pop up and dependant on the value entered it will open a particular report. So for example if they type in EN then it will run the English Timetable Report and if they entered MA it would run the MA Timetable. Now I know I can use the If statement to get...

ooops... found my mistake.. if you format the control to percent you dont need the *100 and neither do you need the % so it looks like this instead =Sum([Achieved])/Count([Surname]) Format - Percent

I have a field on my report =Sum([Achieved])/Count([Surname])*100 & "%" with decimal place at 2 and format at Percent. This works fine except that it doesnt round to 2 and instead gives the percentage like 46.666666666667% I tried to run it without % added at the end of the formula but it...

I do know that I am not going about things in the way that I should however When your cover three of your bosses jobs at the same time as your own you find you run out of hours in the day. I am doing the best I can under the circumstances at the moment. But its on my list of things to do as...

:eek: erm.... can i just say your code works fine and its my own stupidity probably through tiredness that caused the problem... having said that wonder how many people are as baffled as I was when they download the copy. Twice in two days I have made a catastrophic error caused purely by my...

Saved it in 2000 dont worry about looking at it tonight if you are busy it is past 9 at night. Thanks for all your help and would be great if you could look at it for me tomorrow.

english works I dont understand its just all the others that dont show up they stay hidden will clear it out,zip it and send it.. i've checked all the field names match and everything i just cant work out whats wrong :( 8pm at night and I am still stuck on the same problem! i've only been...

Its not working :( I thought it was tested it with English, but that seems to be the only subject working :( Any ideas?

Oh my god didnt expect that! It works it really really works wow, I mean thank you your a complete gem and saved my neck from the chop!

'If you create a table called 'tblSubjectFields' with two fields, 'TxtField' and 'txtLang' and populate this with just the fileds you want to be visible.' bit confused here.. created the table set the subject afterupdate to that and put the tags on all the field.. what I am unsure about it...

I think it does just got home going to give it a whirl now! will report back happy or cry lol