Search results

Can someone please tell me where I am going wrong. I want to import a single worksheet from a workbook using Transferspreadsheet. This is what I have so far: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp", False, variableSheetName I think there should be an exclamation...

The_Doc_Man, can you elaborate? How do I do that exactly?

I want a list of each sheet in a workbook. Can someone tell me where I have gone wrong here?: Sub ListSheets() Dim exlObj As Object Dim exlSht As Object Set exlObj = CreateObject("Excel.Application") Set exlSht = CreateObject("Excel.Sheet") exlObj.Visible = True With exlObj...

Your question has made me realise what an idiot I'm being. Of course it is the subform's recordsource rather than the tabcontrol page's. Fixed it now no problem. Think I've just been staring at this for too long today. Thanks anyway!

I need to assign a subform to a specific page of a tab control using the form on Open event. Can anyone give me the reference for this?

The tables are all linked, but I have a couple of make table queries and need them to create the new table in the source database rather than the current one. I did what you suggested and it works fine. Thanks.

Ok thanks, I feared you would say that! I guess I will just have to re-create them all in code then. Alternatively is there a way of globally setting the destination path for a database?

Can someone please tell me how to set the DestinationDB property of a query programatically?

Could do but wouldn't that mean that I could then end up with partial updates if one block failed, as I would only be able to roll back before commiting the transaction. I just got this from Microsoft, do you think this will deal with the problem ? DAO.DBEngine.SetOption dbMaxLocksPerFile...

Anyone???

I'm trying to run a routine under XP that worked perfectly well under NT 4.0/Novell Netware, but keep hitting a record locking problem. The error says the file sharing lock count has been exceeded. I'm using the .edit / .update method to write new values to specific records in a table of over...

Thanks for the advice.

Sounds good. If we had a 2Mbps broadband connection this should be sufficent I think. Currently we use peer-to-peer, is that a problem do you think?

There are less than 10 users. Perhaps WAN would be an option, but it'll be a costly mistake if it doesn't work (particularly for me)! How does terminal services work?

I have a project to work on that involves one database (albeit two copies) between two sites. Basically the users from both sites need access to current info throughout the day. I realise that replication is a possibility (though not ideal for this application), but can anyone suggest a viable...

Not a best seller then?

Very helpful, thanks.

Good spot, I looked on Ebay but didn't see this one. A question, can Access 97 be installed on a machine running Office 2k, and run along side A2K?

Has snyone read the freelance consultant book advertised on this site? If so is it any good?

Hello, Apologies if this is not the right place for this post. Does anyone have a copy of MS Access 97 they want to sell? Seem to have mislaid my copy and I need one fairly sharpish!