Search results

Hi spikepl, Thanks for the suggestion. Her font size was set to normal. I tried setting it to large and back again and even reset her windows theme but no joy. Good thought though - keep'em coming! All the best M.

Ok, I've looked at the user's problem again and realised that the dropdown filter buttons ARE there. It's just that the button has no image so you don't see the down arrow but you can still click on it! I'm guessing that Access uses a particular font for the down arrow and that is what is...

Hi All, I have a really weird problem and can't seem to figure out the answer. I'm hoping someone else might have come across the same thing. I have a access 2007 db that is rolled out to users using the Developer > Package Solution option. This installs a copy of the db on their pc and Access...

Hi All, Here's a quick and nasty function to convert a number to it's ordinal representation. e.g. 1 = 1st 2 = 2nd 3 = 3rd etc. Public Function IntToOrdinalString(MyNumber As Integer) As String Dim sOutput As String Dim iUnit As Integer iUnit = MyNumber Mod 10...

Folloiwng on from Bannana's post, I had a few gotchas when linking MSAccess to MySQL via ODBC. I'd recommend turning the following on in your ODBC connection: return matched rows instead of affected rows allow big result sets treat BIGINT columns as INT columns Also create your boolean...

Hi All. Not sure if this is even possible but I thought I'd ask :o . Does someone know how to list the date a View in MSSQL 2000 was last used? I've got a DB which has been hacked around with for a long time and there's loads of views defined that I think I can delete. However, some of them...

Hi All, If this would be better posted in another area please let me know. Tar.

Can anyone suggest a better way to do this? I've got a stored procedure in SQL that creates a copy of a record in our contact database and returns a table with a single row to return the new Primary key for the new record. Background In access I've created a general passthrough query called...

Hi Avelino, Thanks for all your help. Worked like a charm! For anyone else getting started with this - I'm not sure if this helps but It took me a while to wrap my head around the concept. I don't directly set values on the Ribbon. Instead it sets values by calling subs that I define. Now...

thanks for the response. Looking at the link you posted, I think I'm correct in thinking that: I have to define a get parameter in the XML that will call a vbfunction which returns the value I want to set for the checkbox. The vbfunction is only called when the ribbon is first opened so I...

hi all, I thought it was high time I got to grips with how to implement custom ribbons. I've managed to write some xml and subs that trigger when buttons, etc are pressed. what i can't figure out is, with checkboxes, how I set their value dynamically. I have a form with a boolean field in it...

Hi Banana, Thanks for all your help and suggestions. It was really useful to be able to bat some ideas back and forth. Have some cred. As the list of IDs in the local table only needs to survive until access is closed I think I'm going to rewrite my code so it uses a MySQL temporary table...

This should list the rows, rather than deleting them. SELECT * FROM TableB WHERE OrderNo NOT IN (SELECT DISTINCT OrderNo FROM TableA);

Hi Banana. The SQL is actually generated on the fly from a custom search form. Basically, I've got a bit of code that picks up all the unbound fields with a particular prefix in their name that contain content and uses the name & the content to write a SELECT WHERE statement. This means I can...

try: DELETE FROM TableB WHERE OrderNo NOT IN (SELECT DISTINCT OrderNo FROM TableA);

Hi Banana, Nice idea for a test. Here's the code syntax corrected. DELETE * FROM LocalTable WHERE LocalTable.ID IN (SELECT ID FROM [ODBC;DSN=MyDatabase;].viewTest); I set up an ODBC datasource so the the connection string wasn't too onerous. Obviously, as before, I've stripped out my naming...

Hi Banana, Thanks for the test. Much appriciated. I thought I might have something seriously wrong with my setup as i couldn't find anything on-line discribing the same issue. At least I know I'm not going mad! Unfortunately the PT is acually a dynamically created query rather than a table. I...

Hi bob. Happy to clarify. The local table isn't on a SQL server. It's a real table in my mdb not a link. The Access DB is not a ADP, hence I can have local tables. The PassThroughQuery is a query that uses ODBC to connect to a MySQL database using pass-though (which I believe makes that...

Delete query referencing a pass-through results in error [Solved] Here's the delete query: Delete from LocalTable where LocalTable.ID IN (SELECT PassThroughQuery.ID FROM PassThroughQuery); The table called "LocalTable" stores a list of IDs I want to delete. The query called...

Hi all, Just for a bit more detail, I found the microsoft page that explains the order of events in forms, reports, etc. here: http://office.microsoft.com/en-us/access/HP051867611033.aspx Opening a form Open → Load → Resize → Activate → Current Closing a form Unload → Deactivate → Close