Search results

I'm going to go with the method I suggested to get around this problem which should solve the problem but I just wondered if there was a better way as building 5 queries seems a bit long winded.

Hi, Can anyone help me with this? I have 2 tables: table 1 (detailed jobchecks) Region - CheckID - CheckDate table 2 (summarised job totals by weekending date) Region - TotalJobs - WeekEndingDate I want to create a report that shows for a given...

I've being dabbling in vba programming for years now and I've always used selects and activates and it's been fine. I liked the idea of stepping through code and seeing things happening on the screen. But as I've got a little bit more confident with my programming I find I don't need to do this...

Thanks for that. I'll give it a go. P

I've read a number of post stating that in vba selecting cells/ranges before performing actions on them is bad programming practice. But what's the alternative. I'm trying to do what i think is a very simple macro - here's a snippet: Sheets("Performance2").Select Range("B6:E10").Select...

I've been wracking my brain trying to solve this problem: I've got a report where I want to show a count of jobs raised for last week but I want to compare it to the same week Last Year. I've done a bit of searching and the nearest I can get is this: ({table.JobRaisedDate} in...

If you use vertical guidelines and align your fields to this it will help keeping your data in the right columns in Excel.

Thanks Kempes, I'll give this a go. P

Hi, I'm just wondering if there's a way to display a message when a chart has no underlying data. At the moment what happens is that, where the chart should be there's just white space. In this instance the fact that there is no data is significant. many thanks, Peter

Hi, I'm working on a Access 2003 adp that's linked to a SQL Server 2000 database. I'm trying to use BULK INSERT to import some data from a text file into a table but I'm getting an error message: Cannot perform bulk insert. Invalid collation name for source column 13 in format file...

Just wondering, has anyone done this, changed an access data project back to a mdb. If so could you tell me is there a lot involved. Could you give me a vague outline of the steps involved?

I've just contacted the company IT guy who assures me that he can dial in. He got me to telnet to one of the ordinary connections(?) which worked but the advanced port didn't work. So apparently it's down to either the isp that I'm using blocking me or some setting on my own pc. I've got norton...

Thanks for the replies. Adam: No the ping doesn't work. I get 'request timed out'. It does give me a proper IP address which I didn't notice before so I pinged this as well with the same result. David: I'll find out about the VPN Tunnels and get back to you. I was able to dial in no problem for...

I'm having a problem with Remote Desktop Connection. I used to be able to dial in a company I do work for but recently I can't. I'm getting the error message "The client could not connect to the remote computer" I'm using windows xp. I've tried turning my firewall off and turning off Norton...

I would recommend that you stick to using a MDB rather than and ADP. You can use the upsizing wizard to move your tables to SQL Server. Some articles I found useful (though they are not tutorials as such) were: http://www.granite.ab.ca/Access/sqlserverupsizing.htm...

Hi, I'm working on an ADP on Access 2003 linked to SQL Server 2000. I'm having a problem with a sub-form. There are several total's columns in this that do not update when the results are filtered. I did a lot of searching on this issue and saw one site (which I now can't find anymore) that...

I didn't get any replies from this so I'm just re-posting to see if anyone can assist.

Hi, I'm working on an ADP on Access 2003 linked to SQL Server 2000. I'm having a problem with a sub-form. There are several total's columns in this that do not update when the results are filtered. I did a lot of searching on this issue and saw one site (which I now can't find anymore) that...

In the course of doing an upsizing project with Access 2003 to SQL Server 2000 I have seen lots of questions related to ADP's and upsizing. I think this could do with it's own forum. There seems to be more and more companies going down the upsizing route.

Bob, just wondering if you can help me with what is a bit of a continuation from the original question. I've been looking all over the internet for the answer to this and the one solution I did come across didn't make sense to me but I can't find where I found it originally anyway. I'm working...