Search results

I am a bit rusty. Using a Microsoft Chart Object 6.0 in an Access 2010 report. It's easy enough to do the basics and that chart responds to data. In my case, I have 12 lines, or columns, being controlled by data. It responds to the data. just fine. What I want to do is control the line...

If I use the following SQL statement, the Dates sort Ascending order and the time assorts in Descending order: strSQL = "Select * From [tmpTempSAPFiles] Where [Technician] = '" & Forms!frmCertify!Technician & "' ORDER BY [FileDate], [FileTime] DESC;" I need the data to sort DESCENDING by...

Created a sub-report (tried same thing using a sub-form on the report) on the main report. At the top of the main report is a graph. Directly below it is the data that supports the graph. I am finding that if the sub-report had enough data to grow beyond Page 1 (of the main report), after the...

I have a simple access data table that maintains a environmental logger readings every five minutes. Two critical fields: ReadingDate & ReadingTime. I want to be able to pull all the readings between two date and times, such as 10 June 2012, 10:00AM and 12 June 2012, 10:00 AM. That sounded...

I can't figure out why this doesn't work: MyForm.Detail.Height = MyForm.Detail.Height - Int(0.75 * 1439.98848009216) I have a start-up that if a data-logger is not detected, I move other various control a little higher as in: Set MyForm = Forms!frmstartup For Each CTL In...

The FlexGrid control does not work in reports. Is there another control, or way way, to show, and format, a lot of columned data in a report without using a bunch of individual text boxes (uggh). Thanks and happy holidays, Dave

Hello there, It's been a while since I have been here, but here goes.... Cobverting our service database from Access to Access 2010 and there has been a few hurtles in the code (i.e., loss of calendar control - solved, Utility.MDS - still in flux, etc) and now this: I have a convenience...

MS Flex Grid is easy to us and works well on a data collection form. I thought I would try to use it in a report and in shows very, very tiny with the report in preview mode. In design mode it is big. Has anyone here ever used a FelxGrid on a report?

I can do the chart very nicely in Excel, but can not figure out how to do a scatter chart in Access that mimics Excel. In Excel you can have multitple X-AXIS in one chart. The Y-AXIS is scaled 1 - 100, major divisions of 10. Each curved line to be drawn on the chart has both Amplitide...

The column of the datasheet could represent a different variable depending how much data was collect for a given function. I find the colum titles make up the ledgend. So I just need to know how to change the datasheet column title through programming. I have tried something like this that...

One to None ???? Okay, relational tables is easy. If two tables are related, by say a SerialNumber field, I want to see what records in table A have no relations in table B and delete those records in table A. How do I do that? We have an instrument table that has 42,000+ instrument records...

Is there anything else that should be done when a form is closed? I ask this because I have observed with the Task Manager, Access 2000 taking 20,000K memory with my main form open. From there I link to another form, keeping main form open. With that second form open, Access is sucking up...

Access Code Slows way down Second time it is run Hay there, I have one form with a rather large amunt of code behind it collecting data from an electronic instrument (via serial commands to that instrument and via GPIB interface to some test equipment). Anyway... The first time I run this...

Why does the following report (correctly) 2 records: strSQL = "SELECT * FROM SERVICERECORDCALEQUIP WHERE RANum like " & TempRA & " ORDER BY RANum;" and this statement on finds one record: strSQL = "SELECT * FROM SERVICERECORDCALEQUIP WHERE RANum = " & TempRA & " ORDER BY RANum;"...

Creating an HTML message in this manor: Set olapp = CreateObject("Outlook.Application") Set olNamespace = olapp.GetNamespace("MAPI") Set olfolder = olNamespace.GetDefaultFolder(olFolderInbox) Set olMailItem = olfolder.Items.Add("IPM.Note") Set olattach = olMailItem.Attachments ' With olMailItem...

Hello there. Access 2000. stdocname = "CustomerWorkOrderRpt.XLS" DoCmd.OutputTo acReport, "CustomerWorkOrderRpt", acFormatXLS, stdocname, True Works, but Access closes, or crashes, immediately after creating the XLS spreadsheet. I have tried AcFormatHTML, AcFormatSNP, acFormatRTF and all...

If a user is asked for the Fiscal Week how can I have VBA determine what the start date of a Fiscal Week is? I know how to enter a Date and determine what fiscal week it is in. I have stolen <grin>;) enough code to do that. Often my manager will tell me to generate a so and so report for...

Hello there, I can export to Excel but only if an "example sheet" already exists. In the example below, NewFilename might = "Week 9 Labor Hours.XLS". If that Excel files doesn't already exist, I get a runtime error "1004 Week 9 Labor Hours.XLS could not be found....". If it already exists...

I can find plent of references to using the Microsoft Chart Active-X on the internet. I can find very little information on MsGraph objects. I actually control them rather well through VBA (i.e., Graph_Data.axes(2).minimumscale = MinScale(((Val(Me.ProbeLowestRespoce)) - 5) -...

I have a nice chart that hasd done what I wanted it too. Now I want to make the amount of X-AXIS data variable. Typically this would be 64 points. If you look at the datasheet, I can manually set the number of points by making sure the row selector is "raised". Now that's say there is only...