Search results

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

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

Hello, I have an appointments database. It enables appointments to be booked with start and end times. Appointments are shown by selecting the day from a calandar object in a form. A report shows appointments for a given sales person by a date range selected. The user has now asked for a...

Retaining an ID on a form - is there a better way. Hello, I currently have a form which enables a user to make appointments for a salesperson. The form has a calendar control and a subform which lists the appointment details ie date, time, status etc. The subform runs of a query where I have...

I have code I place in BeforeUpdate on forms to check for blank and null for what I determine as mandatory fields. I have a subform which carries a salesid from the main form. I have the default value of salesid on the subform referring to the salesid on the main form. The ID is one entry is...

Hello, I am having problems writing a query. In my table I have fields which look up products sold. These are named: ServiceName1, ServiceName2…to…ServiceName10 I then have prices for each Service. These fields are: SalesServName1PriceUsed, SalesServName2PriceUsed….to…...

Hello, I have posted under forms but this could relate to the queries section. I am trying to use an appointments database which I discovered via this forum (http://members.shaw.ca/glenk/access2000.html). It has a calendar. On selecting a date on the calendar, appointments are shown for that...

I have been asked to build a database to be used in Access 2002. I only have Access 2000 but can 'borrow' a PC with 2002 briefly. I was planning to build in Access 2000, upgrade in Access 2002 and then secure in Access 2002. Reading some of the threads I presume it would not be advisable to...

Hello, I cannot get my mind around this problem. I have a Client form and linked to this by ClientID is a policy records form. When the policy record form is opened everything appears to link ok. There is a combo box on this policy records form where you can select the policy type. After...

Hello, I am struggling to write an expression. I have a 12 month moving average amount which is already calculated. I now want to work out a bonus amount which will vary according to this moving avearge amount. The bonus is: Moving Increment Bonus % Average 50000 20 1% per 1000...

I am looking for some guidance on how I can approach a new requirement. We have nine standard letters which could be used for clients. From a form containing the customer name and address details, I am would like a kind of selection box which users can select the template they require, add a...

I have a sense this may be a basic question, but i would like to make sure. I have a secured database following Microsoft's recommended guidelines. If I saved this database as a different name or alternatively copied & pasted as a new name, is anything changed particularly regarding security...

I have nearly completed the security of a database. My final task is to set the permissions for each of my two groups of users. I wanted users to see and edit/add data using forms only. Likewise reports are available from a report form dialog box. One group should have the ability to see all...