Search results

Hi All I have a spreadsheet which I refresh data on which is stored on our accounts package. I do this using ODBC. I want to insert subtotals into the spreadsheet which I can do, however when I go to refresh the data again the subtotals dissapear and I have to insert them again. Is there any...

Hi All Is there a quick key to take you automatically to the formula bar to edit what it contains as opposed to clicking in there with your mouse?? I'm sure there must be and I'd appreciate anybody's help on this. :confused:

Hi I have a worksheet consisting of data in 4 rows and 10 columns In rows 1 and 3 across 10 columns I have dates which are formatted to dd/mm/yy and displayed underneath in rows 2 and 4 accross 10 columns I have number fields. i.e A B C...

Hi All I have a spreadsheet where I have hidden a large number of rows which I want to remain hidden. From the information I have left I want to copy this onto another worksheet without it carrying over the hidden cells. I'm sure there must be a way but no matter what I try it copies the...

Hi All I have set a parameter in a query on a number field. When I run the query it lists all entries relating to the number I enter. Once I have ran the query by either opening the query or clicking on the datasheet view when I am in design view, is there a way that I can re-run the query...

Hi I have a report which runs from a query. It basically is a report I run each week for each employee which they complete as to what their attendance has been for that week. It also lists if they have any holidays booked for that week. The report is run from a query which has a date...

Dear All I have created a query and within this query I have created a field to calculate a percentage from values in two other numeric fields. This shows the correct information however, I want to add a criteria to this field so that it only shows records <=30 (less than 30%). No matter how...

Dear All I have created a form which I call "Switch" to automatically open when myself or a colleague opens this specific database. This has been set through the tools and then start up option on the menu bar. On this form I have created numerous command buttons to open various forms. Reason...

Hi All I have a form which logs all our employees holidays/sick ect. This is ran from a query. In this form I have a date field called MyDate & MyYear which is calculated from MyDate in my query. Is it possible to create a filter on my form by using combo box's rather than option groups? I...

Hi All I have a form showing various employee information. One of the fields is employment date for when the employee started. I want a message box to be displayed to remind me when any of our employees have served 10 years, 15 years, 20 years & so on from their employment date, when the form...

Hi All I have a form with a subform created through a tab control. The subform displays salary information for that employee from when their employment started. This subform has six fields which are Employee ID, Date From, Date To, Salary, Position & Department. I want to be able to create a...

Hi All I have a form called FrmPrintReports. This has an option group which lists all my reports. I then have a command button called PrintPreview which runs the report depending on which option button is highlighted. I have created another form called FrmEmployeeID. This comprises of just...

Hi All I have created a form and numerous subforms ran from queries. Basically In the Form Header I have Employee ID, Surname & Christian Name. In the details part I have created subforms in tab controls. Rather than using my Navigation Buttons to go to each employee, is it possible for my...

Hi All I have a problem with some coding I have entered into a report I have created. My report comprises of 3 fields - MyDate, MyDay and Overtime. I want the report to show Saturdays in red, therefore I have entered the following code into the on format part of my detail part of my report: -...

Hi All I have created two reports with numerous calculated totals in the report footers. Is it possible for me to pull a total over from one report to the other? I have tried creating a text box and in its control source entering =[Rpt The name of my report].[Report]![The name of my text box]...

Hi All I have a query which is based on a table. One of my fields in my table is called MyDate. From this date field I want to create another field in my query to display the week number. Is this possible? Please advise.

Hi All Can anybody help with the following: - I have created a subform from a query. In the subform design view I have created an option group for me to select an option for the form to filter. In my option group properties I have entered the following code in the afterupdate option: -...

Hi All I have a subform which I want to apply a option group to to filter records. My Option Group is called FilterOptions and has at the minute 2 options which are All Dates & 2003. When I click on any of these options I want it to filter all entries on whatever I choose. Therefore I have...

Hi All I have a report with reads from a query. In my query I have 4 fields - a date field, week day, salary month and Overtime. I have created my week day field from my date field so that it displays the day of the week. In my report I have created a text box in the footer to be able to sum...

Hi All I have a subform where the properties are set to Continuous Forms. In the subform part of my formI have a text box called overtime and I want to be able to enter a number into the text box and then on key down it move to the overtime box in the next record underneath as opposed to it...