Search results for query: *

Does anyone know how to get FileMaker Pro e-mail to AOL version 8 or 9.01. I am not a FileMaker Pro person but need some help. Thanks in advance.

The NT server that I'm using has over 6 gb available on the spindal. Nice thought, but no cigar.

I compact the database every morning because of it's size.

I'm running Access 97' the database is about 300 meg. Over the last several days I have to repair the database multiple times a day. Some time the first repair doesn't work and about 30 minutes later I have to repair it again. Repairing it is easy, I want to find out why and fix the real...

I've been looking all over on the web for article to describe why the Access database needs to be split into front-end/back-end and what the benefits there are in doing so. Can anyone help explain why this is necessary and the benefits of do so. My database is about 300 meg. in size running...

Thanks for the info. But how is this related to a FileMaker Pro install script? Pre-thanks

I have a Windows XP system home addition (new Dell computer) that I'm trying to run a FileMaker Pro install script on and keep getting the error "This is not a Win32 application". I have other XP home addition computers that the install script worked just fine on. I have searched...

I have a query that brings back the following data: Order Nbr Style Color Scale Size1Qty Size2Qty Size3Qty 12345 1303 30 S 10 5 12 My database is for apparel and the sizes are grouped within each scale code. Scale "S" = Small thru XL sizes What I...

I have two separate queries that gives me gross sales by customer account, one query for current year, and one for last years gross sales. I need to know in what order on both queries account number 12345 is at. For example: current year account number 12345 is ranked 40th, and last year account...

I want the user to be able to tell me how many records to display on the report. For example: they may only want the top 100 ship to by gross sales in ascending order this time, but next time maybe they only want to see the top 50. I am running a form that gathers information and displays the...

I have split my database into a frontend/backend database. Can I or how do I create a macro that I can execute from a scheduler to compact the database automatically at a particular time of the day without creating another database to compact it? Thanks in advance.

When I open the Startup option box from the tools menu, I change the startup form to open up a particular form name. I then hit the ok button. I then immediately go right back into the tools/startup option and my form name is not there. It's like it never saved my changes. Hope this helps

I have a small database which was working great. All of the sudden the startup page was set back to the defaults and now I cannot change it. I have administrative privileges and still cannot change it. Anyone have an idea? Thanks for the help

Try this it works great for me. DoCmd.OpenReport stDocName, acViewPreview, , criteria DoCmd.SendObject acReport, stDocName, acFormatRTF, eaddress, , , "Open Orders", "Open Orders", 0 DoCmd.Close acReport, stDocName The first DoCmd line executes the report. Need this...

When saving a form (has several listboxes tied to linked tables) it takes about 2 minutes for the changes to be saved. Any ideas would be great. Otherwise the form works great. Pre-thanks

I'm trying to run a query to see if a record exists in a particular file. If it does exists do A else do B. How do I get the result set back from the query. I'm not updating so qrydef won't work. Have been trying runsql or execute but cannot get it to work. Thanks

Thanks the recordseffected property works great with the querydef.

Trying to populate a table with an sql update statement from VB code and if the record is not there I want to execute a separate query to insert the new record. How do I know that the first (update) query resulted in 0 records updated to determine if I need to run the insert statement. Any...

I have 50 tables that need to be cleaned before importing all new data. I'm using an SQL "Delete * from tablename" and executing it through a macro. Keep getting out of disk space and/or memory error. My machine has enough memory and disk space. How can I remove all the data from the...

Trying to write a sales report where each sales rep has a total line on the report. On each total line I need to add the percentage of total sales for that sales rep compared to the entire report total sales. How would I accomplish this? Pre-thanks to anyone