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

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

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

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

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

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

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?

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

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

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

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

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

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

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