Search results

I just did compact and repair of by BE and now I have a second copy of each table, so i have two of each table. One set is linked the other isn't. Is this normal

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?

Made the copies! Thanks for your help!

Thanks, currently there one front end on a shared drive. What do you mean by having them use their own copy?

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...

thank everyone I kept it simple by correcting D-count formula. will have to do the rest in excel thanks

Thanks all, I used a code found on another post f Me.NewRecord then 'do this else 'do that end if thanks!!

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...

The report I have will not be listing any records at all. So I don't think I can do a footer correct. I have been able to get individual results in a query by grouping, but it will not let me do multiple groupings (like a pivot table), so I have to do each individually it seems.

I have been trying to do the following as the control source of my textbox: =DCount([ScreeningType],[tblScreening],1) Screening Type is a field/column in the table "tblScreening". I want to know how many in that column equal 1 (which is the Unique Id for a Drop Down List). I have also tried...

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

Nevermind, after using a different code, I changed name of module so as to not match and it worked 'MoveWD moves datThis on by the intInc weekdays. Public Function MoveWD(datThis As Date, intInc As Integer) As Date MoveWD = datThis For intInc = intInc To Sgn(intInc) Step -Sgn(intInc)...

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...

Activate worked, thank you!!!

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...

Hi I want the form to not allow closure of the form itself until they enter 1 particular field in Sub1. Main Form = tblClient, ClientID Sub1 = tblScreener, Screener ID & ClientID; linked to Main Form by Client ID Sub2 = tblAdmit, AdmitID, ScreenerID, & ClientID; linked to Sub1 by ScreenerID...

I thought I figured it out, but No! The below doesn't work because I made the Unique/Foreign IDs required for my tables so it will not create a record in subform before creating one in the main form. Is there another way around this? I want to keep Id's required, I do not want accidental random...

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...