Search results for query: *

hi, I have a field with test numbers. Test numbers are 6 characters long, but in some cases I have more than one test number in the field so it ends up looking like this 123456123456123456. In that situation I have 3 test numbers and it would be easy for me to do the left, mid and right...

is there a way to get an ms flexgrid to scroll down using code? thanks in advance

does anyone have an example on how to use the timer data control? thanks in advance

hi, I have parameters set on my crystal reports that pull from an access database, but evertime I pull the report it doesn't prompt me for the parameters. I sometimes have to click on the yellow lightning bolt to get it to prompt me for parameters. Is there a setting or a way I can get it to...

hi, I have parameters set on my crystal reports that pull from an access database, but evertime I pull the report it doesn't prompt me for the parameters. I sometimes have to click on the yellow lightning bolt to get it to prompt me for parameters. Is there a setting or a way I can get it to...

hi, I have parameters set on my crystal reports that pull from an access database, but evertime I pull the report it doesn't prompt me for the parameters. I sometimes have to click on the yellow lightning bolt to get it to prompt me for parameters. Is there a setting or a way I can get it to...

I keep getting the error message text property is read only, everytime i change my combo box from 0-combo box to 2-dropdown list. I only have one record in my main table and it has the correct option that is listed in the other table that the options are coming from. here is my code: Private Sub...

does anyone know of a data control that I can use for a field that has a memo datatype in access? I am trying to use a text box but it won't let me wrap words. is there another datacontrol that i can display a paragraph in? thanks in advance

I have a find statement that takes whats in a text box and searches a recordset for it but its not working can anyone tell me why? Dim tempAcctNum As String tempAcctNum = txtAccountNum adotblaccounts.Recordset.Find "AccountNum=tempAcctNum" this blows up and says its out of acceptable...

O.k. i have 2 tables table one has account num and employee in table 2 has employee in it only. i want to connect the account num field on my form to the 1st table using an ado datacontrol, then i want to be able to connect employee from table one to same datacontrol, but i want it to be a drop...

is there a way to do a subform in visual basic where the account num in the main form is linked witht the subform? Thanks in advance

I added my package and dep. wizard the other day and it was under my add ins menu. I went back today and its gone and i tried to add it on again and but its not in the list of options and i don't see it on my start up menu. Does anyone know what could have happenend or how i can get it back? thanks

Is there any ay to get rid of time when prompting for a date? i am using an access 97 db which had the data type date/time and i used a oledb connection. When i just choose date when i set up my parameters and then click set defaults to go to the next page it won't let me choose my field under...

I have an access 97 DB and its tables are linked to a sybase DB using an odbc connection (system dsn) and i have a vb 6 project that has command buttons on a form and everytime one of those buttons is clicked a cr 8.5 report is supposed to run. the reports run except i have to login to the...

is there a way to automatically login to a db without having to login everytime i run a report? I have an access 97 db but it has links to an out side db. i am using an odbc connection and cr8.5. thanks

Can anyne tell me what the best way is to bind a report to an acess 97 DB with alot of records? There are so many ways to bind a report and I am new to crystal. Should i use ADO, Or ODBC or something else. Some of my queries need to be in sql and others i can just bind to a access query. I need...

I have a vb project with about 38 crystal reports and it won't let me add anymore, however it will let me add datareports. I thought this was weird so i added the same reports to another project and it did the exact same thing. I was wondering if anyone knew if there was a limit on the number...

does anyone know what i am doing wrong i keep gettting an aggregate function error related to the field name: SELECT qryAllReportEntryProblemsIncluding501s.[SubmittedBy] as Name, qryAllReportEntryProblemsIncluding501s.[DateEntered] From qryAllReportEntryProblemsIncluding501s UNION ALL Select...

i am using cr viewer to display my reports in vb. I have parameters and when i first run the report it prompts me for them but if i close the report and run it again it does not prompt me and there isn't a refresh button on the viewer. is there a way i can get it to prompt everytime? Thanks

i am trying to run reports from vb and they run but i can't get it to prompt for data the second time. is there a setting or something that requires the propmt to show everytime the report is ran or is there a way to add the refresh button to the viewer? Thanks