Search results

I have found what the problem is with sendkeys, but not sure what the sollution is though. if I press Ctrl + F1 in access it hides/unhides the ribbon, but if I press ctrl+F1 in the vba editor it shows the help, so not sure if anyone can tell me how to get the sendkeys "^{F1}" to affect access.

Hi Adam, Thanks, but unfortunately when I search the help there doesn't seem to be anything n minimizing.maximizing the ribbon in vba (I even tried recording a macro in word, to see if I could convert the vba to access, but righ clicking the bar and selecting the minimize records nothing!) I...

Hi, Does anyone know if you can setup a failover server when creating an Access ADP, the connection string you would use would be something like "Data Source=A;Failover Partner=B;Initial Catalog=AdventureWorks;Integrated Security=True;" but when you use the connections properties in Access I...

I dont know if it will work, but have you tried using format on your columns in your query e.g. format(field,"00.00000000)

Hi, I am trying to right a function to unhide a ribbon bar when a particular Report iss open, as Ctrl + F1 Hides/Unhides the Ribbon bar my thought was to test for the height of the bar and then unhide if required, the code I have is If Application.CommandBars("Ribbon").Height <> 147 Then...

Hi, Does anyone know how to build a toolbar in Access 2007 or is it something that in Microsofts wizdom (stupidity) they have decided to remove. I have a report that all I want is a simple toolbar that has a close button on it, as when I run the Access App in runtime mode there is no close...

Hi, I have a function in my MS Access 2007 database which is setting up an Excel spreadsheet, the only problem is I cant work out how to do the final change which is to make all the text in row 1 bold, I know that the command sI need to issue are as follows Rows("1:1").Select...

Thanks, It is an old project I have inherited, I just hope it behaves itself for the next few months, as we are hoping to move it to asp.net at some time in the near future.

This is very strange, yesterday I tried it on 3 or 4 Pc's (running Windows 2000/XP and Office 2000/2003) and it wouldn't work on any of them, I have even rebooted them multiple times (the app has not been working for a couple of weeks), but this morning everything works. Thanks for all your...

I will try removing the make table and see if that makes any difference, I somehow doubt it will make a difference as if I put a debug point on the command which is raising the error, I can go and look at the table and see the new data in it at that point. As for where it is being called, it is...

Just tried rebooting, but has made no difference, I have also checked the references, I have both compacted and repaired this database and copied all the objects into another db and compacted and repaired that db. What I cant figure out is why it also fails on source from several months ago...

Hi, It is Mainly 2003 SP3 (I have tried it on 1 Windows 2000 & Access 2000 machine), I have tried applying the HotFix but it has made no difference. Thanks, Gavin,

Hi, We have a database which hasn't had the code changed for months, but has all of a sudden started to error on the following line of code Forms![MainForm]![PaymentsSubForm].Form.RecordSource = "Payment" The table Payment is a local table in the mdb database and is created by a make table...

Retrieve Users connected to DB Hi, I am trying to write a form which can list the users connected to the current SQL Server Database in Access, only problem is I cant find a way of doing this without having security impacts on the server. I can use the following SQL to get a list select spid...

Hi, I am trying to use some Access 2000 code to change the access application title, but whenever I run the code I get an "Error 91 Object variable or With block variable not set" error message on the DB.Properties(prpName) = prpValue statement, does anyone have any ideas what I am doing wrong...

Thanks, In the end I gave up on Ms Package Wizard as it is far to restrictive and I am currently evaluating various open/closed source generic package wizards, which are more flexible. Thanks, Gavin,

Hi, I have just started to use the Access 2003 Package Wizard and I am having big problems, my problem is that any Access App deployed at work is installed under C:\MIS, but in there wizdom!!! MS have decided not to allow you to have anything but what they think you should have as the default...

Hi, If I understand you correctly, you need an additional column which is a simple count, so the first record in your top 50 would have a value of 1, the send 2 and so on all the way down to 50. If this is correct, the easiest way is to use the sample above (but you will need an unique...

For more detailed info, have a look at the following link http://www.pcreview.co.uk/forums/thread-1163742.php

Hi, As I dont know the structure of your tables, I can only make a guess, but if you have a unique column in your query you should be able to modify the following query to do what you want SELECT TOP 50 T.Column1, T.Column2, (SELECT COUNT(*)+1 FROM Sheet1 T1 WHERE T1.ID < T.ID) AS MyCount...