Recent content by chunk22

Thanks for the reply, I have done something similar like this so understand where you are coming from however. The issue I have is that the second table I want to query is dynamic and depends on what Incident type is selected from the main form as to what table holds the information. Example...

I have a main table which user enter generic details regarding an incident, i.e. Name, location, person involved, and Incident Type (This will then envoke what form is opened next). Incident types for example are Crime, Anti-Social Behaviour, Violence, etc. These incident type all have their...

Many thanks for the reply, i'm new to using Access and SQL could anyone help with the structure of it, or get me on the right track. Details are: On change event in combo box (Incident Type) to Update a seperate list box with the incident types in the RowSource of a table also called Incident...

I have a form which users enter generic details on for an incident. A field (Incident Type) when selected determines what form is opened next after a click button. I want to display a list box on the form that displays what sub Incident Types are related to the Incident Type they select on the...

Many many thanks for your assistants all. Chunk22

That now loads but you have to click 'yes' to get rid of the window. In the error handling it says "Expression not defined in context" (Watch on "cmdSend_Click() Any suggestions?

What I have done is put the API decs in a module called Module 1 Chunk22

Thanks for your help, I have done that and I get an error again with the following line: uClickYes = RegisterWindowMessage("CLICKYES_SUSPEND_RESUME") Any further sugestions? Thanks again Chunk22

So are you saying that first I need to have the code as follows: 'Private Sub cmdSend_Click()- Not included Dim wnd As Long Dim uClickYes As Long Dim Res As Long On Error GoTo Err_cmdSend_Click uClickYes = RegisterWindowMessage("CLICKYES_SUSPEND_RESUME") ' Find ClickYes Window by classname...

I have tried the above and it returns nothing, no action is carried out. I added a watch to the cmdSend() function and it 'can't compile module' any further ideas? Chunk22

Many Many thanks for your replies. I have been on to the web site you suggested and see what you can insert the code to enable the clickyes. Where would I need to post this, again please excuses my ignorance, I'm still learning. Chunk22

I apologise for being the novice that I am, I have only been using Access and VBA for a few month. I have a database that needs a report to be e-mailed out automatically, without the user have to click send. I have Outlook 2003 / Exchange and Access 2003. I have managed to get the e-mail to...

The wif is the Workgroup information file, when I hade a go at setting up this like I say it works fine but then if you delete this file I could get into the database without logging in. are you saying this is because it was set up incorrectly?

The only thing is with the userlevel stuff,if you manage to find the wif file and delete it it then uses the default file with no locks, has anyone got anything else? Chunk22

More of a misc question? I have a database that I want to role out to staff and have a few security issues. I would like to know if anyone knows of a program (Free or licenced) that can be used to embed my db so that the back end is not accessable apart from an administrator. Can anyone help?