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!

  • Congratulations dencom 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. mercwonder007

    Access Page Help!!!

    We host our website through a 3rd party. I recently created a database on the site but am having a hard time creating an access page that can be viewed by everyone on the web. When I go to the site from another computer it tells me I need to change my security settings to allow it. When I do...
  2. mercwonder007

    QUERY PROBLEMS... HELP!

    I have a form with a bunch of unbound fields on it that have a query tied to them. I am using the form as a custom filter. When I type something in one of the unbound fields it then goes through the query and gives me the answer in a report. However, I now need to ad a list box to the filter...
  3. mercwonder007

    Creating Multiple Criteria Query

    I have a table that consists of address street names. I would like to create a query that allows me to type in multiple street names or possibly choose from a list and have it narrow it down to a report. I don't want a parameter query, I would like to to create a form that has a large field to...
  4. mercwonder007

    Between Function

    I created a query that has a date field in it. The condition is as follows: Between [Enter Begin Date] and [Enter End Date] When I try it and put in dates that I know there is data too, it comes back blank... however, if I put in dates that are before and after the dates they show up. I am...
  5. mercwonder007

    Update Time

    Hello Again, I have a date/time field in a form and I want to have a control button that when I click on it it automatically updates the time to current time. I tried a requery macro and it didn't do a thing. I then tried a repainting macro and again it didn't do a thing. Any thoughts???
  6. mercwonder007

    DATE() APPEND QUERY

    I have an append and delete query that aren't working quit right. I am trying to append all records older than today to a backup table. I have in the query a date field that has a condition as follows: Date()-1 and when I run the query it doesn't work. Any help would be great. Thank you.
  7. mercwonder007

    Access Report

    I have a report that I am running and it consists of multiple records grouped by a company name. I need to have 1 company per page. I tried entering in a page break but that puts all the clients under the group on thier own page. In other words lets assume I have 3 companies with 5 clients...
  8. mercwonder007

    Conditional Formatting Question

    How can I use VBA to change the color of a cell background based off of the data. (Ex. if I type in 1.01 turn the background of the cell to "blue", if I type in 2.02 or 2.03 turn the background to "red") Any help with this would be greatly appreciated. I know I can use conditional formatting...
  9. mercwonder007

    Security Question

    Everytime I open up my database I get a message that says: "Security Warning: Unsafe expressions are not blocked. Do you want to block unsafe expressions?" I then select "NO", Then it gives me another message regarding the Jet4.0 Service pack... I have gone to Microsofts page to download it...
  10. mercwonder007

    Queries

    I have 3 phone fields (Phone, Cell, OtherPhone) I need to create a query that will show the phone numbers in a cingle collumn. I want to show the phone number field first, if that is blank then move on to the Cell phone, if that is blank them move on to the otherphone, if all three are blank...

Part and Inventory Search

Back
Top