Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Dbless

    FileMaker Pro and AOL

    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.
  2. Dbless

    Repairing Database all the &%$# Time

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

    Repairing Database all the &%$# Time

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

    Repairing Database all the &%$# Time

    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...
  5. Dbless

    Why Split the database?

    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...
  6. Dbless

    FileMaker Pro win32 app error

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

    FileMaker Pro win32 app error

    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...
  8. Dbless

    Breaking up is Hard to Do

    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...
  9. Dbless

    Row counter on a query

    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...
  10. Dbless

    Help with Select Top criteria

    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...
  11. Dbless

    Compacting a database

    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.
  12. Dbless

    Cannot change Startup parameters

    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
  13. Dbless

    Cannot change Startup parameters

    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
  14. Dbless

    how to auot export a report

    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...
  15. Dbless

    Saving Form is very very slow

    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
  16. Dbless

    Returned value from RunSqL

    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
  17. Dbless

    Capturing query results to perform another function

    Thanks the recordseffected property works great with the querydef.
  18. Dbless

    Capturing query results to perform another function

    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...
  19. Dbless

    Deleting All Records from many tables

    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...
  20. Dbless

    Sales Report line percentage of total sales

    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

Part and Inventory Search

Back
Top