Search results

  1. T

    removing leading zeros

    Nevermind. Thought I already had the data type set to Number but didnt. Thanks anyway.
  2. T

    removing leading zeros

    I am importing some data (ex., 00012 and 00001) with a link table. Then I am using an append query to dump the info into a table. How can I make the leading zero's disapper and appear as 12 and 1. I thought about setting up the format to exclude the leading zeros, but where there could be 3...
  3. T

    Page Break????

    Can you add a page break in the report writer? Thanks.
  4. T

    Update Query

    Nevermind, just put True in the update field. Duh.
  5. T

    Update Query

    Ok, I did that and it worked. Now, How to I get a check box to update with an update query? Thanks.
  6. T

    Update Query

    WHen creating an update query, there has to be a value in the Update To field. How do I get that to prompt me for a value. I have tried the standard [Enter Date], that does not prompt me for a value. Thanks.
  7. T

    select all

    Trying to get the most help possible.
  8. T

    Updating several records at once

    Must be too big. Have a way I can send it to you? It is 4MB.
  9. T

    Updating several records at once

    Didnt post. Trying again.
  10. T

    Updating several records at once

    Posted a stripped down version here. Take a look.
  11. T

    Updating several records at once

    same error
  12. T

    select all

    The form is setup like a tabular form coming from a table called Printed Checks. See he screen shot attached.
  13. T

    Updating several records at once

    Now I get an error that says invalid outside procedure. I have tried both putting it on the click properties of the check bow like: Private Sub Check14_Click() Dim db As Database Dim rs As Recordset Dim rCount As Integer Dim cnt As Integer rCount = 0 Set db = CurrentDb Set rs =...
  14. T

    Updating several records at once

    Here is my code. Get a compile error. Dim db As Database Dim rs As Recordset Dim rCount As Integer Dim cnt As Integer rCount = 0 Set db = "Printed Checks"(); Set rs = db.OpenRecordset("Table") rs.MoveLast rCount = rs.RecordCount rs.MoveFirst Do Until rs.EOF rs.Fields("Checkboxfield") =...
  15. T

    Updating several records at once

    Need to update several humdred records at once, would like to have an easy way of doing that witha select all check box or something like that. Look at the attachmentto see wha I have.
  16. T

    select all

    I guess an easier way to explain it is, I need to update multiple records at once. I want a way to do it so that it is GUI and regular user can do it. Hope that helps.
  17. T

    select all

    From a form? I will post a screen shot of what I would like to have. I will give a run down of what is going on. This is for a finance company that s issuing checks. Each check is assigned a check number. We typically send out 600 per week. Most of these checks will not be cashed and have...
  18. T

    select all

    I would like to use a tabular form. Any suggestions on the SQL?
  19. T

    select all

    It only seems to work if I have numerous check boxes within the same record. But, if I have a list of records, it does not work. Any suggestions?
  20. T

    select all

    Have a query based on database that has check boxes and a date field. I would like to be a ble to check all at once, a select all button if you will. I would also like to fill in the date field the same way. Any suggestions? Thanks.
Back
Top Bottom