Search results

Using ACC2007 and calling Excell 2007 I ran this module without issue last night but today it is throwing me a compile error as "object library feature not supported" with oSheet highlighted. The line causing the problem is Set oSheet = xlwkb.Sheets("qryGMExport") oSheet is dimmed as...

Thanks guys As soon as I put , dbOpenDynaset after the table name it worked a treat. Much apprecaiate the help - kicking myself too since as soon as I came to it I recalled visiting this issue once before some time ago - must be getting old :-)

I am trying to add some funtionality to a charity's database that I had nothing previously to do with. It was developed in ACC2003 and I am working with ACC2007 but still as an .mdb file Mostly I have managed to do what I need but on this one I get an "Operation is not supported for this type...

Thanks Pono Turns out it is a third party component. Currently trying to purchase. Help much appreciated. Best wishes Malcy

I am having to try and understand a vb.net app following the sudden departure of a clients developer. Most of it I can (sort of) follow but I need to find out how I can get to see what is going on in the class modules. Almost everything happens in one vb form and there are numerous examples of...

Thanks gemma-the-husky My concern is not so much how I can get in, but how can I identify where the code is that is affecting the startup. I thought that by disabling the AutoExec macro and also by "neutralising" the startup form I should have got rid, so I think you must be right about the...

I need to explore a secured db for a new client where previous arrangement had gone sour. They have password for the main db and this gets me in. If I do not hold down the shift key then I get a form that says db is locked but holding shift key gives me full access to the db. I am exploring...

I am having recurring issues where I am working on ACC2007 on my development system and then installing sometimes onto ACC2007 and other times onto ACC2003 (perhaps more relevantly Office 2003 or Office 2007) depending upon what the client has. Most of the time this is OK but if my VBA reaches...

OK Here is the whole sub. I know I am going to kick myself here!!! Private Sub cmdRptDatesOk_Click() On Error GoTo Err_cmdRptDatesOk_Click Dim dbs As DAO.Database Dim rstRd As DAO.Recordset Dim rstRep As DAO.Recordset Dim strQryDef As String Dim stDocName As String Dim...

Hi. I am having to make changes to an older db and decided to upgrade from ADO to DAO whilst I was at it (it made sense at the time). I am building a summary table to run a series of forms and reports. I know it is not the best way but it has worked. I append the employees to the table then run...

Thanks That did the trick. A nice and logical approach which was very easy to implement. Appreciate it. Best wishes

Apologies if this is not clear. I have set up report output to Word since formatting options are better but client now needs a new part added where instead of there simply being one entry to go to bookmark there is in effect a continuous report section which may have zero to perhaps 10 entries...

News to me. I have several Access front end databases that hook into SQL without a problem. The key issue to get the ODBC call set up correctly. Of course, I may have been lucky so perhaps best to wait and see if anyone else responds having had difficulties. HTH

Leigh I tried the suggestions made and they did not work so I extemporised and found a work around (perhaps more appropriate term than a solution). I am pretty sure I have had a similar SQL working previously and I know that I used to see the fields on my form when using wizard to link. That is...

Well for what its worth the solution, in my case, was to rebuild the combo boxes and then add .value to the SQL Why this was needed I do not know but anyway the new code is varProj = DLookup("[lngPr]", "tblProjects", "[lngPrEntity] = " & Me!txtEn.Value & " And [lngPrType] =" & Me.cboProj.Value...

Hi. Got a wierd one here. I am using ACC2007 but with an ACC2003 db format. Have set up a check to see if a project is already listed varProj = DLookup("[lngPr]", "tblProjects", "[lngPrEntity] = " & Me!txtEn & " And [lngPrType] =" & Me.cboProjType & " And [lngPrYear] = " & Me.cboYear) I can...

The above works because have created a new table where there are unique records so an unqualified DCOUNT will work. In your example I think you would need to qualify such as =DCount("StudentID","Tutorial Information", "TutorialNo = " 1) But you would need to play with that syntax on the...

Nice one Paul Thanks very much. I had forgotten that sometimes the solution is so easy!!! Best wishes

I am having fun! An insurance premium refund has to be calculated based on rates and number of days etc. The maths gives this a value of (for instance) 9.0083. This shows up in txtPremium as 9.01 which is OK. You then enter the amount of the refund (txtRefund) given as 9.01 and process the...

Thanks for help. It still glooped at the last record so moved processing loop to ' Load the first record ' rstAprProp.MoveLast rstAprProp.MoveFirst ' Set the counter lngRpt = 1 ' Start the looping Do Until lngRpt = lngCount Where lngCount is taken from a DCount of all...