Search results

Gizmo, Thanks for that, I've looked through a couple of the slides on that page, even if it's not what you hoped it was! I'm not too worried about MySQL / MS SQL, what I'm more concerned about now is programming in ASP. Can I do that on an ASP.NET server? I know it means writing more/complex...

Apologies if this is a really dumb question but: I need to build a website in ASP/ASP.NET. I'm not sure which my client has It will be connected to a database, either MS SQL or MySQL, again I don't know which. For development I want to get a webhost and it's much easier to get ones with...

Props to AnnPhil for a dead simple solution for something that, frankly, a huge number of people ask for.

Ah, the perils of being self-taught and not really understanding (from a Java p.o.v.) the haphazard error handling! Thanks nam

My code is currently running the error handler even if I comment out every single line (apart from strErrMsg and On Error GoTo) in the code, which seems to run perfectly anyway! Function fDeleteXtabs() 'deletes xtab(n) queries 1-9 On Error GoTo fDeleteXtabs_Err Dim strErrMsg As String Dim...

Sorry, that would work if it was an ordinary query, but because it is a crosstab query and I am using the Nz function to include records where there is no data, it is still returning a value even when there are "No current records". The only solution I can see is to get it to load the query as...

Excellent, thanks Smart, that worked.

How can I check from VBA whether a query I have created has no current record? I'm trying to prevent my code from opening a form based on this (crosstab) query if it is empty like this. I have tried using the Report_Error event and also GoTo Err technique inside the report (On NoData event...

Incrementing the counter... old Java habits die hard. 4 lines of code, 1 was redundant, 2 are fine and the other was TRYING to demonstrate what I was trying to do. That's hardly "completely erroneous". Thanks for your help.

I think the title describes what I want to do, but: For example, I want to create multiple recordsets with names created dynamically. For intX = 0 to 5 Dim objRST(intX) As Recordset intX = intX + 1 Next Creating 6 recordsets named objRST0 ... objRST5 I'd then want to process these...

Ah.... ambiguous code. Thanks Bat. WHY ON EARTH doesn't VB/VBA pick up on this? I'm really beginning to hate the loose, silent-error-handling, "RAD" environment! Apparently VB.NET/VB7 is different...

Thanks Sam, really appreciate that. It worked, up to a point... as with your first posting I had to fiddle with the Header.Caption to get it to work, however, this time it didn't. I've put this on the back burner now in favour of an export-to-excel, but I may return to this as it will likely be...

I'm on the work network machines. We have Office 10 and nothing else. I have just tried Compact and Repair. Specifically, the error is: "Run-time error '13' type mismatch" Private Sub Export_Test_Crosstab_Click() Dim xlApp As Excel.Application Dim xlSheet As Excel.Worksheet Dim...

When I import all of the objects in a sample database, the code that worked before no longer works. I have been through and checked the References in the editor, and they are identical. I am working in Access 2002, and I think the sample database was made in 2003. They are both in Access 2000...

Thanks for coming back Sam, I well understand the principle (and getting to that point has taught me a lot). I think I even understand how Access prints the rows in the detail section. I have already purchased two Access books (Access 2003 Bible and Access 2003 VBA - Programmer's Reference)...

Please? Anyone? Look at the number of views this is getting - so many people need this or similar solution!

Also trying to bring this to the top. I have an identical problem. I have seen mentioned a solution by setting Me.nextrecord = False Could someone explain to me where this would go? I have tried Detail_Retreat and other places to no avail. All I end up with is infinite(?) number of duplicate...

Joe, I don't have the foggiest what you're trying to say... I guessed at the syntax and just put into the open event: row_identifier.ControlSource = "qry_person_is_employee." & GLB_rowSelected And it worked.

OK. I've managed to do that, I hadn't realised that you needed to declare a Global variable in a normal Module, not in the form module. I've tried every way I can imagine, but I can't seem to dynamically set the control source of the row headings. i.e. the field selected by the user needs to be...

I got an error: "Cannot use the crosstab of a non-fixed column as a subquery." For anyone else doing this, you have to explicitly define the possible column headings in the SQL TRANSFORM statement in RecordSource. How do I: "grab the appropriate global variable and place it in the report's...