Recent content by RyDan46

I going to upgrade soon as everthing is getting slow, on the new game, and there not look as good as they could be so its time to spend some hard earned cash. My budget is £500. At the moment i have AMD Athlon XP2500 1833.0 333FSB 512 L2 Cache Barton Asus A7V8X KT400 8x AGP DDR Sound lAN USB...

ok im going to send the database to you. Ive took out most of the customers info just left u with my info and my sisters. The subforum is not how i wont it yet but i will finish it once ive got the print report sorted. Im in the UK just to let u no If ive read ur repsones right ur address is...

hi thanks for the reply this is driving me mad lol pissed off as i write this anyway Question what is the foreign key ? is the the primary key ? If it is ive just come across a problem with adding another job to the same persons record in the subreport, ive had to take the primary key of the...

answer to your questions yes i only used 1 line of code at one time and they both do the job. Yes i want to produce a report using the information from the current enteries i have inputed into the subforum. With the code ive used it does that but, when i wont to repeat the process again for...

the 2 lines of code work they seperate the different reports i have created but they r on sperate pages which is ok but i want to to be able to go to the report and only have the last report on there with out having any prevoius reports. ( so what im trying to do is have the report as a template...

Private Sub cmdpreviewcurrent_Click() strwhere = "[Customer ID] = " & Customer_jobs.[Customer ID] strReportName = "Customer_jobs" DoCmd.OpenReport strReportName, acViewPreview, , strwhere End Sub

Ive created a report using infomation from a subforum in my database. When i want to transfer the information from the subforum i have created a command button which send the info onto the report, which is what i want, BUT when i want a new report and i click the transfer button on the subforum...

Ive created a report using infomation from a subforum in my database. When i want to transfer the information from the subforum i have created a command button which send the info onto the report, which is what i want, BUT when i want a new report and i click the transfer button on the subforum...

Ive created a report using infomation from a subforum in my database. When i want to transfer the information from the subforum i have created a command button which send the info onto the report, which is what i want, BUT when i want a new report and i click the transfer button on the subforum...

Ive created a report using infomation from a subforum in my database. When i want to transfer the information from the subforum i have created a command button which send the info onto the report, which is what i want, BUT when i want a new report and i click the transfer button on the subforum...

No im not getting mixed up When i click my report button it adds the info off the current subfourm (showing) onto the report but if i go to another customer and decide to do another report it adds the info but it has the old info still on it from the last time I need it to be clear so i can...

yeah im sure that the command button is on the subfourm any ideas The info is stored into the service record TABLE and i think thats why its keeping the old data on the RECORD I need a clear button or something like that any ideas

Great It worked BUT When i go onto the report the info which i want to print is there ( good), but when i want to do another report for a customer the old info is still on the report how do i clear it so that the report is clear of any other customers info ?

thanks for the post back i'll go and work at it now and let u no what happens thanks for the advice RyDAn

sorry for the delay, with the weekend and all that My fields on the main forum are contact id title first name last name address 1 and 2 town and postcode phone number and mobile car make model registation Subforum service ID first name last name registation description parts replaced Total...