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!

  • Congratulations bkrike 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: *

  • Users: gbfell
  • Content: Threads
  • Order by date
  1. gbfell

    sql server replication issue

    Having a hard time getting a client who uses VPN to sync successfully with a SQL server. Here are the details. FYI, my machine here works perfectly using the same username and password. When using the 'good' user/pw, the errors are as follows... Snapshot will be applied from the alternate...
  2. gbfell

    extending lines/boxes to bottom of section

    How can I do this? I have a field that can grow, and I have boxes/lines I placed in report that go to bottom of section, but when it grows they do not.
  3. gbfell

    running code/module/function from Crystal Reports in Access

    Is there a way for Crystal to call a function or run some VBA code in Access? I have a dynamic query that i need to make each and every time a report is ran, i could probably make a function to make the query in Access, but how to call it?
  4. gbfell

    help quick! subreport data wont show up in footer!

    I SWEAR i had this working, now its not. i have a subreport linked to a report using 'sample_id_l'. Nothing appears in the subreport! when i move it from the footer to the header, it works!?!? when i take the links out, it works in the footer! help!
  5. gbfell

    maximum records and maximum simultaneous connections?

    Hey guys and girls, just like the subject says. 1. what are the maximum records a given table can hold? 2. what are the maximum simultaneous hits a given SQL server can handle?
  6. gbfell

    how to select from a odbc database?

    i need to run the following code in vb insert INTO ACOMPARTMENT select DB2ADMIN.ACOMPARTMENT.* from DB2ADMIN.ACOMPARTMENT IN 'DEMO'; its obviously not working because the 'demo' is the name of the DB2 ODBC datasource, not the path per say. how can i do this?
  7. gbfell

    make table from one mdb to another

    I need a way of selecting all records from a table from one mdb into another. simple, right? how do i do it? do i need multiple connections?
  8. gbfell

    Create xls, and graph in VB

    How can i create an xls file, then graph it in a VB form. how can i do this? i tried using a webbrowser, but don't seem to be able to graph it. i want to graph a numeric column vs a time column (i have both recorded in an access db). the amount of records will change each time i graph it.
  9. gbfell

    function to covert one foreign currency to another foreign currency?

    Does anyone know of a way to do this? we can convert an english currency to any foreign currency, but we need to be able to convert any foreign currency to any other foreign currency. example, icelandic to bulgarian.
  10. gbfell

    formatting foreign currenct???

    We are developing software that allows the user to choose their currency type. we then need to format all currency fields in the program like the type chosen. here is the hitch, we can NOT look at the regional settings, we have to ignore them. so, a user could have english regional setting...
  11. gbfell

    how to select top 3 values?

    I have a field that i want to select the top 3 values from. how can i do this?
  12. gbfell

    Access/SQL paging problems

    We have an Access 2000 *.mdb front end linked to a SQL Server 7 backend. Lately, we are having lots of problems with SQL server process being locked by other processes. The processes that are locking the others are Snapshot Select statements, left default which I believe are read only?!?! We...
  13. gbfell

    Basic SQL Server help

    Hello people, We have designed an Access 2000 front end/SQL Server 7 backend. We have a server than runs only SQL server, with 2 1000 mhz chips, and 512 mb of ram. We have ~10 clients talking to this server, and the db is only about 70 mb. Each client has its own MDB file, with linked tables...

Part and Inventory Search

Back
Top