Search results for query: *

Thank you so much

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

Thanks Remou how stupid of me. Have tried it again but it is putting the same value in Trade_Code for all records.

Hi, I am tryong to loop through a table check a value in the "Trade" cpolumn & depending on this set a new value in "Trade_Code" which is currently empty. When I tried this code it deleted the value in the "Trade" column & set every trade code to 1 the first value it found. How can I set the...

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 George, Thank you so much. I have been trying all sorts of combinations out for hours & finally decided to post it on here. Thanks once again Tim

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 Skip, Thanks for that, but is it possible to actually get the charts Title not name? 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 managed to work it out, I just used a me.requery

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...