Search results

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

Okay, this worked, but I have to type in all the X-AXIS lables manually and save the table in design mode: strCell = "" For X = 1 To 66 strCell = "A" + Trim(Str(X)) objDataSheet.Rows(X).include = False objDataSheet.Range(strCell) = "" Next X

I found I could delete rows like this: strCell = "" For X = 1 To 100 strCell = "A" + Trim(Str(X)) objDataSheet.Rows(X).Delete objDataSheet.Range(strCell) = "" Next X ...and then add as many row of data as need (i.e, 8 row, 16 rows, 32 rows, 64 rows) and the chart would adjust. The X-Axis...

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

Anyway to do that in code?

What is the best way to provide the user with a stop button? This isincase the code gets stuck in a loop, not from programming error necassarily but from external influence. For example the program controls an instrument which responds, your program takes a reading and tells the instrument to...

This was aggravating. I waisted far too much time figuring this out, but I eventually did. Here is what worked: Dim Myrepoert as Report Set MyReport = Reports!rptcertdata_rev1.rptCertDataPage4b_Rev1.Report I know I will forget this totally in a few months and hope I remeber to look at this...

I wish I followed that. I was talking about creating a Table in Word (not a database but a tabular table), then pasting it in to an Access Report. That actually works, but now I want to know how to fill out the data in this ole Word object. Access doesn't have nice tables the way word does...

Okay, banging head up against wall on this one.. In a report I used code as follows: Dim MyReport as Report Set MyReport = Reports!rptCertDataPage4b_Rev1 . . for each CTL in MyReports.Controls..... That worked great. Now that Reports!rptCertDataPage4b_Rev1 is a subreport to a master report...

Nice Word Tables in Access Reports Is it possible to have a table in a report similar to a table in Microsoft Word? Currently, I line up text boxes give each one a unique neame and fill in the data with code on the On_Print event. It works well, and looks good, but with 16 columns and 10...

I can COPY an image to the clip board and paste it in to an object on a form in a database. An save it in the database for viewing later, or printing in a report, etc. Now what I want to do, is receive that BMP through the GPIB port. I basically tell an oscilloscope to hard copy the image to...

[I[/I] I ended up doing this: ' X = InStr(strWidth, "E") W = Val(Left(strWidth, X - 1)) Y = Len(strWidth) Z = Abs(Val(Mid(strWidth, X + 1, Len(strWidth) - X))) + 1 V = 10 ^ Z PulseWidth = Val(strWidth) * V ' tdsGetValidPulserWidth = PulseWidth ' This seems to work

Gosh I was tired and I am no where close to releasing to new revision. This database is actually an instrument test program. I used VBA instead of VB6 becasue it so easy to store records in a database and work with the data. It is much harder to distribute, but I am not worried about that...

Ahhhhh!!! I had a brain fart! That simple, eh? I tried everything but that because I "knew" that would not work! I feel bloody silly now! Thanks much, Dave

Hello there, How do I translate a string such as "123E-3" to a number, such as .123? Is there a built in function for that?

Okay, I have been away from in-depth access for several months and now I am transfering my project to a new computer with Office 2000 and latest patches installed. When I try to run a screen, I get the error "Compile Error. Can't find project or library." I check the references against the...

Excellent. Now I will add that as a maintenance menu function to enable and disbable that. Actually there is very little use to enable this function outside of design mode, but I've had uses for it recently and this is a whole lot easier than editing every form manually - no mistakes and...

Lets say I wanted to change the "Allow Design Changes" parameter on all forms in a database to either "Design View Only" or to "All Views" via code, can this be done. The following does not work (be nice if it did): Public Function frmNoEdit() Dim MyDB As Database Dim MyForm As form Set MyDB...

Oops, sorry about that, but at least I got yaa pointed in the right direction.

We wanted to see the film also, but my wife and I took the kid to see the Simpsons. Of course our kid (5 years old) need a Soda and Popcorn. My wife and I just shared a medium soda. We spend $28US in our small town for all this!! The theator operator got upset when I asked him "Where are we...