Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. biggoober

    Sql-Access Connection problem

    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...
  2. biggoober

    On_Format not firing for whole report

    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...
  3. biggoober

    GMSPRocs problem

    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 ?
  4. biggoober

    5 user limit on 15 user license

    Problem solved, never mind
  5. biggoober

    5 user limit on 15 user license

    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" .
  6. biggoober

    xp_gmNewRecID missing

    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
  7. biggoober

    xp_gmNewRecID missing

    How would I create it?
  8. biggoober

    xp_gmNewRecID missing

    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?
  9. biggoober

    xp_gmNewRecID missing

    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?
  10. biggoober

    From Access to SQL Server

    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...
  11. biggoober

    bcp problem - OS related?

    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...
  12. biggoober

    Automatic e mail from access sending blank report

    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...
  13. biggoober

    Automatic e mail from access sending blank report

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

    How can I send email automatically from MSAccess using vba code

    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...
  15. biggoober

    need help with query

    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...
  16. biggoober

    ldb Mystery

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

    Passing a string into a query criteria

    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 .
  18. biggoober

    linked tables not giving query answers I need

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

    query problems

    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...
  20. biggoober

    Email and Adobe Acrobat from Access

    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.

Part and Inventory Search

Back
Top