Search results

Okay, I did not find an answer to the Error, but I did find this in the help file and it works like a charm to send data to the Windows Clipboard: Use the Windows API To use Windows API calls to send information to the Clipboard, paste the following code into the Declarations section of a...

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

I do use quite a bit of code to read the db table and fill in the datasheet associated with the chart. The problem is there is only one column for and X-AXIS. In Excel, with a scatter chart, each data line has both X-DATA and Y-DATA. See my JPG example again on the top message. Now, I can do...

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?

Being able to rotate the chart would be preferable. The columns in an Access Chart Data Sheet are alway Y AXIS, except for the 1st column, which is the X-AXIS data. I can duplicate my chart exactly, laying on its side using a line chart. It would be great to have an access chart where you had...

How did you do that? Can you make the background translucent? Did you see my example JPG. Can I make that work? I am trying to figure why it is called a scatter chart in Access since it can only support one line?

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

Okay, thanks. I am now using that as a last-resort for one form that I have to do some communications in the form load event. Typically, I hate resume next. I would rather see the errors and correct the code. So once I was sure the code was good, then I used the resume next for that one...

Well, that's all fixed now, for the first page, frmMain. The main lesson I learned is that you shouldnot try to determine the active control before the form is fully loaded. Now I can disable all controls except the one that has focus. For that button, combobox, etc, I use a statis BRunning...

I have this as a public sub. Background. I use the MSComm Active X control to talk to an instrument under test via the serial port. The program has been used for a while now. One of the anoyances is that while communications is running, a user can push a command button, or update a text...

I sometimes get an error "The expression you entered requires the control to be in the active window". That is on program startup after I have a message box pop up and ask the user to turn on an instrument under test. Other times, your suggestion works perfect; thank you. It must think that...

Why doesn't this work?: For Each Ctl In Forms!frmMain.Controls If Ctl.ControlType = acCommandButton Or Ctl.ControlType = acTextBox Or Ctl.ControlType = acOptionGroup Or _ Ctl.ControlType = acListBox Or Ctl.ControlType = acComboBox Or Ctl.ControlType = acCheckBox Then...

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

Okay, I think I have this slow down fixed now. I had used the method of controlling the test equipment as I showed in my last post. They were based on examples from Agilent. Those examples were very minimal. I kept thinking about memory fragmentation. I now dimension the IO libraries globally...

I have been doing more browsing of example and may just have found something I am doing wrong with my GPIB programming. Here is an example of two functions for the o-scope: <code> '=================================================================================== Function tdsSetMeasMode(Mode...

Thanks, I am in Minapolis Airport this morning and taking a break from this for a day. I will be back home tomorrow night. Our service database which I have adding too since 1999 has a BE that is 200 megs, shared by at least 30 people, a huge front end with OCDB links to out data 3 system...

Another question with Memory Fragmentation.. It is worse to declare these at the start of a module, or pass them on (byref) to every sub or function that touches the data? Option Compare Database Private LinLargeData() As Single, dBerror() As Single, Expected() As Single, LinSmallData() As...

Thank you very much for that information. I checked through all the code and the only "ByVal" is at the top of one support module and it is: Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) It is what provide that nice sleep function needed when dealing with test...

I have put this in to a lot of functions and routines with noting trigger so far (I used msgbox instead of debug). I did see something. If I exit the first page, which stays loaded the whole time because of the comm control, and restart it, that initally appears to do the same thing as...