Search results

Cheers Neil.

Hi, got a slight problem. As part of an ASP website I'm trying to insert into two linked tables in an access database using SQL. Standard SQL syntax woiuld be: INSERT ALL INTO tblParent(name, Address) Values ('Dave','Home') INTO tblChild(age, phone) Values ('35','1234567'); Thing is, does...

Hi, got a slight problem. As part of an ASP website I'm trying to insert into two linked tables in an access database using SQL. Standard SQL syntax woiuld be: INSERT ALL INTO tblParent(name, Address) Values ('Dave','Home') INTO tblChild(age, phone) Values ('35','1234567'); Thing is, does...

Found the problem, it lay in my SQL statement. Not only did I need to match the Invoice Number on the form to the Job Details table, but also the Job Details Table Invoice No to the Invoice Table Invoice No.! It's hard working on someone else's stuff! Cheers, Lol

Hi all, been away for some time, got a small problem and hopefully someone can send me in the right direction. I'm working on a colleagues project as part of my HND. he's asked me to look at doing an invoice system for him from his database. I've basically added a button to an existing form and...

Thanks folks, actually used the split function and it works well so far! Cheers, Lol

Hi all, got a curious one. Suppose I have a text box on a form. In that text box I type words which I want to use to perform a search with. The words would be de-limited by say ";" eg> Car;Bus;Bike I need to examine the contents of the text box a character at a time until I find the...

It's definitely an option for future projects but I'm running out of time on this one so I'll go with what I've got. Thanks for your advice so far. Cheers, Lol :D

Hi wayne, never played with Querydefs, but I would like to be able to do this for archival purposes. Am creating a system for a non-computer literate person running a small business (actually it's for my industry project at college) so having the reports saved under different names would be the...

Hi all, am working on something at the minute where I open an existing report, change it's source code to an SQL statement, and print it out. However, I would like to save the report under a new name leaving my original report as a template for next time. I can't find any reference to a SaveAs...

Paul, ignore that message, got it sorted! Thanks for your suggestion! Cheers, Lol :D

Paul, big favour to ask, could you move it and re-post it for me please? In all honesty I haven't had a lot to do with reports and I'm having trouble seeing the wood for the trees at the moment! Am also banging my head on an Excel problem so any small help you can give on this one would be...

Rich, I've managed to strip the database down so it can be posted. The footer I mean is the report footer. Cheers, Lol

I've created the report using exactly the same names as are supplied by the SQL statement and they all appear on the report just fine. The code is actually behind a button on an Access form, again no problems with that. All that is happening when I can get anything to appear in the GrandTotal...

Hi all, got a puzzler. have greated a template report which is opened, the record source changed programmatically to an SQL statement and printed. That all works fine, however I'm just trying to get a simple Sum function to work in the footer and it won't! On the report I have, amongst others...

Thanks Roy, will give it try! I've read so many books of late it's all starting to blur a bit ;) Sometimes I forget the straightforwarsd stuff! Cheers, Lol :D

Hi all, trying to create a recordset through ADO in Access. Got my code behind a button on a form (just at experimental stage). I have replicated the code from that I used in a VB form on a different project but when I try to9 execute the code I just keep getting an eror message with " the...

Pat, I've got to "fess up". This is a friends database and I posted it as a favour as we have been banging our heads all afternoon on it. I found the "BeforeUpdate" technique from previous posts on this site. i tried it and it was acting up (although i find this fromn time to time with Access)...

Pat where I'm coming from is to have a button on a form that when clicked will create the report from scratch witrh a SQL statement as recordsource. I would then like to force a page break programmatically. The report will not be visible at any point, rather it will be printed and closed without...

Hi all, hope someone can be of help with this one. Doing a database for a pet minder and have chosen to use linked forms for a more user friendly interface. The problem I have is that when I enter data on the Animal Details subform relative to an owner it is not updating such that when I examine...