Search results

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...

Yeah that worked, thanx alot

I have form on my database that runs a search query. Basically what should happen is the user types in what they want to search in a text box and the result is displayed in a list box. This currently works but only if the spelling of the search is entered 100% accurately. e.g. if im searching...

I have just created a splash screen for my database. I was wondering if anyone knows anything else that is good to add to this form which would make it look pretty impressive? I would like to add a loading bar (Similar to the one that appears at the bottom the page on internet explorer). Does...

Private Sub UpdateRecords() txtemployee.SetFocus rs.Fields.Item("Employee_Name") = txtEmployeeName.Text txtAddress.SetFocus rs.Fields.Item("Address") = txtAddress.Text txtTown.SetFocus rs.Fields.Item("Town") = txtTown.Text txtCounty.SetFocus rs.Fields.Item("County") = txtCounty.Text...

I have a minor problem with a subform First of the all, the main form shows employees details and the sub form shows the work scheduled for that employee. I have binded the fields together. It displays the first employees workschedule correctly in the sub form, however the problem is when i...