We are a bit behind and all of our access databases were created using Access 2003 and are being run using either Access Runtime 2000 or 2003. I have a department that runs several of these programs. Each program is it's own .mdb but they all link to tables in another .mdb, a client list, that...
We are running out of space on our GroupWise 7.0 server. I happened to notice that we have 2 different OFFiles folders (From what I read, this is where file attachments are stored). One, the correct one, is at the same directory level as ofmsg and ofuser folders. The other is inside of the...
I am using the Microsoft Web Browser Active X control to display a web page, based on information from the form. However, when I go to the next record the old data still appears. I know that I can just redirect the control after switching records, but i really don't want to display the page...
I have a report that works fine on my computer. However, when the user opens the report, one fields' information is not showing. It is just blank. Has anyone else had this problem? I'm using Access runtime 2000, though I modifying the database in Access 2003.
Melissa
Designing Access...
I have a secured database used by several users. It has an autoexec start that opens the main manu. On one machine, nothing opens after the login, it just stays at a gray screen. I even try logging in as me and I get a gray screen. I can log in as either of us on my machine with no problem. I...
I have a query that pulls data from three tables. Table1 contains all clients. Then each client has a record in either Table2 or Table3, but not both. I need to pull a time field from either Table2 or Table3, which ever one they have a record in, and be able to display this on a form in one...
Here's my problem. We use Access 2000, for both front and back end. We are looking to move on to SQL Server and we have no idea what to use for a front end. We thought we'd stick with Access, but I don't want to limit what we can do with sql server by doing that. We took some courses in SQL...
I have a user who is having a problem when printing from Publisher 2003. Each time they print a publication, they are forced to press the form feed or continue button on their printer before it will print. They have no problem from any other software, including other office products. They all...
I have a user who needs to manage two mailboxes. We had a forward rule set up, but then she has to delete all the items from her mailbox as well as the other. So, I had the other user give her proxy access to EVERYTHING mail, appt, tasks - read and write and allow to subscribe to notify and...
I have read thru some of the other responses to questions like this one, but have not found anyone having this problem. I have some fields that I wish to be required. I have set the required property to yes in the table. On my form, I have but an On Error event procedure, so that when a user...
I have the following code from Microsoft's site for skipping used labels when printing mailing labels.
Option Compare Database
Option Explicit
Dim intLabelBlanks As Integer
Dim intLabelCopies As Integer
Dim intBlankCount As Integer
Dim intCopyCount As Integer...
We're just getting into SQL. Took two 1-week courses on it 2 years age, so I'm a bit rusty. I have a Microsoft Access database that I have upsized to a .adp file and linked to the tables on the sql server. Now, all of my queries are gone. I have to create views now, right? How do I create a...
I have a database that has some tables in it that other databases need to link to. However, these tables have information in them that needs to be secured. Once I secure the database with the tables it in, the other databases don't have the ability to access those tables. Now, when going thru...
I have a Sql 7.0 Server. It has all current patches. It is running one application. We have been getting errors which bring the server to a crawl. We have contacted the creators of the program, and they say that it is a problem with our server not their app.
Error 1
The VB Application...
I posted this in an Access Forum, but haven't gotten a response yet, so I thought I'd try here. I just got a new PC with Windows XP. I have installed Office 2000 and my Accees is acting a bit strange. It freezes up quite often and the display keeps going crazy. One minute it'll look like I...
I just got a new PC with Windows XP. I have installed Office 2000 and my Accees is acting a bit strange. It freezes up quite often and the display keeps going crazy. One minute it'll look like I have no forms, but if I click on Reports and back to Forms, they come back. I figure maybe Office...
I have an input box that a user will type in a password in order to close the database. Is there any way to put an input mask of password on that input box? Melissa
Designing Access databases since 1999
I have a database that users are going to be searching thru. They select a search criteria and a screen comes up with the results. I would like to able to print that list of results. The problem is, the users can actually view ALL of the records if they want, and I don't want them to be able...
I have an Access 2000 database that is going to be used by the public and I would like the database to remain open until a staff member wants to shut it down. Obviously, I can just not put an exit button on the Main Menu, but that doesn't keep users from clicking on the "X" to close...
I have a secured database that I need to make a change to a form in. I login as me, I have admin rights, but when I go to design view of my form, it tells me that I 'do not have exclusive rights to the database at this time. If you proceed to make changes, you may be unable to save them...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.