Search results

Thanks for the responses. I will try both of those.

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...

Hi all Just to let you know that this thread in particular helped me out: http://www.access-programmers.co.uk/forums/showpost.php?p=525662&postcount=6 so thank you very much, Bodhisatva. Just to add as well - there's a bug in Microsoft that means if you use the CurrentDB object to reference...

The numeric values are probably being stored in lookup tables somewhere. You will need to design a query joining the numbers to the corresponding numbers in the lookup tables and export the results of that into excel.

Ah. So you've been programming in Access that long :p

Colin - THANK YOU THANK YOU. That did the business. Christ I want to buy you a pint. Or several of whatever it is you're having yourself! Bookmarking this...

Try http://www.microsoft.com/technet/scriptcenter/resources/officetips/jun05/tips0607.mspx

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...

Try importing a smaller chunk of the spreadsheet to see if you get the same error. The size of the file may be too large for Access to deal with, especially as there may be a lot of rows. Alternatively check and see that the data in the excel spreadsheet is clean. Often what happens is that a...

Thanks very much for your assistance with this!

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...

OnMouseOver event?

Since you have the dates in SQL Server format, you might have problems with the "greater than" comparison evaluating the date correctly. You are better off using a date-specific function such as DATEDIFF in your Iif function call, or better still, design a specific function to compare two dates...

Rob I apologise for getting back to this so late. Thanks for your help. It wasn't a stupid question - I hadn't bound a column since I assumed that my combo box being unbound to any table meant that it was pointless to have one. I was wrong. I now have a hidden bound column in my combo boxes and...

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...

or if it is in Access and bound you can requery

My boss found the solution to the problem. It's a self-join: DECLARE @NumberOfComments INT SET @NumberOfComments = [value here] Select PrimaryKey, CommentID, comment From Comments_Table as A Where (Select count(1) From Comments_Table Where rfino=A.RFINo and CommentID >=...

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...