Search results

Hi jdraw, I have edited my post to include the sql from the queries. I don't know how to export the tabledefs as a text file, but both tables have an ID primary key and both tables have an Index on TCC_ID set to Allow Duplicates. (TCC_ID is the CaseID)

Hi, I have an update query which is not updateable for reasons I cannot fathom. I have two tables, tbl_Response and tbl_Activity. BOTH have a CaseID field which is indexed Duplicates OK (each case can have several responses and several activity records). I want to update a date field in the...

Thanks for the tip. I am not sure we can use a 3rd party product for this project, but it certainly looks a pretty smart bit of software, if a little complex!

Thanks for the reply, but this is a totally separate thing. I am developing a db with a large number of objects and am recording version changes in a table. As i am opening this table regularly, it would be useful to have a button on the QuickAccess toolbar to open it directly, rather than using...

Hi, Is there any way to add a command to the QAT to open a specific form or table within your database? (Another useful feature which used to be easy in older versions of Access which some brilliant mind at Microsoft decided to remove!) Cheers, Jim

Hi DBguy, I am trying to write a custom error handler to put into an existing application. I am using something similar to PushCallStack and PopCallStack (see FMS article) so the error handler stores the procedure name, but is there any way that my code can access the info from the Locals...

Hi, I have read a very good article on error handling from FMS here. However I would like to know if it is possible to pass and store the values of any variables in use at the point where the code crashed (i.e. similar to looking at the Locals window.) Surely this would be extremely helpful in...

That is what I wasn't sure about - if you open the form with a 10k recordset and a where condition in the Docmd.Openform statement, does it pull more data across the network than opening the same form with a recordset query that already has the WHERE in it? Agree about the wifi - nothing I can...

Hi, I have taken over a database which is running far too many concurrent users (60+) on an extremely slow network (over wifi! I know!) One of the main forms has a query as its recordset which accesses a table with over 100 fields and 10k records. The query returns all records although the...

No, all of the fields will always contain a value. 3 field composite index seems to work quickly.

Hi, I have a bound form which has a number of fields in it's recordset which are NOT bound to any controls on the form. In VBA, I need to get the value of one of these fields in the current record. However the field I need will change each time the procedure is run and is determined by the vba...

Thanks for the feedback guys. I agree with the never comment - but in this case I am adding a one-off solution to mitigate a poorly designed db in the first place, so this is a real 'never' Going with 3 fields and a single index for all 3.

Hi, I am creating a table with a single memo field and either 3 text fields (tablename, fieldname, caseID) or a single text field with the 3 text strings concatenated. There will be a single NO DUPLICATES index on either the 3 fields or the single concatenated field. My question is this: from...

Hi, I wonder if anyone has tried this (or even if it can be done?) I have an MS Access application which I would like to be able to connect in vba to a MySQL database on my Synology NAS drive remotely over the internet. I have MariaDB and PHPmyAdmin installed on the Synology. I don't have a...

For the benefit of anyone else with the same question, the only way I could get this to work was in the OnCurrent Event to collapse all the rows and then just expand the current row using a SendKeys statement. The record with the focus is always expanded. Not very elegant, but it works, kinda...

Found an interesting thread here where someone posted a very similar question. It might be for my purposes, AWS with MySQL might be the way to go. https://access-programmers.co.uk/forums/showthread.php?t=288343

As far as I can work out, you have to configure the Azure firewall with a list of IP addresses that you want to connect from. Or am I reading this wrong? https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure#manage-firewall-rules-using-the-azure-portal

Hi, I have an Access 2016 application which at present has a small table of data which I maintain by distributing an Access accdb with the updated table to my customers. I would like to change this so that the application looks at a SQL (or other) database over the internet. Some of the...

Thanks DBguy, I would be interested to see how you get on.

Thanks guys. I don't normally use subdatasheets either, for the reasons mentioned. But in this instance, the user needs to be able to drill down 3 layers in the data. I thought this would be more useful than having 3 separate subforms. If subdatasheets offered this functionality as an option...