Search results

Hi, going to be using code to create a report in Access as part of a system I'm developing for a totally non computer literate person. is there any code I can use to force a page break upon meeting certain conditions? This code would reside in the form containing the controls to create the...

Thanks Roy! I was getting mixed up with an SQL dbase and an Access one. Seeing as I'm just learning SQL, and the VB I'm doing is new territory as well, it ain't too bad ;) Thanks for your help, Lol :D

Hi all, got a puzzler. The code below inserts records into a connected Access table. problem is, when I look at the table, the date is 1899! SQL = "Insert Into tblTransaction (TransactionNumber,UserID,SellDate) Values (" & intTransaction & "," & intUser & "," & Format(Now, "Short Date") &...

Roy, your'e the man! It worked nicely thankyou. Didn't appreciate that you had to assign the result to a recordset to get to the value. Thanks, Lol

Thanks Roy will give it a try and let you know! Cheers, Lol :D

Here we go! Option Explicit Public cnABOF As ADODB.Connection ' set connection Public strConnection As String ' declare connection string Public rsListData As ADODB.Recordset Public rsDetails As ADODB.Recordset Public rsTransaction As ADODB.Recordset Public SQL As String ' holds SQL statement to...

Sory Roy, my bad. Here is the database and a notepad document with the module code in it. Cheers, Lol

Hi, got a bit of a headscratcher. In attached folder is a database and VB6 project. The connection is made through ADO and works fine. I have a problem with finding if a record already exists in tblDetails. I've set up a little test routine under Command Button 2 that assigns values to...

Cheers Wayne, I discovered vbTab last night and that does a fair job providing the strings are of a fairly consistent length. I'll try changing font and see if that makes any improvement. Thanks, Lol :D

Hi all, posted this here as I'm not sure where else to put it! In VB6 I have a listbox on a form. I'm using this primarily to display the contents of a recordset in rows. The problem I have is the alignment of the "columns" in the rows. Is there anyway to set the spacing of the "columns"? At the...

Thanks Jings00 that works brilliant. Funny thing is that's one of the permutations I tried and it didn't work! I think I know the reason, and it has a lot of fact to back it up. This is one of the files I have opened at college on the network. We have so many odd occurrences with software at...

Hi Rich, did Save As Previous Version. here's the offending article. Jings00 I altered to what you said and it won't work for me! Somethings afoot here! Ignore the db1 name, it's the same dbase. Lol :D

Don't know how to save in 97 Rich. Glad to upload it or even e-mail it to you if you can tell me how. Using the same tables I've just recreated the basic form/subform layout without any of the requery stuff that exists in the original. i was still getting the #Error message. Let me know about...

Done it Rich. Put the unbound control in the footer, put it's control source =Sum([SubTotal)]. Put the control source of the text box on the main form to refer to the control on the subform footer and I just keep getting "#Name". I've tried all ways with the permutations to do this and it should...

ahh but I have used this technique before in a dbase and it worked. It is even suggested as a solution in the Forms forums when others have asked the question. I'm really at a loss, having followed the technique verbatim, or so I thought, as to why it doesn't work! C'mon experts, I've lost 3...

Thanks Giuseppe but I think I'm just missing something simple here. i used the same technique on a previous dbase without a hitch :rolleyes: Perhaps someone can point the way? Please!! Lol :D

Can't believe I'm posting this :o Have tried every permutation I can find, including the previous requestes from other members, but it still won't work. I have a subform on whose footer I've placed a text box to sum a valu, [SubTotal]. On the main form I've set the control source of a text box...

Hi all, head a bit sore from continual banging head against monitor :( Could someone have a look at the attached VB project and database? it's just a proving ground to get the principals of adding records to master/child tables. In the form load event I call sub routines to open connection and...

Cheers Roy, will give it a try! Lol :D

Hi all, got a problem with the syntax for the Find method in an ADO recordset object. Assuming my recordset is called rsTrial and I want to find a field called Total where Total equals a variable, intTotal. I'm having problems getting the syntax straight. can someone sort me out please? :o...