Search results

Hi; Hoping that someone can suggest a solution for the following: I have a form “frmAdd_Client”, on which, in the form header there is an initial (field(0)) cbo “cboSelect_Client”. Into this control is entered Surname,Prename;Date of birth. If the new data is ‘not in list’, then the detail...

Hi; Wondering if anyone can solve this problem, which worked fine in Ac2 and Ac2k, but does not seem to function properly in Ac2003. I’m using the following elements to print different captions in [lblCopy] in a report/ subreport of which I’m printing two copies. Report ‘Declarations: Dim...

Hi; Does anyone out there have a sample Db for something like a loan- payment invoice; ie, to show monthly payment due, interest (or service charge), and balance remaining? I've looked at the "accounts ledger Db" from MS, but that's not quite what I'm looking for. (In fact, I can't imagine what...

Hi; hope someone can help with the following problem in Ac 2003. I have a report/subreport, used as an invoice. The subreport contains itemized bill lines, which include [charge] for each line. I’m trying to show the sum of the charges on the subreport in a control on the main report, which I’ve...

I'm having a problem appending some records from one table to another, and hope that someone can get me on the right track. I'm trying to append a small group of records-perhaps five at a time, from tbltemp to tblservices. Each line in tblServices must have an entry 'LineNumber', which is...

Scrolling SelectedItem in LB in code Hi: Anyone know if there is any way to make a selecteditem in a listbox move so that it is 'scrolled' to the top of the visible listbox. I'd like to add such a feature to a filltree type of listbox outline. TIA, Richard

I'd like to set a value for control 'units' on 'form2' ans am having difficulty with the following macro. Macro action is: SetValue Item: [Forms]![Form2]![Units] Expression: ElapsedDays([Units]) Macro is run on 'afterupdate' event of contol on form named 'Date_To'. Function "ElapsedDays" is...

I've recently acquired a bug in my app in Ac2k where, if I enter a cbo by a 'setfocus' command on exit from another control on the same form, my cbo doesn't dropdown (as it's coded to do in the 'ongotfocus' event). This problem used to not be present, but it has recently started to occur on...

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

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

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

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

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

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

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

Hi: I'm trying to convert an AC2 Db into AC2000, and am having a bit of trouble with the following code. This is to serve to get numbers from a 'counter Db". >>>>>>> Dim wrkCurrent As WorkSpace Dim dbCounter As DAO.Database (I've added the 'DAO." for AC2000"--not present in the original)...

I'm in the process (beginning) of trying to update a Db written in Access2 basic into visual basic for access2k. I have the following code: "If IsLoaded("Form1") Then------", which is not suitable for visual basic. Can someone explain how to change this code to use the 'isloaded' property...

I'd like to use access to issue letters to individuals. There might be > 1000 characters of text in each letter--far more than can fit into a textbox item in an underlying table. The underlying table has items such as 'addressee' 'date of letter', and 'title' as its rows. Can anyone suggest how...