Search results

ive tried a few things.... i want it to display the results on the current form strWhere = "[EventID] = [EventID]" & Me.Filter Perhaps? i have no idea now

ok, i re-done the code. except now when i preview the report it doesnt show the first record, it shows nothing except the template. im confused! how should the report have been created? based on tables or a query? cos no matter how i create it it only shows the first record (event) and there is...

Private Sub PreviewButton_Click() On Error GoTo Err_PreviewButton_Click Dim stDocName As String stDocName = "EventInvoice" DoCmd.OpenReport stDocName, acPreview Exit_PreviewButton_Click: Exit Sub Err_PreviewButton_Click: MsgBox Err.Description Resume...

been giving it a few tries now...cant get it right....what should it look like now? Private Sub Report_Open(Cancel As Integer) Dim strWhere As String strWhere = "[EventID] = " & Me.Filter DoCmd.OpenForm "frmEditEvent", strWhere DoCmd.Close acForm, "frmEditEvent" End Sub this doesnt work...

im not too sure to be honest...i just made a query that uses all the fields in my form and based my report of that. i understand about using the where clause but im not sure how the code should look. what is it for criteria? is it the filter? thanks for your help

i can get the first record though. its just i want it to display the details from the open form only and NOT the first record in the table. ive tried looking in the help section and tried a different control source etc. no luck with it, any other ideas? thanks

no worries, u gave the answer in another post, sorry if the two were related, and thanks for your help

hi, i have a form that i use to enter data. once data is entered i want it to be printed as an invoice (report) i have created the report template called EventInvoice. how do i get the data from the form onto the report to preview/print? i have managed to do it for the first record but it...

hi, i have a form that i use to enter data. once data is entered i want it to be printed as an invoice (report) i have created the report template called EventInvoice. how do i get the data from the form onto the report to preview/print? i have managed to do it for the first record but it...

spot on!!! perfecctt! thank you soo much

how do i get it to find a record?

Hi, When i try to select a record from a combo box this message appears in the bottom of the screen : Control Can't Be Edit; it's bound to AutoNumber field 'EventID' It will not let me choose a PK/ID. what am i doing wrong or what setting needs to be changed? thanks

no offense but i have no idea what you just said...im not that advanced yet... :(

Private Sub List30_DblClick(Cancel As Integer) Dim rs As Object DoCmd.OpenForm "frmEditEvent" Forms!frmEditEvent.[EventID] = Me.List30.Column(0) DoCmd.Close acForm, "frmEventSearch" End Sub

hi, ive got a search form with a list box in it. when i dbl click it opens a form with that record. it works fine however i always get a run-time error '2448' message saying that i can't assign a value to this object. does this mean i cant change the PK or something. i can see that the form has...

Hi people, i have a search form with a list box. it is based on a query. it works fine for a different project but in this project i need to search for either a perfect match for an ID, or a 'like' match for description, or a like match for the customer. i want the list box to have the...

hi guys, i need to make an events/service purchase database. I have attached an image from excel of what the main form should look like. There is a list of services from the events planner that have a charge depending on what the service is. Each event can have many services. Each customer can...

ye i have but i need something in between. the microsoft templates are very good but are too complex for my task. i need an inventory control and an orders management database. any other ideas? thanks for your help

hi guys, i have searched loads of threads to gather information and some ideas but i still can't quite find what im looking for. i need a stock/"inventory" control database. Something that records stock coming in, stock going out, who buys stock and the current stock situation. I'm not sure...

i wanted a db similar to the Microsoft Example Database "Orders management database". It shows the customer details followed by what they have bought