Search results

not sure what the issue was but I got the IT dept to repair the access install and its all working now so all good but cheers for the reply

nvm ... got IT to repair the install and its working now...

Hi All I am having some issues here. Basically the story goes as such I have 2 databases that I actively use both have been created using access 2000 as this is all I have access to at work for development purposes. I do have access 2003 Runtime environment as well but this is pointless...

That worked ... Cheers Must admit I was pretty stoked that I was fairly close to the right idea but still fairly new to VBA.

Hi All I have a menu button that calls a report which works fine however the user wishes more functionality from this report. This is why I have added a second check box. Lets call the check boxes 1 and 2. I want the report to print records where both 1 and 2 are FALSE. If check box 2 is...

actually nevermind I got it sorted. Problem was I had an excess of #'s in my code so what should have been DoCmd.OpenReport "expired", acViewPrieview,,"ReviewDue <" & Format(Date, "\#mm\/dd\/yyyy\#") I had DoCmd.OpenReport "expired", acViewPrieview, , "ReviewDue < #" & Format(Date...

That makes alot more sence once seeing it. And after running the report with the just the Date option I can see that it will require the formatting of the date as well. However when I run the application I get a runtime error and access closes - without the date formatting the app works...

Coolio Tried it exactly as you mentioned and its giving me a compile error: Expected Expression and Highlighting the first # as in at the red # "ReviewDue < Format(Date, "\#mm\/dd\/yyyy\#") any ideas as to why?

Thanks for the speedy reply Bob You are correct in thinking I am not from the states and I am thinking that (due to being in Aus) that the following would be right for dd/mm/yyyy formatted dates "ReviewDue < Format(Date, "\#dd\/mm\/yyyy\#") Today 03:53 PM and the bit I was looking for...

Hi All I know this has probably been asked a heap of times before but I cannot find the solution. What I would like to do is pretty simple. I want to create a report that refers to a "ReviewDue" cell in a table and if the date has passed then add the expired documents to the report. If...

I see what you did there Thats awesome Cheers for that its just what I was after

Hi All Just wondering how I could go about getting this to work I want the "Admin" user to go to the "Menu" form and the "User" user to log into the "frm_NA_Menu" form. Also the 3 attempts to log in is not working for me here (this could be due to system restrictions at work though and not...

Access has built in security and you could use that. Tools > Security > User-Level Security Wizard I've had some luck with that but only at home never at work due to permissions set on the drives at work and not being able to write/access the required locations. I'm sure there is...

I know theres the security that access has built in however I was avoiding using that as operating system limitations at work exist and has caused troubles in the past when attempting to set a password on a db. I'll move on to the vba coding forum and see if they can help me there. Thanks rey

Hi all Just wondering if it is possible to use a log in form on an access database to allow different users differing access to the database. Further explanation I only want 2 users Admin and User Admin will be the user that maintains the database and will be accessed by a minimum of people...

The solution was surprisingly simple but eluded my non-programmer mind ... funny how when you ask a computer to look something up you have to tell it what you want it to look up .... derp

Ahhh ok I can see what I was missing there. Thanks for the help btw its muchly appreciated and sorry about the wasting of time with the empty database. That solution worked perfect (once I rebuilt the query in the original database). So thanks heaps

Sorry posted that before my morning coffee and just went and did the mass delete (not the the original has much in it ~10 records in total so far) Here's the dummy one with 3 dummy records, a few categories (which I realise are under the department table) and some committee's included. I've...

I got the dbl click event idea but my VBA is really poor... to the point where its pretty much non-existant and the use of variables (although its not so bad that i do not recognise the idea of variables) really throws me. Any chance you could either have a look at the database and see where...

After having a go at that I found its not quite what I was after. I was hoping to display the records instead of just the name of the record if that makes sense. Thanks for the pointers though... a way to click on the record name and see the full record on a separate page or something like...