Recent content by cajsoft

Post a copy of my DB? table1 clientid clientname table2 clientid Placementname PlacementAddress PlacementDate Ok, I want to be able to print all records in table 2 relating to table1.. How can I accomplish this on a form (print button) Thanks Craig.

Hi, I have a form with some fields on it.. it's a subform. It has multiple rows. Is there any way I can print the rows as in a report. I Dont know how to pass the subforum values from the form to the printer? I tried the print table macro but it prints the whole table data and not just the...

any ideas?

Hi, Thanks for your input. I agree about network rights/permissions but I have taken this out the equation and tried to open it myself. I have full administrator rights for the network share and when I open the database, the LDB file is not created.. I checked Tools, Options, the database is...

Hi, I have a multi user Access 2000 DB on a network share.. the database has started to give me problems recently. Sometime when the first user access's the database, the LDB file is created.. allowing other users to enter the database too.. but 3 out of 5 times the first person who access the...

thanks for the reply, That has fixed my duplicate surname issue, but the totals are all wrong now.. :(

Hi I'm having a bit of a problem with the sql query below SELECT [Table 1 Personal Details].Surname, Sum([Table 3 Daily Activity].[Public Holiday]) AS [SumOfPublic Holiday], [Table 3 Daily Activity].[Week Commencing], Sum([Table 3 Daily Activity].[Authorised Absence]) AS [SumOfAuthorised...

Hi, I'm struggeling with one part of referencing a subform.. how do you reference a subform that has spaces in the name. ie. I'm trying to do this Me!Funding Subform CJ.Form!Detail.BackColor = 8421504 but it doesnt work any ideas/ thanks CJ

Thanks alot for this.... Great resource.. CJ.

Thanks ever so much on this.. your the best.. and is it just as easy to affect controls on a subform from the main form.. ie. changebackground colour on the subform. p.s. I promise this is the last question.. ;)

Thanks for that.. it worked a treat :) Can I ask another quick question on the same topic.. I have a subform on this form, how can I check the value on a parent form in a subform. I.e. if parentform.Fieldname = 1 then blah blah Thanks CJ

Thanks. I am very new to access programming.. I have worked with VB mainly in the past.. do you mean a FORM.CURRENT event or are you referring to something else?

Hi, I require to be able to check whether or not a yes/no box has been selected, each time the database is navigated.. ie, next record , previous record. I cannot find the event in VB to allow me to perform this function. I see AfterUpdte and beforeUpdate events, but sometimes the data is...