Search results

I have an online timesheet system - its basic but does what i need - every week i pull out a CSV file with everyones time and then make a report. In order to expedite the reporting process i thought I know, lets make a database with a nice report already formatted. So far so good. HOWEVER the...

The Gurus on this forum have always been great at helping me with the most mundane of questions, one thing i have missed out is the very basics of database normalisation - i always figured since i could get my database to do what i want, i must be doing it right. Since i have had a verbal...

SOLVED - Date dependent element of query. This is probably a stupid question, but having searched the forum(s) and scoured my Access book i am damned if i can find an answer, so i turn to you good people for a hand. What i think i need is some sort of IF statement, let me explain. I have a...

I have a query based on two tables. Table one gives a list of staff time transactions i.e. hours spent on a particular job. Table two gives a list of the staff rates, so enable project costs to be calcuated - hence there is a relationship between the Staff Name fields of both tables. IF i do...

I have two drop down menus on a form which are used to select a special date range (using sap week numbering) they are called: Combo86 Combo88 these values are used in a query which is run when a user selects a report. The question is, how do i alert the stupid user who is trying to run a...

I have a table called tbl_esttime, what i want to be able to do is that on the click event of a button - write values to the table, so my table structure is: tbl_esttime ID Job NO Staff Member Hours What i need to do is write 5 new records in the table, as such: Job NO Staff...

I have two tables: tbl_finance actually records the hours worked on a job, whereas tbl_esttime records the hours that I think are going to be worked on a project (for estimating budget purposes) When i run qry_estimatedhours - i get a nice total of the number of hours by grade that are...

I have a lookup query which references tbl_projectdetails: SELECT tbl_projectdetails.[Project Code], tbl_projectdetails.[Service Area], tbl_projectdetails.[Project Title], tbl_projectdetails.[Work Stage], tbl_projectdetails.[Project Director], tbl_projectdetails.[Project Manager]...

I have a short piece of code behind a button: Private Sub miniwip_Click() On Error GoTo Err_miniwip_Click Dim stDocName As String stDocName = "qry_to calcuate costs for est time hours" DoCmd.OpenQuery stDocName, acNormal, acEdit 'run first make table query for finance...

I have a report which pulls in data from three related tables, the fields are: Job NO Job Title Spend Estimated Fee FD3.6 Fees Fee Remaining % Spend of these fields, the last three are caculated on the report. Now the problem i am having which occurs at both query and report level is that when...

:confused:I have a subreport [qry_projectviewsummary subform] on Form [tbl_projectdetails], I have created the following expression in the footer of the subreport =Sum([Cost]) which provides a SUM of the Cost fields of the subreport. When i reference this in the form, as such...

Hey, thought it was better late than never to actually come say hello here :D so greetings to everyone on access programmers, by far my favourite online resource for helping out with all my access problems. You are indeed a great bunch of folks from which i have learnt many a thing, thankyou...

All Ii am after quite simply is a table which produces a log in and an exit time and person / machine name when opening my database, (I do not want to go down the route of using the inbuilt user level permissions for access) I have scripts which work very nicely for getting the current user...

If you download the attached database, unzip, then run - select Frm_home to stat from then run the Mini WIP Report - you will see what i am talking about. I am working on a database which records hours spent working on time charge jobs per person - this is for the engineering consultancy for...

Introducing the tables and structure to start with, three tables - the common element between them all is the Job No/Project Code, for example CO00507144. Table - Finance. Attr: Project Manager Field2 Job NO Job Title Network Activity Work Stage Employee No Staff Member Amey Fiscal Week Year...

I have a table - which lists transactions for jobs, i.e. each entry consists of a member of staff, their grade, hours they have worked, cost and charge out rates etc. From this i have a query - which runs max and min totals on the Fiscal Week Year column, now for the min total - it quite...

I have two tables: - Project finance, each line is a single transaction for a job, i.e. how many hours someone has spent working on a project, so for each project there are / will be multiple lines. - Grade rates, a list of staff members, their grade and their charge out rate per hour. What...

New report record created Report is produced Output from database for client Each member of staff logs how many hours they have spent working on the project What i want to be able to do is run a query which calculates the time / charges for that report. So when i select Mr Smith as a project...

Is it possible to update a field in a record using a VBA button ? What i want to do is have a button on a form, which when pressed changes a certain field value from its default "no" to "yes", i am happy with how to do the yes no VBA question box .. but the code on how to udate the field ...

Ok here is my problem, i have a table which contains a list of staff, the charge out rate and then team role (this is either leader, member or observer) This table is interogated by three queries to identify the leaders, members and observers, which are used as lookup sources for my report...