Recent content by miaki16

David, I figured it out. I played with the placement of the Nz() function and it now calculates as expected. Thanks for your help and pointing me in the right direction. Greatly appreciated! As for Fairview, I have heard of it. In fact one of my operators that I am constructing the database...

Thanks David. I have wrapped all the calculated fields that may return nulls in the Nz() function and I am still getting the same #Error. Here are my new calculated fields: FallVolume: Nz(FormatNumber(DLookUp("[Volume]","[tblTankGaugeCharts]","[DipDepth]=" & [FallDipReading] & "And [TankID]="...

I am making an application to track methanol usage in an oil and gas field throughout the winter months in Canada. I have a query set up to do several simple but time consuming calculations. There query determines the volume in the tank at the start of the fall based on a measurement, the...

I have a table containing test data for wells. I would like to determine the flow corresponding to the longest test for each well and unique zone within that well. I tried grouping the TestDuration field by MAX, but this did not work. I believe I may need a nested query to get the results I am...

Currently I am trying to highlight indivdual data markers on a plot. I originally wanted the values to display when hovering over the markers (like they do in Excel) but have given up on this as I can not seem to make it work with MS Graph in Access. It will display values for each marker when I...

I don't know how to delete specific items. But you could try and add this code to your outlook automation procedure: .DeleteAfterSubmit = True This would let Outlook send the message telling you the db is up and running without storing the message in your sent items folder.

After sifting through all my code for the last day I found my problem. It was actually in another form, I forgot to delete a Docmd.Quit from my pre-user tracking version. I deleted this line of code in and it works fine now. Thanks.

I have set up a database that is shared over a network drive. Some of my fellow employees leave the database open and I am unbale to make changes to it. I created a way to log these users out automatically using a hidden form that checks to see if a linked database is allowing users to log in. I...

Just wondering if anyone knows a work around to allow report areas larger than the 22" x 22" limitation? Heres my problem, I have a database for an oil and gas property and would like to be able to display various information about the wells on a map. I have access to a 36" plotter and would...