Recent content by Simon_MT

Here are twi piece code: Function GetWinUserName() GetWinUserName = VBA.Environ("UserName") End Function then Function GetUser() Dim db As DAO.Database Dim rs As DAO.Recordset With CodeContextObject Set db = CurrentDb Set rs = db.OpenRecordset("SELECT...

Performance can rely on Pre-Filtering records and careful indexing. It may pay to understand where the bottlenecks occur and fine-tune your Access database to see if any performance gains can be acheived. 25,000 records in a table is well within the cope of Access. I found that Indexing fields...

Perhaps try this it maybe a little longer. Function SearchProject() As String With CodeContextObject If Len(.cmb_project_name) > 0 SearchProject = '" & .cmb.project_name & "' Else SearchProject = "" End If End With End Function Function...

If you want to consolidate sales into one invoice you may need a Invoice table and attach the transactions to the invoice. If you step back a little - create a screen with unprocessed orders and select each one and after the invoice is printed change the flag to printed and run through this...

I have used Xenu for years and its good for both 404s and missing assets although it will not pick-up <Picture> element assets used with Media queries. That is asking a lot. Will do local and external web sites. Simon

Perhaps you should put the Vehicle and Chauffeur into Bookings and then put all the vehicle information (Make) into Vehicles Simon

Like County Parish Numbers the piece of land reference does not change, in your case, the ownership does. Using the same principle that the land has a unique ID and then attached to each title holder. Simon

Where it gets messy is hard coding WHERE statements if you are using FUZZY logic. I have pop-up Forms with multiple dropdown lists and choose which one you want to use. So I separate the Criteria in VBA and apply the criteria using a standard SQL statement when opening up the From and just add...

I have a couple of sites using an Access backend. They were orginally written with VB in Classic ASP. So I had to go under the bonnet and make the engine. Then ASP.Net can along and then you had to go under the bonnet and the car didn't go faster or do anything better worse it destroyed the...

I know unbound forms but here is another way of looking at the problem. I separate the functions of entering or updating an Invoice and enquiring on a Invoice. You can change an Invoice to the point where it has been updated into AR and the GL. If you do change an Approved Invoice the Status...

With Later (2013) versions you can make Circles or Circle(Step(x, y), radius, color, start, end, aspect). In embed a circle on the Form or Button, with Access 2007 or earlier bitmaps only. Simon

May I suggest looking at Power BI. I have tried Charts in Access but I have found that POwer BI is rather good. I don't normally promote products but I'm just surprised how good Power BI is and this is form a certified sceptic. Simon

Yes you can do this in VBA it depends if Weghted Averages are used. On a form or report you either Sum Result, Acc and Ref and then perform your calculations. All you do in VBA is Total Query perform the calculations and Update them to Form or Update Query. Simon

Taking a step back an IP Camera is always an IP camera, I understand the structure you have and perhaps having individual codes for the Items no matter what categories or sub-categories are used you are still refering to an Foreign ID that relates an IP camera. Simon

Perhaps look at the problem from the Widget level. After acquisition (Purchase) the attrition is either Burst or Scheduled. Or Usage method could be "A", "B" or "S" so looking at the Stock usage as long as you can separate the type of transaction you know the type of movement. Counting the...