Can you have more than 3 colors with Conditional formatting?

Is there are way to send update tasks to the MySQL server that releases the user interface to move onto other things?

I'm trying to improve the performance of my application when a user makes a change that effects data in other tables, as it triggers a handful of various update and delete queries.

I thought I could use the trigger capability in the MySQL table, and simply append a temporary  table with needed parameters, and then have the trigger  run though the list of queries that use those parameters and all of this would run on the server and the UI would be released so the user could navigate to their next task instead of waiting for all this to finish processing.

I know the Events I set up in MySQL can run in the background and run a list of queries at a set interval that don't effect the UI, so I'm thinking there must be a  way to trigger a similar capability.

So far I'm still getting the spinning cursor wheel while the UI waits for the trigger queries to run.  I need more speed Scotty!!!  What am I missing?

The UI is MS Access using VBA and passthrough queries with MySQL ODBC connections to the MySQL server.

And I'm using Navicat for MySQL for all my MySQL development.

Thanks!

Please see the attached file.  When you open the table you will see this data:


I need to create a query that takes the information and uses the fields that are not "0" and combine them into a result that looks like this:

CD-2, GH-3, IJ-6, OP-2, ST4

I don't know where to begin.  Any help much appreciated.
Test.accdb

I have an application written in Access 10.  It is installed in over 100 sites.  Just recently some users have been getting the attached error message after years of running the program without a problem.  It seems to be associated with the Access 10 Run Time.  If I repeatedly click on Ignore, Cancel, or Retry it tries to install it and fails, and rolls the update back.  If I do this 4 or 5 times and then start the application, it runs.

Any clues?

Thanks in advance.

Clive
Could-not-Register-Font.JPG

I have a form that has a sub-form.  The subform is a datasheet.  On the main form is a checkbox named chkPrint.  when the user clicks the checkbox I want only the records in the subform to show those with a Code that equals "P".  

Here is what I have but it doesn't work.

    Me.subfrmVendorList.Form.Filter = "Code =" & chkbxPrint.Value
    Me.subfrmVendorList.Form.FilterOn = True

We have 2 users of an access 2010 application who get an error ''could not update;  currently locked'. I have tracked down the row in the table that these forms are accessing and can see no issues at all, e.g. signs of corruption. Is there anything else that can be done. There are a few forms that show/update date in this particular row, unsure really what may cause this, but as its affecting multiple users each with their own FE the common denominator being that row, what can be done.
If I connect to the backend of the system and try and manually edit a single column in the record it gives the same error.

I am exporting a number from Access 2010 to Excel and Excel is labelling the cells with the error Number Stored as Text.

The export VBA uses:
DoCmd.OutputTo acOutputQuery, "Beneficiaries Report Anonymised", acFormatXLSX, , True

The query field in question is:
IIf(IsNull([dob]),"",FormatNumber(getage([dob]),0)) AS Age

[dob] is the person's date of birth

The GetAge function is:

Public Function GetAge(pDOB As Date, Optional pDate As Date = 0) As Integer

'get age as of a specified date, or today
   GetAge = 0
   If Nz(pDOB, 0) = 0 Then Exit Function
   If pDate = 0 Then pDate = Date

   GetAge = DateDiff("yyyy", pDOB, pDate) + (pDate < DateSerial(Year(pDate), Month(pDOB), Day(pDOB)))
End Function

When the number gets to Excel it is on the right of the cell, so that indicates it's a number, but it persists with the little green error flag.

Am I missing something, or will I have to write some code to clear the error in Excel.

I know how to hide the Ribbon in Access.  It is possible to still give them the Spelling and Refresh buttons?

I have a form that has a listbox.  Also on the form is a textbox.  When the user enters a letter (will always be a single letter, in the textbox, I want the listbox to be filtered and only show the records that have that selection code in the table.  I've tried this and it isn't working:

Private Sub txtFilteredVendorCode_Change()

    Me.Form.lstVendors.Filter = "SelectionCode like '" & Me.txtFilteredVendorCode.Text & "*'"
    Me.Form.lstVendors.FilterOn = True

End Sub

Select all Open in new window

I have a number field in access query that I need to be exactly 10 character long with leading zeros and including the cents, but no decimal.

What I have formatted now:
Amount: Format([GROSS],"00000000.00")
which displays
00000124.58
What I need displayed is
0000012458

Hi,

It would be great if someone could help me out with following query.

I am looking for MS Access VBA script which can copy range of cells (A1:S35) from a spreadsheet(sheet name: aaa) from one workbook(aaaa.xlsxs) and paste (paste special with format) on to another workbook(bbbb.xlsx) spreadsheet (sheet name :aaa).

Thank you
A