Search results

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

you need to use the pk of the reservation table to.

Function GetLastModDate(strFilePath as string) as date Dim f As Scripting.FileSystemObject Dim fl As Scripting.file Dim dtM As Date Set f = New Scripting.FileSystemObject Set fl = f.GetFile(strPath) dtDM = fl.DateLastModified GetLastModDate=dtDM end function

Can you not have the main database as just what is needed for the opening, then rather than opening you link the tables and import everything else from the selected database, this will negate the versioning issue also as as soon as the form is changed in the network version the next use will...

WHERE (field1 =true or field2=true or field3=true)

You are not using the Lot ID in the Dlookups though? Look on the net at DLOOKUP multiple criteria, then you can modify what you already have