Search results for query: *

Ah, sorry, forget all this. I just missed a GROUP BY clause at the end. *embarrassed*

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

I had the same problem. My solution was to add in a reference to the Excel object library and then declare the Excel objects. I can then close the Excel process by closing the Excel objects and releasing the variables: Dim appExcel As Excel.Application Dim wbk As Excel.Workbook Dim wks As...

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

Starting to make sense now. ER diagrams are very different to just writing SQL! Thank you for your quick responses, r937 and johnherman.

Ah, so I just label the relationship connectors differently? I didn't know that. Thanks.

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

It's slightly unusual to use SQL ALTER TABLE syntax with Access, and it will only work with Jet databases. It would be more normal to use DAO methods with TableDefs (or ADO methods with Connections) to make changes to table structures in Access. Now, are you trying to remove a Default Value...

PHV is right that the DoCmd.TransferSpreadsheet is probably the best way to accomplish what you need. There are a number of other ways to do it, however. You could create a recordset from your Excel data and loop through that, appending each virtual row to your Access table. There are also a...

Thanks for the replies. I was trying to replicate a behaviour I'd seen in Oracle forms, where the tab is actually not selectable. The page.enabled = false functionality isn't quite what I want, but it will do. Thanks for saving me from spending hours trying to figure out how to do something...

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'm afraid it's not possible to do this in SQL. Each table needs to be queried seperately for the data you're looking for. To automate it, you would need a procedural extension like PL/SQL or T-SQL to loop through each column in each table looking for the string you're after. Or you could...

OK, I need a bit more help. Call the edhistory table sen_provision. It has the following columns: location_id referral_id start_date end_date provision_code hours_per_week date_agreed The primary key is a composite of referral_id, provision_code and date_agreed. The cal_term table has this...

Thanks for your comments, lameid. I will make sure the connection is closed and the cn object is set to nothing. jedraw - I have looked at pass-through queries, but I find they run much more slowly than ADO recordsets returning data, even when that data is then appended to temporary Access tables.

PHV - thanks for your swift reply! That works well. (I may come back to this thread with an additional related question if I can't figure the rest of my problem out) Best wishes, cjashwell

Ed - thanks very much for that. I have created a module containing the public declaration of the connection object, and the connection procedure with username and password passed from the connect form: Option Explicit Public cnImp As New ADODB.Connection Public Sub OpenConn(strUser As...

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

Thanks for your help macropod, and for linking to that very valuable resource. Best wishes.

Great - that does seem to work. Thank you very much indeed. Can you tell me where this is documented, as I searched offline and online Help quite extensively but didn't find any references to this technique?