Search results

I'd post the table layout but the query is too complicated for it to display graphically. It's not that complicated though. Most of it is just tables replacing ID's from the main table. As I said in the first, I'm trying to do is use ORDER BY with a variable. I can get the variable to fill out...

Okay I did a bit more messing around and figured out that if I do ORDER BY [TempVars]![SortOpenBy]; It doesn't give the error, but it's also not sorting at all. In the debug I do print [TempVars]![SortOpenBy] Which returns a perfectly valid field. If I type it in manually instead of using...

So it appears that this query can't resolve the last variable of [TempVars]![SortOrderBy] but if I were to change that to just WorkOrder for example, it works fine. SELECT ticketqueue.ID, ticketqueue.WorkOrder, ticketqueue.Details, ticketstatus.StatusName, ticketpriority.PriorityName...

Well it was worth shot. Gave the error of too few value for the number of columns. I suppose if I rework it to use INSERT INTO table SET that is supported in MySQL, it may work and not be that difficult. Any idea if this works in Access?

This gives an error INSERT INTO ticketchanges VALUES (NULL,46,,'Hello',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2); This leaves the column blank INSERT INTO ticketchanges VALUES (NULL,46,'','Hello',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2); This works but uses system time INSERT INTO...

It is indeed. If I omit that field I get an error from access of an invalid insert statement. If I use '' it works but the field is blank.

Hmmm.. I didn't try that. However when I do it does work except it prevents the server from using it's default. That column is a DATETIME with the default of CURRENT_TIMESTAMP. I don't want to use NOW() in the code because that would use the system time instead of the server's...

Hi all. First post here. Super new to messing around with VBA but have gotten pretty far I think. Here's the problem. I have a variable that contains a perfectly acceptable MySQL statement (as in, I can copy it into mysql directly and it works) yet when I run it through CurrentDb.Execute...