Search results

Thanks FoFa for that help is seems to be the answer . Thanks again:)

Thanks very much Treason, very helpful info Thanks again

Treason Sorry to ask this but i have been searching high and low for some code or way of getting users off the database without ringing them all up and telling them to get off etc !! Is there a way to do this. Sorry to butt in on your original question. Thanks.

Hi everyone. Not quite sure how to go about this but here's the problem:- I have to produce a report showing only the initials of a person's surname, and just the first 4 digits of a person's postcode. The 1000s of records which are currently in the database at the moment are as follows:-...

Pasting from check boxes Thanks IMO, that was just the ticket. Its worked perfectly. Thanks for your help

Hi Everyone. Im sure one of you out there knows the answer to my bugging problem, ive looked through ( and through !! ) Access help with not much luck. I have a series of check boxes as follows: Part A, Part B Part C etc etc. What I would like to happen is that when a check box is selected (...

Check Boxes Thanks Neileg and Jeremie, I have tried both of your suggestions and both work very well. A Great help. Thanks Again.

Sorry if this sounds a daft question but i have tried looking everywhere on MS Access Help but with no luck. Is there a way to have the fields below as checkboxes that when selected add up the sum of only those parts chosen. Part A = £52.00, Part B = £85.00, Part C = £41.00 etc etc. Ie -...

Thanks for that help Mark, this is certainly what i was looking for, can i also let other users know about the new record and not just the operator who created it. Ie Sales user creates record and recieves a confirmation message, also the workshop department receives the same message ( e-mail...

Is there a way of sending an automatic message or displaying a popup box to other users when a record in a form has been created? Thanks for your help

Hey Thanks Hayley and Colin, I found it, it was a naming conflict. Thanks for your help.

Hi all I am trying to run a code that picks up the username to show on an Audit Trail, however the following message has now started appearing and i can tfor the life of me work out why. Im very new to Modules etc. UserName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1) it highlights "Left" as the...

Thanks Ancient One and Mile o Phile. I will try what you suggest. Thanks for your help

Compile error Thanks Guys for the tips, ive sorted it a bit more now after reading some more Access Help, but I cant get my head around this Delare business. How do i delcare my statement?

Sorry Guys and Girls but im very new to this VBA lark. Anyway i have a message that comes uo with "Compile Error, variable not found" I am trying to run a code as follows. Public Function LoginName() sUser = DLookup("UserEntered", "usersentries", "[colin]") End Function I am using this...

Thanks for your help GHudson, its working perfectly now. Thanks again for your help

Audit Trails Revised Thanks for your help GHudson its worked wonders. A small point though, i use a login form that asks the user to enter username and password. How can i get this username recorded on the audit trail and not the Access Workgroups security username? Ie- your code stats Dim...

I am stuck with a bit of code that i have used to create an Audit log of users changes on a form. At the moment the code uses the "currentuser ()" to tell me who has made these changes. ( see below ) 'Set date and current user if form has been updated. MyForm!Updates = MyForm!Updates &...

Ive copied the following script from the Microsoft Articles on how to keep an Audit Trail of changes to records in a form. It works perfectly however, i dont not want it to record blank values, only changes to a record. At the moment it is recording every field that is blank. I just need a...

Thanks FoFa for that help, it seems to have solved it, thanks again