Search results for query: *

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, 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 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, 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, I am trying to get this query to run from VBA but keep getting "Expected end of statement error". Within in this I am trying to add the string months to a value using "as" & I think I have got my & " messed up. strSQL = "SELECT tblRisk.RiskRef, tblRisk.RiskDesc, tblrisk.ReviewFreq" & "...

Hi, Is there anyway to determine when you are at the last record of a form based on a SQL query?

Hi All, I am trying to build a report where the details of the current risk assessment is shown & then after it all the alterations to the record are displayed. The first part is ok it is the second where I am having problems, the modifications to the assessments are held in a seperate table...

Hi, I have set up an audit table to track any changes to a Risk Assesment. Table structures below: tblAuditRisk ID PK LoginName TableName RecordPKey FieldName OrigValue NewValue Date tblRisk RiskRef PK RiskDesc ReviewFreq DeptRef Process AssessorRef Task PersonAtRisk Comments Method...

Hi, I have set up an audit table based on Allen Brownes example. How can can loop through this table & compare each field & return the differnces between them. There are 12 fields which could contain different data. So I would need to compare each of these based on the RiskRef field which...

Hi, What would be the best way of doing this: A tbale needs to be allowed to be dited & I need to keep a copy of data pre edited, I am thinking along either of these 2 lines: Note there will only ever be a max of 600 records! 1) Create a temp table & copy all the records to it from the master...

Hi All, I have a couple of functions which need to be called from different forms. At present I have referenced the fields as: Forms![frmTEST]!txtMyRef What I would like to happen is whatever form the function is called from that forms name is automatically passed to the function. Could someone...

Hi All, I am unable to get the following code to open the selected form. Private Sub cmdOpenSelected_Click() Dim stDocName As String Dim stLinkCriteria As String On Error GoTo Err_cmdOpenSelected_Click Select Case fraChooseForm.Value Case Is = 1...

Hi, When trying this DLookup a null is always returned. I know both of the criterias have been met. If I split the criteria ie. only use 1 then I get a value returned, but with both nothing. I have also tried enclosing the date with #'s but it still will not return a value. Any ideas...

I have been given a flat, only 1 table Access DB to work with. Please could anyone let me know if they my normalisation of this is OK. I have joined all the tables together using tblAssessment at the bottom of the list. Thanks in advance. tblRisk RiskRef PK RiskDesc ReviewFreq tblDept...

I am trying to modify the code below, at present it loops through ADOrs1 & writes a new review date to tblReview for each record based on a value in a text box. I need to be able to loop through ADOrs1 as before but keep looping until the review date written to tblRebview is less than a given...