Search results

I have a question about validation rules. I have in my db field called approved by which is the name of the manager approving the results, now what I wish to do is have the validation rule work in two ways (1) Only the manager logged in can approve results, this is so that the managers can not...

I've just managed to do something similar in my db. This is how I did it (1) use the macro command called TRANSFRSPREADSHEET (2) In Transfer Type enter Export (3) In Spreadsheet type put Excel (4) In Table Name put the name of the query you have used (5) In file name put whatever you wish to...

:D Thankyou, I didn't realise that you could do it that way. The macro says what TABLE name to use so i thought it would only work with Tables. Thanks very much, my db has just taken a big step forward.

Is it possible to export the data recovered from a query into Excel? I have managed to get the query to work properly but I can't figure out how to export it. Is this possible? Thanks for any help

ok thanks for your help. I will give that a try

Ok I have two different versions of the switchboard, one with the button and one without. Would I use a command in the autoexec macro do enable the correct one? PS I am rather new to using access.

hello I am making a datbase that controls a lot of results of our work. Now what I would like to do is to have a different switchboard depending on the user when they log in. All of our results need to be approved by a supervisor, so what I would like to do is have the button for the approval...

hello I have a little problem on a db I am making. I have 2 number fields that I am adding and subtracting to give me a range, both of which have 2 decimal places. Now when I put the results onto a report it lists the results with 8 decimal places. i.e. 24.10 + 6.30 = 30.40000153 instead of...