Search results

I did check each part. I will have to upload later. I am pressed for time at the moment. Thanks

I did that, and made sure my sub report is also set to can shrink..didn't work.

Here you go:

I checked and it is set to none.

When I add a subreport in the report footer, it adds space between each record on the main report. I can't figure out why this is happening or how to fix it. Without the subport my report is 10 pages, with the sub, it's 14. The subreport itself is only a few records long. Help please

I have a number of reports, all tied to various parameter queries and I would like to now make a switchboard form so that my end user can select a specific report and open it in print preview. This is a new area of db design for me and I'd like to make this as efficient as possible. So first...

With 365 the data is in Azure.

Currently I am creating reports in my desktop Access 2016, where the data I'm using is linked to our Access Web App in Office 365. This is a fine solution if I am the only person creating and running reports and I am the only person in our organization who knows how to use Access. We would like...

Yeah, it's not super obvious on the forum page, and I because I was in that section of the forum, I didn't think to mention it up-top, sorry for the confusion.

I may have to come back to this later, when I am not pressed for time. I have learned that it is hard to strip, copy and post a web database. Thanks though

Hmm, I do have both included. Here is a snapshot.

When I did this, I run into this problem: Enter in db FirstName - John LastName - Smith Enter in db FirstName - John LastName - White Not allowed because first name is a duplicate.

In my contacts table, I have fields LastName, FirstName, and FullName. FullName is set to no duplicates, but I am wondering if, in the view where we enter the contact initially, I can set a macro on the after update of the LastName field that would check if a record containing both FirstName and...

I have built a web app which is doing what I need for my own branch of our organization, but now we are working on using it company wide (small non profit with two offices). I need to build some user limits to this and I am unsure of how to go about it. The permission flow I need is: Admin can...

I have a 2013 web app linked to a desktop db so that I can run reports. I have a field called Notes in the app, and on the App side my only option for format, if I want to enter text as if it were a memo field, is long text. The field is set to that, text entered. Now I am pulling this text/data...

Okay, I solved it! I created 4 queries Q1 - brings together the 3 join tables, contacts, activitycontacts & activity hrs Q2 - brings together other 3 join tables, contacts, surveys & contactsurveys Q3- using Q1, and adding a group/sum, I sum the activity hrs, and include all the info I need from...

Oh boy! That was simple and I feel a big "doh" for not thinking of that. One thing, now where ever the added columns are null, it says #deleted.

I have been successfully building and using select queries for awhile, but now I am stumped. I have a the following query, Capture1. The result is what I want, a record per contact including activity time. In the report I have based on this, I can then see each contact once with all their...

Ah, that worked but FYI, in Access web the &'s are now +, so the expression that worked is: +[LastName]+Left([FirstName],1)+Right([Phone1],4) I decided to use the last 4 of the phone #, instead of ID, and your solution helped me figure out to go from the right. Thank you!!

I want an calculated field in my contacts table that brings together [LastName], and the first letter of [FirstName] and [ConID], so that I get SmithJ15. I know how to concatenate all three fields, what I can't figure out is how to express, return only first letter of FirstName. BTW: I think...