Search results

Yes, I found that if I put Control Source=[searchresult].[ListCount]-1 & " Records Found." it works

sorry that should value equals zero

I have a form with subforms and I produce a report from them, I don't use sub-reports the report is based on a query. If one of the subforms is not used by the user it creates an error on the report because it can't calculate the total. I have seem people say about HasData but I can't find...

It gave me an error this property is read-only and can not be set

the datbase is to big to attach, but this is what I use to search Me.searchresult.RowSource = "SELECT Bookrecord.RecordNo, Bookrecord.Title, Bookrecord.Edition FROM Bookrecord WHERE (((Bookrecord.Title) Like '*' & [Forms]![frmsearch]![Title] & '*'))ORDER BY Bookrecord.Title;" Is there a...

I have a search form, there are several text boxes and a listbox, the user enters in a title of a book and clicks search, the code behind the search is a sql query, it populates the listbox with the query result. How can I put a text box on the form that will show how many results where found

Sorry about that hear is the database

I have build a electronic library for my company. But when I go to the search form a enter text for it to search by, either whole text or part text. It sometimes finds all the records matching the text or sometimes only shows some of the results. I have attached to database, if somebody could...

On my main form I have two subforms, one for parts and one for labour. When I select what parts the customers wants and what type of labour they require and how many hours. I can click produce invoice report and that works fine. But if I don't select either parts or labour the report shows...

How would it produce a new record? and show in the form. I have not used append query so I am not sure how it works

In access there is a wizard that lets you duplicate records, on my form I have a subform as well is it possible to duplicate both. The main form contains customers details the subform contains a quote for a job, as jobs can be simular I wanted to copy the record so I could just change the odd...

QUOTE Hello again, I have come back to this project but still can't get my head around it. I can see how you attach the quote ID but not the customer ID. Also when you select a customer from the combo box it treats it is a new record. I also noticed that the customers have a text for ID, is it...

quotes Hello again, I have come back to this project but I still do not understand how Northwind works. I can not see why the subform is a query, and how if you pick a customer froma list it will generate a new autonumber when the list is pulling info from a table. How does the products sold...

I have tried this and could be a good solution, there are a couple of points if you help. I need four search fields, so I would put four combo boxes on the form, is there a way I could put a button on the form to clear whatever to combobox was showing from the last search so they can start a new...

I have posted a simular question before but not alot of response. so I rewording it. I have a listbox on a form in the header, when the user clicks on an item it finds and shows the record in the form details. the list contains alot of book titles. I want to put a textbox on the form so if the...

Thanks for your reply but it is not quite what I wanted. The form they want is basic on some old software they used, so the user can enter the book in a text box and click serach, and it will highlight the book in the list and show the record

I have build a form based on a table, I used the wizard to create a list box that when you select a record it fills in the fields on the form. I wanted to put a text box on the form so users can put in a book title and click search, it would hightlight the correct record in the listbox and find...

It would good if when the user first runs the database it prompts for a username or open a form for the user to fillin. Is it possible for a macro to check to see if there is a username so the form would not open again if there was a name in the table?

I don't have security, but the idea is that each salesperson, would have there own copy of the database on there laptop, so there would not be any other user enteredjust there own name. I just wanted the reports to automatically pull the data from the Usertable and put it into a textbox on the...

I am building a database for salespersons, each salesperson would have the database on there laptop. When they run the database they can enter there name which is stored in a table. I would like all reports to put there name on them, how do I get the report to pull the username from the table