confused99
Last Activity: Jun 20 '07, 01:00 PM
Joined: May 23 '07
Location:
-
Form Filter
I have a form (Form1) which has a field called 'ID' and a command button. When I click on the command button, another form (Form2) opens and the value of the field 'ID' is taken from Form1 to Form2. But sometimes, Form2 gets a filter from somewhere and a different value of ID is stored in the field. When I remove the filter in the form properties, it works fine for sometime. But this occurs again after sometime. Please help me out -
Object Variable Or With Block Variable Not Set
Hi everybody... I've been working on moving access data to a word document for the last 10 days but keep getting stuck. The latest problem is that i'm getting the error "Object Variable Or With Block Variable Not Set". The code is as follows.
Dim objWord As New Word.Document
Set objWord=GetObje ct("C:\Abc.doc" )
objWord.Applica tion.Visible=Tr ue
objWord.MailMer ge.OpenDataSour ce _
... -
Can anybody tell me how I can get a sub form which displays data from a table to export the rows to a Word Document? I tried the lines in the post above this. But I'm getting a few errors related to Object Variable. I'm new to Access and I don't have a clue. Please help.
Could you also please tell me how I can make these values appear in the Word Document wherever I want?? I need help in setting the markers. -
I tried doing as you said. But there seems to be a bit of a problem with the syntax in a couple of places. Please help me out...Leave a comment:
-
Linking 2 Databases
How do i get a query in 1 database to fetch results from a table in another database?
I am using MSSQL 2005 -
Access and Word
I have a report template in MS Word which has a number of blank tables where data needs to be filled apart from some static text.
All the data that should go into these tables are in a MSSQL database with Access as the front end which has all the forms. How do I make Access generate reports on the lines of the template with all the data from the database tables added to the static text?
The template is not just a single... -
Using AutoNumbers
I have a Table with an autonumber as the ID. I'm trying to get a form where i have a drop down box which displays all the ID values from the table and on selecting one of the values, i want the other fields in the form to get automatically filled by reading from the table.
But i'm not able to do this because i keep getting an error message saying that the auto number cannot be manually updated, which is not what i'm intending to do.... -
Linking 2 forms
Hi there
I have a form (Form1) which has 2 command buttons. One button opens Form2 and is linked to form1 by a field and on using this, the values in Form1 are transferred to Form2.
There's another button which is supposed to open Form2 with all its fields blank (it should be pointing to a new row in the source table). Plz gimme tips on how this 2nd thing is to be done.
I managed to do this in a slightly untidy... -
Two Access Questions
Hi
This is my first thread here. I have a project in MS Access and i have 2 problems related to it.
1. In all the forms where i have the navigation buttons, the delete button is disabled. I am able to delete records by selecting one of the records and using the delete key on my keyboard. But the delete button on the navigation bar in the form is always disabled.
(In the form properties, i have enabled deletions)...
No activity results to display
Leave a comment: