Search results for query: *

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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.