Recent content by EssexRob

i havent unchecked it yet. do i need to uncheck it then browse for an updated file? because i browsed for a dao file but couldn't find one.

I had a search client form. This form used to work fine, so i haven't tocuhed it for a while. Basically what happens is you double click on the client and it clones it to the form. However just a second ago i tested the form again and an error appears "ActiveX component cant create object"...

Thanks for the help. It didnt appear to work, little difficult to explain. txtsearchstring appears on the subform this is = to client_id. The listbox displays a query showing all jobs related to the client. When i click on the next client button the textbox "txtsearchstring" does update to...

I have a private sub on a subform called txtsearchstring_change. The txtsearchstring box is = to the client_id on the main form. Basically when the user clicks on the next record button (which is on the main form) it should update the txtsearchstring_change on the subform and then display the...

I have a form and the information on the form is displayed in a report so the user can print it out. I have placed a command button on the form so that when you press the button you can print the report. I was wondering if there was a way how i could just get it to print of the specific page i...

The listbox is on frm_jobs. This is the subform. The code is being executed from frm_jobs. The subform appears on the frm_clients. Thanks

Thanks for that. If currently this was my code (below) and the subform appears in tabctrl14, page54 and subform is called 'frm_jobs'. Then would anyone be able to help me with what code i would have to add? This is my code: Private Sub List67_DblClick(Cancel As Integer) On Error GoTo...

hey everyone. I have a form, and this form contains a list box which displays data from a query. When you double click on the list result it displays the results on the form. (This is done by some visual basic code) The query which is the source of the list box works so that it displays just...

Just a quick problem. I done the subreports, all working well. However the first record (job1) copies the specification and method on to page2. i.e Page1 Shows: Client name etc. Method: 1 2...

Thanks a lot for the help

Thanks for the help. With my tables i have specification table and method table which join one to many with another table. The reason is all though specifications and method are long memos the same ones tend to be used over and over again. One job could contain at least 3 or 4 method statements...

Thanks, im not sure about this being a normalization problem. The reason its a memo field is because it could be a long statement of text writing, therefore it could not be a text field.

im trying to create a report. basically i need the client name, frequency of job, supervisor and the method and specification of the job. The problem i have is that the method and specification get muddled up (e.g. they either display side by side or display in a format...

Hey all, i have a problem with a search. Its a little confusing: I have a list box which runs a query displaying jobs. I want the list to show just the results of the client thats details are currently on screen. e.g. Client 1 may have 10 different jobs. So the list should show the 10...

On a form i have clients details with a subform displaying jobs related to the clients. The jobs subform is in a tabular format, obviously so i can see all the data of jobs for the client. The job however requires more information (such as specification etc) which i would like to be able to...