Search results

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

drawbacks of putting report into access - additional work for me now, engineers like XL advantages - might be easier and less work in the long run

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

Since my code and layout is receiving comments I thought I might put in a few points/questions on your reasoning. 1. I rather have queries in the code so that I know exactly what they are relevant to. The database has tens of queries if i have them as queries in access I will forget the purpose...

Thanks very much. all fixed Quotation marks.....Where clause variables....:banghead:

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

What is the difference between this and 'Option Explicit' ?

figured it out, field size was 255 so I was comparing "DESIGN" with "DESIGN ....255 spaces..."

Hi, No error message, the elseif statement simply does not execute when I want it to! Check out the previously attached screenshot with the active watches. Maybe it is to do with the data type, the array is a string, the recordset is object/field2? The highlighted line of code (elseif) in the...

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