Search results for query: *

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...

Can someone tell me if it is possible to run an Access application as a stand-alone program without the various menus and "stuff" that comes up when you open the MS Access program? I'm not a REAL programmer so I apologize for not being able to speak the language well enough to ask the...

Thanks CosmoKramer!

I am trying to create a counter which will return the number of records which occur in a particular group. So far I hace created a text box called "Counter" and set the control source to =1. In the group footer, I have created a box where the control source is set to =sum([counter])...

Thanks Guys! Bringing up the point about how I was linking to the files made me go back and take a look at it. Instead of linking to free tables I linked to the .dbc (database container?) and things seem to be working well now. I'm sort of the default computer guy here and don't speak the...

I am trying to write an access application to pull data from our Foxpro database system. Whenever I link to a .DBF file, and create a form, it tells me that it "Cannot locate requested xbase memo file". Can someone tell me how to fix this problem? I am using Access 2000.