Search results

Hi all, i have an access database which is linked to a sql server table. Up until yesterday everything worked fine and anyone one of my 20 users could log in. Today they are getting these error messages: warning unsafe expressions and then sql state: 28000 sql server error: 18456 login...

cheers greg

cheers greg

Hi all, i have a form with a table inside it, and five drop down lists that can be used as filters, i need to be able to print the list displayed in the table once it has been filtered but cant get the syntax in the vb to work properly. is this possible or am i trying something unachievable. greg

hi all, ive ste up a form with list boxes being used as filters but once ive made a selection i can deselect it to clear the filter. any ideas where the stetings are to control this? greg

You star!! i wasn't aware some properties needs activating in vb. thanks very much!

Hi all, i have a subform as part of a larger form used for entering grades. the form references a table with grades for all terms, im trying to get the form to just display the grades for this term which is identified by a field: ExamId = JsGrades2 using the filter option in the properties box...

cheers, i had put my quotes in the wrong place. ta greg

here is the code: Dim stDocName As String stDocName = "Referral Slip" DoCmd.OpenReport stDocName, acPreview, , Me.RefID.Value = RepRefId greg

Hi all, Im trying to print a report from a form. I want the report to have the contents of the forms current record. The underlying table has an autonumber as it's index/primary key and it's this im referencing. What happens is a record is saved and the autonumber is generated...

Hi, just to let you know that i had made a fundamental error that i could not see. I had use some boolean fields and had used a default value that was recognised in sql but not access so thanks for all your help its sorted now. Kind regards greg

that didn't work. greg

rename the tables on the server? ill try that, thanks.. greg

Hi all, I set up three tables (pastoral, referral, confidential) all at the exact same time on our sql server, all have the exact same permissions and i am the owner of all three. Ecah have a primary key in the form of an autonumber. When i link to these tables in access i can delete from...

This works great thanks- although my foms defeinitly load slower now. cheers greg

cool, i think i will change the code so it's using the else...if statements instead- makes sense...less room for error there cheers greg

cool, i have looked at the code and will change it so it works on the if...else format instead...makes sense- less room for error there... cheers greg

cool, will try that cheers greg

what an idiot i am? :eek: cant believ i forgot to put the end if...else statement...sometimes cant see the wood for the trees... you are a star!! greg

furthermore if i set the boxes to transparent i dont get the problem but of course they are now not coloured in anyway. greg