Search results

Hi Paul, Just for your info, and if I'm on the right track, based on this post from another thread, excerpt here:As an aside, I noticed that the TransactionQuantity per line is either positive or negative. The negative entries relate to 'Sold_$'. Without directly referring to the...

Hope someone can help. I've been given an Excel spreadsheet and asked to clean it up as it's not doing what it's supposed to. It's a Leave Roster spreadsheet. What has happened is that 67 checkboxes have been added to individual cells, in the same column. Each checkbox is named...

I had to check, changing my timezone back and forth and Now() gives the correct results: ? now() (Melbourne) 7/04/2019 7:07:36 PM ? now() (Darwin) 7/04/2019 6:38:34 PM ? now() (Melbourne) 7/04/2019 7:09:15 PM

Actually, to make it clearer, won't use now() in the function: ? datediff("n", #7/apr/2019 23:00#, #8/apr/2019 01:00#) 120 As an aside, if I had of entered the date as '8/4/2019' the system assumes it's a US date, again, a pain in the a..... always catches me out. You can use only the...

Dealing with time calculations is a real pain. Anyway, the DateDiff() function should help. From the immediate window: ? datediff("n", now(),#8/apr/2019 01:20#) 489 So that's a time past midnight and the result is in minutes. I'll get back to you about rounding to 5 mins, my mind's gone...

Without checking the rest of the code, comment out the offending line and it should all work. If you want to keep the On Error GoTo ErrorHandler you have to add the error routine, it's highlighted in blue. Function Age(varBirthDate As Variant) As Integer Dim varAge As Variant On...

Which form to look at?

A shared drive on another PC and server. I don't even know where the server physically resides albeit, not in our building. I'm not sure if this is relevant but for all network access, I use UNC and not drive mapping.

Just throwing this out there, where you loop through every control within the 'RCDatum' commandbar and delete, why not delete the 'RCDatum' commandbar directly; no need for the 'Do Until' code. Code I use, though not nearly as many items as what you require, is as follows: Dim strBarName...

Yes, this is why I chimed in, my app creates folders and sub-folders on a network drive and we all reckon our network is slow. Strange, I haven't had a timing problem copying files to folders and sub-folders created just prior by Access. I know there are no timing issues as I have a logging...

In one of my applications users upload (attach) files to relevant records. I only use what is provided by Access, Dir(), MkDir() and FileCopy() and have never come across a timing issue. I don't even use the vbScript FileSystemObject method. To answer your original question, yes, I create...

Hi Paul, No worries. I am still curious though, what do you guys actually do or what is your core business?

What does a Non-Government Organisation do? I know you must be keeping track of share investments but what is the high-stress nature of the core business where volunteers are only rostered every other month? I'm curious. Speaking about volunteers, you do realise that in this forum we are...

Understood Did you run the SQL query I posted? It is just a simple matter of opening the query at your end, go into SQL View and paste over what is there. Then you run it, check the results. Are the results as you expected? Try this yourself, if you have problems, by all means, raise a...

As regards your Notes table. Can you have many notes per census data record (one to many) or is it a one-to-one type relationship?

I feel your pain as well, especially as regards searchability. I know I have said to others search this site and you'll find many other references; I should qualify that and say use the Advanced Search of Google to do it. For bookmarking, isn't that what subscribed threads are for, under...

Sounds like you need to add a sub-form to your form. That sub-form will only show records that are linked to the parent form. If entering records into the sub-form, if linked correctly, your account number will be automatically entered. For further see this:

I got your form to generate data. The recordsource of the form needs to be changed slightly, image attached. Your table, "Junction - Subcon Estimate" field "EstimateNo" needs to be linked to table "Estimates" field "EstimateName" and not "EstimateNo". Data will now be generated; this is as...

Try this for starters. You need to edit Query 1 (qryZ_01_CalculateLineTotals) by adding in the field, "TransactionType". In the Criteria columns, enter "Bought_$" and in the same column below, enter "Drip". That will restrict the query to only retrieve records marked as "Bought_$" or...

You'll have to explain to me what is 'Drip' when batched together with 'Bought_$ and Sold_$. I've perused your latest db but can't do anything useful with it at the moment.