Search results

This morning when I checked my email I had a long list of messages from Access World Forum notifying me of responses to old postings. I had already read all of these responses. They go back for about one year. Does anyone know why I received these notifications? It's not a problem. I'm...

We are running Access 2003 over a thin client. There are up to eight users, each have their own front end. Yesterday Access started periodically displaying an error message that said it had encountered a problem and was shutting itself down. My thinking is that the problem has to be with the...

I have inhereted a Word project that contains a lot of graphics made using boxes, arrows, etc. made with the Word drawing tools. Whenever I insert new text or change the formatting on pages before these drawings, the boxes and text in the graphics shift around. I tried making text boxes and...

We are using Access 2003 and printing to an HP Color Laser Jet 3600dn. Reports will print, but attempting to print the results of a query causes the following error message to print: PCL XL error Subsystem: KERNEL Error: IllegalTag Operator: OpenDataSource...

Has anyone had people using two different version of Access for their front end? We are in transition from 2003 to 2010. The back end is in 2003. One user already has 2010 for the front end, but the others still have 2003 (at least for a few days). Thanks, Cherry

I have turned the Microsoft website upside down trying to find the VBA 7 Reference Manual. No luck. Can anyone point me in the right direction? I have to rebuild our Access database almost completely. None of the buttons, macros, combo-boxes built with 2003 work in 2010. And none of the...

Hi. My name is Cherry. I have been popping in and out of this site for a couple of years, but have spent more time here in the last month or so than the rest of the time combined. I want all of you who answer our questions to know that what you do is incredibly valuable for people like...

My new Access 2010 will not allow me to change the file format on any of my existing databases to 2007. I was advised to go to File>Save Database As and then select the 2007 format. However, Access will only offer me the old .mdb selection. Could this be because we skipped straight from 2003...

I have a database for which each user has their own copy of the front end. The backend sits in a central location on our network. I have just upgraded from Access 2003 to 2010 and find that, if you are in the backend, you can modify tables on the fly. Is there a way to keep my users from...

I just got Access 2010. My database is currently in version 2003. I've searched the Microsoft site for how to change the table format to 2010, but I couldn't find anything. Can anyone point me in the right direction? Thanks for your help. Cherry

I found this message somewhere on this forum and cannot get back to it. If 2007 won't run code from 2003, then I'm assuming that 2010 won't either. I do not understand the implications of 'trusted location' or 'explicitly enabled'. I have a couple of pretty complicated applications that were...

We are currently using Access 2003. I realize that it is going away and we have been planning to move to 2007 for nearly a year. Now that 2010 is out, our IT guy wants to move us straight to 2010. The upgrade is finally scheduled for early June. I am skeptical about moving to a brand new...

I have a small Access 2003 database which contains master records for our staff. There is a browse window in the master for which displays their hours of continuing education. This database is sitting on a network drive. I can open the database and view the master form with no problem. When...

I'm working in Access 2003. I have a field for gender in a form. The user will enter either F or M, but cannot leave the field blank. I am running a procedure on the Exit event which gives an error message if the field is blank, but I can't stop the insertion point from moving on to the next...

I am using Access 2003. I have a lengthy questionnaire which contains mostly yes/no and multiple choice questions. On some questions a follow-up text field must be filled in based upon the answer that was provided in the multiple choice block. I have to generate a report from this data which...

We are currently using Access 2003, but will be upgrading to 2007. I just don't know when the upgrade will take place, but I suspect it will be a few months from now. I want to develop an application which will be delivered to our end users as a runtime. The application is for a fairly long...

I have an Access 2003 database of client records. The data is in a backend and each of about six users have their own individual front ends. My problem is that if one user adds a new master record the other users cannot see it unless they exit the data entry form and open it again. The master...

I'm currently running Access 2003. My database contains master client records, each of which has as many as three types of child records. My database is set up so that the child records will be deleted if the master is deleted. I have made a query writes out a table containing the ClientID...

I have a report which is run monthly. It is a list of clients for which we have provided services during the previous month and it totals the hours of service per client and at the end of the report. I now need for it to sub-total within each client's transactions for each calendar week during...

I am working on an employee information database in Access 2003. I have a combo box at the top of my form which is used to select which employee to display. After the selection has been made, I want the combo box to return to being blank (like it is when I first open the form). Currently, the...