Search results

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

Ah ha! So simple! That did the trick - Thanks!!

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

Well, in the process of making a "dummy" copy, I deleted and then re created a new ContactActivity Table, and suddenly the problem is solved. Not sure what the heck got corrupted, but there it is. In case anyone else has this issue here is what I did: 1. Saved a copy of the db to my desktop...

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

Well the solution above lets me see data by current quarter. What I would like to do is look at data from quarter 1, or 2, etc, 1 being Jan 1 - Mar 31, standard fiscal quarters.

How do I set this to look for previous quarters? Thanks

Re: Pick items I'm not trying to be dense, but could you "step by step" it a bit more. What kind of view is your "select form"? If I use the list view, I get a filter on the left, but I know of no way to put actions on this filter. Kind of confused. Sorry

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

Thank you!!! That did the trick :)

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

Yeah! That was a simple fix :) Thanks

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

Yes but when I did this: DateDiff(Minute, [StartTime], [EndTime]/60) it gave me an error message.

Aha! I got it to work! Using Jeff Conrads book, I wrote the expression as: DateDiff(Minute, [StartTime], [EndTime]. I guess the Web App takes the whole name of time/date parts, rather than symbols. Go figure Now how to get it to show time like this: 1.5 hrs? If I do it as minute, 2 hrs gives...