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

Hi, Yes thats correct. but this happens only if the user is in the record. Otherwise when the delete runs the records simply disappears and the form is clean. This is a more elegant and professional look rather than the #deleted return. There must be a way to make the form work cleanly in...

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

Why do IT departments hate access databases so much ? cheers phil

Hi boyd Thanks for your reply The database is quite small and i am so far down the line i dont really want to start making big structural changes. If i create a blank back end i would still have to copy all the tables and relationships to it. Also having only one front end and many back ends...

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

Hi everyone, Thanks for your advice. I tried doing the above and imported the Excel worksheet into a new table called "Sheet1" I then tried to create an append query but am getting a little stuck. I feel I'm quite close Can you help Thanks Phil

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

Sorry HTH I take your point You are right I am getting right into Access and VBA at the moment and when I get into something I get over-excited and want to learn everything about it and build the best solution possible straight away. Thanks for your help Phil

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