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
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
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
In your example, because you use CurrentDB to execute your INSERT you’ve made it harder for yourself. Instead, this will work: Dim query As String Dim newRow As Long ‘ note change of data type Dim db As DAO.Database query = “INSERT INTO InvoiceNumbers (date) VALUES (” & NOW() & “);” Set db = CurrentDB … Read more
There is perfect logic to the Parentheses Rule in VB(A), and it goes like this. If a procedure (function or sub) is called with arguments, and the call is on a line with other statements or keywords, the arguments must be enclosed in parentheses. This to distinguish the arguments belonging to the procedure call from … Read more
We wrote our own script in VBScript, that uses the undocumented Application.SaveAsText() in Access to export all code, form, macro and report modules. Here it is, it should give you some pointers. (Beware: some of the messages are in german, but you can easily change that.) EDIT: To summarize various comments below: Our Project assumes … Read more
This is easy using Allen Browne’s ConcatRelated() function. Copy the function from that web page and paste it into an Access standard code module. Then this query will return what you asked for. SELECT i.N_ID, i.F_Name, i.L_Name, ConcatRelated( “Course_ID”, “tbl_Courses”, “N_ID = ‘” & [N_ID] & “‘” ) AS Course_IDs FROM tbl_Instructors AS i; Consider … Read more
To Decompile an Access database you’ll need to create a shortcut with the following elements: Path to the MS Access Executable (MSACESS.exe) Path to the database you would like to decompile The /decompile flag All together, then, the shortcut would look something like the following: “C:\Program Files\Microsoft Office\Office\MSACCESS.EXE” “C:\users\tim\documents\Mydatabase.mdb” /decompile Obviously, the paths will be … Read more