Search results for query: *

Hi I need some help. We have an Oracle database that I have link from Oracle to Access 2003. I can see and query the data without problems. The link table name is Oracle_RT_DATA and the Access database name is TMSR.mdb. I have created a query from the Oracle_RT_DATA table name qryrtdata. I...

Hi I have created a table with the contact information.I have a form with a combo box name contact and there is a dropdown list with the names fro which the user can select. Sometimes a new contact is manually type in the form field. How do I populated the contact table with the new contact and...

Hi I am tying to compare dates from two fields I would like to show all records that have a INREF_PODATE that is greater than the INV_DATE. I am trying to show when payments were made before an invoice was received. {invoice_podate.INV_DATE} >={invoice_podate.NREF_PODATE}

Hi I have a text field (line-descr) which holds dates in this format *030803*. I have created an update query to convert the text field to date. However, I receive an error unable to update due to data type conversion. Here is the update query. UPDATE inv_podate SET inv_podate.INV_PODATE =...

Hi Can I derive a day of the week (e.g. Monday) from a long or short date (e.g. 1/29/2004) in Crystal Reports 8.0?

Hi I have two fields surv_date & day. Once I type the date (01/05/03) in the surv_date field, I would like to populate the day field automatically with the weekday based on the surv_date. I am using this function =Format([Surv_Date],"dddd") as the control source to show the actual day of the...

Hi I have the following fields on a form effective_date, time, surv_date, day, bus_num, run_num, ntd, special, and regular. I would like to click the add_record command button and automatically copy the contents of these fields to the newly added record because the content will be the same for...

Hi I have placed a command button on a form to duplicate a record in an effort reduce typing. When I click on the duplicate button, Access return a Run-time error 3075 and open the Visual Basic editor and highlighting this line of code. Set qdef = CurrentDb.CreateQueryDef(sQueryName, "Select...

Hello, I have a form created from a table name Result. It holds all the data for bus stop locations (more than 6,200). Locations are used by more than one STOP. When any field on the form created from the Result table is edited, I would like to have another form pop up after saving the edits...

Hello, I have a form created from the bs_loc table. It holds all the data for the unique stop locations (more than 5,500). Locations are used by more than one STOP. When any field on the form is edited, I would like to have another form pop up after selecting update, showing all the related...

I am trying to insert records from one table (bs_loc) to (Rt1Stps) table. All the fields are text except date1. Here is the sql query: INSERT INTO Rt1Stps (STOP, LOC_ID, DESCR, MUNIC, AMENITIES, ADA, DIST_IN, MAIN, CROSS, RW, HISTORY, DATE1) VALUES ('STOP' Loc_id, DESCR, MUNIC, AMENITIES, ADA...

Hi I hope someone can help me. I have an Access table name bs_loc. This table has an autonumber name LOC_ID. The other fields are DESCRIPTION, MUNICIPALITY, AMENITIES, DATE1, HISTORY, ADA, DIST_INT, MAIN, CROSS, AND RW. All of these fields are populated. I would like to insert records from...

Hope this can be done Is there a way to create a Running Sum for a form in Access? I have a field name DIST_STOP which show incremental distances for bus stops. I have a sequential ID field LOC_ID which is unique for each record. Microsoft has advised to do this but I get all zeros in the...

Hello, I am working on a major project for which I need assistance. I have an Access 2000 DB with three fields of importance Stop Loc_Id Cumulative Distance "Stop" This number field hold a 5 digit number e.g 01103 which is a bus route and stop number. The first two digits are the Route Number...

Hi I have created a pivot report via a odbc connection to Oracle 8i. I am using Excell & Microsoft query as the query tool. I am querying for vehicle numbers VHCL_ID. The nunbering is as follows: 9901-9935 1999 series 0021-0035 2000 series 0101-0135 2001 series 0201-0235 2002 series 0301-0335...

Hello I have cells in a form formatted as custom time 8:30 [h]:mm which fine. However, when someone enter 8.00, (decimal instead of colon) the calculations within the form are incorrect. Is there a way to format the cell so that only time can be entered. I have protected the sheet, but these...

Can this be done? I have been confronted with a user and inventory tracking form. Column A has the total for the month (50), column C has the total after the first week (40), column E has the total for the second week, and column G has the total for the third week, and column I has the total...

I have been really struggling with a project at work. It is a time sheet. For the most part, with the great assistance of Blue Dragon2, I have captured 90% of the scheduled work shifts. There is one scenario that is wild but allowed by administration. A person leaves early one day for a doctors...

Hi I would like to add the values in a column, but two cells must be omitted during the calculation. Here is the formula: =COUNTIF(D14:D25,">0")*0.02083333333. I need to skip cellS D18&D19 and count D14:D17 & D20:D25. I have tried the following...

Hello, we have a windows 2000 server with a shared folder (A). There is a log folder (C) within another folder (B) that users need have write access. Shared folder A permissions are read only, folder B is not shared, and folder C (Log) is shared granting write access, but not full control. This...