Search results for query: *

I have an existing table that has a field cblcode1 and cblcode2. cblcode1 always has data in it and cblcode2 is null sometimes and has data on other records. I need to create a query that can output the single record into multiple records when cblcode1 and cblcode2 both have data in it. As...

I have a table that is setup with 3 fields sequence, cable_num, and route example data: sequence cable_num route 1 10AB001-001 32413 2 10AB001-001 19485 3 10AB001-001 55521 4 10AB001-001 3e325 5 10AB001-001...

I have two tables that look like: Table: projects fields: project_num text field project_count text field Table: po fields: po_num as text field po_project_num as text field po_count as text field On the form, frm_po with record source to po...

I have a table with 2 fields cable_num cond_num cable_num is a text field cond_num is a numeric field ex. cable_num cond_num 1AP0001 4 1BA0001 2 I need the above info in a new table and formatted like below: 1AP0001_1 4 1AP0001_2 4 1AP0001_3...

I have a table with cable_num cond_num cable_num is a text field cond_num is a numeric field ex. cable_num cond_num 1AP0001 4 1BA0001 2 I need to make this data converted to: 1AP0001_1 4 1AP0001_2 4 1AP0001_3 4 1AP0001_4 4...

I am getting a TFLE_programmer_error1 a00084d5 HEX message and my backup fails. It is trying to backup 3 different servers. I have the backup agents intstalled. I can backup these three servers one at a time and it will work, just not all at once on the same tape. This used to work and all of a...

I am trying to run an access database from a terminal services server running Windows Server 2003. I am trying to make the database startup immediately after logging into the server. I have tried sever lines on the RDP connection file to start access and the database but nothing has worked...

I am trying to run an access database from a terminal services server running Windows Server 2003. I am trying to make the database startup immediately after logging into the server so the user cannot gain access to the desktop of the server. I have tried sever lines on the RDP connection file...

I have a field called start_date and a field called duration. I also have a field called project_value. What I am trying to accomplish is: Insert into a table the value of the start date and the monthly increments up to the number that is the duration field. Example: 5/1/2008 with...

I am tring to calculate a field on a form by mutiplying two other fields together. I keep getting NaN as the value. I am using the on blur event on x_proj_value and x_proj_percent so that it populates a value into x_ext_value. Here is what I have so far. <script language="javascript"...

I am trying to make a query to pick numbers out of a table of several numbers that equals my end result which is known already. There are much more numbers in my number table that will not be used. The hard part is finding the correct numbers to add up to the total. There is negative numbers and...

Is there a way to restrict the single quote symbol from being typed into a text box on a form? I am running into errors on my append and update statments when a user types in a description such as " 25' Tape Measure " When I remove the single quote the statements process just fine. I really...

I have a Windows 2000 Server running Exchange 2000. Just recently my presubmission queue started backing up. I have ran offline defrags of my exchange database. Restarted all the exchange and IIS services. Scanned for viruses and nothing shows up. Nothing Seems to help. The processor does go to...

I am trying to add a select box to my table that is populated from a query. Here is my javascript code. The items in red is what I added but cannot make work. This code works if it is all just input boxes. <script language="javascript"> function deleteIt(i) { var theTable =...

I have an access database program that uses this code to put a number on the form based on what the last form number was. It happen when the form loads. I am rewriting the program to be web-based. I need to know how to do the following in javascript. Private Sub Form_Current() If...

I am trying to use an insert query in my cfloops. I started out with this code that displays the values to the page. It works just fine. Now I wanted to modify it to include an insert query that sent the data to a database <cfset j = #total_count#> <cfloop index = "RowCount" from = "1" to =...

I am having trouble with my row numbers on the table to re arrange them selves to the proper order when a row is deleted from. For example 1 2 3 4 When i delete row 3 the order looks like this 1 2 4 When i add a row it then looks like this 1 2 4 4 I would like it to have renumbered itself...

I am trying to output a set of variables from a dynamic table using a cfloop. Here is my code. <cfset j = 1> <cfloop index = "RowCount" from = "1" to = #j#> <cfloop index="ColumnCount" from = "1" to = "3"> <cfoutput>txt#ColumnCount#Row#RowCount#</cfoutput>&nbsp;&nbsp...

I have a dynamic table that is created with the use of javascript. I have an add row button and a delete row button. These buttons work fine. I also have a submit button that will take me to my process page where i would like to use an insert statement to take all the data that was typed on...

I have two functions addrow() and deleterow(i) The delete row function works for the first row on the table and then will not delete any others. The addrow function works everytime. Here is my code. Any help would be greatly appreciated.. <script language="javascript"> function deleteRow(i)...