Recent content by expublish

Worked - thanks. By the way ... I work for a charity - probably worse than the NHS!

I have a table with a currency field. There are lots of records, each with a salary in the currency field. What I need to do is increase the salary in each record by 2% - i.e. an annual salary increase (bloody tight!). This is a one off thing, so I am guessing some sort of update query. Anyone...

I see - in that case follow Colin's advice above.

See Colin's reply. Active thread ;)

Chewy Firstly please explain what you mean by a 'query' item. I understand what you say to be a record. Also I am confused by "! want only one queried item per page...which could actuially be more than one page" Do you mean one record could be too big to fit on one page? Scott

Surely all you need to do is setup a query, create a report based on the query and create a macro/vba module that prints the report. You can design the report so it only has 1 record per page. Unless I have misunderstood the question? Scott

As DJN said the report needs to be based on something - what you want to do is better done using ASP. Can take a long time to explain doing that so get a book if this is what you want to do. This project sounds suspiciously like A-Level Computing to me :-) Scott

Database structure: tblusers(ID,username,password) tblvalues(ID,value) They are not currently joined in any kind of relationship. When I add records to the tblusers table I would like the password field to automatically be populated by a random value from the tblvalues table. There are lots...

Pleasure.

DateDiff("d",[Date Orig],[RelFloorDate]) Invalid syntax means you've buggered it up in some way. HTH Scott.

Lynsey2 - pic has gone from the server ... try downloading it and then adding an attachment to a post. EXP

This is the next big step in developing! You need to learn ASP/ASP.NET! Basically forget the form you have made - as this will be completely useless for use on the web. You need to use the table data in the database and create a series of asp pages that displays that data, filtered to your...

Like it! Not trying to be a clever dick or anything, but when would you need to use this?

How can I change this to run a macro if they click yes?

I have a command button on a form that runs a macro. On the On_Click command before the macro is run I would like a pop up msg box to say 'Are you sure...' with Yes/No options. Onbviously the yes will carry on the command and the no will return to the form no changes. Any help is great, Scott...