I am programming in Access 2002, Using Windows 2000.
I installed the new SP3 to my computer, and now when I try to create a query using the tables in access, it adds all the fields to the query, even if I have only added one. And I am getting compile errors in all my queries....
Does anyone...
I am using MSWord XP.
I have a word document that has three pages as part of the document. I merge the document and I get three pages for each one of my records, but I only want to print pg 1 for each one of the records in each section. Does anyone know how to do this easily.
I have tried...
You can create a folder and assign Security to the folder, what version of MS are you using, in Version MS XP, you would create the folder, then right click the folder and go to Properties then go to the "Sharing" Tab. You can have it so that no one can go in it but you, or you can...
I am using Access 2002 sp 2 on a Windows 2000 sp 2 computer.
When writing a query or code and a field is text or a string, what is the difference with an if statement when asked as follows, because I get different answers with each statement, and don't understand why.
Iif([field]=""...
Create a form that uses the table called members. Then Create an append query that uses the query from the form . Create a button on the form that runs the append query and appends the information into another table which has those fields as text.
Thank you very much SMedvid. Now I would like to throw a wrench in the question. The Report has Groupings on it. Each grouping could fall on many pages, now the client wants the grouping header with Cont'd if the grouping is continued on to another page. Is that possible?
Thank you again
I have Access 2002 and have a report that has about 100 pages, I would like to put Cont'd in the Page header on all pages except for the first. I would appreciate any help in making this happen. Thank YOU
I guess what I really need is a recordset. I'm kind of new to VB, but have been working with Access for a very long time. When I asked another Programmer (4d) for help, I was told what I needed was an array. I am using this for a show all form, where the Partners Name is in one field, and all...
I have an access 2002 database where I have two tables, a Fund table which lists funds and a Partner Fund table which associates many partners to many funds. I need to create an array that lists the partners once in one field and have another field that holds all the funds that they are in...
If you hyperlink the file to a button, or label it will open the file also. In the properties of the button or label, click on format, click on hyperlink address, click the three dots, browse to the file, click okay.
I am trying to update an open Access DB with information from a MS Word Macro, the problem is that it will not update the field, and I don't know what is the problem. It runs through the whole macro, and does not give me an error message. The following is my code.
Dim DB As database
Dim...
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.