Search results for query: *

Installed the latest xampp last night by (backing-up and) clearing out the old first. But MySQL isn't obliging. The command prompt says' 'Can't connect to MySQL server on localhost' I tried a mysqld-nt --install and the command prompt says it is installed. When I offered mysql\bin 'mysql...

With Back and Next at the bottom of 9 webpages, I would like to be able to say s o m e t h i n g like if($id == '1'){ <a href="../parents/sip2.php>{ if($id == '2'){ <a href="../parents/sip3.php>} ... and that sort of thing for the 9 pages. Then I would like to do the same for Back (But I...

I want to create this in the query that feeds a subform, frmMatrix. If [DailyGrind] = "Dismissed" And [Sacked] = "Unsacked" Then [DailyGrind] = "Available" Be most grateful for some guidance.

I have two lots of code. One lists articles for display, and click on the item and that story appears. It works well. If one of the stories is long, I want it to appear bit by bit, or page by page, using the term [PAGEBREAK]. This code works fine. But – being short of knowledge – I don’t know...

If the field, LastJobEndDate, is more than 28 days old, a message should appear in field DailyGrind 'Available'. For some unknown reason, this sub won't change the message. H e l p, please Experts. Private Sub Form_Current() If Abs(DateDiff("d", LastJobEndDate, Date)) >= 28 Then...

Something is wrong with this crosstab query. It is fed by two queries, and my join arrangement is the most likely cause. The result should arrive with 10 columns, but it makes 15. And some of the fictitious columns have totals, so it isn't a matter of simply deleting the unwanted columns...

This is my regular crosstab query, only now it is fed by two tables. Does this mean I have to make a join, please, Experts. If it does mean a join, I'd be grateful to know where the join is declared. TRANSFORM Count(qryEmployees.Roots) AS Ethnicity SELECT qryEmpWorkers.DailyGrind FROM...

Is there a way to say in MySQL, please, DELETE * FROM ThisTable INSERT into ThatTable;

I'd like to sort the files by the date field (DoA), when when it is used like this, how do I, please, Gurus? ... CONCAT(TO_DAYS(Curdate()) - TO_DAYS(DoA), 'days') AS LateBy ... ORDER BY LateBy DESC;

To call a Public Sub ('Hide'), I've been using the word Hide within form_current(). But using it just the same way in another db, I get the error message that the sub or function is not defined. What can access mean, please, Experts?

The form “frmMatrix” has two subforms. First is subform “frmWorkers”, and the second subform is “frmTransfers”. To email, and to print a document (via Word) from the db, I need to refer to fields on the Form, and the SubForm “frmWorkers”. Advice from Microsoft says I have to refer to subform...

Is there something quirky with the error message "Method or data member not found", please, Experts? The error message arrives even when VBA itself has chosen the particular member, such as "Me.txtSName". Usually, I think, it hints of a spelling error. But perhaps it points to something else...

This code has been working well. But moved to a new db, an Error Message says it is too complicated. Is it, experts, please? Private Sub cmdDeleteRecord_Click() IsOk = MsgBox("Is this really for the chop?", vbYesNoCancel, "Zapped!") If ((IsOk = 6) Or (IsOk = 2)) Then stDocName...

One form, two subforms in a new db. The three work well together, except when it comes to a new record. When I want to input details of a new record, the main form and a subform work ok, but the third subform won't accept anything. What haven't I done, please, Experts?

I need to update one field from another in the same table. DailyGrind has the info. It is a text field. I want to update the text into the field WorkID. WorkID is a look-up field, so its Data Type is Number. How can I move the text over, please, Experts?

I’m trying to make a relational database of a large single-table db. There are some look-up fields that I would like to update from the previous table. The information to be moved across sits in text fields. But the new ones, being look-up fields, has the data type ‘Number’. Is there a way...

In the same table, TableOne, I'd like to move information from FieldOne to FieldFour where DoA is null. How is it done, please, Experts?

I want to group in descending order the records Sent and also Received when php summons info from the mysql db. When I code ... ORDER BY Received, Sent FROM tbl DESC Received (or maybe Sent) is treated the wrong way. Be grateful for advice on the correct way.

Is there an automatic way to record the date any and every time a record is changed in Access, please, Gurus?

Last in, first to appear is the desire. Yet when I call on the database via php, I get post for May 9, May 8, etc, and after that May 24, May 23, May 21. Something’s wrong. $query = "SELECT PostID, CONCAT(FName, ' ', SName) AS Name, About, Date_Format(DoA, '%b %e') As DoA FROM Post ORDER BY...