Search results for query: *

Hi all. I have an issue with a piece of SQL I'm trying to write for a MySQL database, and I wonder if anyone has time to have a look at it and see if they can suggest a solution. The database is used for tracking workflow of projects. Projects are recorded as being at particular stages...

Hi all. Does anyone know if there is any way to programmatically modify both the structure and the data of a text file that is a linked table in Access? I have a file of >900k records that is linked as a table in Access (version 2003 on Windows XP SP2) . The file is a structured CSV file with...

Hello. I have a problem concerning ER modelling a relationship between two tables in a database used as part of a charity fundraising system. I am trying to prepare an ERD based on a third-party supplied system. The tables I'm concerned with are Constituent (which describes people) and Donation...

Hi all. Is it possible to have a Tab control with one or more Pages greyed out and non-selectable by users until certain conditions are met? For example, until a value is selected in a list box on Page 1 of a Tab control, Page 2 is greyed and can't be selected. I have seen this implemented in...

I wonder if anyone can help with this problem. I have two tables, edhistory and cal_term. The edhistory records the start and end dates of a pupil’s time at a particular school. The relevant fields are: SchoolID PupilID StartDate EndDate The cal_term table contains details about the school...

Hello. I have written a reporting application in Access 2003 that connects to Oracle via ODBC in order to pull in data that is then displayed to users as Access reports. I have used mainly DAO to connect to Oracle, although I am starting to re-write everything in ADO (sorry, I'm a bit behind...

Hi there. Does anyone know how to use Word fields to evaluate a date passed from a mailmerge field to see if it falls between two dates? For example, if I want to know whether 10th September 2007 is between 1st September 2007 and 15th September 2007, how do I do this? Assuming the Date merge...

I am using an Oracle 9i db but I thought I would post this question here as a) there is no specific Oracle SQL forum available, b) the Oracle developer forum looks pretty sparse, and c) I thought it might be interesting to see if/how my problem can be solved in 'pure' ANSI SQL. If I'm in the...

I'm trying to deploy a third-party VB application on a Win2k SP4 machine. The application runs until a certain point at which it falls over with : "run-time error 339: Component 'MSFLXGRD.OCX' or one of its dependencies is not correctly registered: a file is missing or invalid' So I search for...

In my report_nodata event I have the following code: Private Sub Report_NoData(Cancel As Integer) On Error GoTo Err_handle Cancel = True Exit_repnodata: Exit Sub Err_handle: Resume Exit_repnodata End Sub And in the code for the form calling the report I have: On Error GoTo Err_handle...

Hi there, I've tried searching for the answer to this, but haven't found what I'm looking for, so I would really appreciate any help anyone can offer. I am trying to produce an update query to update a value in one table (Address) from another table (Pupil) which are joined (many-to-many...

Hi, I'm working with Excel 2000 under Win2k SP4. I would like to add a horizontal line to the foot of my worksheet pages as a matter of formatting neatness. What is the best way to do this? Adding a line using the drawing function on the actual worksheet doesn't seem to be the optimum...

Hi, Does anyone know if it's possible to display the series names as labels in Excel charts(I'm using Excel 2k under Win2k sp2)? It's straightforward to set the data labels to display Value or Point names, but I can't figure out how to display the names of the series' as labels. Any...

Hi, I'm tearing my hair out over this problem. I'm working with Access 2000, and I have a report, based on a query, which contains a subreport in order to show a subset of the main query's data. I can set a text box in my main report to show the values I want from the subreport using the...

Hi there, I wonder if anyone could help me out with this problem: I am trying to compare two recordsets with different numbers of records to see if there are any closely matched records in each. I need to know for each record in the first recordset whether there is a close match in the second...

Hi I have a grouped report that produces some blank space at the end of each group's pages. I want to fill this blank space with horizontal lines, so that comments can be written on the hard copy. Each group contains a different number of records, so the amount of blank space is different for...

Hi Can somebody give me some assistance with the following: I'm writing a routine to clean some data in an Excel 97 spreadsheet. I need to have each column 'cleaned' using the worksheet functions CLEAN and TRIM. The sub I've written goes through the worksheet inserting a new column next to...

Hi all, I need to create a Word email mail merge that includes an attached Excel file. Creating the email-merge is straightforward, but can anyone advise me how to attach the Excel file? I'm using Office 97 but instructions relating to Office 2k or XP equally useful. Thanks in advance for any...

Hi Does anyone know if there is a way of setting up an Excel cell with some kind of 'input mask' that will automatically capitalise any alpha characters that are entered? I can't seem to find the function within the cell formatting menu, but perhaps I'm not looking in the right place? Thanks in...

Hi Apologies for cross-posting, but can anyone help me to plot a median line across a scatter chart I'm working on in Excel 2000? I don't want a trendline, just a line representing the median values across my hundreds of data points. Much gratitude in advance for any help offered. CJA.