Search Result

Hi all

Having had such great help from you guys in the past I'm hoping that someone could shed some light on this issue I've been unable to solve.

I have diluted my database down to the objects nescessary to establish the problem which I believe is a relationship/key issue. For your information though, the relationship should be one-to-one.

From the StudentInfo form you can open up the MedicalForm for...

This is a copy of an old post in here, but (presumably because it is so old) I cannot post an answer to, so I am re-creating it....

=============== =============== ==========


Seems like a $rs-> EOF messes up the record set ?
(using php 4.2.2 and MSSQL database)
I try to read the ntext-field "body".



THIS WORKS !!

...

I am completely new to access programming let alone VB. But I got pretty far with some help from the main programmer.. However I'm trying to introduce a new feature to the database which is basically this:

1) Make selection of "Symptom" from the "Patient" table via Combo box on the form.

2) Click a button on the form to open the report "Patient PD Report" showing details of all recorded...

Today I've been trying out a personal project I have been interested in for a while. MS Access 2000.

I get a daily list of currency exchange rates via email, but it's a bit of a pain to go through them and extract the few I need, and I don't keep up on it very well! However, I did determine that the actual message files are nice and readable as plain text (I still use Eudora 7). So I thought it might be possible to write a bit of VBA...

How do,

I have a form that outputs addresses in a format that can be printed on to 3x7 label paper for envelopes.

What I want is a way to enter blank (or " ") rows to the query result where the user specifies so no label is printed in that particular place.

I am aware of the problems of inserting blank records to tables. I say this as the other forums I have searched all reply with disbelief...

Im a rookie.

I have am unbound combo box populated with values (rowsource) from a query which has 2 tables in it. Each table has its own ID, but both are included in the combo box (info3). Sometimes the combobox has ID values from Table A, but the corresponding ID value in table B is NULL. The bound column is the ID from B, because I use it to populate text boxes, by going to that record using:

strCriteria = "[ID]...

Hi, I've got an XML file with one <title> and one <link> attribute.
What I want to do is implement a hyperlink with the name of the <title> element and whose NavigateUrl property is set to the <link> element.

For an unusual reason, the hyperlink never appears but, when debugged, both items from the XML file are appended to the hyperlink. What have I done wrong?

Cheers,
Matt
...

I am needing to SELECT all fields/records from a large table (96 columns, over 100 million records) into an outfile. I need to change any "NULL" to a blank. I can use

"SELECT IFNULL(field_na me,'') FROM table_name WHERE transDate = date INTO OUTFILE '/tmp/sample-file.csv' FIELDS TERMINATED BY '|';",

but that only works by column name - it does not work for

"SELECT IFNULL(*,'')...

Hi I was wondering if someone could help me with this problem I have plotting with Office Web Components...

In have a data sheet with x vs y data where if a value is zero it is removed and replaced with blank ("") which is required for what I am designing.

The reason I do this is that in excel if the blank is encountered the two points either side of the blank cell are not joined by a line even in the same...