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

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

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

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

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

I am trying to write a function that will open a file based on its application name, which is stored in a table. This one works fine: Function GetExcelPath() MsgBox Excel.Application.Path End Function but when I run this one, I get "Run-time error '429' ActiveX component can't create...

I have a function which copies a report to a temp. version, makes changes and then opens for printing. It works fine on "Home" computer, but from any other I get "Run-time Error '40070' Method 'Close' of object '|DoCmd' failed". It works if I change to acSaveNo, but that...

I am trying to display AutoCAD 2000 drawings which are OLE objects from a table in a bound object frame in a report. The problem is that they do not display consistently. Even with size mode set to zoom they do not scale to fit frame. Also whenever I run the report, the drawings are opened up in...

I am trying to write a function which will close the currently active database and open another one. I can get another database open, but can't seem to close the original one.