Search results for query: *

Using Access and need to limit the number of records updated to 1000....the "limit" function appears to not be acceptable to access....how can I do this? thanks in advance!

I use a field in 36 different formulas. Is it possible to mass change the field name in the formulas without having to open each one up, change the field and save?

I have a table that resembles this: RECID ITEM COST 001 ALPHA 5.00 002 ALPHA 6.00 003 ALPHA 7.00 004 BRAVO 3.00 005 BRAVO 4.00. My report is set up so that the output is the last record for any given item. I do this by hidding the details and putting fields in the...

Is this better than Crystal for report authoring and distribution?

Is is possible to create a crystal report where the user can select the database on the fly? I have 10 databases with identical tables names and structures. Each database represents data from a different company.

Is there a way to specify the size of the page without being limited to the size of paper that the printer can accept. I am trying to create a report that will always be exported to excel, but I need more room to work with in the layout.

Is it possible to create a pass through query that uses prompts so that when the user runs the report, the user is prompted and the query uses the parameters input? (I'm using a pass-through because I need it to be read only) Troy

Is there a way to keep pages with no data from printing in FRx?

When using a reporting tree, is it possible to get FRx to not print the company name on the report?

How can I prompt a user for a field name and use that name in the update query...ie...the tables in question have 12 columns, one for each month....the colmuns are named 01, 02, 03 etc....i want the user to input the appropriate column name have the query update just that column...Thanks in advance

Thinking about buying FP...a couple of questions: 1. Can database results be presented in 2,3 or more columns instead of the standard 1 record per row...i.e. an ecommerce site that lists the products in 2 columns instead of one? 2. Can FP "build" or populate a page on the fly...ie if a product...

How do I create a prompt in a query that allows the user to select the value from a list? T

Does Peachtree have the ability to generate Purchase Orders from Sales Orders because an item is out of stock? T

I need to pull data from 2 tables. I have current year data in table A and prior year data in table B, hence, the field names are identical. I need to be able to input a date range like 1/1/2003 through 6/4/2004 and get all the records that meet that criteria. There is no relationship between...

I am trying to create a macro that copies data from all the files in a directory to a file called costs.xls. But my macro keeps trying to open the same file. Your help is appreciated. Listed below is what I have. Sub DirLoop() Dim MyFile As String, Sep As String ' Sets up the...

Newbie: I have some records that I am importing from a text file into Access. There are 4 fields for each record, but the data in the source file is "not flat"., i.e. it looks like this: Record1.field1 Record1.field2 Record1.field3 Record1.field4 Record2.field1 Record2.field2 Record2.field3...

I want to print a report out of project using Day 1, Day 2, etc. instead of actual dates. The timescale displays it the way I want it, but when I print reports, I get actual dates.