Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jeffwest2

    I am trying to populate a text box

    Its ok, have dealt with this in a different way and works. Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued existence, if you have any plans about seeing tomorrow — there's one thing you never — ever, put in a trap. … Me.
  2. jeffwest2

    I am trying to populate a text box

    I am trying to populate a text box with multiple entries from a table that is not linked to my main form. I have a combo box that is linked to a query that just brings back the grouping of the search field (i.e. I have multiple items that are the same and have the same type Address, Id and...
  3. jeffwest2

    Access update VBA

    You are right, I did do a little bit of lazy coding with this, some of it was due to time constraints(not really an excuse) and some was trying to get things working different ways and not going back and correcting them but leaving it. Thankfully I do have a little time to tidy things up now...
  4. jeffwest2

    Access update VBA

    Thanks for the additional stuff, alot of this was trying to get things working quickly as I had little time to put something in place, I now have a bit of time to go back and tidy it up, so this gives me a bit more to think about, Didn't anyone ever tell you? There's one thing you never put in...
  5. jeffwest2

    Access update VBA

    3 updates was only because i couldn't get them to work originally, had a just got mixed up so included here as it was. Thanks for the code, it seems to work again now, so hopefully i will be able to move this on a bit. Didn't anyone ever tell you? There's one thing you never put in a trap — if...
  6. jeffwest2

    Access update VBA

    On the close of a form I have a series of codes that 'should' update a table with in the database with data from the fields on the form, the issue i have is that the update sql doesn't seem to work. Code is below, the highlighted bit is what doesn't seem to want to work. Private Sub...
  7. jeffwest2

    Query Running Show progress

    Primary keys are fine, I have a customer controlled Id that I need to be matching against, so PK's aren't too much of a problem, but thanks anyway. New version went live yesterday and seems to work fine. Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart...
  8. jeffwest2

    View running Query Details

    Thanks for anyone that looked at this, I have done it another way which is running a lot better. Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued existence, if you have any plans about seeing tomorrow — there's one thing you...
  9. jeffwest2

    Query Running Show progress

    Andy Thanks for the logic check, think I was trying to do too much with a program thathas got a bit out of control, rethinking it has made it run quicker, thanks for that. Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued...
  10. jeffwest2

    Query Running Show progress

    I have a an Access 2007 program that imports in some data, then runs a query to check for duplicates and removes the new records where duplicates exists, the issue is this runs really slowly. I have tried to change this to VBA SQL, but it runs just as slowly, so, my next idea was to try and...
  11. jeffwest2

    View running Query Details

    I have a an Access 2007 program that imports in some data, then runs a query to check for duplicates and removes the new records where duplicates exists, the issue is this runs really slowly. I have tried to change this to VBA SQL, but it runs just as slowly, so, my next idea was to try and...
  12. jeffwest2

    Percent of a fixed number

    This just doesn't seem to work, I can not seem to get it to create the additional column is there asetting somewhere that you have ticked/unticked that also shows this. I have created the most basic crosstab I could, but it still isn't working :-( Didn't anyone ever tell you? There's one thing...
  13. jeffwest2

    Percent of a fixed number

    Of Course, CRXI doesn't have the bits you were n about, so I have downloaded a demo for CR 2011, however, when I click on child element it doesn't add the 0 column to the left, which is clearly causing an issue :-( Didn't anyone ever tell you? There's one thing you never put in a trap — if...
  14. jeffwest2

    Percent of a fixed number

    Thanks for the responses, I have CRXI so hopefully I can test this this morning and see what happens. Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued existence, if you have any plans about seeing tomorrow — there's one thing...
  15. jeffwest2

    Percent of a fixed number

    This what my crosstab looks like, the % at the end needs to be a % of 24 not of the total for the hour which it is now Hope this helps. Accepted Accepted In Store Appointment Appointment in store Callback Contacting Declined UnContactable Withdrawn Wrong Number Total 9.00...
  16. jeffwest2

    Percent of a fixed number

    Thanks for giving me another code to look at, however this is still showing as a % of the row/column and not a % of 24 which is my issue/ Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued existence, if you have any plans about...
  17. jeffwest2

    Percent of a fixed number

    I have some agents that need to call a minimum of 24 records per hour, I have a crosstab report that will show me those records, what I need to do is work out what percentage of the minmum calls that they need to do have they actually done, e.g. I know that 13 calls is 54.16% of 24, how do I do...
  18. jeffwest2

    Monday as First day of the week

    Thanks guys, that really helped. Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued existence, if you have any plans about seeing tomorrow — there's one thing you never — ever, put in a trap. … Me.
  19. jeffwest2

    Monday as First day of the week

    I can see some solutions within this, but I can't get any of them to work, so here goes. I have to create a crosstab report that lists the days of the week at the top, I want to make Monday as the first day of the week, this is what I have at the moment on my crosstab column DayOfWeek...
  20. jeffwest2

    Import CSV file into table omitting first 4 rows

    Cheers Andrzejek, that worked a treat, much appreciated. Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued existence, if you have any plans about seeing tomorrow — there's one thing you never — ever, put in a trap. … Me.

Part and Inventory Search

Back
Top