Search results

I have a table of data for donations given by people to an organisation The fields are ContactNumber, Amount, Frequency, StartDate and FinishDate. Frequency can be 1 (Monthly), 2 (Annually) or 3 (One-off). I want to generate a cash-flow forecast by month from a given start date to a given end...

I have a Navigation Form with two tiers of tabs. I have a form with two subforms on it. I have a button which calls a pop-up form to add new records. When I close the popup I want the form in the Navigation Form to refresh. I have read dozens of threads, and I am sure that the following is...

Ooo. Here's a blast from the past. I'll start by saying that I gave up on web-based access databases because I just couldn't get the functionality that I needed without VBA. I now use a web-based backend that holds the tables in sharepoint (hosted in office365) and vba-heavy front ends that...

Thanks for that. I have decided to go with the date criteria "Between Date() And Date()-6" for fldDateAdded in qryWorkByClub-7CJ, so that I can show the total submitted in the last 7 days in brackets. That seems to throw up the results I want in qryReportSourceCJ. However... Unfortunately my...

I have attached a sample db to show the problem. The work reports submitted are in tblWorkDone. You will see that there is a fldDate, which refers to the date it happened and a fldDateAdded, which refers to when the report was added to my db. It is fldDateAdded that is important...

Thanks for this. I seem to be nearly there. My problem is that in cases where there are no records for Clubs in the "date-7" version, it is blocking showing the records from the "now" version, also. To explain that a bit better: say 10 clubs had sent in records this week, but only 5 had...

I have a database that reports activities by region. Each week, my regional volunteers report statistics on a number of club activities. This is in the form of zero to theoretically infinite activity reports that they enter on a website. I download the .csv from the website, add the activity...

I am using: DoCmd.SendObject acSendReport, "rptBlah", acFormatPDF, strTo, strCC, , "Regional Work Report", strBody, False to send reports via outlook, which works fine - apart from the fact that I get Outlook generating warnings that "another program is trying to access outlook" - and...

I have a database (MSAccess 2013) for my organisation with the BE in sharepoint and the FE on each user's own laptop/PC. The sharepoint tables are hosted via my Office365 account. I give each user an organisation email address (first.last@myorg.onmicrosoft.com) and they use that to log...

It's just the data that I want to "snapshot". The database I back up by simply making copies.

Thank you for your answers. What seems to have worked relatively simply, is just to make a copy of the front-end and then go through and click "Convert to local Table" on all of the tables. A bit time consuming, but gets what I wanted, I think. Thanks again, George

I have a back-end db in access 2010, linked to a set of sharepoint tables on office365. I want to make a completely unlinked copy of the db to store a "snapshot" of the data on a fixed date. I have tried "save as" using the "Save as Local Database" option, but for some reason, it still...

Have you tried looking up the record in PurchaseOrders itself rather than on a select clause based on PurchaseOrders?

Try this: To have the "Pool" form open to a specific record, when you double click that record in the "Pool Name" Combo box, put the following macro in the "On double click" event of the "Pool Name" Combo Box: SetTempVar Name: tmpID Expression = [Pool Name] (the name of the Combo Box)...

Hi, I am building a web database that lists customers and events. Each customer can go to several events, each event can have several customers. When you open the Customer Form, there is a sub-form showing all the Events he is going to. If you double-click an Event, it opens the event...

Doh. I just use the same macro that is used to set the filter on child2 when the user first selected the region. Sorted. (Although, I do sort of get the feeling that I'm talking to myself, here... :rolleyes:)

Ok, I've been busy. I've discovered Table Data Macros and I have set up a TDMacro on tblCustReg that is called by double clicking on child1, supplying the parameters to the TDM to make the new record. That all works. Hurrah! The last thing I need to do is add something to the end of the...

I am just getting started with web databases in Access 2010, my previous experience being with Access 97. I am trying to divide my customers up by (user-specified) regions. I have a table (tblCustReg) with a record ID field, fldCustomerID and fldRegionID fields. I have a form with a...