Search results for query: *

Thats brilliant. Thank you. Just what I was looking for

If it's for a report just use the running sum property on the field

Hi all, Just wondering if anyone knows a quick way to insert a blank record at the start of a bound ms acess drop-down box. I'd rather not use VBA, and don't want a blank record in my table. If anyone has any suggestions? Cheers, Stu

If you have enterprise manager on your computer, hook up the reference to the Microsoft SQLDMO Object Library. I can't give you any specific code, I just know that a guy that worked for us used it in an asp page (vbscript) to automate the backups of our SQL Data. Have a scout around on the...

Use the reply to property... so... cdoMessage.From="My Website" cdoMessage.ReplyTo="myemail@mywebsite.com" cdoMessage.To="mymail@hotmail.com" cdoMessage.Subject=Request.Form("subject") cdoMessage.TextBody= Request.Form("comment")

Could you not use hierarchical recordset? I've used this once before - its tricky to get right but got good results.. have a look at this... http://www.4guysfromrolla.com/webtech/060301-1.shtml and also, try increasing the cachesize of your recordset - to say 100, so instead of making 100...

Sorry mate, I'm going to have to admit defeat on this one. Should work. Nothing looks out of place. Weird

Where is your adodb.connection object being setup?

false420, could you post the entire code?

James, I bow to your superior knowledge - it works nicely. Thanks mate I owe you one.

Hi James, Yeah, essentially that is what I'm trying to achieve - I'm going to have to rebuild your query because I'm using slightly different tables, I only used table1 and table2 to try not to confuse the issue. I'll let you know how I get on. Cheers

Sorry, I'm finding it difficult to explain... I'm almost confusing myself! Erm, right... Table1 |Table2 ~~~~~~ |~~~~~~ ID (PK) ----------> |ID(FK) (..other fields..) |FacilID Table1 has one record: ID=12 Table2 has two records: |---> ID=12, FacilID=23 |--->...

I use literals coz I don't have full access to the servers to setup DSNs and such. I don't know if they're any faster. Sorry I couldn't help mate. I'd love to know the outcome though.

I don't know then mate - I'm beat too. The only other thing I can suggest is check the DSN is set up correctly. Just because it works elsewhere, it doesn't mean it'll work how it should in your environment. I dunno too much about DSN connections because I just use literal connection strings.

Sorry mate, that didn't work either. This is v. frustrating and something that should really work. If I do FacilID=29 AND FacilID=34 nothing comes up which is correct because there isn't a 34 entry for the master record. However, if do FacilID=29 AND FacilID=23, nothing comes up which is wrong...

you connecting to SQL or access?, and could you post the connection string (obviously starring out passwords?)

Hi, I've tried all the joins - INNER, LEFT OUTER, FULL, even CROSS joins, but to no avail. I need to select all the records from TABLE1 in case there are no records in TABLE2.

I'm just thinking if it was a SQL statement problem, you'd get an invalid syntax error or something? So thats why I think the problem lies elsewhere. Maybe you could try setting the cursorlocation of the connection. This sometimes solves my problems. objConnHD.Cursorlocation = 2 'server cursor...

Something to do with your connection string maybe?

have you included your adovbs.inc file. Or failing that, change adOpenKeyset to a 1?