Search results for query: *

I have 2 windows 7 computers on a network. One has a Sql Server 2008 database, I can connect access 2007 to the sql database from the other computer and everything works fine. But when I close Access 2007, and then run it again, it won't find the database (password is saved). If I do...

I have several large reports for which that I produce "Tables of Contents". I have a table with two columns, description and pagenumber. In the On_Open module I run a query that clears this table. In the On_Format module of the group header, I add a line to this table, consisting of the group...

I am using the demo code in the document that comes with the GMSprocs, and it's killing me. GMV_NV_SetValue is returning a null value for the maxindex and there is nothing in the table it creates in tempdb, although the column names are there. I am pulling my hair out, any tips ?

Problem solved, never mind

I just migrated goldmine sales and marketing 5.5 SQL Server version to a new server. Although we have a 15 user license, it's only letting 5 people on. We get a message that says it's from the server that the "standard license 5 user limit exceeded" .

OK, I've found the extended proc, You guys have been very helpful, although I'm sure I have not asked my last question on this subject. Thanks again

How would I create it?

I have that zip file (gmprocs.zip), but I can't find the extended stored procedure xp_GMNewRecID in it. Is there anothe r file I need?

I can't find xp_GMNewRecID in the Master database of this Sql Server version of Goldmine 5.5. How is this extended proc supposed to be installed? Does it come with the installation CDs? Is there somewhere to download it?

Thats a good book. I just finished a conversion and basicly, you can keep your forms and your reports, but the VB code will have to be changed if it does any data handling. Queries will have to be replaced by stored procedures or views. I found it helpful to paste the SQL from my access...

I use the following bcp bwsql..saleinfo in saleinfo.txt -f saleinfo.fmt -Usa -P bcp works fine with Sql Server 7.0 on an XP pro box, but the same statement doesn't work with SQL Server 7.0 on an NT based machine I get an "attempt to read unknown version of bcp format file" error. The...

You can put a program break on the sendobject line and check the values to see if they make it this far. maybe create a logfile and log the email values if it is a hard to reproduce problem. Have you changed the Email program, or patched the system with security patches? Are all the users...

Can you see the code that sends the email? Is it using sendobject?

You can use SENDOBJECT to call you default email program and send the email. There are some problems with this, for example if you use Netscape Mail, (not Netscape Messenger), the email address won't come thru. syntax example DoCmd.SendObject acSendReport, "ReportName", acFormatRTF...

you could do this query1 select dps1 as dps from table where not isnull(dps1); query2 select dps2 as dps from table where isnull(dps1) and not isnull(dps2); query3 select dps3 as dps from table where isnull(dps1) and isnull(dps2) and not isnull(dps3); Union query select dps from query1...

Just for giggles, rename the development mdb's and see if production still opens the ldb there.

Create a table called "criteria", with columns corresponding to the values you wish to pass. (example: Customer, Date, Item) In your code when you wish your query to run, clear this table, then write what you want to pass to the query. Have your query use this table .

instead of LIKE LEFT([PRODUCT #],7)AND "-C" Did you try LIKE LEFT([PRODUCT #],7) & "-C" & is the operator for concatenation (joining strings)

You could write 5 simple queries like this, Select Action Item 1 as Action Item, Completed 1 as completed from whatever; Select Action Item 2 as Action Item, Completed 2 as completed from whatever; etc. then write a UNION query. select action item, completed from query1 UNION select...

I am trying to automate the following process. 1) send report output from several reports to adobe acrobat. 2) merge the resulting pdf files into one file. 3) email the resulting file to an address in an access table. Any tips would be greatly appreciated.