Search results

Hi Everybody, I've just progressed onto the DAO chapter of my VBA text and am already confused by what is supposed to be one of the simplest aspects of the Database object, that being counting the number of databases open in a workspace. The text says " Normally, we will have only one database...

I have encountered an apparent inconsistency in the way VBA handles calls to functions from within a subroutine, as well as calls to a function from the Immediate window. In both cases how VBA responded seemed to be dependent on whether there was one or whether there was more than one argument...

Hi Folks, I'm working through an old manual that provides an introduction to VBA programming in Access and I'm stumped at their use of the IsMissing funtion. The code they provide is thus:- Function MakeIceCream (Optional CocoaToBeAdded As Variant) As String If IsMissing(CocoaToBeAdded) Then...

Hi All, This isn't an "I've got a problem" post but more one where I am after some general advice. I recently created (with the help of several helpful members of this forum!) a Sub Procedure in VBA to enable me to automate the Import of some data. The procedure contained a few docmd's and...

Hi All, If a run the following SQL string from within VBA and the string is all on one line, it works fine:- SQL = "UPDATE tblContactImport INNER JOIN Customers ON tblContactImport.cuco_Company = Customers.cu_ID SET tblContactImport.cuco_NewPhone = Mid(Customers.cu_PhoneNumber,1,5)+'...

Hi y'all I'm trying to use a SQL SELECT INTO statement to back up the table tblContactImport into a new table with the same name albeit with today's date stuck on the end :- for example if I ran the query to back up tblContactImport today, then I would like the new table to be called...

Hi All, I currently have a macro, that using the OpenQuery macro action, runs a number of update queries. However, as my database expands I do not want endless queries clogging up the navigation pane, so after finding out about the RunSQL macro command, I wish to copy the SQL statement for each...

Hi All, I have a table - tblCustomers that contains the text field c_PhoneNumber that surprise surprise holds phone numbers. The trouble is that many of the records contain non-numeric characters such as hyphens and brackets as well as spaces. I would like to strip all of these out with an SQL...

Hi All I have a textbox - Forms![FrmPGFinal]![txtComments] that is bound to [tblPGFinal]![Comments], which has a Memo data type. I have an unbound pop up form - Forms![frmPopUpComments] with a single text field – [txtInsertComment]. There is also a command button – cmdOK. When I open the...