Recent content by nathansav

Hi, I am currently working in Access 2010, and one of the users in my team is using an Access 2003 DB in 2010, this is all fine. However, some questions were asked about the MDW file, so i've been taking a look. I have joined the workgroup, which i am not a member of, now i cant use access...

Hi namliam, thanks for that, its what i thought, i thought there may be a way of sorting it out. That's the approach that i have used, apart from the user to open and close (compact on close) as the final step of the DB installation. Thanks Nathan.

I thought the SQL would have given it away from the OLD connection i am doing an insert into db2, which bloats.

Hi, I have written a tool in Excel VBA that compares an old copy of a database, to the new copy. Any static tables are removed and added from the old. So in the new i use connNEW.Execute "drop table x" and then in the old i use a SQL insert into so connOLD.Execute "Select x.* into db2 ..."...

You can put it in the textbox property or vba.

DLOOKUP is probably best, or you can code it on the text box change event, but you'll also need to put it in the form load for that.

Something like this, got some isses at the moment so cant test Public Sub b() Dim a As TableDef Dim f As Field DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "Sheet1", "c:\c", True, "A1:C100" Set a = CurrentDb.TableDefs("tblFile") Set f = a.CreateField("n", dbLong)...

Are you doing the append in access? There is a plaintext() function in Access i believe.

If you take out the bit in bold, the subquery, then you are left with your query. The jumbled mess is the SQL :o) (select top 1 t1.[defect status] from tbl_status_phase_change as t1 where t1.defect_id=main.defect_ID and t1.bu_date<(select min(t2.BU_date) from tbl_status_phase_change as t2...

Apologies, but have you read my post????? I have that, there is no data for status_from which is why i am using a subquery to find the status before it was at the current status

Hi, I have attached some sample data, and the query i use, apologies i thought that would have been enough. The query is off that data, so taking the 2 into access would have shown. Here is the data on the left, output on the right Thanks

DCOUNT look at that on the net, help.

Attached an excel version of the table

Hi Firstly a bit of background into the madness of my table. I had a sharepoint site linked to an access database for reporting. This SP site created workflows and tracked statuses, however for just over a day our SP server got full, so the new list items for tracking couldnt be created. As...

=iif(returned=false and returndate<date(),20*(returndate-date),"") in a text box on the form