Search results

I have a combo box on a form that selects all workers i need to select workers with a certain boss id no. the boss id no. is held on another open form in an unbound box called bossid I have the select from right but when i specify where workers.bossid = [form_who]![bossid] it doesnt work. is...

I DID IT!! Hey forny forny forny!! I blooming did it! Cheers bud i set the recordset up then used the with end with commands to use the recordset to add a new record, add the data and update!! top geezer in my eyes matey righty dokey then skip i have to go and finish it if i need more...

I have just tried recordset I have read all the help files and have added code that updates each field for each record to add. How do i for instance add field1, field2 and field3 from table a to field4, field5 and field6 in tableb using addnew? This isnt very easy!! Once I have learnt it...

i think so I think i shall create the amounts within tableb when initially added to tablea. Then only get table b form to show amounts due to date. How can i get a query to show where a date is todays date and less than todays date? Is there a command to take data from a query and paste it to...

still need help on the above subject s

ok righty dokey then, tablea has another field called payment frequency choices being pcm or weekly when you first add the amount due it sets the first date. I was going to set it up to add either 7 or 30 days to the due date each time it posts the amount to tableb ready for the next payment.

yep Thats pretty much it. I want amounts to be posted in tableb when the amount due date in tablea = todays date for instance. I have a query that produces the amounts due according to date from tablea already. I do have the one to many relationship already set up. Amounts due in table a are...

bit more info Cheers for your reply bud. The way the db works is tablea holds amounts due after an agreement. tableb holds transactions of when those amounts are paid along with some other info. I want to create new 'transactions' within tableb using the amounts from my tablea query when...

I have two tables: tablea and tableb tablea has two fields: amountdue and duedate tableb has three fields: amountdue, amountpaid and paiddate I have a query that looks in tablea and selects the records that have a due date of the current day which works. I have a tasks form with the query as...

Brilliant! Cheers Travis it worked a treat! It was just specifying a field in a form rather than table and i had done it before but just couldnt remember for love nor money! Cheers pal! J

Can anyone tell me what needs to be added into this to work please? Table wanting to update is worker, the field within worker is applicant. It finds it but the where claus of the sql isnt working. I want to find the record where worker.name field = a field on a form called wdetails (the field...

Yep that bit i have no problem with its the best way to go about taking that information from the query and then dropping it into a transaction table.

Hey folks gurus and fellow programmers long time no post! Nice new setup! I need some help for a system which i am working on. I want to be able to search a table with fields [property name] [rent due date] and [rent amount] when the rent due date the current date i want it to take that...

Hiya I think i would do this by creating a form that looks like the msg box, then add your buttons your self. then rather then in vb type msgbox, open the form. When the user clicks the button it does what you want it to do and closes your 'form msgbox' Other than that im not sure if you can...

I am trying to make a db that has an outlook schedule type look to it. I need to be able to asign tasks to it as well. Any ideas??? I used the calendar add in from access and can use the value form it for the user to select a date for the task now how to fit that in to a schedule. P.S. Rich...

Yes i created the resource scheduling one. It didnt really fit in to how i need the schedule. You know what outlook tasks and calendar sort of thingy looks like?? thats the sort of thing i need! What do you think my friend?? Am i stuffed!?!?

I have the same problem. I have a db with properties and one property can have up to 4 tenants. so i have added 4 fields to the main property table each with a lookup to its own lookup table. then on the form you use the combo to select a tenant then open the tenant detil form linking by tenant...

How can i make a schedule in access 2000. I want to be able to show times in a day and assign many tasks to a time (and day) Help would be greatly appreciated. Thank you Chris