Search results

Thank you very much - that seems to be working well!

I've got 2 crosstab queries that both work, but I'd like to combine them together. The first shows the total time that various vehicles were used for at each base: TRANSFORM Sum(Cdbl(Nz(M.dtTripTime, 0))) AS SheetTime SELECT M.lngVehicleID ,Sum(Cdbl(Nz(M.dtTripTime, 0))) AS Total FROM...

This is on a sharepoint web database... I'm trying to run a data macro which simply retrieves field values. When I run it from within Access, it gives no errors. However, whenever I try to run it on Sharepoint it throws up a 3875 error. The only information I can find on that error is...

I appear to have found a solution that works. You can create a data macro on a web query (you have to open a table first in order for Access 2010 to present you the option). I created a very simple web query which merely sorted the table in descending date order. I then created a data macro...

And, unfortunately, for web databases (or so it would seem)! Many thanks for the suggestion, but unfortunately those queries aren't web-compatible... this is why I've been bashing my head against a brick wall with web databases today. You can't even edit SQL for web queries... :banghead:

Hi all, I'm trying to return the most recent value from a table, before today's date. As this is a web database, I believe I need to use a data macro to achieve it (which I'm very new to). So far, I have: Look Up A Record In tblPrices Where Condition = [tblPrices].[dtPriceDate] <= Date()...

Hello all, I have a UDF in a module which is the controlsource of multiple textboxes. In addition to setting the value of the textbox, I'd like the UDF to set the fore and back colors rather than use conditional formatting (I'm attempting to speed up a very slow report). However, I can't find...

I'm trying to create a report for any given month which shows each employee and where they will be on each day of that month (Base1, Base2, Base3, Base4, Vacation). The employees are stored in tblEmployees The movements of the employees are stored in tblMovements My current method works, but...

You are missing a space between until and .eof. So it should read do until .eof

Private Sub Status_AfterUpdate() Dim strSQL as String If Status = 4 then strSQL = "INSERT INTO Tbl_IF (ready) VALUES (true);" Elseif Status = 15 then strSQL = "INSERT INTO Tbl_viewing (ready) VALUES (true);" End if If strSQL <> "" then currentdb.Execute(strSQL) End Sub You probably want...

If you have to use 2 tables, can you change the layout of the tables? First table is Students Second table is Shoes (field for type and field for color)

Functions and subs are very similar. The main difference is that a function can return a value, whereas a sub does not. The other difference is that a function can be called using "=FunctionName"... which is why I used a function above. You can place the function in the same place as you would...

I would probably use a simple function, something along the lines of: Private Function CapitalizeFirstLetter (currentControl as Control) currentControl = UCase(Left(currentControl, 1)) & LCase(Mid(currentControl, 2)) End function (Note: you should put in some error handling, and you should...

Or probably a combination of them both!

Thank you very much for the reply. The questions possibly didn't make sense because of my confusion over what I was asking about! To cut to the chase, I think sharepoint is probably not my solution at the moment; migration to SQL, run over the LAN with remote desktops as you suggest appears to...

Thanks for more suggestions. I can't seem to get it working right now. As an interim solution, I have just placed a combo box for the user to select the district they want to check. It isn't ideal, but I will revisit this when I get more time to better explore both of your suggestions. On a...

Are you sure you put all the square brackets in? That looks like the result of RunningTotal: DSum("[Total Hours]","tblLabourHours2","Formatted Cost Code='" & [Formatted Cost Code] & "' AND TransDate<=#" & [TransDate] & "#") rather than (differences shown in red) RunningTotal: DSum("[Total...

Wow! Thank you very much for the detailed reply. I don't have the ability to test it out right now, but your explanations make sense. Actually, some employees can be drivers and loaders, others just loaders. But for this report I'm not interested in which capacity they visit the district. So...

Hello, thanks for the replies. The required tables and fields would be: tblEmployees lngEmployeeID (PK) strFullName tblShifts lngShiftID (PK) lngDriver (FK from tblEmployees*) lngLoader (FK from tblEmployees*) tblDeliveries lngDeliveryID (PK) lngShiftID (FK from tblShifts) lngDistrictID (FK...

Thanks for introducing me to a new feature of Access I never knew exists! (find unmatched query wizard) Unfortunately, it will not solve my problem in this instance. The query which shows who HAS made deliveries simply finds all deliveries (with their associated employees conducting the...