Search results for query: *

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...

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...

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...

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...

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...

Hello All, I have a query that works and is returning accurate data, but I want to display it in a different format. Basically, what I need help with is making this into a crosstab query. My query returns: Zone | Priority | Trans A | 2 | 50 A | 3 | 10 B |...

Hello, I'm new to using php and am in need of some guidance. Below is the code I'm trying to display. However, all it returns is a blank page. If I replace the SQL with a simple echo text for a good connection test it displays, but I cannot get it to display the query results. Is my SQL...

First off, I am using Access 2010. I have a table [selecting_locations] that lists item number, warehouse location, and qty. For example item_nbr location qty 123456 P123A 1 123456 P321A...

I have a form that or may not contain multiple records. I want to check the record count and display a message to the user if multiples exist. I put the code below in the "On Open" event, but it does not run the check. However if I open the form, go to design view, and the toggle back to form...

Can anyone tell me how to add the "OfficeLinks" button to the menu bar using VBA? I can add it manually using the custom toolbars but I want to do this with code. Any help would be greatly appreciated. I'm running Access 2003

Is there a way to format Now()-1 as text used in a query criteria? example 2011-10-26 07:30:00 would show as 20111026073000

I have a table that contains a record for PO# 12345, the same PO arrives again and a new records needs to be inserted into the table, but since the PO# is the unique identifier I need it to be inserted as something like 123451. Is it possible to have Access check for the PO, if it already...

Can anyone tell me how to reference a form value in another database? For example If db1.form.value = True then 'do this in db2 else end if Thanks

I'm using an hta to control Access macros from multiple databases, but if a user cancels a query input they receive a runtime error message asking them to debug. I do not want my users to have that option. Is there a way to suppress this message? I have included my script below. <SCRIPT...