Search results for query: *

Hi all, I hope you can give me some advice. I have a problem with a form and subform. The main form contains customer details, such as bank details and the total cost of purchases made by the customer. The subform records each payment. The subform has a field for total, which is what is...

Hi, I'm new to this list and wondered if anyone could advise me regarding differing renderings of the same webpage in IE6, Netscape 7.01 and Netscape 4.6. I have inherited a website and am carrying some web authoring using Macromedia Contribute (although I plan to 'get' the site using...

Hi, I have a query regarding a mailing list I have been asked to produce. My client has a database which contains names and addresses of customers interested in my client's training service. Some of these customers go on to register for a training course, some do not. My client wants to send...

Hi, I am attempting to write some Access Basic code with little progress. I wonder if anyone could advise. I have a main form and a subform. The first form is called PaymentAmend and contains client bank details and the outstanding balance for the client. The subform is called PaymentTendered...

Hi, I am attempting to write some Access Basic code with little progress. I wonder if anyone could advise. I have a main form and a subform. The first form is called PaymentAmend and contains client bank details and the outstanding balance for the client. The subform is called PaymentTendered...

Hmmm! That's a moot point at the moment. I'm having trouble getting the mailmerge function to work in Access. I go to tools; export to word; select the document, then an message appears telling me there is no data (or words to that effect). I'm going to have to spend a bit longer figuring out...

Hi Pwise, I have done what you said and it worked. Thank you! This leaves me with two separate operations: one to make the mailshot; one to update the sentmailings table. I am wondering if it might be possible to carry out both with one action. What do you think? Maisie

Hi Pwise, thanks for the advice. My problem is I am having trouble finding out how to create an append query from a select query in the books that I have. Can you advise? Thanks Marta

Hi, I have a database with a list of clients who I wish to send mail, and then keep brief details of the type of mail, date sent etc... What I have at the moment is a client table and mailshot table. The client table has name address etc... The mailshot table holds the type of mailshot; leaflet...

Hi, I wonder if anyone could help me. I am developing an online quiz using Ultradev. I have a quiz page which dynamically displays a question and 4 possible answers; this data comes from a table named QuestionTable. On the same page is an insert form, which inserts ticky boxes containing the...

Hi, I wonder if anyone could help me. I am developing an online quiz. I have a quiz page which dynamically displays a question and 4 possible answers; this data comes from a table named QuestionTable. On the same page is an insert form, which inserts ticky boxes containing the choice of the...

Hi Thank you all for your helpful suggestions. THe problem with the autonumber suggestion is that perhaps as a consequence of indexing with no repeats, very few of my tables begin at 1. I am entering the data from an asp form. I thought that if I entered to data into a query which has an...

Hi I have tried the Access SQL forum, but to no avail so I'm trying this forum, if I'm in the wrong place I do aplogise. I am working on a quiz database and one of my tables holds a question and its related answers, I need a method by which I can number questions sequentially as they are...

Hi I am working on a quiz database with tables which hold questions answers and results. I have a table which holds a question and its related answers and am using an autonumber field as its primary key. However I need a method by which I can number questions sequentially as they are entered...

I have tried to alter the manner in which the data is sent to the database, by using the scripting dictionary. However I am getting confused by the code written by Ultradev. I have included the code below <%@LANGUAGE=&quot;VBSCRIPT&quot;%> <!--#include file=&quot;../Connections/CNDS.asp&quot...

Hello, I am using Ultradev to develop an on-line quiz. There are two tables involved in the quiz itself: One containing the questions and answers, and one for storing the response of the quiz taker, together with their unique id. I have a page with navigation bars at the bottom, displaying a...

The comparison on boolean fields. I actually had more than one pair of fields to compare and have ended up using the switch function, and it works. Yay! Thank you very much for your help Regards Marta

Thanks for the expression, I must be doing something wrong, because the query leaves out records where both fields are true, and on the table afterwards the matching fields have been awarded '0'. I am wondering if I have put the expression into the wrong place, in addition I tend to write...

Hi, I hope someone can help me. I am using Access and writing query based upon two tables. I want to compare a boolean field from each table, the two fields are set to true/false. If both fields are true then I want to add 1 to a calculated field called total, or something similar. If the fields...