M8KWR
I am having some problems and need some assistance. I don't have a SQL backend. We have the Goldmine database files on a file server. I am trying to create the DSN File on a workstation where I have the MS Access Report Writer I created and I receive the following error:
You cannot use...
M8KWR
Thanks for all your help. I am having some issues. Any suggestions on linking the tables. I keep getting an error saying some user and some unknown computer is connected to the database. Any advice?
Can anyone tell me how to setup an ODBC connection and what Goldmine tables to connect to use Access as a Report Writer for GM. I want to use MS Access to pull data from Goldmine to run a report based off of the contact and contact history database. I have imported the tables into Access...
Hi Doug
I wrote some custom reports in Access and I want to pull data from Goldmine into Access to run the report. I want live data written in one direction.
I don't want to go through the trouble of manually importing the data rather just connect to the GM database and pull the data.
Any...
Hi Chad
Thanks for the email. I'm not connecting to the wrong database. I connected to the Contact1 database, which is several hundred megabytes. Any ideas?
Thanks,
Dave
Hi Deborah
I hope you had a nice holiday. I started playing around with your instructions which worked very well. I was able to connect to the GM database, but I have a problem. It only brings 1 record into my spreadsheet.
Any ideas?
Thanks,
Dave
I want to thank everyone for their help. I will go ahead and try everything you suggested.
Deborah - I'm having trouble with Access seeing the Goldmine Date as a Date. So when I run a filter I get records outside of my date range.
I have that post titled: Date Filter in Query not working...
Thanks for the tips guys. DataDiva they doen't want to purcahse anymore software.
Hap how do you put Access in Exclusive mode? And is there any way for me to prevent users from writing back data to access? I want one direction read only access.
Thanks,
Dave
Skip
I figured out why the date filter was not working correctly. It was becase I had other criteria specified in another field to filter "ES" and "NS". This creates another problem for me. Because I am trying to filter new sales and existing sales when I specify the dates after the ES and NS...
I have a query that filters certain dates using the command Between [Enter Begin Date] And [Enter End Date]. When I enter the dates to run the filter the query runs, but I have dates outside of the scope. Any ideas? Thank you in advance.
We wrote a MS Access database to create custom reports from the Goldmine 6.0 tables. We did this because it was easier to write the reports in Access than using the Goldmine Report writer. I am running into problems though:
-I need to link the tables from Goldmine to MS Access. When I do this I...
I have an issue with printing to my local printer with remote desktop.I have a Dell 720 printer and when I connect to my remote PC my local printer is displayed in my printers on my remote PC and even goes through the setup of aligning the printer, however when I go to print test - it says...
I've narrowed down the problem - it is with the date field. Eash donation is tied to a date. The date is very important because I need the report to be between a certain date range, but the problem is the Amount field cannot sum itself properly when the date field is in there, but if I don't...
The database is broken in 2 tables - donors and contributions
The donors has an ID field
The contributions table has an ID field and a NAMEID field. The NAMEID field is the foreign key.
Both tables are linked.
Will this affect our the Group By feature works?
Ginger
Thanks for the reponse. This helped, but its only taking the sum for that single record? Do if donor1 gave $20 the sumofamount is $20. My quesry lists all the donations a donor has given, for example donor1 has made 10 - $20 donations. I want th sumofamount to equal $200.
Any ideas?
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.