Search results

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

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

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

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

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

I would like to have my Report Title show the current quarter #. I thought I could set the control of field [Quarter] to an expression like this: [Quarter]&"th","Qrt",& Format(Date(),"yyyy") so that I get this: 4th Qrt 2015 I know the expression example I've given is not right, but nothing I...

I have successfully filtered a query pull out records with dates in the current quarter, but I would like to set up a parameter to enter the quarter #, and filter for that. Two pertinent fields are: DatePart("q",[SupportHrs].[DateAdded]) with criteria: DatePart("q",Now())...

When entering new records, sometimes when I have a bunch to enter, I get an error message that the macro can only run the query 19 times. How do I fix this? Usual workflow is this: Open unbound form Manage activities, select button, new, opens form, fill in information, click Related Items...

On an unbound form, is it possible to refresh or clear a textbox after an update? On an unbound form I have some unbound textboxes where after update, a macro runs based on the value in the text box. Is there a way to clear the textbox as part of the macro, perhaps, so that when I come back to...

My understanding is we can not restrict access within an app, so everyone who can use the app can see all the views, and there is no way to limit some views to certain people only. So, I am curious is it's possible to create linked apps. where one app contains, for example, a contact table and...

After successfully building and using my Access app, suddenly I am getting "No Items to display" when I try to add data using a related items popup form. I have checked all the tables and queries, and nothing has changed. The data is all intact, the queries pull all data together correctly...

I asked some form of this question a while back, but did not get a clear answer. Is the following possible? After I add records (activities) to a main table , I want to open a form to a specific activity with a (combobox) list of possible participants. I'd like to be able to multiselect...

I have a table with field DateAdded, and I would like to query the table for only those records where the date is in the current quarter. I can not find an example of how to write the expression for this and whether to put the expression in the criteria of the DateAdded field or to create a...

Access 2013 Web app Is it possible to have a datasheet view pull in data from the one side of a relationship and add to the underlying join table. The problem I'm finding is that I set up the datasheet to be based on a query where the two tables are brought in, they become read only. What is a...

Is it possible to have an autocomplete textbox run a macro when no matching record is found, rather than just giving me "not matching records" message, stops, opens a specific popup and allows me to add a record. I am using the autocomplete on a popup form to add participants to activities, but...

Access 2013 Web App: I have an activity start time and end time and would like to calculate elapsed time. How do I set this up in a calculated field on the table. While I am on the subject, is there a way to use a date field calculation to return the name of a month, not it's #. Thanks

In my Office 365 Access app, I have a table Activities, a table Contacts and a join table for activities/participants (contacts). In my form for entering/editing an activity, the related item control would be the contacts assigned to that activity, all fine. Now when I pop up a form to assign...