Recent content by GRW

I'm after a bit of advice.... Have developed a booking system for a client, Access 2003 adp front end with SQL Server 2000 backend, they want to offer search and view facilities on their intranet and possibly on the internet. Very broad but Simple question, whats the best way to do it ?:eek...

You could try using the newer ADO extensions (ADOX) in addition to normal ADO. Try adding a reference to Microsoft ADO ext. 2.8 for DDL and Security (2.8 is my current version, yours might not be the same...) and run the following, Dim cat As ADOX.Catalog Dim tbl As Table Dim ColCount As...

Thinking of it, when you compile it should highlight where the problem is...

It's probably something as simple as misspelling a variable type, for example, somewhere in your code you could of typed dim str as strin instead of dim str as string

I might be wrong, only my views, but if you've got linked tables as opposed to an access project, the processing of data is all still happening locally inside of the mdb/mde instead of at the server end.

Something on these lines.... dim rst as ADODB.recordset set rst = new ADODB.recordset rst.open "TableName", "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\inetpub\wwwroot\webapplication1\dbs1.mdb" ' normal looping etc. here or test the open by debug.print rst.fields(0).value ' should...

Before I spend hours trying to code something, does anyone know of a way to stop a subreport splitting over a page. Main report with 8 subreports, in a sort of planner / calender layout, don't really want one of the weeks splitting over a page. Searched the forums, but can't seem to find a...

Just a confirmation, Intellipoint 3.2 & 4.1, do solve the problem and allow scrolling everywhere within access. Both can be downloaded from microsoft, but you do lose functionality of the horizontal scrolling. Gary

Glad its not just me.... I'm pretty sure its not an access problem as I tested it this morning on 2 machines, both identical full XP setups, XP Pro, Office XP + developer, 1 had the older version of intellipoint, 1 the new. The older intellipoint software worked fine until I upgraded it. Its a...

Has anyone else had problems with intellipoint v5 software where it no longer allows code to be scrolled using the wheel within a VBA window....!!!!! Scrolling works fine everywhere else, even the projects and properties area within the same window. Very strange...so much for buying a new...

Anyone ?

Is it possible, before I go mad, to create a sort of mailing label style subform... eg. records across then down Its for a course registration section which will run on a touch screen, The main form has 2 subforms, the user selects course from one subform, which then populates students in the...

Has anyone got any good ideas for AutoDialling from a form ? Using the standard command.... Application.Run "utility.wlib_AutoDial", stDialStr.... works but looks very untidy, dialer.exe gets loaded and you still have to 'OK' the number to be dialed. I would like something that looks fairly...

Thanks for the replys.... Rich, any idea where there would be any examples of this....coding wouldn't be a problem.... Just to explain the scenario... The system itself has several sub-systems. On a self created user form I want to be able to assign what sub-systems the user can access...which...

I want to reproduce something you see all the time within windows / access on a form but I'm not quite sure what controls to use... Its the situation where you have a list down the left arrow indicators down the middle and a list down the right....you then select something in the left box, click...