Search results

Probably a stupid question - but Is there a quick way to determine in code if a user is using Full version Access or Access Runtime Thanks

When you say "ALL" the tabs - did you remember to select the Up arrow and add the user to "Database" which does not drop down - but is above the others in the list !! If you have tried this and it does not work then I am at a loss to help - sorry ! GSC

I am sure somebody can help if you give more details, or ask a specific question ?, or even post an example of the code that is not working ! But it might be difficult to second guess what you have done so far !

Have you tried to import all objects to a new blank database - or will it not let you ? Sometimes it works - if you can see the objects - providid you have at least 'admin' rights to the 'database' object. - otherwise - you could try sending it to "Jon" at "Access World" he his a wonderful chap...

Probably a silly question - just me be lazy - is there a simple way to convert a MDA security file (Access V2) to an MDW (Access 97). Without having to retype all the groups, user names - import everything ..... I have inheritted an OLD (!!) database which was originnaly Access V2 - was...

Try looking at the help for "Balloons" - they are quite versatile and you can do just about anything with them - have a play ! Gary

Thanks Rich, Sorry for delay in getting back - was up the hospital all yesterday. Works a treat ! - I new it there had to be a simple way to do it - just need to tidy it up now and can have a early finish today. Cheers Gary

Help - need to draw a table in access using verticle lines drawn dynamically at report run time using the On-Page event. Trouble is I don't know the verticle length in advance. I can use a verticle 'bottom' value = 18.3 to draw a line to just above my footer, but need it to stop at bottom of...

Thanks Rich I did try that this morning but was getting syntax errors and/or Enter Parameter Value problems. ----I was forgetting the "=" sign - it makes all the difference. Cheers

I know that it should be simple but I have a mental block today (like most days) I want to output the contents of a text field on a report - but to enclose it in brackets. I could use the format = (@@@@@) - but I do not know how long the text value is beforhand. Is there a simple way ...

Steve, I think you are correct ! I suspected that someone has been playing with the spreadsheet - but have no evidence - I have not access to edit security only to poke the values into an area of one sheet. What I was hopeing was that somebody would be able to give a precise definition of the...

I suspect what you are trying to do is design just one set of forms and reports which read 'staff' and then be able to swap between tables. 1) If so you could make the link to the backend only at run-time and set the link table name to 'staff' during that 'run' and destroy it on complete. 2)...

Assuming your text box is called "Text1" then a line of code like:- Me![text1] = mytime HTH

Your requirement sounds similar to an Archive problem I had. I wanted to 'save' any 'deleted' records into an Archive table for 'Audit' purposes. I wrote a piece of code that used the "On Delete" event to save the record to a temporary table - prior to the database asking the usual question...

Thanks steve - I am pritty sure that is not the problem, though thanks for the info. The way the code works is that the Module in Access finds the appropriate records in the spreadsheet at runtime so as to allow for people re-ordering the table, spreadsheet or both. Tests show that the code...

Help please ! Trying to poke values into a Excel spreadsheet from Access table using OLE. Everything works fine (for several months)- software rolled out. But suddenly it has stopped working part way through the access table. I get an Error #1004. Anybody know what this error is? I can't...

If all users have 'accounts' then you could test to see what person or group is loggged on and allow or deny access that way! e.g. if currentuser() = "Admin" then exit sub if currentuser() = "H" then docmd.openform "myform" end if

Ruby - I know you have asked the question before so I will try to help - you need the OR function... First of all I have added comments to your existing code to help you (and me) understand what is already there ! [Also I do not have the IsNothing function - but I am sure that IsNull will do...

Sylvia, Its difficult to know what the problem is - but it sounds like the underlying query for the original form is trying to read a 'value' from another form - which is probably not now open. - Maybee the 'maintenance form' ? Make a note of the field name in the parameter box and then open...

Accesswatch - you are partialy correct. In Office XP 'Clippy' (and his friends) can be 'switched-off' and 'on' again. Unlike the current situation where they suddenly re-appear without being 'summond'. In my case they will be 'OFF' - but many people like them - hence the original question...