Recent content by scriggs

Hi MVP The fields are not constant and are supplied by a 3rd party - they will change everytime so need to be detected. The structure is the same with week and dept across the top 2 rows and name down first column. Then any number of columns (can be 255) with the data in each column. I guess...

Hi I have a query which is left joined so some fields have no data. Also some fields have a zero in them. I am trying to perform a calculation like a/b and if a or b is missing then I get an #error. I have tried iif(isnull(a),0,a/b) and nz(a,0) but still get errors. Any ideas?

Not quite what I was looking for, but a good lateral thinking move. I am going to use this for now, only problem is if the data in the my source is missing a week of data. Thanks.

I have a table which shows holds data stored with week no and year, i.e. Week Year 3 2007 2 2007 1 2007 52 2006 51 2006 50 2006 49 2006 .. 3 2006 2 2006 1 2006 53 2005 52 2005 51 2005 50 2005 I need to select a week and then pick...

Hi I have been provided some data in Excel which I want to normalize and put into Access. The data comes in like Weeks and department across here Sales Sales Sales Sales Ops Ops Ops Name 1 2 3 4 1 2 3...

Thanks for the replies. Remou - your solution does not work, I had already tried the form error event but it occurs after the Access error. PHV - the BeforeUpdate is the correct place, and then I have used setfocus back to the missing field as well as docmd.cancelevent to stop the error...

I have a form to add new entries to a table. The table has index fields linked to other tables. If a user does not fill in all the fields, or clicks into the next row, etc. then Access gives an error message: "The Microsoft Jet database engine cannot find a record in the table 'tblStockStatus'...

Thanks for the replies. For a quick short term solution I have gone with htaccess protection, but the interface is not that pretty. I was hoping to set something up with session variables and a form, so that once logged in I can carry around the site. The problem I am hitting is two places: 1...

Hi I have a webpage with thumbnail images which are previewed when you click on them using HTML <img src="files/plan5small.jpg" alt="Plan5" width="100" onmouseover="plan.src='files/plan5.jpg';" onmouseout="plan.src='files/plan5.jpg';"> I am trying to password protect the preview function...

I have a cross tab query which shows week dates as column headings, like: Name 30/10/06 06/11/06 -------- -------- -------- Mark 10 15 John 15 20 I need to show the week number as well as the date, how can I add that as a second column header, or similar. Name...

MichaelRed Thanks for the reply, very good comments and things to consider. Is superflous to my post, I am importing databases with identical structures generated by 000's of individual terminals running the same software. The purpose of this accumulation is to get the data into a single...

Golom That sounds great, just like I was looking for. I will try it out later and report back.

Hi CMP I have tried adding error handling but this error message appears before the error handling - i.e. the error comes, then waits for user input, then runs error handler. For now I have just used setWarning=false but not ideal as I cannot trap or log the error files. Eoin

I have a routine which is importing 000's of Microsoft Access databases into a large Access Database. Some of the files appear to be corrupt and when the routine tries to open them I get the error: "The database xxx needs to be repaired or isn't a database file. You or another user may have...

Thanks for the advice, I tried changing the code but it does not work for me. I get the &lt; and &gt; showing in the code and displaying as text on screen rather than being interpreted as tags. <XHTML>SPAN CLASS="BOLD"</XTML>