Search results for query: *

I'm trying to pass a date parameter into the Fill method of a tableadapter and I'm getting an error message stating "cannot convert from 'string' to 'System.DateTime?'. Here's my code... using MIS_Database.Schemas.Rpt3YrsDataSetTableAdapters; using System.Data; namespace MIS_Database.Schemas {...

We currently use Paradox for our database programming, but as we have heard Paradox will soon become obsolete. I understand it may continue to work, but as far as we know, no company is going to continue enhancing it. What we're trying to figure out now is which direction to head. Does anyone...

I have a drop-down list, but the users want to be able to select more than one of the items from the drop-down list. Is this possible? For example, I want the user to be able to hold down the CTRL key and click on all the items in the list that are relevant for that record. Any help would be...

Has anyone ever seen this error message in Paradox? An attempt was made to access an unnamed file past its end. I don't know why it's all of a sudden coming up on a computer of existing paradox programs. Thanks, Amy

Is there a way to create a watermark on a report in Paradox? The only way I know to create the watermark effect is to change the font color to "Gray". My problem is that on the report I have a table frame that will have many records. Each of those records needs to display the watermark that...

Is there a limit to the number of aliases that you can store in the bde file? I'm at a point to where when I try to add another alias to the bde, I get a message saying "cannot write to engine configuration file". I think the code was 8453. Does anyone know how to get around this? Thanks in...

In Paradox 10, using an XP machine, I'm getting an error message saying "cannot write to file" when I try to save my work. This is happening when I try to save all forms and scripts. Does anyone have any ideas as to why I'm getting this error message? Thanks, Amy

I need help printing to a dot matrix printer from Paradox 10, but the real problem is that the paper size is 8.5 x 5.5. I can't get Paradox to remember the page size when it starts to print. Everything looks fine when I print to the screen. Does anyone know how to manipulate Paradox so that I...

I need to somehow format my report so that the data that contains a negative number will be shaded in grey. I have a table in the report which contains columns of currency. It has been requested to me that I shade the negative numbers so they stand out on the report. Is there a way to do this...

Is there a way in Paradox to create a query that will result in a answer table that has a certain field's data as the answer table's field names. For example, Table1.db has the fields "Date", "Employee Name" and "Amount". I'd like to query the "Employee...

I have created a Dialog Box in Access, but when I open the Dialog Box, it is too small and doesn't show all the controls that I have on the form. Is there a way to resize it? I'm new at Access and don't know all the tricks yet, so any suggestions would be greatly appreciated. Thanks, Amy

I want to create a Delete query based on a parameter that the user enters. How can I make the query not execute if the user doesn't enter the criteria or enters invalid data for the parameter? I know that the following code will select all values if no value is entered, but I don't want the...

I'm trying to use a variable in a loop for shortening my VBA code. I have 100 fields in a table that I need to run the same code on, but I don't know how to use a variable to reference a field name. Is this possible? The fields in the table are as follows: Fund 1 Fund 2 Fund 3 Fund 4 etc...

The table that I'm querying has one key field and 100 other fields. For each of those 100 data fields that has a value greater than zero, I will insert a record into another table, that contains the key field and the "greater than zero" field. This an example of a table I'm trying to...

How do you create a running sum in an Access query?