Search results

Hi, I am trying to explain to a user why we need to split a database on a server where it will have multiple users. I have explained the problems they can have if they don't, but they are now seeing why this would be since it is another mdb file. My question: What makes it different then just...

Hi, I have just upgraded an Access application from 2003 to 2010. In this applications I have reports that they run. The users are telling me that the reports are taken longer to run, in some cases up to three minutes longer. The thing is that I did nothing to these reports. I did to some...

Hi, I have an 2010 MS Access application on a sever. I created a new Quick Access Menu bar (with just the items that the users wanted). I imported it into the application; and it works great for me. However, when someone else logs into the server, they do not see the new toll bar (menu). How...

Hi, Actually I have two questions on the same thing. 1) I just took a 2003 application and moved to 2010. it is working great, however, I kept it as an .mdb file. Should I have changed it to a .accdb file, and if so how do I do that safely? 2) Then I am putting this on a server for multiple...

Hi, I am working in MS Access 2010. I have a Datasheet view and if you click on a cell in the view it highlights the entire row. it does not seem to allow the user to change anything, which is a good thing, but the user does not want it to do that. Is there a way to stop it from highlighting...

Hi, I am a contractor, that was brought in to make some enhancements and upgrade their application from Access 2003 to 2010 and put it on a sever. Now I know the first thing that you will say here is that they need to spilt it in a front end and back end and it is what I would do to; but they...

Hi, I am trying to set the default value on a combobox. And maybe I am saying this wrong for wha tI want to do, if so I am sorry. I wrote SQL statement that populates the combobox, and that works; but when I ran the application initially the combobox is blank. If I click the arrow I can see and...

Hi, First, I am sorry if this is not totally clear as I have not done this to much. I upgraded their application from 2003 to 2010. However, the users are telling me that they would go to External Data --> ODBC Databases they would put in the credentials and would get a list of link tables to...

Hi, I have been asked to do something to prevent the users from going into the customized menu strip on top of the MS Access application. I searched the net but cannot find anything. I want them to be able to use it, but not make changes to it. Can someone tell me how to do this, if it can be...

Question about the find dialog box Hi, I just upgraded and application from MS Access 2003 - 2010. In the old application they had the focus set to an textbox on the form that haled and ID field. Which I set up the same in the new application so when the form loads the box has the focus. In...

Hi, I just upgraded an application from 2003 to 2010, and put it on a 2008 server; and it is working great. However, the users are going to go in there and start testing it in a week or so. They told me that when they put it on the server before and multiple users tried using it, they would...

Hi, I am working in MS Access 2010 I found some basic code to hide the ribbon, and I could just go into options to do this too. However, either way I want to be able to hid the ribbon, and still keep the quick Access menu that is above it. I cannot find how to do this does anyone have any...

Hi, I am using MS Access 2010. I looked up how to set a timer. I want to set a timer for form inactivity, but before it even gets to my code it comes up with that Form_Timer() function is not define. what so I have to do to define this? Thank you My code: Private Sub Form_Timer() If...

Hi, I have and MS Access application that I upgraded from 2003 to 2010 on my local machine, and it works great. I then put it on a 2003 server with office 2003, and though this in an 2010 application that I copied there; it also works great, much to my surprise. However, in the end we want it...

Hi, I have been looking every where and I cannot find this. I need to create through code a subform on a main form. We have a main form that has textboxes that get populated with data on the top of the form and on the bottom of the form they want to be able to hit button and bring in any one...

Hi, I ma trying to find away to check is a textbox on a form in null then I want to put a certain value in there. Actually I have about 15 of these text boxes. Therefore I am trying to use a variable and as the for loop go through each one, it checks to see if the box is null, and if it is it...

Hi, I have atable with ID ranges like this: ID1 ID2 Logo 1 50 HO 51 75 HY 76 100 GM I want to know how I would write a SQL statement that would find which logao given a certain input. So for example, If I had th euser enter 53 from a textbox on a form it should...

Hi, I have an Access 2003 application that I am developing, and need to create controls based on what a user selects in a list box. So, if the list box has three entries and the the user picks number 2, I need to create two text boxes. If they pick three then create three boxes. I did this...