Search results

First off I am using Access 2003 database on Access 2007 I'm not quite show how to explain the problem I have been having lately. Basically I am trying to take two records from one table and sum the quantity field in them to display the information on a different table. I.E. table one has...

I am doing this in Access 2007. I'm having an issue trying to move between records on a set form. The form is linked to a table where each order is created has multiple lines to it. When I try using the buttons I made to move between the records I view duplicate records until I finally get to a...

I am using Access 2007 and am attempting to create a report similar to one I currently use in Excel. The issue I seem to be having is finding a way to have the data for each 'job' on the same line going from left to right lining up with the days of the month. I've attached a PDF of what I have...

So I've managed to use a search form that was posted on here but I am having a problem being able to search based on the displayed results of a combo box. I am trying to have a field search the second column of the combo box but I don't know the code to do so. To simplify the question here, is...

I've been looking about and was wondering if it is possible to make a report based off a query that would combine fields that are closely related but not the exact same. My example is, I have parts : BM 2K A BM 2K B BM 2K A Type 2 BM 2K B Type 2 (these items go from 1K all the way to 12K) Each...

Ok so I've been put in charge of another database, this one was built by someone else and I have been trying to create a new form based off the programmers tables and queries. The problem I have run into is that I have 1 shipment with 10 line items to it so on my form it displays that way. Is...

Ok a bit of background, I've made 3 or 4 (could even be a dozen by now) databases in Access 2007 and instead of running them all as separate files I was wondering if there is a way to combine them all into one database or exe file. Now some of these are quite large databases so combining them by...

I'm hoping to get a reply to solve this. Attached is my Access 2007 database, what I was trying to do is use the AutoNumber field as a hyperlink to go from the search form to the matching Accident/Near Miss Form so that the user can update records that they just searched for. I keep getting an...

I'm not sure who did what to the database that I loaded but someone found the, what I call the middle file after I split the database and then made it ACCDE. Now when I log in I get this message: "The SQL Statement could not be executed because it contains ambiguous outer joins. To force one...

Attached is part of a 2007 Access Database, as you can see I copied the form view and layout from the sample I've seen posted on this site but I can't get either of the filter buttons to work. Any idea what and where I am going wrong with the code?

Not 100% sure this goes in this section but I'm giving it a shot. As my SN shows I'm not a programmer yet I've been asked to build an access database for the EH&S (since I've built a few minor ones for my department) and I was wondering how I would go about using the calendar control option...