Activity Stream

An alternative that you haven't mentioned would be have the Azure BE with Access FEs for the main users and for the changing volunteers to have them...

Hi Micron: The action or macro is exporting the data from one of the tables to a .csv file and saving it to the "R" drive on our older tablets. ...

Lot's of Google results about editing import specification. You could try them or the easiest might be to recreate the import. Here's just one....

Wrong site. ;)

I've used a prompt on opening as well, where someone created a record but missed important data. I can tell you that they get ignored just as much as...

Minty, You definitely have my attention with the "Dashboard" on my opening menu. That could be a viable solution to your reluctance to the email...

Could you post a small sample with just the report and any dependent objects (no sensitive data please, just some "dummy" records to illustrate the...

Here is one way to do it using domain aggregate functions. Cheers, Vlad

The weird thing is, when I add this to the control source it works perfectly in the report view. However, when I export it to Excel the dates are...

For new record use form AfterInsert event to send email. Seems logical that you should be able to get at record data to include in your email but...

Okay that makes more sense. I have (at the request of managers and others normally higher up the food chain) added lots of "Double check, and Email...

See if this helps. It duplicates some of Vlad's fix. Also established ref integrity for tables. Set Data Entry = NO for the Users form. Changed...

Thank you very much! I will check out the Free Runtime version of Access. Can you refer me to any lists or articles about what I should do to my...

The number of records will be very few and an email would be a prompt that a record has been created and is ready for "required information" to be...

If you're interested in taking a look, I've attached a zip version. It's a very small DB so far and I didn't bother scrubbing the data because it's...

Welcome to AWF!

Maybe try this: Me.Parent.Form.Requery Cheers, Vlad

No it won't, adding the second table will create duplicates which will skew your totals as you experienced. You can get your fixed cost by using a...

If this is to check one user's credentials then loading a whole table of records makes no sense to me. If that table only held one record, then...

Thank you! I can't believe it was that simple. My next problem is getting the button 'assign position' on the subform to refresh the main form so...

Welcome Puja. I moved your post out of the Forms forum, since it didn't have anything to do with forms.

Good points! I was intending to solve a new problem to me, which I wasn't going to get into in this thread, but it explains why I have tblMaterials ...

Can I enquire what sort of data is being recorded? What is the purpose? If this involves any sort of significant number of records my advice would...

I think it should be (why have tblMaterials in there): SELECT qryCostingPerOz.productName, Sum(qryCostingPerOz.totalCost) AS SumOftotalCost FROM...

You haven't joined your two tables on anything FROM tblMaterials, qryCostingPerOz So you Are getting a cartesian join, which will join every...

Just change the row source for the second combo to include the parent form:

Hmm, I thought I replied. Came back because of an email and I see the 'restore content' thing in the post area, which is a great feature. yes to...