The above design requires four subforms. Each subform should be based on the junction table with book id as the link child and master field and a combo box based on the relevant table for the second table id. For example, your first subform is Authors, the table it is based on is Libri_Autori Link … Read more
First, Password is a reserved word, so use [Password]. Second, a date expression must be wrapped in octothorpes: #2017/04/24# Also, if you won’t use parameters, even though recommended, use a function like this to concatenate your values: ‘ Converts a value of any type to its string representation. ‘ The function can be concatenated into … Read more
To build on Ilya’s answer try the following query: SELECT MSysObjects.Name AS table_name FROM MSysObjects WHERE (((Left([Name],1))<>”~”) AND ((Left([Name],4))<>”MSys”) AND ((MSysObjects.Type) In (1,4,6))) order by MSysObjects.Name (this one works without modification with an MDB) ACCDB users may need to do something like this SELECT MSysObjects.Name AS table_name FROM MSysObjects WHERE (((Left([Name],1))<>”~”) AND ((Left([Name],4))<>”MSys”) AND ((MSysObjects.Type) … Read more
Access 2010 has both stored procedures, and also has table triggers. And, both features are available even when you not using a server (so, in 100% file based mode). If you using SQL Server with Access, then of course the stored procedures are built using SQL Server and not Access. For Access 2010, you open … Read more
It is a very bad idea indeed to name anything Name. It seems to me that you need cascading comboboxes. You will need a little VBA. Two combo boxes called, say, cboLocation and cboNodes, on a forrm called, say, frmForm cboLocation RowSource: SELECT ID, [Name] FROM Locations ORDER BY [Name] ColumnCount: 2 ColumnWidths: 0;2.00cm ”The … Read more
Causes General error Unable to open registry key Temporary (volatile) Ace DSN for process … This is the top-level error message produced by the Access Database Engine (a.k.a. “ACE”) ODBC driver when the current process is unable to open the Access database file for one of the following reasons: Some other process has opened the … Read more
Despite the (formerly) accepted answer to this question, the bang is not in fact a member or collection access operator. It does one simple and specific thing: The bang operator provides late-bound access to the default member of an object, by passing the literal name following the bang operator as a string argument to that … Read more
You should be able to do this with a pretty standard DAO recordset loop. You can see some examples at the following links: http://msdn.microsoft.com/en-us/library/bb243789%28v=office.12%29.aspx http://www.granite.ab.ca/access/email/recordsetloop.htm My own standard loop looks something like this: Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset(“SELECT * FROM Contacts”) ‘Check to see if the recordset actually contains rows If Not … Read more
To get different random record you can use, which would require a ID field in your table SELECT TOP 1 questionID FROM questions ORDER BY Rnd(-(100000*questionID)*Time()) A negative value passed as parameter to the Rnd-function will deliver the first random value from the generator using this parameter as start value. (A kind of defined randomize). … Read more
Typically you have to write a function that will allow you to create a concatenated list. Here’s what I’ve used:. Public Function GetList(SQL As String _ , Optional ColumnDelimeter As String = “, ” _ , Optional RowDelimeter As String = vbCrLf) As String ‘PURPOSE: to return a combined string from the passed query ‘ARGS: … Read more