Search results

hi, i am connecting to an instance of SQL server and selecting some records from a table. In Access the query takes 45 seconds to run. When I do the same thing in Excel it takes a second. Does anyone have any idea why this would happen. Everything is the same between the access and excel query...

Hello, When I try to import a sheet from Excel into an existing table I get a subscript out of range error. When I then import the sheet into a new table and then import it into the existing table I was trying above immediately afterwards it works fine What a mystery?!?!!? Anyone ever seen...

Hello, I have a form with a subform on it On the subform I have a button which I can add a record The added record appears with a button (which is on the subform) that allows the user to delete it. Everything works well unless the user is on one of the controls of the record to be...

Hello, When you open a DB and you get the prompt to "accept this content" is there a way to programatically set it to accept the content for the DB that is being opened. I am user navigation forms which will cover the screen and thus the user would not see this prompt. I dont want to change...

Hello, Whenever I open a form in acDialog it opens as a small window at the top left of the screen. In order to get it to show as full screen I use DoCmd.Maximize in Form_Load. However, this hides the statusbar which I use for updates/progress. Is there a way to get it to show as full screen...

Hello, Is there a way to completely hide/minimise the ribbon in access so that the startup form and the other forms it navigates to are the only screens/selections the user can press. I know in Access options you can set it to get rid of most of the tabs but I am still left with the home tab...

ello, Has anyone been able to deploy comboboxes as filters on a form satisfactorily. I have a form with several fields and am trying to use comboboxes as filter. The ControlSources for the comboboxes are the field from the table. It is easy with one filter. I just set the filter and then...

Hello Is there a saveas for a database in access I am creating a reporting database that will use new data each month and thus i want to open the previous months database get the new date and then save the database as a new version with a new name There is a saveas in the office button menu...

Hello, I am creating a database which has several tables and one of them needs information from someone elses database. I want to link the table in my database to theirs but I want to make the link read-only so that if I "accidently" change something in my table it wont mess up their database...

Hello, I am trying to import some excel data that comes from a daily extract into a database The problem is that the excel data is not normalised but the access database is. I am attaching the database below below as an example. The excel file Firstname Lastname Department Harry...

Hello, If stored queries are better to use than dynamic queries i.e. in terms of performance and compilation is it better to use a stored query for the row source for a form/report or even a control rather than type in the SQL into the property Is this also better for performance Thanks Phil

Hello, I keep seeing in books that I should construct my queries so that they can be optimized by rushmore technology, but I havent been able to find anywhere how to construct queries in this way or how rushmore works and what exactly it looks for in a query in order to optimize it Does anyone...

Hello, I have these two pieces of code in a book :- 1) Dim cmd1 As ADODB.Command Dim rst1 As ADODB.Recordset Set cmd1 = New ADODB.Command With cmd1 .ActiveConnection = CurrentProject.Connection .CommandText = "SELECT * FROM mytbl;" .CommandType = adCmdText End With Set rst1 =...

Is there anywhere I can get a full list of all the properties I can set with the above code. An example wiould be CurrentDB().Properties("StartUpForm") Is there a list of all the properties I can set with this. (I tried Access help and the object browser but came up with nothing Thanks Phil

Looking at the ADO object model is there an equivalent way of creating a stored query as you can with the QueryDef object in DAO or do you have to revert back to DAO (which I assumes was being phased out in favour of ADO) Thanks Phil

Hello, How much slower is it really to use dynamic queries. In Access and Access VBA books which cover ADO you always see recordsets built with SELECT queries in VBA. These queries, which I assume are the definition of dynamic queries, as they are built on the fly with parameters supplied by...

I came across the following line in a piece of code :- Set RS = CurrentDb.OpenRcordset (SELECT * FROM mytbl;) I feel confident enough to assume that this is not ADO, but is it DOA or something else. There seems to be so many ways to interact with tables/queries (ADO, DAO, dynamic queries in...

When working in VBA is a connection string really necessary, even a simple one like CurrentProject.Connection. In Excel VBA assumes you are working with the current file Is it necessay to have a connection string every time in Access Thanks Phil

Hello, What is the difference between the Screen object and "Me" Dont they both refer to the active form? Is there any difference really? Thanks Phil

What is a stored query? Is it just a query that you create in design view that is saved in the db (and thus compiled) that you can execute in vba with :- DoCmd.OpenQuery or is there more to it? Thanks Phil