Search results

Hi, The following code refers to a continuous form based on a temporary table. In order to simulate grouping I set a textbox to value 1 and have conditional formatting give it a black background in order to draw a line every time part of a string in another field changes. The highlighted line...

Hi, So I have data in a temporary table which represents lines of a drawing. I need to turn this data into a picture. I think I have two options; first option is to use the print event in an access report to turn my data into lines and circles on an access report; second option is to link to...

Hi, I am vaguely aware that temporary tables do not have the best reputation. I have recently started using temporary tables and I have found that I can make the db far more user friendly using temporary tables than without. I would like to use a whole lot more but I want to know if I am...

Hi, My db has multiple linked tables. As time passes and work on a project continues data needs to be added to a separate table that is linked to the first table to be populated. ie, Initial design data is entered first, when drilling is complete more data is added to a linked table, when...

Hi, I have a couple of tables which only have a single field. Is it worth adding a second field in order to hold an ID number (is this commonly termed an index number?) for each entry. My other tables with multiple fields include a field for an ID number and these tables are linked via these...

Hi, I have a report which is created from a series of queries and recordsets then displayed in MS excel. The report looks like it may become a bit of a monster with requests for plenty more calculated fields to be added. The report contains a lot of dense data primarily for the consumption of...

Hi, I just altered a query that was Previously working OK. I now get a data type mismatch error. The error occurs in the query with the 'AND' in the 'WHERE' clause tblHolesDesignAndSurvey.IDStope data type is number. Any help much appreciated Thanks Sub DisseminateDesignData(STPName As...

Hi, In the highlighted line of code attached I am comparing two strings one from a snapshot recordset and one from an array. The logic fails, you can see in the watches window both values equal "DESIGN and the elseif statement should execute but it does not. The only reason I can see for this...