Search results for query: *

I have some custom forms that I use for data entry. I recently reformatted my hard drive and reinstalled Win-Xp from scratch. I previously had Windows XP upgraded from 98 (was FAT32 now NTFS). Ever since I did this, my keyboard is unreliable when entering data in forms. It used to be even when...

Well, once again it was gone when I got to work this morning. Thanks for your suggestion xlhelp, I will try it and let you know if it works.

I have a custom toolbar that I created with buttons that run macros. Every once in a while this toolbar is deleted. It only takes 5-10 minutes to recreate it, but it is annoying. Does anyone have any ideas? P.S. The toolbar is not just hidden, it is actually deleted. It does not show up in...

P.S. - I found this link to be very helpful. It provides charts for communications parameters for many industrial machine controls. This stuff is extremely hard to find, so it's nice to get a lot in 1 place. http://www.suchsoftware.com/pcnc.pdf

Well, I solved my problem (for 1 machine at least). I had to lower baud rate from 9600 to 1200. I tried this earlier, but there was also a problem where the computer needed to be restarted after an unsucessful transfer attempt before it would work again. I think I must have been in that mode...

It is running Windows XP Home Edition. I have tried different baud settings down to 300 bps with no luck (usual is 9600). I can receive data from the machine with no problem, but when I send nothing gets to the machine. I have checked the parameters on both the machine and windows terminal. It...

I am using a laptop which does not have a serial port, that is why I got the USB to serial cable. We have over a dozen different machines with all different types of cables for communication. They are all set up for serial. I have had the same problem with our oldest machine (Mitsubishi Lathe)...

I tried that and it worked fine. I don't think it's the cable because I have been able to receive data from the machine, just not send to it. Also a machine tech. that my boss talked to said that windows XP just will not work for sending to machines. I have a hard time believing that there is...

I am trying to transfer text files from laptop to industrial machine. We could do this fine with laptop running Win95, but not with new XP laptop. I am able to receive data from the machine, but can not send to it. We have the same problem with several different machines, so I think it is with...

Thanks KenReay, That worked great.

I have a main report called Production By Week. This contains a subreport for each production line. Each subreport is based on a crosstab query with row headings for partname, partnumber, and total production. My column headings are 1-7 for the days of the week. In the report footer of...

My problem is that I can't select the controls that are in the same report section (page footer) as the subreport, because the subreport is in design view rather than showing as a control like it did in Access 97.

I recently upgraded from 97 to 2000. I have several reports with subreports (to look up revision information)in the page footer. I also have a label control which sits on top of subreport and shows page number for the main report. When I open the main report in design view, the subreport is also...

I solved the problem by changing the field size in table from Single to Double. It works, but I don't know why. My data is easily small enough to fit in a single field. Any ideas?

I have tried all of the above, and nothing seems to work. I can't set the table data type to long integer, as i am working with decimals, so i used single which should be OK. I changed the fieldname from Val to DataVal. i checked recordset to make sure it was getting all the data, I can't think...

I am changing an Excel worksheet to Access 97 and noticed that the stDev result was different between the 2 programs using the same data... Any ideas why? Access Query: SELECT StDev([Val]) AS STDEV FROM tbl_SPC_AllVal; = 0.0161574017103552 Excel Calculation: =STDEV(K27:K56) = 0.004231248 I...

I have a report based on a query that returns a single record. Lets say 5 fields are named Val1 through Val5 and appear in text-boxes txt1 through txt5. What is the proper syntax to use in controlsource property of calculated control for finding max, min, avg, etc. of the value of these controls?

I am trying to write a function which will activate a word document in an unbound object frame when the report is opened. This is my function now. Private Sub Report_Open(Cancel As Integer) Dim UnboundOLE As ObjectFrame On Error GoTo Err_Report_Open Set UnboundOLE =...

At least now I know it's not just me. Thanks.

I do have my references set right, and your code works fine. I was hoping to be able to get the information without actually creating an instance of word. What I don't understand is why it works with excel, but not word.