Recent content by philfer

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