Search results for query: *

I have a field set up in Access 97 that is "Short Date," so that it looks like 8/22/03. I have made a report using Crystal that needs to limit the records by a range of dates, but for some reason, I can't get it to pick up the correct data. I've tried lots of combinations and nothing...

Hello, In some of my reports, the items in the selection formula prompt you to enter any changes or just to use the default value. I am having a problem doing this with boolean values. For example, I want to be able to change "false" to "true" in some cases, but when I run...

Hello, I have an Access 97 database that will be used by several people at the same time. One of the things needed when a person starts a new record is to automatically fill in their name. Does anyone know how to make Access read a file on a person's computer (a text file, for example) and...

Does anyone have any idea why I can't link more than one field from an Access database to the database that's supposed to be returning information? Let's say for example I have a database that has 10 fields to enter in item numbers, all associated with the same record. Now I want to link all...

I have a form that has a few buttons on it that run queries. These queries ask for an account number when you run them. The problem is, I have that accout number in a text box on the form already. How can I pass along that number into the "Enter parameter" box so that the query will...

I have a database that has two forms, two tables, and a query. Here's what I would like it to do, but can't figure out how to do it. The first form contains an account number text box. After the person types in this account number, it should run a query that pulls the name and address from...

If I have a field that won't let me do a sum({fieldname}) because of the message saying "The field can not be summarized," how can I add them up so that I can subtract them from something else? I've tried everything I know of in Crystal to get it to work, so I hope you advanced people...

I have a report that I'd like to print out just the first 50 records after going through the entire database and totaling things up. Any idea how to do that? Thanks.

I have an older report that was created that had a field that was designated as "Time." When I selected Format Field, it was always set up as a time field. But since I did a Verify Database on this report, it has somehow changed the field from Time to Number, making all the times...

I have a report that is located on a network drive. When I run this report on one computer, it retrieves all the data as it should and produces accurate results. When I click on "Browse Data" the information listed is correct, in this case times that a transaction took place. On...

I've asked this before, but gotten very little response. I hope I can do better here. I have an Access database that has two tables. On one form, when someone clicks a button, it should add 1 to the number currently in that field and then save that number to another table so that when the...

In Microsoft Access 97, how do I tell VBA to save the properties of a table I've changed? For example, if I change the default value of a field in a table to 12345, what's the command to make it save it so that it'll always be that number (or whatever number I tell it to use in the future)...

I have a Crystal Report that prints data from an Access database for a 5 day period. What I need Crystal to do now is to actually count how many of the records actually has data in them and output the total. For example, if one person had data for 5 days, it would display 5. If someone else...

I have a spreadsheet that has many fields that a person can type a number into. Upon moving off that field, I would like a "Total" field to automatically add up all these fields (running total) and store it in the database. How do I do this? I've tried a few ways and none of them...

Hello, I've just gotten a new computer and now whenever I run any Crystal Reports and export them to Excel, they export differently than what they did before. For example, if rows A and C contained data when using the old computer, now rows B and C will contain the data. All the other...

I have a database that I am trying to use ODBC with, but all it tells me is #Name? in the field I'm trying to set up and I don't know how to fix it. Here's what I want it to do. When I type in a number into one field, I want the next field to automatically fill in the company name using an...

I have a Crystal Report (version 7) that was designed to print items that have more than one location assigned to them in the same area. The selection formula is as follows: {location1.mapstck_location} > &quot;P01000A11&quot; AND {location1.mapstck_location} < &quot;P99999X11&quot; and...

I have a report that I'm trying to write with Crystal 7 that needs to look at a history file of shipments and compare them to a database of order numbers. If the shipments file entry does not match an order number, it should be listed on the report. I can't get it to work and was hoping...

I'm looking for an Excel macro that will look at a column of numbers and if the number is 0 in that column, it will hide that row (record) from view. Any ideas?

Probably an easy one... I have an Access database in use for a Crystal 7 report, but had to add a few fields to the actual database so that they could be included in the report, but Crystal 7 doesn't see them. If I remove the database and readd, I'll lose all the fields in the report (of which...