Recent content by AdamO

I have a database on a server which has worked fine for some years now. Today i tried to install a new FE and I needed to run the Linked Table wizard to connect to the BE. When I opened the Linked Table option I could not view any of the links with the new FE or run the wizard. I kept the...

Hello, I have some reports which are currently set up as follows: Lead Grouping: Salesperson name Next Grouping: Appointment date by month Detail: the summary amounts for numbers of appointments & amount sold. I have been asked to show the report with separate lines showing the 'Detail' above...

Hi, Over the past three months I have been trying to develop an application which can repeat appointment entries. I would like to have the option to repeat an appointment entry for a given number of weeks. For example if an appointment entry was placed for today (Wednesday), there would be a...

Hi, I have a form with a Calendar control on it which enable an appointment to be made. The fields are: Appt Date Appt Start Time Appt End Time Appt Position Appt Reason. Everything works fine, however I have now been asked to build a facility to enter appointments for a given time in the...

Hello, I have Customers recorded and a number of addresses associated with each customer. They are in two tables linked by CustomerID and are shown in forms as frmCustomers & subfrmCustomerAddresses. From frmCustomers, I open another form which records the orders maid by that customer. What I...

Hi, I have a form which controls purchases. There are two subforms: 1. Shows the items purchases 2. One field on this which totals the items purchases in 1 What I would like to occur is that as soon as 1 is exited, 2 is updated. I have placed a save option on exiting 1, but that does not...

IGNORE THIS THREAD - IT IS A DUPLICATION. I have found the original. The search on my name did not bring up all of my entries! Thanks.

Hello, Apologies if this is duplicated elsewhere. I did post yesterday, but I cannot now trace the entry. I have a database with a back end on a server and front ends on client pc's. It is written in Access 2000. I have been asked to upgrade to Access 2002. On help from Microsoft, they...

Hello, I have a database split with the back end on a server and front ends on pc's. It is written in 2002 and needs to be upgraded to 2002. Microsoft mention in their help guides that you should recreate the workgroup file in 2002 and then convert the database. I have done this, but I am...

I have a form with a tab control. The users required that the tab control changed colour depending on whether any information was contained within one of the fields on tab concerned. As I understand it, you cannot change the colour of these tab controls, so I looked for a different solution...

Thanks Rich & abezuide for your replies. Rich, unfortunately the export option does not give me an option to save to a lower version. Abezuide, I have no experience of Union queries but will try. If you have an example it would be appreciated. I am enclosing my stripped down database anyway...

Hello Rich, Thanks for getting back. I thought I was getting to a desired result. I created a table tblDates with dates for the next five years. The field name is the same as the date field in my appointments table tblAppointments. I ensured the relationship between tblDates and...

I am still having some problems unfortunately. I thought the requirement was no longer needed, but I have just hear it is. I have an SQL as follows: SELECT tblAppointments.ApptID, tblAppointments.ClientID, tblClients.ClientPCTitle, tblClients.ClientPCForename, tblClients.ClientPCSurname...

Hello, Thank you for your replies. Apologies, I believe I may not have made myself clear from the outset. The database enables appointments to be entered. The field supports a date being selected. There will be some days where there are no appointments. When I run a report (by date range...

Thanks for your reply. I have been trying a number of options without success so far. In your reply you mention making a table where days of the week are defined. Am I right in assuming I would have to manually enter dates for the next five years of so in order for the join query to work...