Search results

Hi all, I have tried searching for other relevant posts but have not found anything. I have a form that gives the user the option of opening up 3 different forms (bit like a switchboard). When a form is selected to open, upon opening, the main selection form is visible behind the opened...

Cheers. :) The union query has worked, although I've still got 2 clients that pop up with a duplicate record. If I use: SELECT (Person_Id), (Name), (Address) FROM (tbl_A_no_duplicates) UNION SELECT (Person_Id), (Name), (Address) FROM (tbl_B_no_duplicates) UNION SELECT (Person_Id), (Name)...

dcx693, Thanks for the suggestion. I created a union query but when I run the query, it returns all the records from all 3 tables. Here is the SQL statement, SELECT (Person_Id), (Name), (Surname), (Date_of_Birth), (Address), (Post_Code), (Supplier_Name), (Service_Type), (Start_Date) FROM...

Hi all, I have a database that contains records for all of our clients. One of the fields relates to service type received. The main table that holds all the records has many duplicates, as some clients have more than one service. I have created separate tables and append queries to filter out...

Jon K - Thanks for the advice, even the admin staff can do it - well chuffed. However, I just thought about updating the table. The table will need to updated every now and then with a more accurate list of users. Is there anyway I can update this table and still use the queries and reports I...

Thanks Jon K Worked a treat.:D :D

Unfortunately, there is only one field for assessments and this contains all the different types. It is set out like so: ID (Primary key) - Name - Surname - Assessment So if Joe Bloggs has had for different assessments, then he is listed 4 times, but the assessment details are different. Any...

Hi guys, I have been given a table that was produced in Excel that I have imported into Access, it is a list of service users that have received an assessment from us. There are 11 different assessments and not all users have had one of each. For example, one user has 4 different assessments...

Hi, I have been given the task of producing a feasibility study on the benefits of building a separate (secure) database on Access or having the software developers build an add-on to our existing system. I was wondering if any body could help me with some of the pro's and con's for each...

Thanks for the advice. I have just completed the user level security wizard and was well impressed. Just tried it out on an unsespecting admin clerk - worked a treat. Thanks for all your help. :D

Thanks Autoeng. Worked a treat. Oldsoftboss, Thanks for the code. Haven't tried it yet though, boss got me working on something else... I like the db form you emailed to me - just what I was looking for. Thanks for you help. ghudson, Now you got me!!! If I used Access security would this...

Hiya, I am trying to create a form that can be used as the user level logon screen. The form has been designed with an option group for selecting the type of user and then a text box for the password to be entered in, followed by a continue button. Once the user has selected their type and...

Hi, At the bottom of each of my reports I have a text box that displays the total number of records within the report. What I am trying to do is create a new report that will show the values from each of these text boxes, basically producing a summary sheet. Is this possible?

;) Thanks Sara, Worked first time.

Basically on the page footer.

Thanks for the advice Colin. It has worked on one of the forms, but not the other. Basically the report shows information relating to clients details, (as defined in the query). I'm trying to include a text box on the report that will display the number of records in the report. So for...

Hiya, I'm having a bit of trouble showing the totals at the bottom of a report. I have tried setting the control source to =Count(*) but the message in the text box displays #Error Doe's anybody know what I'm doing wrong? Any help would be greatly appreciated. Thanks

Hiya, I have a number of reports that provide specific information relating to the queries they are based on, as well as a sum in a text box to calculate the number of records within the report. Basically I am wanting to take the outcome of the sums on all reports and then produce one report...

:) Thanks, totally forgot about that.

Hello, There is probably a really simple answer to this, but my mind has gone totally blank. Basically I am trying to create a query that will count all of the records in a form that match the criteria I want. For instance, out of 100 children registered, I want to find out the number that are...