Search results for query: *

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.

No, not mathmatically. i mean formatting with the currency symbol, decimal seperator, thousand seperator, etc...

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.

can you copy and paste your current code/sql? why cant you just modify it to group on month instead of week?

ok now we are able to format the number properly, but when we try to insert it into an access db, it wont take it. it will only accept values that are the same as your current regional settings. how can we do this? we'd like to be able to insert the values into a currency or number field...

Does anyone know a way to grab all of the different types of currency formats? Perhaps using an API call for example? If we could do that, we may be closer to our goal, because we could grab that and format it accordingly.