Search results

  1. J

    Form data -> report -> Help!!

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

    Form data -> report -> Help!!

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

    Form data -> report -> Help!!

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

    Form data -> report -> Help!!

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

    Form data -> report -> Help!!

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

    Form data -> report -> 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
  7. J

    Control Can't Be Edit; it's bound to AutoNumber field 'EventID'

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

    Form data -> report -> 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...
  9. J

    Form data -> report -> 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...
  10. J

    Run-time error '2448'

    spot on!!! perfecctt! thank you soo much
  11. J

    Control Can't Be Edit; it's bound to AutoNumber field 'EventID'

    how do i get it to find a record?
  12. J

    Control Can't Be Edit; it's bound to AutoNumber field 'EventID'

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

    Run-time error '2448'

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

    Run-time error '2448'

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

    Run-time error '2448'

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

    Search Form Based On Query

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

    Event/service Purchase Database

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

    Stock Control Database

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

    Stock Control Database

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

    Stock and Sales Form/Sub/Append!?? Help

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