Search results

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

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

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

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

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

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

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

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

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") &...

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

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

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

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

Hi all, thanks for the help on previous problem, however my course leader has thrown another spanner in the works. I was previously doing a database in Access to simulate a barcode POS system. Because I can't get my hands on a scanner he now wants me to do a front end in VB and connect to my...

Hi, as part of my ongoing nightmare dbase I want to output data from a query to Excel. This is straightforward enough, however, I want to plot a graph on my spreadsheet in Excel from the exported data. If I use the Do.Cmd acOutputTo method it any chart I have created and any subsequent sheets I...

Hi all, hope someone can point out the schoolboy error I'm probably making here :o I have a button on a form, formA, when I click this button it opens a new form, form B. Data entered on form B is displayed as a summary on form A in continuous sheet style. Form B has a button it so that when...

Hi, got a small problem. As part of a database I have to do for a booking system for a conference centre I have a form (frmSummary) that displays the results of a query (qryT101Book), the query itself displays all the bookings for a certain room from today onwards. This form only displays a...

Hi, hope someone can be of help here please? First, apologies for kength of post. I have a database which is to replicate an EPOS, in particular the barcode input (I plan to buy a scanner for this part later). The tables are as follows: Product: Barcode (Key), Product ID (Indexed to not allow...