Recent content by KW99

Thanks for this. I had looked at this one and I guess just wondered if there were some fancy ones out there now. Its no problem though I can customise as appropriate. Does anyone know why Microsoft have abandoned the OCX Calendars from 2007 onwards? I guess it will be better for 'future...

I wrote some databases a few years ago in Access 2003, however recently have upgraded to Access 2010. Unfortunately I used the inbuilt calendars in Access, which following the upgrade to Access 2010 now no longer work (get a missing or broken ref to file mscalocx version 7). I can...

Really, that is quite shocking. I am really surprised that there is not some way of writing in a basic input mask in the code. I could make some forms up, but it means changing about 9 switchboards and it would have been alot easier to just amend a little bit of the code.

This should be an easy one but I am not 100% sure how to do it. I have written the following code on a command button to set up a basic password for opening a 'locked switchboard'. What I really want to do is hide the password being typed into the input box with asterix's. Here is the current...

Sorted this myself thanks. I think I was having some sort of block when trying to do this originally. I decided to make a tabular form from the query and then insert this as the sub form. This then obviously allows you to add the delete command button to each of the records. Job done!!

Ok I have a quick question with regards to a form / query I have produced. I have a form with search parameters on it and a requery button to search for records which subsequently appear in a nested sub form (from a query) in the form itself. Now I have left it so that a user can amend the...

How do I set up a password entry which pops up on the database opening? No user logons are required just a simple password! I do not want to use the Access built in one as this is pretty un user friendly and if the database is transferred to a new pc, the password is no longer asked for...

Thanks for this, I actually just nested the query in the report. I am not sure why I did not do this in the first place. Thanks for your advice anyway.

Ok here is my problem (not sure if this is easily solved by a query or report, so I posted it in the query section): I have designed a database amongst other things to calculate client investment values based on price, units etc and criteria, such as date which is chosen by the user from a...

Wonderful.....worked like a charm!!! Thanks for your help.

Hi Wondering if anyone can help. I have a form, which is set up so that the user can select the search criteria from drop downs. The problem is I would like the date drop down to only allow the user to select an available date from a table of data hence I have linked the date dropdown to the...

Thats great, thanks for the help!!

Hi, I am trying to put a simple password on a command button on a form in order to open another form (if that makes sense). I have the following code (which I found on another thread) Private Sub Delmenu1_Click() On Error GoTo Err_Delmenu1_Click Retry: Dim strInput As String strInput =...

Hi, I wonder if there is anyone who can help with this one. It should be quite easy but I cannot seem to get my head round it at the moment. I am trying to add an investment section to a database I have designed. So far I have tables as follows: Table 1 Client Name Table 2 Fund Name...

Thanks I have sorted it now.