Search results

I'm guessing that you only want one instance of the data returned? If this is the case, use DISTINCT in your query i.e. SELECT DISTINCT ..... Hope this helps

Its difficult to say exactly why this is the case. Is your Titles table related to any other tables who's primary keys do not allow the selection of the additions you have put in place? This could explain the Cascade error you mention Can you check the relationships between your tables and...

What errors are you getting when you run the code? Also, I am not sure that you are referencing your user form correctly From memory, try using something like Forms!LiqForm!ListCT.List(i,0) when you are trying to assign your variables W1dge

Forgot to mention one quirk of Access, and that is how much space can be taken up by continually creating and deleting tables! It may be worth compacting and repairing once in a while, especially if you find that the database starts to slow down. Obviously, this will depend on how much data...

I'm not sure why you would want to export to Excel and then import as you have already done the hard part in linking and developing the queries! If you want to keep the data in Access, the easiest thing to do is change your queries from ordinary Select queries to Append queries. That way, you...

I seem to remember something similar to this a long time ago. As I recall, my problem was down to having references set to both DAO and ADODB, and not specifying in code which to use. For example, I think you should specify that you want to use DAO rather than ADODB when you define your...

I think it might work if you use the following, where I have simply replaced the TRUE vb Keyword with the integer value for true which I think is -1 I.e. strWhere = "[ProjectID]=" & Me![ProjectID] & " AND ([frmBillSubform].Form![HoursBilled]) = -1" W1dge

Forgot to add, that you should then set the Source Object property of the subform to be your Recordset object W1dge

Which version of VB? .Net, VB6 or VBA? If you are using VB6/VBA, I think you can do it using the Openrecordset method of the Recordset class Off the top of my head, the syntax is something like; Dim obj as Recordset Set obj = OpenRecordset ("SELECT Table1.Column1 FROM Table1 WHERE...

Try this SQL, it should solve your problem SELECT Table1.Column1 FROM Table1 WHERE ([Column2]+[Column3])<[Column4]; W1dge

Try this function that I use when converting time in milliseconds to real time. Time is diplayed as a string that you could manipulate to give the level of precision you require. It may be a little agricultural, but it works for me.:D Function MillisecondsToTime(ByVal lngMilliseconds As...

Is it possible to perform calculations across 2 adjacent rows in SQL? At the moment, I have a running count that tracks the number of updates that go into our database against a specific JobID. Is it possible to subtract the running count for a previous update from the current update. For...

Is it possible to perform calculations across 2 adjacent rows in SQL? At the moment, I have a running count that tracks the number of updates that go into our database against a specific JobID. Is it possible to subtract the running count for a previous update from the current update. For...

Paul Tried what you suggested and it works a treat:D Thanks once again W1dge

Thanks Paul :) Will give it a try W1dge

Hi, I have a database that tracks jobs as they are being completed. I have 2 tables, the first of which contains details of the jobs and the second contains details of the individual tasks that make up each job (Job and Task respectively) Within the Job table, there are several fields...