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 derfloh 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: *

  • Users: Layth
  • Content: Threads
  • Order by date
  1. Layth

    Running a macro from a report.

    If I wanted access to run a macro when the user clicked on a report how would I do that. I have two reports that both run on code that is in an AutoExec macro, one of the reports needs extra automation, so as soon as the user clicks on that report I want access to run the other set of code that...
  2. Layth

    Reserved error (-7711)

    Does anyone know what "Reserved error (-7711) there is no message for this error" in Access means. thanks, Layth
  3. Layth

    Too many fields in a union query

    When I run a union query the I see a message box that says "To Many Fields Defined". What does this mean and how do I get around it? Thanks, Layth
  4. Layth

    Updating linked tables.

    I have an access database that has multiple linked tables. One query pulls out all of the information I need, I then turn that query into a make table query and query the subsequent table. From there I use other queries to count records, manipulate records mathematically based on their fields...
  5. Layth

    Searching by Date

    I have a report that shows all 310 records from a query. I have one field called stopdate, I want to do search in the field stopdate so that it only shows the records that correspond to the date that the user will insert in the beginning of the report in a text box. The report would look like...
  6. Layth

    Too many Fields

    I'm making a report based on a query with 30 fields. When I run the report I get an error message, "The wizard is unable to create your form or report you chose too many fields, please try again with fewer fields." I have made a form based on the same amount of records, so how do I get around...
  7. Layth

    Combining three fields into one

    I have three fields in a query that each give a decimal amount, the three are unique meaning if one is not null, the other two are null. What I'm trying to do is place all three of these fields into one field I'll show an example City Code 1 Code 2 Code3 San Juan...
  8. Layth

    Changing to decimal

    I need to return a decimal dollar amount, to decimal places, from the code below, I know its something simple, but I have tried decimal, float, double and none of these work. Here's the code [START THE EQUATIONS HERE].[MIN Of INSERTIONCOST] * ([START THE EQUATIONS HERE].[Total Of AMPORDERFK] -...
  9. Layth

    Combining multiple dates on one record

    I have two tables this is the content Table no. 1 name: New Primary Table AMPORDERFK, CompanyName, City 1 SCG Carson 2 MMN Hubbard 3 Staford Crystal 4 Miller...
  10. Layth

    Counting in SQL

    I have an SQL statement that counts by field AMPORDERFK and groups by fields ALTACCTNBR, SLUGLINE, and BASEAMOUNT. While this part works great, I want to know how to insert the rest of my fields into the query without them grouping the count. If I include them in the select statement I get an...
  11. Layth

    using a query on two other queries

    I have made two queries based on the same table. One is a cross tab table to count a the number of a certain type of record. The other calculates a mathematical equation based on a field in the record and returns a new field with the answer to the new field. When I try to query both of...
  12. Layth

    Using a field name with underscores in SQL

    I have a database with linked tables to another database. I have pulled the information that I need from these tables through a make-table query. Now I want to query the new table, but I run into a problem. Certain fields in the original database had fields with the same name such as code...
  13. Layth

    Converting queries into tables

    Hello I have a database project where I have made multiple queries based on multiple tables, I need to know how to export these queries into new tables so that the queries' previous relationship with original access tables remains intact. Any information on how to do that would be appreciated...
  14. Layth

    Manipulating records mathematiclly

    I'm working on an access database where I need to manipulate some fields mathematically and either return the result in a new field or table or query. For instance I have a table that has a field of millimeters that I need to convert to inches. An additional problem is that the millimeters are...
  15. Layth

    Counting records

    Hi, I'm working on a access database project were I need to use the Microsoft Visual Basic editor. Here's my problem I have a query with a field called AMPORDERFK this field keeps track of the number of ads that a client has, hypothetically every record could have the same value, they don't...
  16. Layth

    How to copy rows from one table and paste to another in access.

    I am working on a single table database project. In this project I need to copy records that have a value in the "description" field greater than zero, and they need to be copied and inserted into a new table that many of times. Example, If a record has a value of 10 the entire record will be...

Part and Inventory Search

Back
Top