Search results for query: *

I have imported a table which is very big (over 200 columns). I want to split this table into two linked (in one-to-one relationship) by an autonumber ID. Is there an efficient way to do this? I would assume I can't write out table 2 until table 1 has been completely written and the autonumber...

I want to hide the 'File Edit Insert' menubar for the duration of my application. How is this done?

I need to speed up query qryMaxThru SSR (below), it uses the two other queries listed. This query extracts the latest record from a set of records with date ranges. The latest date range for each key (SSR/Task) needs to be extracted. This needs to run extremely fast as it is executed many times...

In Access 2000 in SQL is there any difference when comparing dates to the efficiency of? WHERE MYDATE BETWEEN ... AND ... and WHERE MYDATE >= ... AND MYDATE <= ...

I have tried everything I can think of and get syntax errors. I need to do UPDATE tblA LEFT JOIN tblB ON tblA.X = tblB.X LEFT JOIN tblC on tblA.Y = tblC.Y SET ..., SET ..., etc. etc.

In the below query I need to do the first 2 SET statements even if the inner join finds no match in tblPriority, is this possible? UPDATE tblSSRData As D INNER JOIN tblPriority As P ON D.TASK_PRI_CD_1 = P.Code SET D.CLOSDATE = ED(PRO_FROM,CLS_FROM), D.COMPDATE =...

Which of the following is more efficient, or is there no difference? SELECT tblSSRData.*, tblPriority.Desc AS PriDesc, tblPriority.Target AS PriTarg FROM tblSSRData, qryMaxThru, tblPriority WHERE (((tblSSRData.[SSR_#])=[qryMaxThru].[SSR_#]) AND ((tblSSRData.[TASK_#])=[QryMaxThru].[Task_#]) AND...

I have this very complex report I've written. Its not a normal report. I build a custom table which just consists of detal lines. Hundreds of SQL calls are used to build this table. This table becomes the report control source. My problem is that the first column needs to print as bold or normal...

I'm building a table which will be the input to my report. In the first column I put headings for each row of data. I'd like some of these to print in bold and some in normal weight. Is it possible to have conditional formatting on a field in my report?

I have a table with columns called M1 thru M12 representing data for a month. Can I load these columns in a loop such as: For i = 1 to 12 rs.fields("M" & i).value = .... Next

I get an error message on the .Add LINE ("only user-defined types defined in public object modules can be coerced to or from a variant or passed to late-bound functions") Dim myPriority As typPriority 'In module CustomTypes Dim colPriority As New Collection ......... Do While...

I have a report that prints monthly percentages and then a quarterly percentage. I have a function that calculates the monthly percentages. I'd like this function to pass back not only the percentage but also the dividend and divisor for the calculation so that I can use these to form the...

I posted this before buy never got a suitable answer and am still struggling with the problem.... I have a table of service request (SR) data extracts. There is no unique key. The extract can be run for any time period and each extract may or may not contain the same SR number. Each extract...

I thought it was possibnle to call a public function from an SQL query but I am getting 'variable not defined'. The error is in the call of Function ED toward the end. Here is my SQL: strSQL = "SELECT [SSR_#], [TASK_#], [TASK_DESCRIPTION], [PRIORITY], " & _ " [ASN_FROM] As...

I am importing some data into my access database (access 2000). The data contains about 50 columns with a status and a date, this represents status history. There is also a column for 'current status and a date'. What I need to do is to move this current status and date into the correct column...

I'm reading a table that has 3 dates, closed, promoted and cancelled. Any or all of these dates can be populated or null. I need to find the earliest date or null if there are none and use this result in comparisons with other dates. Can this be done in SQL or should I create a query to fill an...

I have a table of service request (SR) data extracts. There is no unique key. The extract can be run for any time period and each extract may contain the same SR number. Each extract record has a run date. What I need to do is extract each unique SR number for the latest run date in the file...

My database appears to be screwed up. I can't run it, I get 'Error accessing file, network connection may have been lost'. I can't compact/repair it, I get the same message. If I open it in shift-key mode, I can't compile it, get same message. I can't copy a report to a new report, I get 'Name...