Search results

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

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

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

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

Ive spent the last hour and a half trying to sort this out. I know this is a dead simple thing to do but it just doesn't seem to be working for me. I have a form based on a table (tbl_MMT) that contains a combo box amongst other things. The combo box looks up values from another table...

This seems so simple but I cannot get it to work. I have read on a few forums and posts that the Like keyword cannot be used with a combo box string/value, although I don't have a reliable source to confirm this. My problem is as follows: I have a form called frm_converter which has a combo...

OK I know this question has probably been asked a thousand times but with the search tool on this site its hard to be specific since it seems to be cutting out words 3 letters long or shorter. What I would like to do is have Access only take up one window/icon in the taskbar. Every time I...