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
Change it to an update query. For Field: put [Net Income] For Update To: put [Net Income] * 1.1