Search results

Hello all I have a multi user split database which has been working fine for about one year (users have a "copy" of the database that they use). I have not done "compact and repair" or on close, as I don't fully understand it and have been reading mixed things about how it impacts the...

Hi all I currently have a combobox search button that can look up entries by last name and then generate a form based on the name selection. Is it possible that when the user begins entry, it can search by any part of the entire name? First name or Last name?

Hi all I have a split Access Database. The users are using the front end for data entry via forms only (they do not have access to the tables themselves). When on it at the same time, the error "You do not have exclusive access to the database at this time. If you proceed with changes, you...

Hi all I have form, that contains two subforms. Subform One = Client Info Table Subform Two = Screening Info Table Subform Two has a button with following code to create a new screening for this client: Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec It opens the screening data entry...

Hello I would like to make a report that lists totals...such as: Total X records: ### Total Criteria Y records: ### I have been unsuccessfully trying this via DCount control source in an unbound text box. Are there other more efficient ways to achieve this?

Since Access 2013 cannot do Pivot Table, is it possible to automate it with Excel? If I link Access to an Excel Workgroup that has a dashboard for example, will this work? I already know I can export each time to analyze, but I am wondering if there is an easier more efficient way ? Thanks

Hi all I have this function below, and I have it as an expression in a query, and I get the error: 'Undefined function 'AddWeekDays' in expression.' I am new to this, am I missing something? Expression: AddWeekDays([AdmitDate],3) The goal of this expression is to take the "AdmitDate" field...

Hello I have for example, If statements that are based on the selection of a field and depending will grey out/disable other fields. If the user is entering on the form for the first time it works, but when they reopen (a hyperlink that opens the same form for that record) to make edits or add...

Hello Not sure if this is possible. I have a Main Form. That Main Form has a Subform. That Subform has a Subform. They are based on tables and linked by their Id's. Currently, users are able to enter into the Main Form and create a new entry, without having to enter anything into Subform...

Hello I have tblClient, tblScreening and tblAdmit. I want only those screenings that have a corresponding entry in the tblAdmit (I don't want to see tblScreening records that don't have an AdmitID already). Within tblAdmit, I don't want to see records that have been fully completed, I only...

Hi all I have a form that displays in datasheet view. I have a code that disables other controls when one control option is selected. When I am doing data entry on one record in datasheet view, it works well but applies the condition to all of the records/rows. How do I limit this code to...

I have just added "Option Explicit" and am trying to add variables to old code. In my codes I am referring to "field names" (example below). I added variables on the top of my module such as: Dim PreExistingProgram as Integer This caused compile problems in all of my modules, with errors...

Im new to vba. Im halfway through building my database and have realized how important "option explicit" is, which I have not been using, and am still trying to grasp the concept of. I'm thinking of turning it on now to use moving forward and figure out along the way, or is it imperative that...