Recent content by Apschminkey

This works perfectly. Thanks for all of your help!

Here is the code I have in the On Format event so far: Private Sub GroupHeader6_Format(Cancel As Integer, FormatCount As Integer) Me.STA_LabSheetSubreport_A.Visible = (Me.Testname = "Test A") Me.STA_LabSheetSubreport_B.Visible = (Me.Testname = "Test-B") Me.STA_LabSheetSubreport_C.Visible =...

I used the report header of the subreport......it works!

Is it possible that because I am putting something in the page header of a subreport (which really doesn't have a "page" of its own) it will not print?

This is REALLY close! I created two subreports, each with one line of text, and they become visible as the test name dictates. The single line of text that I put into the subreport is in the details section, and it shows up twice when it prints in the main report. I haven't figured out if this...

I DO have to print bunches of lab sheets at one time. If I use the On Format event will the "visibility" reset if the next page to be printed is a different test? In other words, if I have several different types of report to print with the subreports toggle on and off as needed?

I am making changes to a commercial laboratory LIMS system that our company uses to track and report test samples. We have a document called a “Lab Sheet” which is used to document various pieces of information before the data is entered into the computer. Currently, to print these lab sheets I...

I have copied part of a text search facility from: http://www.microsoft-accesssolutions.co.uk/text_search.htm onto an application that I have been working on. Originally it searched a field called strStudentID for a particular string and then went to THAT record. I am using it to search a...

Northwind has a form which is very close to what I need to accomplish. The difference is that on their Order form you select a customer and then you add any number of products to the order. The list of products is not filtered by any other parameter on the form.

I am trying to design a form which can be used to order supplies for our laboratory. I have a table which contains a list of lab supplies (vendor, description, price, catalog number etc). On the form, I would like to first select the vendor using a combo box (I can handle it to here). I would...

I actually found the answer to this one on the Microsoft site. Turns out that my ODBC links were set to "fetch data in background".....that was Baaaaad. Thanks.

Our company runs a Foxpro database to track laboratory testing samples. I have developed an Access application which allows us to retrieve infromation from the Foxpro tables. It was pointed out to me today that if the same report is run multiple times, even just seconds apart, some of the data...

Duane: I didn't use the alias in anotehr column but I tried to sort the "aliased" column. Here is the SQL view. EXP (the sum of prices) is the value which I would like to sort. SELECT comp.cnum, Sum(samp_lns.price) AS EXP FROM (samp INNER JOIN samp_lns ON samp.labnum = samp_lns.labnum) INNER...

I have created a query which produces a list of customers and their sum-totals (Expr1: Sum([price])of sales for a given period of time (using "where"). The datasheet view gives me the correct results. If I create a report based on the above query, everything seems ok until Access tries to...

I have an Access form which we use to input contact information for various people in our marketing database. Each of these clients falls into a certain category which is recorded by clicking one box in the "Contact Type" group options box. The selections are stored as numeric data...