Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gscma1
  • Content: Threads
  • Order by date
  1. gscma1

    table - missing field

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

    archiving data

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

    autopopulate and update in form

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

    criteria in query

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

    Form to autopopulate from other forms.

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

    search function - parameter query

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

    Report showing totals of monthly wages

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

    Problem with Wage Rate updating

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

    Help with table set up and reports

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

    Too Many Fields?

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

    warning message

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

    Autofill, afterupdate question

    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'...
  13. gscma1

    Sum in Report

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

    REPORT CALCULATIONS

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

    Login Form Password Problems

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

    changes made to update from a certain date

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

    Select All Records from a Combo Box

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

    Too many fields to produce a report

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

    Sorting in a query

    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!
  20. gscma1

    Total Field in Form?

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

Part and Inventory Search

Back
Top