Recent content by Fransdekock

Hi I am doing a timesheet database system which records a contractors hours worked in a week and the rate they worked at as well as overtime hours and their respective overtime rates this is set up as Week1 Week1Rate Week2 Week2Rate Week3 Week3Rate Week4 Week4Rate Week5 Week5Rate OWeek1...

:( Hi I'm currently administering a database a previous developer really messed up. I have a problem getiing a total I have two tables a ResourceTable and a ResourceSub table The resource table holds information for ResourceID - Primary key StaffID for member of staff projectID for the...

Thx for the comeback! [project_job_number] is a text field. Should i use If isnull(Dlookup([project_job_number],"projects","[project_job_number]=" & [forms]![projects_frm].[project_job_number])) then as validation ?

Hi I have a problem where a user would enter a project code eg 113-099. I put in a list box that filters all the project codes for instance if the user enters 1 it will show all codes starting with a 1 and every additional number they enter it filters the list box to show which codes already...

Can u create tables from forms! Letting user select what they need and then entering the data into it ? Please let me know Thx for any help

I get this error on a microsoft office class object and everytime i try to run vba code as well. THe form name is Form_HDM Subform1 but the thing is that the form doesnt exist. Not even in macros.How can i remove this ? Anyone have any ideas... or just remove that class object..... please let...

Hi I think i have a unique problem. I have a subform where the user type in number of days worked by a contractor in certain weeks. Standard fields are week1 to week 5. This subform gets its data from a query. The afterupdate for each week triggers a setvalue macro to take the contractors rate...

Hi I think i have a unique problem. I have a subform where the user type in number of days worked by a contractor in certain weeks. Standard fields are week1 to week 5. This subform gets its data from a query. The afterupdate for each week triggers a setvalue macro to take the contractors...

Thx so much for ur help..... appreciate it!

Thx for ur help I have an idea dont know how well its going to work. So using ur idea of keeping the unit price on the invoice table what if i keep it in both tables. Invoice and products. So at creation of the invoice or when a new invoice id is created it takes the current price and inserts...

Thx for ur help I have an idea dont know how well its going to work. So using ur idea of keeping the unit price on the invoice table what if i keep it in both tables. Invoice and products. So at creation of the invoice or when a new invoice id is created it takes the current price and inserts...

Thx for ur help I have an idea dont know how well its going to work. So using ur idea of keeping the unit price on the invoice table what if i keep it in both tables. Invoice and products. So at creation of the invoice or when a new invoice id is created it takes the current price and inserts...

How do u link it just at invoice creation ? Excuse me asking but this is new to me

Hi i have a quick question Lets say u have a database that keeps track of all items sold and their respective prices. So u have a items table that keeps the product information and price. Then these items are displayed on invoice kept in a invoice table linked with a foreign key and a one to...

Hi i have a quick question Lets say u have a database that keeps track of all items sold and their respective prices. So u have a items table that keeps the product information and price. Then these items are displayed on invoice kept in a invoice table linked with a foreign key and a one to...