Search results

Hi I need some help urgently with a mail merge I created. I have created a mail merge based on a query from my access database, it works fine when the database is not open but when I try to access it when my database is open - I get a Data Link Properties windows asking to specify a...

Thanks! Thanks guys for your help! It worked!

Hi The reason why it is setup so badly is because each table is an export from two different systems. It is a nightmare! Unfortuntely there is no employee table with an ID field....is there another way I can do this please. Thanks for your response.

Hi I am struggling with something im sure is quite simple. I have two tables - the first has employee name and each record represents 1 telephone call answered. The second table also has the employee name but this table has a field with calls answered. What I need to do is crosscheck the...

Thank you :) Thanks for your help. I have managed to sort it arby adding an alert function into the script just above the final script! Thanks for your help! Dazstarr

Hello I have recently finished a data access page and have one last thing to do on it. When you press a button (Command0), it saves the record into the table. This is fine, but I want it to display a message box as well. I am not sure what code to put in and where to put it. Below is a...

Query Help Thanks for your post... But it is not giving me the info i require. The results need to be broken down by each question and each site. So the rows will be each site and 10 columns for the 10 questions with a percentage in each field broken down by site. I have been assured this...

Query Help Many Thanks for your help!! I have never tried something like this before.... Do I need to do this in 2 separate queries or can i calculate this in one field? Many Thanks for your response. Daz

Do I need a crosstab query? Hi All Im after some help with a query im building. I have a table called QuizResults which has 10 Yes/No fields. The table also has a field called Site. Each site will take a quiz and the problem I am having is with the statistics side of things. What I need...

DAP Login Ideally - what I (or management!) want is 1 link to a webpage where a user inputs a username and password which then takes them to a another webpage. Can this be done? I managed to crack it using a access form, but no idea how to do it on a data access page. I tried exporting the...

DAP Login Im quite new to access and have never used data access pages so pls bear with me. By switchboard - does this mean use an access form to login - which then points to the data access page? Thanks

Hello Can anyone help? Im in the process of making an access database with a login form. I used VB code to validate the login which was bound to a logon button after the user puts in a username and password. This worked fine - but I now need to do the same for a data access page. Can anyone...