Search results for query: *

I need to use a having clause in 8.5. I went to the Database > Show SQL Query, modified the select statement, but it wont save my changes. Is there another way to use a sql query in CR 8.5?

Im pretty certain, almost positive, this cannot be done, but figured i would ask. Is it possible to have a custom tool-tip when the mouse hovers over a field in datasheet/table view in access? Scenario: Field A holds a string such as "A12" When a person hovers over this field, a custom tooltip...

Having some trouble figuring this out. Was wondering if there is a way, in Crystal Reports 8.5, to describe a table in crystal reports? or print the field types (field name, string, 255 characters) for cetain tables? e.g. (FirstName, String, 255) or (Date_Of_Birth, DateTime) etc. Any help would...

Control: Microsoft ListView Control, Version 6. ERROR: System.InvalidCastException was unhandled Message="Unable to cast COM object of type 'MSComctlLib.ListItemClass' to class type 'System.Windows.Forms.ListViewItem'. Instances of types that represent COM components cannot be cast to types...

I have a text box on a form, which will accept the date in the format of mm/dd/yyyy. Is there a way to adjust the input mask to be mm/dd/4DigitCurrentYear (e.g. mm/dd/2009) so the year would be in the input mask by default? I have tried this: mm/dd/"2009" or mm/dd/2\0\0\9 as the input mask as...

Is there a way to have a textbox with the input mask set to 99/99/0000, with the format set to mm/dd/yyyy, but allow the user to enter a partial date? such as just the day, just the day and month? When the textbox loses focus, it throws an error obviously.. but is there a way around this? Not...

I have a continuous form set up with all my information in the detailed section. The height of the detailed section is 11.6146 (not sure if this helps). The form itself is comprised of large amount of textboxes, labels, group option boxes, lines etc. When scrolling in form view, the form barely...

Just curious as to what would be the best way to going about adding a "check for updates" feature to an application whether its by a user clicking on "Check for updates" or the program automatically doing so. Recent research keeps pointing to an activex control or ClickOnce. any help on this...

When rolling out software that uses a mysql backend, how is it possible to configure the odbc driver for mysql during the installation process of the software? Is there anyway to do this via command line, installshield, batch files..? What would one do if individuals were not "computer...

Sorry if this is in the wrong forum, I wasnt sure if it was vb or mysql Does anyone have any documentation or would be willingly to provide some assistance in how to open mysqldump.exe within vb6 and set the parameters it requests so that i can back up my sql database? Basically, someone would...

Sorry if this is in the wrong forum, I wasnt sure if it was vb or mysql Does anyone have any documentation or would be willingly to provide some assistance in how to open mysqldump.exe within vb6 and set the parameters it requests so that i can back up my sql database? Basically, someone...

I posted the following under mysql, but was directed here, hopefully someone can assist me When trying to update a table i get the following error on the .update command: Row cannot be located for updating. Some values may have been changed since it was last read. I've tried changing the...

When trying to update a table i get the following error on the .update command: Row cannot be located for updating. Some values may have been changed since it was last read. I've tried changing the option in the connection string to option=2;....and it didn't work. I also tried checking "row...

Can anyone help in assisting me assign a primary key (auto number, int, not null) to another field which is varchar(5). After my select i try setting the varchar field equal to the primary key field after the select statement like the following: table!varchar = table!primary_key But it tells...

in my code i have the following: tableName!Date = "2006/12/07", where "Date" is the name of the column in the mysql table and it is defined/has a type of datetime.. When i get to this line of code however, the value of date stays null. Ive managed to assign other fields in the table similarly...