Search results for query: *

My database is well and truly set up and has been functioning for almost a year. however, i have recently noticed i made an error in my table creation as i forgot to include a year field. i have a tblWeeksDates which includes the week numbers for this year 1 - 52 and the start date of each...

Can you archive data within your database? I have data for the year 2006, and i wanted to start a fresh year 2007. is it possible to archive my previous data - i still need this data for reports etc, but it would be easier if it wasn't held within my forms. many thanks

I have a value stored in one table that i wish to transfer to another form I have tblEmployees this stores the employee name, wage rate etc. I have tblHours this is used each week to input employee wages - the empployee id is entered, the hours worked, the week number etc. i want tblHours to...

I have a query and i want the report to print out details of employee cash required that week. These have been input in tblHours. However i have set the query up with 'True' in the criteria for each of the Cash fields. so as not to print off all employees including those without cash. these...

I have a database which works fine for inputting weekly wages and calculating gross and nett totals etc. each week a certain amount of cash is paid to workers as part of their wage. we have a cash distribution form which is currently on microsoft excel, which means it is completed out of the...

My database uses various parameter queries where the user must input a code to return the required results e.g. parameter query : enter employee id: This would then bring up details on that employee. is it possible to have a search facility for the user to enable them to for example press f2...

I have a database which holds employees wages weekly. i need a report to show the monthly total of each employees wages. e.g. Emp Id Forename Surname Gross Wage 1 Joe Bloggs £2000.00 2 Fred Smith £1670.00 3 Barry White £1750.00 etc... however i can only seem to...

Hi, I have a wages database which is used weekly to determine the weekly wage of each employee based on the hours they've worked. each employee has a daily wage rate which may increase over time. I have a Master Wage Sheet which calculates the employees gross, tax and net wages. The gross...

hi, i am creating a database which should if it works correctly create a cashflow forecast. i have two tables tblDevapp and tblCostCodes i need to draw information from both of these tables to create a report. the whole database contains about 7 tables Jobs; DevApp Budget; DevApp Actuals...

I have 3 seperate tables which i want to link together in one report, however i have too many fields. tblCostCodes has about 55 fields tblDevApp has about 10 fields tblSales has about 10 fields I don't actually need all fields to be visible within the report however i do need them for...

I have the following tables tblEmployees (containing: empid,forename,surname,address etc...) tblEmployeeLoans (containing: loanid,empid,amount,reason,weekno,repayment amount;paidback etc...) tblHours (containing: empid,hours,cash,weekno,etc...) all employees are paid weekly. if an employee...

I have a form 'frmHours' whereby the user enters data about an employees hours worked and cash required each week. cboEmpId cboWeekNo cboPeriod Hours Cash is it possible to have a text field update with the employee name, when the empid combo box has been selected? also 'tblemployees'...

I HAVE REPORT WHICH PRINTS OFF THE DETAILS OF EACH EMPLOYEES GROSS WAGES PER WEEK BY THE AMOUNT OF HOURS THEY WORKED AT EACH INDIVIDUAL JOB: I.E. JOE BLOGGS WK 1 £100 JOB 1 WK 1 £90 JOB 2 WK 2 £330 JOB 1 ETC... IS IT POSSIBLE TO HAVE FORMULA WORK OUT THE TOTAL WAGES FOR A SPECIFIC WEEK I.E...

I HAVE REPORT WHICH PRINTS OFF THE DETAILS OF EACH EMPLOYEES GROSS WAGES PER WEEK BY THE AMOUNT OF HOURS THEY WORKED AT EACH INDIVIDUAL JOB: I.E. JOE BLOGGS WK 1 £100 JOB 1 WK 1 £90 JOB 2 WK 2 £330 JOB 1 ETC... IS IT POSSIBLE TO HAVE FORMULA WORK OUT THE TOTAL WAGES FOR A SPECIFIC WEEK I.E...

I have been trying to set up a login screen whereby several different users can log in to the database with their own passwords etc. i have followed instructions on www.databasedev.co.uk/login.html it will let the first user in my table login, however it will not let any other user, and...

I have a database which calculates employee wages. it has a table for employee details including wage rate, name address etc... tblemployees. I have another table, tblhours, where employees hours are entered each week, therefore foreign key from tblemployees is employee id. It is possible that...

Does anybody no if it's possible to have an option to 'select all records' from a drop down combo box? I have a database which uses 10 records for one table and 5 from another every time a specific report is run. there are only 7 fields which change everytime and these are stored within another...

I need to produce a report from a query, i know how to do this however, my query contains too many fields for a report to be produced. The problem is half the field could be hidden in the report however because there are so many initially the report builder won't work. I need all the fields...

I'm sure there is a very simple answer to this but here we go... if i want all records with location ending "ON" in descending order, what do i put in the sort criteria of my query?? Please help!

This is probably a very easy to solve question but... an i get a field on my form to toal up the values of some other fields? for example, the user inputs the price for an electricity connection;gas connection;water connection;bt connection. I want the total of these connections to work out in...