Search results

I'm attempting to upgrade my Ac2 program to Ac2000, and I'm having a confusing problem with an 'orderentry' form/subform, which worked perfectly in Acees2, yet does not function in access2000, which I hope someone can help solve. In Ac2, the subform worked purely as a data entry form, which it...

Hope Someone an help with the following problem. I'm trying to open a report based on tblReports, which has fields reportID, CustomerID, and txtReport. I'd like to use a dialog form to select the customer from a cboselectcustomer, and then use cmdbtn to open the report to show the customer and...

I'm not sure, but my combobox should need its underlying query updated before the cb can even show the new data item (I think). Anyhow, the code I shoewed worked fine in Ac2.

Hi; I'm trying to use code to follow up a 'notinlist' event for a combobx field on a form. This code works perfectly in Access2, but I'm trying to upgrade to Access2000, and this same code is failing, with errmsg of : "You must save the current field before you run the requery action" The code...

There is probably a problem with your printer. It is unable to take the margin all the way to zero. >>>>> It's an Epson LQ570e (quite new), and it settles for zero margins when I run my app (same app, same report) from Ac2. It's just not doing it from Ac2k. Also, I'm getting the same problem...

I have a report/subreport designed in AC2, which prints on my pin printer without a problem. In Ac2, I'm able to set my print setup margins to 0" (top, bottom, right, left) When I take this same report in Ac2k, I seem unable to make it conform to Ac2k requirements. Although the margins are set...

Miraculous! The 'three thingy thing really put order back in chaos!

Hi; I'm using Ac2k, and have set uo my app, imported from Ac2. The app works fine, but my Db window is all garbled, with tables, queries, etc out of alphabetic order and not evenly tiled on the screen. Is this Correctable? If so, How? Richard

Target field of shortcut icon is "MS Office 2000 Pro", but this is no help, as already stated. The only place I seem to find the actual db files is in 'my documents'---is that where they are stored?

Hope that someone can tell me how to find files in MSOffice. I’m using Windows ME, and I have MS Access 20000 installed in Microsoft Office Directory. In Windows Explorer, when I look For Access2000 it doesn’t seem to appear anywhere! Thus, of course, I can’t seem to find the databases in my PC...

Discovered that 'type mismatch' disappears when month and year are given NO arguments in Start. Problem solved. Richard

yes, it stops the ByRef error, but it again generates the Type Mismatch error at the line : start = DateValue(month(D) & "/1/" & year(D)) in the LenMonth function. Richard

unfortuneately, that gives an "By Ref Argument Type Mismatch" with the calling function, which is: >>>>>>> Private Function Cal(m, y) Dim F As Form, C As Control Set F = Forms![Calendar] For k = 0 To 41 F("Button" & k).Visible = False Next DayOne = DateValue(m &...

Hi; I'm using the following code in Ac2 without problem, but Ac2K is not recognizing 'd' as date. Can someone suggest the corrected syntax? >>>>>>> Function LenMonth(d) Start = DateValue(month(d) & " / 1 / " & year(d)) Finish = DateAdd("m", 1, Start) LenMonth = Finish - Start End Function

Hi; I'm trying to convert Ac2 Db to Ac2K, and the following code doesn't compile: >>>>>>> Private Sub Finish_Click() On Error GoTo Err_Finish_Click Dim MySQL As String, MySQL1 As String, MySQL2 As String, Dt As String, I As Integer DoCmd.SetWarnings False Dim Db As DAO.Database, rst As...

No, the DAO reference is installed already.

Hi: I'm trying to convert some Ac2 code to VBA for Ac2k. I have the following globals defined in a module for an "outline" type of form, as follows: >>>>>>> Option Compare Database Option Explicit Dim Tree As ListType Dim MappeTable As DAO.Recordset Dim MappeTableClone As DAO.Recordset Dim...

Perfect! Thanx much

yes, it's global

Yes, I left off the errorhandling at the end to shorten for reader. "StrCounterDbname" comes from calling function. Yes, full name is "glrGetNextCounter", which I forgot to change in all places on the submitted code.