I have created a form which has a main sheet (with lease header information) and a subform (which has lease detail information). I have established the...

Windows 2000 Office 2000 main form: A-Schedule-New Subform 1: A-main-subform Subform 2; A-Sum-Hours-Subform Subform 2 is based on a query that totals some...

Hi Below you can see the code of a refresh button I have on my form. The code is working great but I just have one problem. On my main form I have 5...

I have a form with a subform. I want to add to the main form, push a button that runs a macro that appends data into the table that drives the subform. I can...

Hi, I have a form with combo box and multi page tab control with many controls bound to my query. Query is based on value chosen from combo box. How can I...

Hi to all, I do not know if anyone can help me on this one. I have a form that contains a tab control with 15 tabs on it, tab 1 contains approx 120 fields,...

Im trying to refresh the screen after deleting a record. This is what is under my delete button. sql = "DELETE * FROM tbl_memberOverrides " sql = sql & "WHERE...

Hi, I have a main form with two subforms. In the subform I have combo boxes that allow users to select items from an item list. The subform is continous...

hi, how can i refresh values in a subform ? i have a button in the main form that changes the values if a field in the subform but it does not refresh...

Hello, I would like to ask you this question. I have connected some tables and views through ODBC from my DB on MS SQL Server to my Access application. Since...

wat i want is to insert the calculated values(simple addition or subtraction) in fields of my table by using expression builders in my forms..i have made that...

I have a main form (Contacts) which has many related tables. For this message we will use the related table "Letters" which stores records representing...

the ingredients of my situation consist in three tables a) Audit Reports (parent): PK = "IRB Number" b) Evaluations: PK = "IRB Number" and "Date of...

I have a subform whose source is a query. The SQL statement for the query is obtained from the code given below . Function s() Dim frm As Form, ctl As...

Hi: Can any one please tell me the regExpression. I try to do thru instr but the style of data is not same always. I need the number "894052" from this string...

Does anyone know how I can check the regional settings on the PC that the user is using. I would like to know what country it is set for - e.g Australia,...

Can anyone help me! My Date field in Access returns error even with the correct date format dd.mm.yyyy Ironically, it works on a windows XP, but not on Windows...

I want to change the image in an OLEunbound object frame on a form. However Access 2003 gives me an error message: "The OLE server isn't registered." I can't...

Hi, I have a project that uses the MSFlexGrid control and I want to ask if there is any way to automate the installation and registration of the corresponding...

Hello, I use some ActiveX component which displays animated gifs on forms. This component consists only of one dll file and runs without problems. It has to...