Search results

I have a table linked to a sql database, I want to run a query that will only show certain depots but not sure how. i.e weston,london I can run a query that will work if I put in a single depot but I need a query that I can have serveral depots

I have database where users can produce a quote. Each new quote gets a quote number, when users add a item to the quote, they also add a DHR (daily hire rate) The table records the item and adds the quote and the DHR I want to run a query so it shows the quote number and adds all the DHR's for...

I have build a customized main bar can you change the font size of the text on the buttons

On a form I have a button that runs an update query, it updates records between to number on the form, can I get rid of the update message and replace it with "You are updating records between xxx to xxx" click OK and update

I have been asked to build a database to cost up a building job. i.e number of windows, doors, area of plot. Does anybody have any ideas on how to build this, I wanted to user to select each item from a combo box and then I would get added to a list the list then would create a report

I have been asked to produce a running total for companies we deal with. on a form I put two text boxes start and end dates and a listbox that should show all companies with work attached to them between these dates but the result is it shows the same company several times if work has been done...

Is it possible to set the percentage in the report preview before the report opens?

When i delete a record from a sub form on my main form, can you have the message say which record is being deleted i.e are yousure you what to delete item no 123

When i run this code, if the checkbox is not ticked it works. Either the Jobcard is complete and it shows the report or it goes to the control. But if you go to the control then tick it, then press yes for complete nothing happens can you help. If Me.completed.Value = 0 Then If MsgBox("Is...

I have two tables one holds jobcard info the other what stock was used with the jobcard. I have made a query from this and then a report. The report should show all job cards per company per week. It does show this but calculates the hours wrong. Because the two tables are linked when the query...

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

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

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

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

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

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

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

Does anybody know if there are books for learning visual basic for access 97/2000

On my form I have a button which opens a calendar, when the user clicks on a date it puts the date into a text box and close. If the user clciks on the button by accident,I want the user to be able to click anywhere on the form instead and the form will close. I tried OnLostFocus, but it puts...