I have installed a program on 4 different computers. On one of the computers the date and time functions do not work. It is running Windows98. I let Office2000 repair Access.
The rest of the program seems to be working fine. Any ideas as to what causes this problem.
Any help will be...
I need to compare the values in an object on the main form to an object on the subform. The main form (Donors) has an object called TotalCommitment. The subform (donations) has an object called Total. The following code gives me error message 2450. MSAccess cannot find a form named...
When I try to open a web page I get the following message:
Server error: Cannot open file "service.lck" for writing.
That file name might be "service.ick", I can't tell which.
I understand that this might be a server error. I have full administrative rights. My OS is MS...
My 3 column report prints right on my home and my office computers but when I install it on two others it only prints one column. They all are the same version of Access 2000.
All computers are set in Page Setup/Columns to the same settings for 3 columns. All other settings on the Columns page...
How can I pass a variable from the open event in a report to the report itself. The query for the report already has a couple of inner joins and a union. It is really complicated for me. Now my user needs some additional information that I need another query to calculate.
I then have to...
On Docmd.close 2 dialog boxes come up asking for values for Forms![Find Skills]!listFindSkill and Forms![Find Skills]!listFindSubCat.
These two criteria are used to fill the subcategory list box based on a value selected in the combo box. The other is used to fill the skills list box based on...
The code I am trying to used worked in an Access 97 application. However I am getting an error in 2000. Here is the code:
Sub cboFindLname_AfterUpdate()
Dim rst As DAO.Recordset
Dim strSearchName As String
Set rst = Me.Recordset
strSearchName = cmdFindLname.Column(1)...
I have a report built on a control source with 3 criteria based on a form. The report will run correctly if the form is not open and each of the criteria is entered when requested. If the form is open I get an empty record. The form name is "Find Skills", all the criteria is present...
I have a report built on a control source with 3 criteria based on a form. The report will run correctly if the form is not open and each of the criteria is entered when requested. If the form is open I get an empty record. The form name is "Find Skills", all the criteria is present...
I have a list box that works fine. My problem is that I need the selected value in the box stored in a varaible. I have tried the following in an on click procedure:
dim varC as string
varC = Forms![Find Skills}!listFindSkills.column(2) and
varC = me.listFindSkills
I get varC = Null
Any...
I need a good source for addins for MS Access 2000. I especially need the Switchboard Add-in.
I have searched on this and other sites but have come up empty.
Thanks for your help.
Jim
JimRich
Although I have been programming since 86 I have never actually programmed in VB6. However, I am teaching a High School class in VB6. I know that is not very good but it is my situation. Here is my problem.
I receive the following message when trying to set up a DBGrid.
No compatible data...
How can I disable or map the backspace key in MS Word 2000?
I teach kid how to type and they are frustring themselves using the backspace key.
I need to be able to toggle it.
How can I disable the backspace key in MS Word 2000?
I teach kid how to type and they are frustring themselves using the backspace key.
I need to be able to toggle it.
I have hyperlinks in a file that is used by everyone on my network. On one computer the word "hyperlink" and the bookmark are spelled out with {} around them.
Where is the setting to fix this problem.
Thanks!
Jim
I had a virus and this problem started after the virus was gone. Access 2000 has been reinstalled several times with the same messages reoccuring (I also reinstalled the operating system.) There are two messages that happen when I open Access one following the other.(They also happen if I try...
My form starts in Edit mode i.e. a blank entry form. When data is entered and the form is closed the save is automatic. That is okay. Sometimes the user exits without entering data. In that case a blank record is added. I do not want the blank record saved. How can I prevent a blank record...
I upgraded my computer to one that came with Windows XP. I have a program written in Access 97. Even though I installed Access 97 on the new computer I am having trouble with my program.
It is on my server and runs fine on the other computers on the network none of which are XP. I do not...
When my user enters a new child record, the last tab page causes the linking key to the parent record to be erased. The user selects the Source of Business from a drop down box; the cursor is moved to the end of the pre-defined text so additional info can be entered. Upon changing to any other...
Like many people I want a single button that will open a Word Mail Merge doc. What I would like is when the Word doc is opended it would have the fields already filled with the data and not have to run the Mail Merge function in Word.
My user will make a selection by Letter Name on an Access...
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.