A standalone system creates a new MDB log file daily.
I would like to import 1 table from each of these individual MDB's into a new MDB containing a single table for the month. The table names are the same.
Thanks in advance for your help
Hi All,
My system has 4 trackers each is accessed using Pro Comm Plus via a modem.
How can I get the information stored in the tel dir, single line & multi line forms to an external program ie Word or Excel.
I am unclear as to what keyboard commands to use & how to access them.
Thanks in adavnce...
Hi All,
Please could someone help, I need to program a system speed call & do not know which form to use etc..
System is an SX2000.
Example someone dials 8111, system dials external number
Thanks in advance
Hi Remou
Thanks for your help I had typo, as I had been trying all diffent things after posting.
It does work but I get an error at the end a file sharing lock count something about editing a registry value.
Thanks for your help
Tim
...Sub cmdTRCode_Click()
Dim rst As ADODB.Recordset
Dim strSQL As String
Set conDatabase = CurrentProject.Connection
strSQL = "SELECT * FROM tblNewDataRange"
Set rst = New Recordset
rst.Open strSQL, conDatabase, adOpenDynamic, adLockOptimistic
With rst
Do...
Hi Golom & Skip,
Thanks for your advice. I have now done away with checking for null becasue it could be that a value gets deleted.
All is working fine.
Thanks
Hi All,
I am trying to allow a user to edit existing data via a form, then save any changes using a query.
As there could well be some empty fields (strings) I check to see if they are empty then build the sql string using only the fields that are not empty.
When executing the query I get an...
Hi,
I have written a function to loop through a table & concatenate all the Add_Info for a specific job & write it back to new table in 1 record.
On some the existing data I am getting errors, these seem to be caused by the use of ' in the concatenated text, also it appears that other characters...
Hi,
I have a frame's background color to a differnt one form the detail section. In the design view it displays correctly but when opening the form the color is the same as the details.
It is almost as if the background property has been set to transparent, the only way to be able to get the...
Hi Skip & xlbo,
My fault I should have mentioned I had tried to get the chart title but missed .text from my effort.
I do not expect you to do my work for me, in future I will ensure that I make it crystal clear what I have tried & what did not work.
Any way thanks for your help Skip
Tim
Hi,
I am new to Excel VBA & need some help.
I am trying to loop through all worksheets in a workbook.
Each worksheet has a graph in it, I need to get each charts title & then build a TOC with the returned charts titles.
Thanks in advance
Tim
Hi All,
I have a form based on a query & have been trying for ages to move to either the next record or previous record after the current record is deleted.
The forms recordsource could contain a single record or multiple records.
I have tried bookmarking & moving either direction after deleting...
Hi PHV,
Thanks so much for your help.
I will have another play in the morning.
I cannot see why the query needs or is asking for the criteria again.
Thanks once again
Tim
Hi PHV,
Nearly there now, to check the sytax I passes strSQL to msgbox. For some reason it is prompting for criteria siteref! But tne sql statement is being passed the 2 values for the where clause.
Do you have an idea why it would be asking for SiteRef yet again?
Thanks
Tim
Hi PHV,
Thanks for the info (yet again!
I am now getting the error "Expected end of statement" on the very last line in bold below is the part highlighted by the debugger.
strSQL = "SELECT tblRisk.RiskRef, tblRisk.RiskDesc, tblrisk.ReviewFreq & ' Months' AS Review, tblReview.ReviewDT AS...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.