Search results

There are mysterious gray or green vertical lines on some of my forms. They are not controls. You can see them in design and form view. I would like any advice on getting rid of these vertical lines. Thanks.

OK, I solved this myself. I changed the criteria to: stLinkCriteria = "[CaseID] = " & QUOTE & Me.[CaseID] & QUOTE & "AND [PageSeq] = " & QUOTE & Me.[PageSeq] & QUOTE & "AND [ColumnNo] = " & Me.[ColumnNo] & "AND [arvEvent] = " & QUOTE & Me.[arvEvent] & QUOTE (QUOTE is Pat Hartman's global...

I decided to post some more detail in case this was not clear. My structure, which captures the data on scanned paper forms, is as follows: tblARVMaster CaseID - e.g.ADPT0000696 - the case ID is unique in this table only. FormID - e.g.50973 - this keeps track of the version of the data...

I have a continuous subform with a button that is supposed to open another continuous form of related records. I have done this in the past with help from the forum and tried to follow the same method. However this time, it does not work. I have the following: The record source of both forms...

Thanks, Peter. You had the right idea. I decreased the size of the text box and the point size of the barcode to move it away from another line on the side. That did the trick. Thanks again for your help.

We have an Access report which is a case list. The case numbers are printed on the report in a barcode font. The case number format is "M" followed by 5 digits (There is also code to surround it with asterisks). Our scanning process also uses a separate preprinted sheet with barcodes that...

Thanks Pat, it worked when I changed the code to the AfterUpdate events. That was easy! :)

Thanks for your response, Travis, but I need some clarification. Where is the variable set to True? in the OnClick code? Is that before or after the Docmd.Close? Then does the OnExit code go in the Else part (=True) in the Unload event? What goes in the first part (If Cancel = False)? nothing...

I have a form some of whose controls have OnExit events. These events are to go to a different control next depending on the value entered. When the form is opened, the first of these controls has the focus. When I click a button on the form to go to another form, I have to click it several...

I tried opening the form and the underlying table directly from the database window on the user's machine. The results were: - Opening the form in Form View: a message pops up: "There is no object in this control." When I click OK, I get the message: "The expression On Open you entered as the...

I checked the permissions (for the table and the form) and it looks the same from my machine and the user's. What else can I do? Thanks for your responses.

Front end and back end on the server seems to be the practice in this department. (However, I did not design this database). As for the user, she has used other functions in the same database successfully in the past. I believe this was the first time she was trying to use this form. What else...

There is a front end and back end, however: 1.Both are on the server and the user has only a shortcut on their machine. 2.Some of the tables reside in the front end, including the table on which this form is based.

I like to use tab forms. One problem with the navigation by the users, however, is that they usually have their computers on a different resolution than I have mine. This requires me to either resize the form and/or controls so everything fits on their screen, or to make sure I leave the scroll...

When one user clicks on the button to open a particular form, she gets a blank gray screen. The second form opens fine for me and for another user. The code behind the button makes the first form invisible then opens the second form. It seems to be doing the first but not the second for this...

Thanks Pat. Your suggestion worked.

I want to link a field in one table to a corresponding field in another, but some of the possible values do not match. I want to change these 3 values in the first table to match their corresponding values in the 2nd table. e.g. if field1 = "A" change it to "B" if field1 = "C" change it to "D"...

My report is based on a query which includes the tables on both sides of a one-to-many relationship. The many-side table fields are in the detail and the one-side fields are in the page header. In design view, there is no blank space at the end of the page header and minimal space at the top and...

I finally got it to work! Starting from the Excel file in its original format, I edited each value in the two columns that was converting to scientific notation (i.e. those with at least 7 digits without a leading zero or letter). All I did was double-click the field, type a non-numeric...

Well, first I removed the formulas in the MOTHERSS field on the values starting with zero, e.g. TEXT("012345678","00000000#") was changed to 012345678. However, the other values still came out in sci. notation. Then I formatted the column with the custom format 000000000. Then the MOTHERSS field...