Search results

Hi All, It's been a while :) I wonder if anyone familiar with Access 2007 could advise me here. I'm experienced with developing Access 2000 and I think 2003 but I'm relatively new to 2007 and haven't come across this before. The people I'm working with are saying that when they select a...

Hi, I'm wondering if anyone knows of any free or cheap software like Terminal Services or Remote Desktop but which I can use to link into an Apple Macintosh? (I'm presuming that you can see the desktop of any pc if you are logged in but just in case) thanks in advance.

Hello, When automating SaveAs in a macro, how do I stop the app switching focus to the new file? I want to do some more processing with the source file after I've saved it as the new file but I keep losing focus. And if I call Application.Workbooks("newfilename").Close, it closes everything...

Hello, I wonder could anyone help, rescue and succour me. As a former VB6 developer, I'm now working with wonderful Access VBA 2000 which makes the simplest operation such as creating a listbox or adding a control array into a living, breathing nightmare. Today's incubus is option buttons...

Hello I was wondering if there were any way to simulate the access Linked Table Manager programmatically? We have a SQL Server view in our app which fails to update correctly in Access unless the actual link is refreshed. I'd like to be able to do this each time we link up the app to the live...

Selecting a value from an unbound combo box in Access 2000 Hi, I am attempting to default a combo box to a value I have passed in. I have already populated the combo box dynamically by setting the column numbers and widths and specifying the row source as Value List, supplying the row source...

Hi all, I am trying to generate a query in Access which will return the last five comments on a case. The Access is linked to a SQL Server backend. I thought I'd try building a view there. I want a view that looks like Primary Key Comment ID 1 5 1...

Hi all, Could somebody confirm whether or not Excel 97 supports the .EnableSelection property on a locked range, and allows the cells below it to remain unlocked? I have a protected worksheet with a macro which allows the user to click on the locked row and paste the row information into a new...

Hi all, Could somebody confirm whether or not Excel 97 supports the .EnableSelection property on a locked range, and allows the cells below it to remain unlocked? I have a protected worksheet with a macro which allows the user to click on the locked row and paste the row information into a new...