Recent content by benderulz

I'm trying to use an After Update trigger to compare two column in my table (custom_avail_history) and if they do not match, insert the record into another table (custom_avail_history_changelog) to track changes over time. When I try using the code below it tells me "ERROR 1054: 1054: Unknown...

It was an issue with my primary key settings. I see what you are talking about reassigning the variables. I was running the two select queries because I did not know how to insert into 2 different columns from the same query. Thank you for help. I learned a lot from your optimization.

Can anyone tell me why my insert statement in the loop is only inserting the first record? The code completes 5 trips through the loop and it is selecting different sets each time through (I can see the sets with the echo at the end of the loop), but it only inserts the first set. $count = 0...

I'm not sure what you mean when you say "use the shell"?

The code below creates the table and inserts the rows, but it runs very slow. Is there a better method of inserting the results into my table? The select query could run as high as 18,000 rows depending on the time frame. Any direction on how to do this more efficiently would be appreciated...

Can I ask why you don't send your email using the CDO or Outlook library instead of this special utility?

Isn't that what is holding my header in place when I scroll through the body?

Ok I really need this to work, and I've been beating my head against the wall too long already so any help would be GREATLY appreciated. Everything is working great with code show below except, the column widths in the tbody do not match the column widths in the thead which is a fixed row...

Thanks for the example spamjim. I have the scroll function working great but my header row still scrolls with the rest of the table. Can you give me some insight into what I did wrong here? echo '<div id="tableContainer" class="tableContainer">'; echo '<table border="1" width="99.9%"...

How can I make the below code display with a locked header so that when the user is scrolling down the display the header of the table is still visible? I have tried displaying a table with just the header and then a scrollable table below it, but then the columns do not match up because the...

How can I make the below code display with a locked header so that when the user is scrolling down the display the header of the table is still visible? I have tried displaying a table with just the header and then a scrollable table below it, but then the columns do not match up because the...

The code you posted at 24 Sep 13 19:31 did exactly what I needed. It properly placed the higher priority values. Thank you so much for all your help!!!

You would use [Forms]![FormName]![TextBoxName] as the criteria in the date field of your query.

I will try these as soon as a get back in the office tomorrow. Thank you so much.

If I use the print_r($rows) to display the array the column numbers match for the different priority rows (but it does not display in a user friendly format). Does the echo table not know how to handle the column numbers?