Posts by 01silverado

    Re: Check Field To See If Duplicate Already Exists

    I get a warning when I hit "New Record". But that doesnt happen until I have typed in 25 fields. I need a check right after I enter the Ticket #.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]I see what your saying Mavyak, but there has got to be an automatic check.

    I have a database that keeps track of information off of a ticket.
    Each Ticket has the Ticket # at the top of it. This # is also the key. Sometimes I will get a duplicate and I dont know it until I have typed in the entire ticket and clicked "New Record".
    Is there a validation or something that if I enter in a Ticket # that already exists, it will flag me? I was hoping a Validation rule or in the Macro Builer. I dont have experience with code.

    Re: Concatenate Text Or General Columns

    Got it.
    I dont know what the deal is but I just drag the equation then go to Tools-Options-Recalculate and it works.
    It is someone elses spreadsheet so I guess they have some different settings.
    thanks for the quick help.

    Hey, every once in awhile I have trouble using the =Concatenate() or =(A1&B1) to combine data in one cell. It will work for the first cell but then when I drag the equation it gives me the exact same result as the first cell. But when I click to look at the formula it looks good and when I hit Enter the cell reads the correct value. So I have to open each individual cell and hit enter. What is goin on here. I have attached a small example.
    Also, sometimes I will type in a formula and hit enter and it just displays the formula. It does not return a value. Any ideas?

    Re: Query Search Criteria User Input

    yeah the space is a typo.
    I just assumed it was not connecting. For some reason it is not working.

    When I type in the Emp Name and then hit the button, the query will pop up and shows every record. It does not search for anything, I also dont get any kind of error.
    thanks[hr]*[/hr] Auto Merged Post;[dl]*[/dl]I figured it out. There is probably a better way but I had to base my Search Form on a Table that has just one field called Search.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Got it to work. There is probably a better way.
    Had to create a table with one field, Search. That table is then connected to the Form Search.

    I would like to make a query that allows the user to be able to search my Description field. I dont want the user to have to open the query in design mode and enter *Jim* under criteria.

    I found this code:

    Like "*" & [Forms]![Search]![ Emp Name] &"*"

    I entered this in the criteria. Then I created a Form called "Search" with a field named "Emp Name". I then created a button that opens up the query.
    For some reason it is not connecting the Emp Name to the Query.
    Any ideas?

    Re: Display Query Criteria In Report With A Chart

    I am able to make my different parameters appear in a report.
    My query Criteria: Like [Enter Department]
    In the report, I have a text box w/ =[Enter Department]

    However when I try it in a report that also has a chart in it. It will ask "Enter Department" several times. Any ideas?

    Does it have to do with the report being based on a query and the chart being based on the same query?

    thanks again.

    I have a query with critera in the date field ( Between [Type the beginning date:] And [Type the ending date:] )

    I want to create a chart from the data in the query, and display the date range at the top of the report. I have had no success.

    I tried: Creating a report based on the qry. Then inserting a chart based on the same query. Then a text box w/ ( =[Type the beginning date:] & " to " & [Type the ending date:] ) at the top of the report.

    When I try to view the report it ends up asking me for the start and end date several times? Can I make a report using the chart wizard? But then how do I display the criteria?

    I hope all this makes since. Thanks for the help.

    Re: Pivot Table Settings? query Could Not Be Processed

    Yes, I am using the Northwind.mdb. I can do all of the queries, select, crosstab, etc. I am just having no luck with the pivot tables.

    Here is the SQL of the failing qry:
    SELECT Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country, [FirstName] & " " & [LastName] AS Salesperson, Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Shippers.CompanyName, [Order Details].ProductID, Products.ProductName, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount, CCur([Order Details].UnitPrice*[Quantity]*(1-[Discount])/100)*100 AS ExtendedPrice, Orders.Freight
    FROM Shippers INNER JOIN (Products INNER JOIN ((Employees INNER JOIN (Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) ON Employees.EmployeeID = Orders.EmployeeID) INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID) ON Shippers.ShipperID = Orders.ShipVia;

    Let me know if you have any other ideas. Thanks Again.

    Re: Pivot Table Settings? query Could Not Be Processed

    Im still fairly new to Access. What do you mean by the data source? For this particular example I was just using the Microsoft example database. I am using Access at my job so there could be a security issue. Is there preferences or security settings I can check?

    Hey, I just started trying to play around with Pivot Tables in Access, but keep getting an error.
    I tried following this Microsoft Office Tutorial:…3.aspx?pid=CL100570041033
    But when I start dropping the fields in I get this error in the details box of the pivot table.
    "The query could not be processed:
    o The data provider didn't supply any further error information"

    Do I have a setting or preference setup worong? Anybody have any ideas I could try?


    Re: Validation Rule For List Box In A Table

    I tryed this:
    No validation rule
    Display Control: List Box
    Row Source Type: Table/ Query
    Row Source: SELECT [List Dept].[Dept #] FROM [List Dept];
    Bound Column: 1
    Column Count 1

    It still allows the user to type in any value in the Dept # field.
    thanks again

    Re: Validation Rule For List Box In A Table

    yes, I'll be running a query. The main purpose is to only have relevant data. I have several "correct" tables. And then several tables that look at these correct tables to get certain data. I hope this is making since.