Search:

Type: Posts; User: bama4954; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: "subform datasheet view will only allow me to edit when first opened"

    That is my problem, I want to use it to edit and add records on the subform in datasheet view. Like I was saying to Micron, I have one that is emaluated that works but I can't seem to replicate it to...
  2. Re: "subform datasheet view will only allow me to edit when first opened"

    I understand what you are saying. The filter and the query are both correct. The problem is when I link the master and child to say the PK or JobNumber. It only returns one job number or one record....
  3. Re: "subform datasheet view will only allow me to edit when first opened"

    No it is not bound. I think I am going to just throw the towel in and use the regular method of having a main form and sub form done the old fashion way. The whole reason is I did not want to link...
  4. Re: "subform datasheet view will only allow me to edit when first opened"

    This is an Emulated Split Form. The Parent and Child supposedly don't need to be linked. But I have not got it to work with them linked or without.


    Recordset Code:

    Private Sub...
  5. "subform datasheet view will only allow me to edit when first opened"

    I have added a subform to the main form so I could have some controls on the main form and the datasheet view on the subform. When I first open the main form I can edit in the subform datasheet...
  6. Re: SQL statement is give me error 3061 Too few parameters. Expected 1

    I had forgotten to change the bound column and number of columns on cboJobID. I changed that and it worked fine.

    Thank you so much. Asking you questions is making me a better and better in Access!
  7. Re: SQL statement is give me error 3061 Too few parameters. Expected 1

    JobID is a number. 384456
  8. Re: SQL statement is give me error 3061 Too few parameters. Expected 1

    So now I am wanting to change the combo box to search for JobNumber instead of EquipID. Here is the new sql statement. I am getting the same error: Missing Parameter expected 1. What am I doing...
  9. Compare two excel sheets and highlight the cells that are different

    I built an excel workbook that compares two excel sheets and shows what the changes are on a third sheet and also highlights the cells that are different. The only problem is if I add or delete rows...
  10. Re: SQL statement is give me error 3061 Too few parameters. Expected 1

    I finally figured it out. Thanks to everyone that helped me through this. I just had to walk away from it for a bit it just popped into my head what I was doing wrong. It is working great now but I...
  11. Re: SQL statement is give me error 3061 Too few parameters. Expected 1

    Answers to your questions:


    What value does the message box display?
    (The value is a list of Equipment. It shows the equipID when running code)
    What value does the message box display? (1...
  12. Re: SQL statement is give me error 3061 Too few parameters. Expected 1

    Sorry, here is the entire code: First part is the loading of the list box. The second a mod of the building of the three tags.

    Option Compare Database
    Option Explicit
    Public rstTag As Recordset...
  13. Re: SQL statement is give me error 3061 Too few parameters. Expected 1

    I solved that problem with the mismatch error. Now it is populating the list box with the correct records but it is not populating the report but the correct records are displayed on the underlying...
  14. Re: SQL statement is give me error 3061 Too few parameters. Expected 1

    I have it working when I select a piece of equipment from the combo box. But when I add the [Forms]![frmTagReport]![cboEquipNumber] in the grid of the underlying query it gives me a mismatch error. I...
  15. Re: SQL statement is give me error 3061 Too few parameters. Expected 1

    stumac you nailed it!! Thank you so much!
    Question: So if I wanted to change the InputBox to a combo box and load it with the actual Equipment Number, not the ID. What changes would I need to make?...
  16. Re: SQL statement is give me error 3061 Too few parameters. Expected 1

    No leading quote. It is a search box that pops up when the query is executed. However it will not work in VBA. I tried creating a form also with a combo box and got the same error. Too few...
  17. SQL statement is give me error 3061 Too few parameters. Expected 1

    The SQL statement works in the query grid but not in the vba. I want a search box to pop up and I will enter the EquipID into the search box then it will load the correct records into a list box for...
  18. Re: Microsoft Access cannot find the referenced form 'frmTagPrintEquip'

    I got it figured out. I needed to open the form before the SQL runs. Duh... Thanks a lot for you help!
  19. Microsoft Access cannot find the referenced form 'frmTagPrintEquip'

    I am running SQL statement but get the title error. The form is a lookup combo box that is closed until a cmd button opens it.

    strSQL = "SELECT tblTag.TagNumber, tblTag.TagID,...
  20. Re: Show all records of Main form in the subform instead of just one

    welshgasman: I got it to working except I cannot edit the records from the subform. The only thing I have on the main form is a cmd button to add a new record and a search cbo to search for a job...
  21. Re: Show all records of Main form in the subform instead of just one

    I have it linked to TagID on the link Master Field and TagID on the child field. It only shows 1 record, I want it to show all records and if I click in a record in the main form in form view then I...
  22. Show all records of Main form in the subform instead of just one

    I have a main form named "frmTagEntry". The Subform is named "subTagEntry". I want to be able to view all of the records in the subform in datasheet view and have them linked with all of the records...
  23. Replies
    8
    Views
    255

    Re: Count or Sum if three conditions are met

    Bam! That did it tyija1995! I had to mess around to get it working correctly but it worked! Thanks!
  24. Replies
    8
    Views
    255

    Re: Count or Sum if three conditions are met

    That works if the conditions are met on that row. I need it to work if the condition is met on other rows in that range. Example: If I have 1, Repcon, > 0 in row 3 it works. But if I have the same in...
  25. Replies
    8
    Views
    255

    Re: Count or Sum if three conditions are met

    I tried that already. I get 0, or error.
Results 1 to 25 of 35
Page 1 of 2 1 2