Search results

I have build a search form, the user types is a file next and the results are shown in a listbox, the listbox is attached to a query. I want to put a button on the form so they can search again, the button would clear the listbox of the previous results. What would be the vb code for this?

I have build a search form. On it are six textboxes each for each field of a record, below is a listbox with a query attached, if the user enters text into one of the fields the listbox will show results. I want to have a button so the user can search again, the button would clear all the text...

I have a listbox on a form which connected to a query, this shows pay no, first name, last name. Is they a way to get a query to llok at the second and third colum. If I put in forms![searchform]![mylistbox] it only shows the first column.

I would like to define a week from Monday to Friday. or would it be easier to have then week starting Sunday ending Saturday How would I does this

I have a form with a calendar on, if the user selects a date, a list box with a query attach will show all personnal that have booked holidays from that date plus two weeks. Is there a function that will calculate the week instead. i.e if someone asks for the 23/10/02 off then it would show me...

I am trying to produce a yearly report to show all the holidays people have taken. I design the report to show thew person name then group by month and show all holidays for that month. i.e Joe Bloggs December 1/12/02 to 2/12/02 12/12/02 to 14/12/02 When I preview the report the months are...

I am trying to get a query to show records from the 1/1/02 to 31/12/02, so the user can see what holidays they have had ,but have the year set to the current year. I used Field Year: Format([Start date],"yyyy") Criteria Format([now()],"yyyy") The query asks for a input for now(), what is...

I have records of persons holidays they have taken and sick days they have taken. The records are enter like Start date 12/2/02 End date 14/2/02 How can a get a query to show results by entering just the year. I wanted to put a combo box on a form so the user would choose from the list and the...

I have build a database so the company can enter peoples holidays, they can select each person and a report will show all there holidays taken. I want to be able to select a person and a year, so the report will show holidays for that particular year. Can anybody help

I have found the answer Thanks

On a form I designed the user puts in materials & labour the format is currency. When I put in £25.45 in materials and then tab to the next box, the materials text box keeps rounding my numbers up i.e £25.00 how can I stop this

I tried a similar question in gerneral bur no replys.I have a login form where the user puts there username and password and security is already set, the vb code runs a query and if the query matches the user input it open the main menu. I would like to design a form with check boxes relating to...

When I tried to insert The ActiveX control, it gave a message "you do not have a license" for this. Any ideas why?

I put this topic in General but no response. I have a form where the user can put a photo on,they right click and insert object etc.. is it possible to attach some code to a button that will automate this process, so the user clicks on the button and the file that contains the photos opens they...

I have a form where a user can select an item from a listbox and press search, it then opens that record. Is there a code to check if the user has selected from the list. If they just press search without selecting from the list I get an error message

What is the RTF control?

You can use the code DoCmd.SendObject acSendReport, "rptResult", acFormatRTF, attach the code to a button. change acSendReport to whatever you are e-mailing i.e form,table .... and the name of what you are sending. If you leave out the format, it will bring a box up so you can choose what...

The code I used was a query code. [Lastname]is a field in the listbox, [cboname] is the listbox name Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmcontactview" stLinkCriteria = "[LastName]=" & "'" & Me![cboname] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria

Thanks, did not think of that

Can anybody help me to use a Boolean variable. I have two buttons on a form one for editing and the other for read-only. Instead of making two forms with the different property set t read-onlt or edit I wanted to use the Boolean. If a user clicked on edit the Boolean would be true, and the form...