Search results

Hello all, I have a form for physical therapists to identify a patient's pain location(s) using option button controls that overlay an outline of a body part (leg, arm, etc.). The associated report needs to display only the controls that are True. Each of the controls starts with "Pain" (Pain1...

Hello group, I have a customer who is receiving a 3021 (no current record) message. The message occurs when the user clicks on a patient's name in a dropdown list. The dropdown is populated with a query accessing the patient table. The information for the selected patient should display on a...

Bob, thank for the information. I will give that a try. These users have the runtime version of Access 2007. I will need to send them an update. Are the Database Locking settings in the FE? Thanks, Bill

Hello group, I have a multi-user application with split databases (BE/FE). The database is opened in Shared mode, Default Record Locking is set to Edited Record, Open Database by Record-level locking. Each user has their own FE. The users are physical therapists writing their treatment notes...

Hello all, I am using Access 2007 and have implemented the ribbon. I have two contextual tabs: one for several forms; one for print preview. The form and report 'Ribbon name' property has the name of the ribbon (Documentation and PrintPreview). The first time I go to a form with a...

Bob, the code to capture the content of the memo field is StText = Forms(GlobalSavedTextFormNam)(GlobalSavedTextFieldNameInternal) Thanks, Bill

Hello, I have functioning code in a command button that will capture ALL the text in a memo field and save it to a special keyed table based on the name of the memo field. I would like to add a new feature where the user can select / hi-light some of the text in the memo field and the...

Hi all, I am adding a table to a backend DB using DDL. I want to add referential integrity to the relationship between the new table (TblDocWHLower - the child) and an existing table (TblDocMain - the parent). When I execute the following code I receive a "syntax error on Constraint clause"...

Hello, I am trying to mimic a government report in access. The checkboxes have a border color of red. When I change the Border Color to red ('255') in the group control checkbox properties the border continues to be displayed as black. Can the checkbox border color be changed? Thanks for...

Hi, I am developing with Access 2002. I have a split DB (FE and BE). I have a short-cut that compacts the FE successfully using the "/Compact" command. I have tried to implement "Compact on Close" (Tools/Options/General tab) in a runtime environment but when I quit the FE I receive...

Hi, I would like to recreate a record locking problem (error # 3218) our users are experiencing on an application we have developed. I currently do not have access to a network, so I would like to run multiple instances of Access on one machine. How do I do that? Thanks, Bill

Thanks for the reply Pdx_Man. I tried your suggestion - removing the special character ( "-") and spaces. The new code is CommandBars("ToolBarAppointments").Controls("Block Time").Enabled = False but I receive the same runtime error - "Invalid Procedure call or Argument". I did...

Hi, I have created a custom menu bar for my application at design-time. At runtime I successfully disable controls and sub-menu items on the menu bar based on what the user can do on a particulare form or report. The following code works for menu bar items and sub-menus: CommandBars("PT...

OutputTo and common dialog IIkhoutx, can you explain how you programmatically integrate the OutputTo command with the command dialog so the user can choose where to save the file? Thanks, Bill Echert

Hi, I have created a custom menu bar and would like to be able to disable and enable the controls under the sub-menues based on the which screen the user is on. I want the control to be visible but grayed-out when it is disabled. I am using Access 2002. For example, the Menu bar is called...

The subform should contain blank fields, just as the main form is displayed with blank fields, so information for a claim can be entered. Right now all I get on the subform is the background color no fields. Thanks, Bill

Hi, I am having a problem with displaying a blank sub-form. I have a form that displays patient information and a sub-form that displays the corresponding claim information. New patient and claim information is also entered on this form/sub-form. The sub-form has navigation buttons to moved...

Legendv, I am looking for a way to suppress the MS Access error messages and replace them with my own, user friendly messages. Did you ever find a way to do this? Thanks, Bill

Thanks. That worked great! Bill

I am new to Access and hope someone can help with this issue. I have a continuous form that has a query as it's record source. This form is only for viewing existing records, not entering a new record. All the records are displayed correctly, except the last record on the form is a blank...