Search results

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

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

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

Hi, I have two queries: 1) called 'Update Holiday' 2) called 'Delete Holiday' One is an append query and the other is a delete query. I need my Database to run these two queries on the last day of each financial year - so on 31st March 2002 (31/03/02). I do not want them run on any other...

Hi, I have a report based on a Parameter Query. The field I search by is 'Employee Name' and I want the report in desc order of field named 'Start'. In my query I have set this but when I preview the report the records are not in the order of the 'Start' field, they are jumbled up. I have...

Is it possible to create a query that will display 1 random record when run? If so, how? Scott.

Hi all, 1) Great new look forum! 2) I know this is not a direct Access question, but IMO Access and ASP go hand in hand. My situation is as follows; I have an asp page that simply shows records from a Access DB table or query. They are showing fine. However, I need the ability to be able to...

Hi, I have been using this to add up 6 fields from a table giving the total: [Assist]+[Clean Sheet]+[Goal]+[Hatrick Bonus]+[Penalty Save] AS Total FROM [Weekly Scoring] But instead of adding them up it puts them together. e.g. > fields are 2,3,4,5,6. The total field shows 23456 instead of...

Hi, I have a main form with two subforms. Details are entered on the main form, then options selected from sub form 1 and sub form 2. In the subforms (shown in datasheet view) when I try and select a value from a combo (only 1 field) I get a message "This property is read only and can't be...

I have a table called Units. In it there are various fields related to the unit. One field is called 'Path to image'. This contains the network path to the image that relates to that record. I have a form based on the table. I have all the fields displayed, apart from 'Path to image'. I would...

I have two tables that look like this: 1) Employees Employee ID (key) Employee Name [other irrelevant fields] Holiday Due (this is the entitlement per year) [other irrelevant fields] 2) Holidays Holiday ID (key) Employee ID (lookup in above table) Notified (date) Start (date) Finish (date)...

I have several parameter queries. What I need to know is how to change the title of dialogue box that pops up asking the user for criteria. It currently shows "Enter Parameter Value". How can I change this? Thanks. Scott.

I have a staff database. Within this there is a table that holds employee details. One field is called 'Start Date'. I need to be able to see a report of what employees have got 5 years service, 10 years service, 15 years serice and 20 years service coming up. I appreciate this are likely to...

I have several pie chart reports. They look fine. However, I can't seem to make the values for the sections of the chart to show. Basically a % for each section (part 1 = 25%, part 2 = 50%, etc) or the actual value for each section. Any ideas how to do this as it is vital for statistical...

I have a text field on a form. I am using it for the message part of an e-mail. At the moment the user can type a message, but only as one line. They cannot press return/enter and go to the next line - it takes them to the next form object in the tab order. How can I make the text field so they...

It is not so much a problem as a query. I have a form where the user fills out a couple of fields and clicks a button and an e-mail is sent to a load of recipients. My query is nothing to do with this however. When the user clicks the send button I would like them to be prompted with a message...

I have a form where the user types out an email message and clicks the send button to send it. I want to make it so that when they have clicked the button, it becomes unclickable for a second time. This stops them sending the message by more than one time accidentally. It needs to bedisabled...

Hi All, Hope everyone had a great easter! I have a form with a simple tab control on it. It has two tabs with a couple of fields in each tab. When the form is opened the first tab is the active one. When I click the other tab, the page moves upwards, so the top of the tab is at the bottom of...

Hi, I have created a simple Pie Chart based on one field of a table, using the wizard. It is fine, except that the first value on the legend says Slice 1. Why does it do this? All the other values are listed OK in the legend. When I look at it in design view the legend shows East, West and...

I have a report that is based on a query that filters out people, who's birthday it is in the next 10 days. Now, I want this report to only open if there is data in it. I.E If it is no-ones birthday in the next 10 days, do not open. Otherwise do open. I assume I need to put some code in the On...