Search results for query: *

hi. I've got a table in my db which is called ProjectBookings. The table holds details of different projects booked for this company, with the following main fields: ProjectID BookingReceived ClientID InvoiceSubmitBy InvoicedYesNo there are other fields but these are the main ones. The way...

Thanks Crowley16! Finally got it sorted I think i was just missing the point a bit!! Changed the minutes field and the bookingAmount field so it simply calculated [hours]*[rate] which then followed the calculation through wonderfully! :) Just completed the change throughout the system where...

Ok guys im still having loads of probs with this. My access Knowledge is a bit shot to pieces as its a while since i've used it. Here's a few more details about what im trying to do (apologies if I've misunderstood your directions already Crowley16): I have a Project Bookings form. On this...

ok i'll give that a try...so is there no easy way to just change a value in a field if it's negative to positive? I know it's not such good practice was just hoping i wouldnt have to go through my whole system and make loads of changes just me being lazy

Not sure but are you possibly opening the form in Add mode only so it will therefore not allow you to view any previously added records? Have you checked the table view to ensure the details are being submitted from the form? Let us know how you get on

I'm developing a system which is used for calculation of employees hours worked and rates of pay. I currently have a query which is calculating the hours worked between a [StartTime] and [EndTime] primarily using the DateDiff function. This works great most of the time however on some...

I had this problem and found that the pages on my report were slightly too wide. try resizing them slightly and see if this clears the problem. Just worked for me :) Let us know how you get on

Yeah i've just got rid of some code which was changing some of the properties on the form...seems to be working ok now, although the guy im doing the db for has decided he doesnt need that fuction now :S thanks for your help anyways, will remember that code as I can see it coming in handy again...

It's still not working but i think it might be a problem with my code somewhere else. I'll keep checking, thanks for your input so far :)

Hi AceMan. Thanks for your reply. I've tried the code you've given and it seems to work for the very first record when i reset all the info in the database but after that my subform wont allow any entries it jst comes up blank. Any ideas? I've tried getting the form to refresh with the...

Hi. I have a main form in by system [Projects] with a subform which is used to allocate employees to each particular record. On the main bookings form there is a field which states the number of employees required for that project (this is always stated in advance). I now want to know if it's...