I'm trying to write an Access query to compare records and give me exceptions where values don't match in some fields and do match in others.
I have a table which lists customers, policy ID...
I'm trying to create a pop-up form to filter a report. The form has 5 drop down combo boxes and then the 3 command buttons. The five menus are searching for either numbers or letters. The f...
I've built a report in MS Access that uses a query. I want the query to reference an open form for the date range. If I put the code snippet below into the Access Query design view, it says ...
I have this criterion in a Query in the date field of the underlying Table:
<["Before which date"] And >["After which date?"]
The query then only selects records between those dates.
H...
I have a large table that I have selected data from th by use of queries, totaling 15 different queries. I want to take those queries and sum the totals of one of the fields within the query ...
Ok so I have a table with the major event time timelines and a query which calculates all the days a the unique ID, Application Assigned Number, was suspended.. So I have used an inner join t...
Greetings,
I have a calculation that is completed in one of my queries.
TimeFRMT: (Format(([Minutes]\60)+(CInt(([Minutes]-(60*([Minutes]\60)))/15)*15/60),"Fixed")*[Number_Of_Children]
...
I am working on a database in Access 2007 and have managed to do everything that I've wanted so far without having to make any macros or do any coding... since I've never done either, I'm rat...
Hi,
Is it possible to output a report as HTML and then send that report as an email which is visible in the Body/Message section of the email? I currently send email from access coded into...
I have a question regarding generation of ACCESS reports and converting them to .pdf documents. I have a function in an ACCESS database that loops through records in a table and creates a rep...
I am writing a Access database to track some information in a small company. In the Detail section of the report I have drawn vertical lines that run from the top of the Detail section to the...
I have a database that was created in Access 2007 by a co-worker. It is a simple tape log database. What he wants me to do is to create a report based on a query that initially asks for user...
I am creating a pop-up form to filter a report. I have created five drop down menus, however one of them is not working. The other four work perfectly but when I try to filter using the firs...
Dear Experts,
a client of mine asked me to alter their system so they can print their Access based invoices directly to PDF and then to Outlook. This now works like a charm.
There's only...
I am trying to build a report that counts the total records within a date range and then breaks the various types of records into their respective groups nd shows the percentage that the repre...
I have a field on a report and depending on what value is returned in this field for the current record I want to pull in a gif file. (Or any type of picture file). So for instance if [txtTest...
I have a query that is used for a Report. There is a field in the query that has a criteria value of;
Between [Enter Start Date] And [Enter Final Date]
I would like the values that are e...
Dear Experts:
I encountered an MS Access 2003 file with reports inside.
After opening the design view of a report, I am able to see the list of field names by clicking the "Field L...
I am trying to build a report that combines multiple tables and will give me the report below:
Report should be sorted by contractor doing the work, then by permit type, then by permit numb...
I have a report that I am creating that I want to count the number of records (permits issued to a construction company), then total them at the end of each section. It should look like this:...
I have an Access 2003 database which is used to print an Invoice into a pre-printed 8.5 x 14 form in the printer.
The report design uses an Ole (Unbound Ole Frame) of Microsoft Word.
The u...
Without using specirfic usernames, is there a way of limiting the number of simultaneous connections to a database? i.e. you might have 10 usernames but only 3 can be using the DB at the same ...
Hello,
I have a Access database which contains simple form of the items that entered during the week. I am accessing that records as a all record and it shows in asp all the entered records...
Bare with me while I try to explain this one.
I have developed a front end to a database using MS Access 2003 Forms. In particular I have one form that is used to display Statistics etc abo...
In print preview the report logo and images in the report display fine but when sent to the printer the logo and images do not appear at all. This happens on two different printers which both...
