Search results

I have been using a database built in 2003. Yesterday I installed Access 2007. All was fine & I can open the 2003 database in the new Access programme and everything works - or appears to. I then thought I would create a 2007 format so created a black database and imported all of the database...

I have a form where the position for one field can be: Outstanding, Declined, Current or Cancelled. Currently I order: qryProposals.PropStatus DESC, qryProposals.PropDescName. I would like to order, but not in a ascending or decending manner. For example: Outstanding, Current, Declined...

I have part of my database which looks calculates from multiplying a price and store numbers a monthly revenue. This applies for each order. Each order also has a start date. What I would like to do is calcuate in a report a projected revenue month by month and this is where I would...

Hello, I wonder if someone can point me in the right direction. I have built a report which details proposal information by proposal. Each proposal could have a number of different marketing activity amounts associated with it. I have therefore totalled these amounts in a different report and...

Hello. Within our customer record (frmCustomers) we have a tab which details all proposals. These are contained in a subform (continuous form frmproposals). Each proposal can have a number of sales payments against it. Therefore there is a separate form (frmSales) which has been set up to open...

I have a database of customers and I want to check for duplicate entries. I have written a query that looks at duplicates of customer names. This works fine. The problem is that some users are entering new customers and may slightly change the wording of the customer name so that it therefore...

Sales information can be added against a customer record. What I would like to achieve is for users to still be able to record new sales information, but historical sales information (e.g. before 2007) can be viewed but not be able to be edited or changed. Is there a way of achieving this...

Hello, Today I have been experiencing a problem trying to open Access. If if selected either a shortcut to a database I often use or select Access from the Start Menu (All Programs) my PC would freeze. The CPU usage would rise to 100% and I could do nothing apart from unplug and take the...

I have a secured database and I need to have an identical separate database. The difference is that one database is for one county and the other is for another. I have been asked to have two separate databases rather than combine under one. There is no problem buliding the second database as it...

I have a database with lists clients across the UK. I have now been asked to provide options where users can select clients grouped by geopraphical area e.g say clients in Scotland. I can of course do this but having numerous identical forms where the source queries have different parameters...

I am not sure if my understanding is correct, but here goes. We have a database which is split FE & BE over a network of five users. Everything has been running smoothly until just over a week ago. At that time the database slowed considerably. The only thing we noticed was that in the...

I have a database built in Office 2000. The client wants it across a network but insists they do not want it split! They want it in a shared drive which everyone has access to via a shortcut. The database is secured so I presume the Workgroup file will have to be on each PC and a shortcut to...

Hi, I have a control on a form which opens up Word and completes fields in the Word document with data on the form. It basically fills in an invoice form. Everything works ok apart from when the invoice date and order date fields are passed. In the tables and in the forms, the dates are in...

Hello, Please bear with me in my explanation. I have a report which summarises appointments for salespersons. There are headers for the Sales persons name and then the Lead Type and below this there is summary number for three types of appointment: Held, Sold & Other. It looks like: Name #...

Hello, I am looking for a way to ensure a sub form is refreshed or requeried. I have forms as follows: 1.form for Purchases 2.subform for all items purchased 3.subform which has the total purchase price ie the total of all items in the subform 2 above A save is forced in 1 before data in 2...

Hello, I have an Orders form (frmOrders) which has a subform (frmOrderDetails) detailing the individual order items. For example, there is one order which may consist of many items. The problem I have experienced is that if someone completes frmOrderDetails first and then moves to frmOrders...

I have a Customer database which allows input of name and address details of the main contact and their partner. On the form, when you get to the partners details, the address is often identical. Is there a way of having a default value being the main contacts address. If this is the case there...

Hi, I have searched various solutions from this forum, but am still not getting the result I am after. I have a form detailing sales (frmSales). Within this form there are two subforms (subfrmSalesItemsForSubfrm) and (frmsubfrmCalcCommSunnByClient). The first offers options to select products...

Hello, I have secured a database using the steps 1 to 10 within the Frequently Asked Questions About Microsoft® Access Security for Microsoft Access versions 2.0 through 2000. I have followed the steps methodically, however when testing the security I find I can open the database using my...

I have a sub form and the SQL is: SELECT qryAppointments.ApptDate, qryAppointments.ApptStartTime, qryAppointments.ApptEndTime, qryAppointments.ClientID, qryAppointments.ClientPCTitle, qryAppointments.ClientFullName, qryAppointments.ClientPCForename, qryAppointments.ClientPCSurname...