Search results

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

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

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

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

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

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

I am designing my first database using visual basic, althought i have good previous Access Experience however this rarely involved using visual basic. I have just pulled some data from my tbl_job. which links client_id, supervisor_id in order to create a job. (Code shown below): Option Compare...