Search results

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...

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...

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...

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...

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...

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...

Hi, I have set up a form with combo boxes, which get their data from tables. I have also set up a received date box which uses a calender to fill. The box on the form I need to autofill is the target date. This will obviously be a date in the future. I can set this as a standard date by...

Hi, I have created a form with drop downs to set the parameters for a specific query. I have also created a command button to run the query when the desired parameters have been chosen. The query then pops up when the run button is pressed. Is it possible to add a button (attached to the...

I have set up a a form to select the parameters for a query. I have tried to create a button for the user to clear all of the parameters to save them having to do it one by one manually or having to close the form and reopen. I have used the following Event Procedure: Private Sub...

Hi, Please see the SQL from my query so far... SELECT [Task Screen Data].[Task Reference], [Task Screen Data].Client, [Task Screen Data].[Administrator Dealing], [Task Screen Data].[Date Received], [Task Screen Data].[Task Type], [Task Screen Data].[Member Task], [Task Screen...