Recent content by gwunta1907

The initial release of Access 2010 runtime was in October of 2010 (as per the link in the post above) however a service pack (Access 2010 Runtime SP1) was released in June 2011 that included updates up to and including April 2011. You can get the service pack at...

I have programmed an Access application to manipulate and consolidate SharePoint linked tables with local backend Access based tables. I wrote VBA to toggle the application between online and offline mode and it works as expected in the full version of both Access 2007 and 2010. However some...

Hi all, Im not sure if this is possible. Any gurus out there might be able to answer this one. I have a table with, amongst other information, delivery dates for consignments. Each consignment consists of one or more containers. Where there are multiple containers. As each container arrives...

OK, figured it out. Correct syntax is ' Is Null ' Moderators, feel free to remove this thread

Trying to put a query together where the criteria is for books that have not been returned. The returnDate field in that the criteria relates to has no default value set for it, so I thought in the criteria I could just put ' = null ' but that doesn't seem to be producing any result. There are...

Thanks for getting back to me Beetle. Yes, the query uses criteria supplied by a control on a form. The form is open with the control containing the data for the query's criteria but still the error message persists

Hi guys, I have a report I would like to export to excel - well I want to actually be able to export the data that is in the report. After some searching on the forums I found what I thought was the solution but it throwing an error. The code is listed below Dim objXL As Object Dim...

Success!! Thankyou grzzlo, I must having been writing my previous post while you were posting. Thankyou again for your help, the learning curve is steep at the moment for me haha

Yeah I had a look at that before I posted pbaldy, but still having problems. I tried this: Me.exin = DLookup("USD_Equivalent", "tbl_rated", "Currency Like """ & Me.Currency_Name & """" AND "Dated = # Me.SailingDate #") But still get a type mismatch error

hi guys, I'm trying to do a DLookup specifying two criteria. The first criterion is a text field an the second is a Date field. Im sure I have the syntax wrong as the error Im getting is a Type mismatch error. Ive checked both tables where I am comparing data and they are both set to...

You can do it all from the form using VBA aiikahn. The code that I gave you works from within the form code.

Thankyou very much kind sir!! Kiwiman, your solution worked perfect. I was putting the DLookup on the Lostfocus event of the control I wanted to be as the target of the lookup. Thankyou again :)

John, could you offer any help on this?

I have used a table called 'RunOnce' that stores the date that a macro, query or some instruction has run. You create an insert query into the table, specifying the field, entering the date like this: CurrentDb.Execute "INSERT INTO tbl_RunOnce ( DateRun ) Select #" & Date & "#" Just...

Update: Tried the DLookup function with the following syntax in one of the fields: DLookup("PFO","tbl_Shipping_Charges","Item_ID = " & Me!ItemNum) However still no luck....