Posts by 01silverado

  • Check Field To See If Duplicate Already Exists

    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.

  • Check Field To See If Duplicate Already Exists

    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.
    Thanks
    Jason

  • Formula Not Recalculating When Dragged

    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.

  • Formula Not Recalculating When Dragged

    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?
    thanks,
    Jason

  • Query Search Criteria User Input

    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.

  • Query Search Criteria User Input

    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?
    Thanks,
    Jason

  • Display Query Criteria In Report With A Chart

    Re: Display Query Criteria In Report With A Chart


    Thanks.
    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.

  • Display Query Criteria In Report With A Chart

    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.

  • Pivot Table Settings? query Could Not Be Processed

    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.

  • Pivot Table Settings? query Could Not Be Processed

    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?
    Thanks

  • Pivot Table Settings? query Could Not Be Processed

    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:
    http://office.microsoft.com/en…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?

    Thanks,
    Jason

  • Validation Rule For List Box In A Table

    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

  • Validation Rule For List Box In A Table

    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.
    Thanks