Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cdw0308

    2 fields 1 record change to 2 records in new 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...
  2. cdw0308

    Data Restructuring

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

    counter field and increment feature

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

    loop help

    That was it. I had them both as Text fields instead of numberic. Thanks for all the help. It worked great.
  5. cdw0308

    loop help

    The Maximum number of for cond_num is 48 I have thouands of cable_nums that this has to be done to. I would like to find a way to do it without manually typing it in excel and exporting every record. I made a table called Number_List with a field called intList. I input the numbers 1 - 48 in...
  6. cdw0308

    loop help

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

    replicate data based on record criteria

    Can you provide some actual code that could get me started? Thanks
  8. cdw0308

    replicate data based on record criteria

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

    TFLE_programmer_error1

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

    Run Access Database from Terminal Services

    I managed to figure it out. I just wrote a batch script and called it to execute the access database at startup and it is working. Thanks
  11. cdw0308

    Run Access Database from Terminal Services

    I have tried the UNC path as well and I still get this error message. An error (193) occured while creating user logon. The initial program cannot be started. Any other ideas?
  12. cdw0308

    Run Access Database from Terminal Services

    Can you elaborate on what you mean by UNC path? The paths I have tried to use so far already are on my original post. Thanks
  13. cdw0308

    Run Access Database from Terminal Services

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

    Starting Access 2007 App on Windows 2003 Terminal Server

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

    Date Forecasting

    i need to be able to show a matrix of amounts along with there dates. If I enter a project start date of 5/12/2008 and it has a duration of 3 months with a project value of 75,000 I need to populate a forecast table with 5/12/2008 to month1 field 6/12/2008 to month2 field 7/12/2008 to month3...
  16. cdw0308

    Date Forecasting

    I am not sure if I understand. I am not good with date calculations. The end date is determined once i know the duration which can be anything between 1 and 12. Then i need to have every month that falls into date range inserted into the table as well as a corresponding value which is...
  17. cdw0308

    Date Forecasting

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

    NaN Problem

    Thanks tsuji That worked great. I have it working correctly now.
  19. cdw0308

    NaN Problem

    I put in alert(var1); alert(var2); and it returns: [object] for both alert boxes. Any suggestions?
  20. cdw0308

    NaN Problem

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

Part and Inventory Search

Back
Top