Search results

Hi there! I hope that what I'm about to write makes sense and I don't cause too much confusion... We have quite an extensive database (or at least it's extensive for us), around 250mb. It's a split database with the back-end being held on our server. It holds around 6 years worth of...

Hi, I'm trying to send a report using the EmailObject macro. I've completed all the relevant fields i.e. To, Subject, Message Edit etc. However, I want the macro to use an email template that has already been created and is held on our server. I've tried using the path for the file and also...

Hi guys, I've hit a bit of a brick wall when completing a form build. Basically I have created a form that allows the user to raise an installation order. The form works perfectly and takes all of the information from the form (which is stored in tables) and places it into a nice Report that...

Hi, I have a form that we use for adding orders. The order will contain product lines, so I use a continuous form to do this. At the bottom of the form is a text box that calculates the total cost of the order by taking all the unit amounts. This box is just used for displaying a figure on a...

Hi, I'm not sure how this is happening, however I'm hoping that someone can help. I have a table containing a list of customers and their contact details. The table includes an AutoNumber field which is set as the Primary Key and Indexed with No Duplicates. We have over 650 records on this...

Hi, Is there a reason why a PasteAppend command will work on one machine but not on another? I've tried issuing a different front end copy, tried to diagnose the issue, however I'm not getting much luck. When I click the 'Copy Line' command button on my machine it does what it's supposed to...

Hi, I'm trying to create and AfterUpdate event that will display a MsgBox if a Quantity entered into Box A, is greater than the Quantity shown in Box B. I've managed to find a piece of code on this forum that sort of looked like it was what I needed. However, in my circumstances, it isn't just...

Hi all,, I've been asked to work on a new "Installations" section of our database. I didn't design the database itself, so it's always a little difficult to make sure anything new that is implemented works as it should. I won't bore you with all the details regarding the new section as our...

Hello, I've built a query to perform a simple calculation. To take a Contribution figure, which effectively is our Sales Figure, the Anticipated Start Date of the Project and then divide the Contribution by the Duration of the Project. For example The Contribution of a Project is say, £10,000...

Hi, I'm trying to run a query that calculates a figure over a certain number of months. The exact calculation is: Contribution Value divided by Duration of Works I then have the report set up to take into account the Anticipated Start Date. From this date it takes the results from the above...

Hi, I want to update a record when I select a specific option from a combo box in a form. The concept seems simple, its the code that I struggle with... I have a combo box in a form that has two options -- "Won" or "Lost" I have a field in my table called "DateWon" When I select "Won" from...

Hi, I'm hoping that you can help me with my issue. I'm trying to use the Totals function in Reports to total Sum our Quote Values. The field that is being totalled is from a calculation in a query that makes up the report itself. The calculation in the query works out the ContributionValue...

Hi all, I'm hoping you can help me with a small question I have... I have a database that we use for our Fitters that install our Products. It works simply by attaching an Order No and Fitter next to a Product. At a later stage once the fitter has installed the Product, we input the quantity...

Hi, I'm trying to create a simple command button that will generate a sequential number using the DMAX function. The database will be used only by one user so I wont have the issue of 2 users attempting to use the same number. I've spent some time looking through this forum to try and find...

Hi, Is there a way I can sum a calculated field on a report? I have a report that calculates the cost of miles travelled. Under the Detail section is a text box which totals the miles using =Sum([Appointed Charge] However, I'm looking for a way I can include a text box in the...

Hi, How can I include a field from a table in to a query - that has no relationship? For example... I want to know the cost for all materials on each job - I can get that answer. However, I only want to know this for jobs that have been despatched (indicated by having a '2' in the field) The...

Good afternoon, I'm really struggling with my query and I hope I can explain well enough for you to be able to help me. I've been asked to product a report that shows our 'Material Allowance' was for all Jobs where, the Job is complete. (We have a field called '% Done' and when it shows 100...

Hi, I'm looking for a way to merge various fields from a table into just one using a query. The purpose will be for easier copying and pasting in to an email. So we have a table to stores information such as Site Contact, Address 1, Address 2, Address 3, Postcode etc. I want to be able to...

Hi All, I'm designing a new database that will be used in the company that I work for and hopefully assist with our installations department. The purpose of the database will be to record what we call 'F Notes', which is basically a Purchase Order, only that we use a unqiue number that begins...

Hi All, I've created a report that shows quotation values for each of our customer. I want the report to be a summary rather than show a line by line figure. So I've grouped by Customer and then created a =Sum(