Search results

Hi Want I want to achieve is something like the following: -------------------------------------------- If AllowBypassKey = true then 'something like this should check whether the user has 'enabled the shift-key create a text file on c:\ End If...

I have the following problem. Access 97 tells me that PropType As DAO.DataTypeEnum is not an Automation type supported in Visual Basic. I have the reference set to DAO 3.6. I have also tried DAO 3.51 but with no success. In Access 2000. The code worked perfectly. Thanks for any help.

when I try to install a runtime97-Application I get the following error message. ____________________________ C:\Programme\Gemeinsame Dateien\msacc8.olb (this is the German version for shared files) Unable to register the type library: LoadTypeLib failed; code 0x80029C4A Click retry to try...

I have a crosstab query with the following elements: rows: date columns: articles values: numbers The numbers are running sums calculated in another query. NUMBERS TODAY: The numbers in the crosstab query according to the state today are as following (example Article A): 5 6 9 14...

I have a crosstab query with the following elements: rows: date columns: articles values: numbers The numbers are running sums calculated in another query. NUMBERS TODAY: The numbers in the crosstab query according to the state today are as following (example Article A): 5 6 9 14 etc...

I have a crosstab query with the following settings: rows: dates columns: articles Values: Numbers how can I always add the number 2 to each value and not only to the first value? Example As it is now As it should be 3 5 (3+2) 5...

I have a question regarding the on current event of a subform. My subform has 5 fields. Each field has an after update event, something like this (shortened): Begin code ..... .... me.dirty = false Me.requery .... ..... End code When the after update event of a field is finished I would like...

I am trying the following: I have a subform with maximum 10 records. If one or more of the records have a negative value, I would like to make a certain text box in another subform visible. I guess that to achieve this, I will have to somehow loop through each record in the subform to check...

Is use Access 97 in German. When I distribute a database with the Runtime 97, the msgboxes, etc. have their command buttons in German (OK, etc.). How can I change them to English?

FACTS I designed a report that looks great in layout preview on the screen. The report includes text boxes. The text boxes have borderlines (black / hairline). The borderlines are clearly visible in the layout view of the report. Furthermore, the report has rows with alternate colors which...

When I process the below code in an AfterUpdateEvent of a subform field, I get runtime error 97 (Object variable or With block variable not set). The debug window marks the following line yellow: OrigSelTop = SR.SelTop FYI: I use Access97. ' Our class to hold a couple of Public vars...

I have a subform with the fields A, B, C and D. When I try to click on field C (third field) of a specific record, the cursor goes first to field A (first field) of this specific record. When I then click again on field C, the cursor enters field C of this record (what I wanted to achieve with...

Is there a VBA code to make the blinking cursor disappear during the processing of a time-consuming code?

I have a subform with several text boxes (let's say A, B, C and D). When I try to click on text box C (third text box) of a specific recordset, the cursor goes first to text box A (first text box) of this specific recordset. When I then click again on text box C, the cursor sets the focus on...

This message was once put in this Access Forum: ____________________________________________ Below is the code from the Microsoft Access 97 "Reports" sample db that alternates the color between rows within a report. You should be able to modify the code to use in a form. Private Sub...

I had a nicely working Access 2000 database. I used some refresh commands and I really tried to avoid stuff like requery and recalc since they move the cursor around (e.g. back to the first record). Everything worked perfectly. Now the problem: When I converted it to Access97, things got...

The problem is the following: I have a subform. The subform includes 5 fields (text boxes). After an input in a field, I refresh the subform with the following code: Forms![frmArticle]![sbfrmDetails].Form.Refresh Strange enough that after the refresh the cursor goes back to the first field of...

I have a subform which works fine in general. However, one current problem is the following: when I press the {enter} key or the {tab} key on the subform, Access often doesn't show anymore all records. The cursor then goes to the next record and some of the previous records are not visible...

Hi I have got a subform which works fine in general. However, one current disadvantage is the following: when I press the {enter} key or the {tab} key, Access often doesn't show anymore all records. It then goes to the next record and cuts some records above. Do you have any ideas how to...

Hi I created a nice database in Access 2000. Forms, reports, etc. work fine. I then converted the database to Access 97. The forms work fine as well. However, 1 report cannot be opened (not even in design view). Access says, that some signs are not recognized by Access (strange, since the...