Search results

I have a large Access 2000 database and need to set up a very light security on it. All i need is to be able to specific if a form is edit or read only depending on the path taken to reach this form i.e if the user selects a viewer option or an edit option. I dont need any passwords or user...

Thank you thats done the job a treat.

I have it set up like this for many complex reasons. Great Stuff.... Hows it done? Thanks

I have a primary key field. 5 digits ie 023/03 i am using an input mask of 00/000 but if the frist digit is a zero (as it will be until we generate over 99 records) then its not visable. The wizard wont run coz its a number field and the help file doesnt seem to contain the answers. Thanks in...

Anyone know if its possible to get MS Access to look at a users IP address to identify them? And further control there access level to forms?

Is it possible to Concatenate memo boxes so the combined content can be viewed on a form..and updatable on a form i.e two way realtionship so information entered in various memo boxes can be joined with defined seperaters and the infomation can be edited in this new combination memo box and the...

Is it possible to loop the record selection ie. when you get to the last record it goes back to the first rather than hitting a blank record (new record). I am using a combo box for record selection so VB code would do the job maybe??????

It worked!! Thanks for your help. Re-wrote the whole thing in SQL view and it works again and again with out any additions to the code.:D

If i keep running it it keeps adding critea and sub querys untill it reaches a point and says " you cancelled the previos operation"

Growing all the time I think i know the cause now!!! On closer inspection it seems as if my code is growing all the time i.e ever time i run the query it adds a new line into the critiea, this is why the last option stops working and then the next as the code becomes to long.. i think... any...

SELECT [Inital PMQ data].[PMQ #], [Inital PMQ data].[Start Date], [Inital PMQ data].Material, [Inital PMQ data].supplierID, [Comment blocks].Details, [Progress Meter].[Production Runs], [Inital PMQ data].Priority, [Comment blocks].[Comments 1], [Comment blocks].[Comments 2], [Comment...

im using [forms]![frmexample]![example] or [forms]![frmexample]![example] is null. So blank fields are not a problem, im requerying the a subform to display the results on the afterupdate of the combo box example. It all works it just wont do more than 2 at a time. Will look into this code a bit...

I have a select query that gets it criteria from a form using the [forms]![frmrep]![field] format... this works fine up to two criteria (selecting two diffrent fields to filter by) then any additional fields with criteria dont work? no error messages the query just ignores them.......... is this...

I know this comes up a lot and i have looked through the past threads and at the microsoft site but i just cant get this to work. the code runs and produces an outlook box with all the appropreate bits filled in but its produce's an error on click of the send button. When trting to save the...

It Works!!! Thanks for all your help its working like a dream! So much better than using the glue option!!

Let me know if you have any luck.

Access 2000 as of this morning. could'nt get em to take it up to XP where i belive all my wheel based problems are said to stop!

i cant get the mousewheel.zip example to work although the dll is added in the ref's it comes up with run time error 429 "Active x components can't be created" Any idea's?

i dont want users to be able to skip records even when they are just viewing data i.e not adding or editing whats there through a filtered form view. I could trigger a update to the record on open of the form i.e auto in todays date into a invisable field but its a bit of a messy solution. Just...

VB Problem I now exactly what i need to do to fix the problem thanks the the microsoft step by step. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q278379 But i dont seem to have VB 6. so cant build the .DLL can anyone send it to me? or am i just being foolish can i do it in the...