Recent content by gbfell

anyone? please help

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

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.

building fields in the select statement. it needs to be able to select from column a and b one time, and another time select from column c or d.

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?

Got it! thanks. the value had changed because it repeated itself in the details section. :)

how can i check it? the field i'm passing to the subreport is a number, and its named 'sample_id_l'. its the same in the subreport?!?! and why would it work in the header or details then?

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!

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?

any other ideas? i want to insert into an access db, from an ODBC DB2 db.

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?

fantastic i'll try it now.

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?

I haven't had a chance yet, but i think it looks like it will work. i'll post more later. thanks guys (and girls :)

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.