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

  1. smoker1

    If... Then Statement Issues

    I really appreciate your help, Roy, but it still is highlighting all the fields, even when there is data in the [RippedName] field. Any help? Is it possibly because the RippedName and the AppName are both in the detail section, and the report has already formatted before seeing if the...
  2. smoker1

    If... Then Statement Issues

    Well, that made it past the debugger... but it's not doing what I want it to do. Basically if the field RippedName is Null, then I want the field AppName to be highlighted (therefore the change in backcolor). Right now the code you recommended is highlighting everything even if the field is...
  3. smoker1

    If... Then Statement Issues

    Can anyone tell me why this code is not working in the OnFormat code for the detail section of a report? Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me!RippedName Is Null Then AppName.BackColor = 12632256 Else End If End Sub The debugger is stating that an object...
  4. smoker1

    "405 Method Not Allowed" Error -- website based on db

    " I am currently developing a webpage for my brother's car dealership with FrontPage 2002. I have created a credit application page to interface with the corresponding database. I have uploaded the database to the server, but when I try to click the ok button (where it should send the data...
  5. smoker1

    Opening form with empty fields

    HELP! I haven't worked with MS Access in a very long time, and am getting stuck on the most simple problem. I have a form which is tied to a table. When the form opens, it populates the fields with the first records data. Since I have a combo box [cboPrimaryCustomerName] which searches for...
  6. smoker1

    crosshair cursor

    I appreciate everyone's help.... but, I have a custom cursor (that I just happened to name crosshair -- after the bow crosshair) that needs to be used. Any help??
  7. smoker1

    crosshair cursor

    Unfortunately, that is not what I was thinking... I need to figure out a way that I can have a custom cursor be used on the page. I have drawn & saved it in my Windows cursor file, but cannot figure out the HTML to have it on the webpage. In other words, I don't know how to make a cursor...
  8. smoker1

    crosshair cursor

    Hello all!! I am developing a website (FrontPage 2000) in which the client wants a crosshair cursor once the website is opened. Unfortunately, I don't know how to do this. Can anyone help me with the HTML coding? P.S. I only want the mouse to change while on this website, so I will need...
  9. smoker1

    insterting dates into a table

    All you need to do is insert a Save DoCmd into your form's "on close" property.
  10. smoker1

    Help with setting Input Mask/ Format on Field

    Actually, I want the year to be constant. So the first record would be contact 2002-1. The second, 2002-2. The hundredth, 2002-100..... Any help?
  11. smoker1

    Assigning Code to Function Keys

    Phil, You will need to be a little more specific if you want this answered. Let use know if you need assistance with writing the code or setting up the command. Then someone will be able to help you. Angela
  12. smoker1

    Why Wizards do not work in XP

    Dick, I can't explain why it doesn't work, but I would have you check your installation of XP. When installing, choose the Typical installation (which includes the label wizard). Check your add/remove programs in the windows control panel for the label wizard. If it is not there, you can...
  13. smoker1

    Add Auto-Number Field using a query

    Robert, Access help topic "change the starting value of an autonumber field" tells you how to accomplish this with a query. Hope that helps. Angela
  14. smoker1

    How do How do I set a minimum amount of entries for a set of records i

    Doc, Not sure I totally understand how your tables are set up... If you have a table for each test, why can't you create at least 6 required result fields? For example, for the gestational diabetes table: TestName Text Result1 Number Result2 Number Result3 Number ..... If...
  15. smoker1

    Help with setting Input Mask/ Format on Field

    Hello all! I haven't been working with Access 2000 much lately, and have forgotten some of my old "tricks". I am designing a contact management DB which needs to have the an automatic contact id. I want the id to have the following format: current year - integer...
  16. smoker1

    automatically update a field

    How can I make an update query that updates on the first of each month? (I know how to do it every so many days, but that doesn't work for my need.) Thanks in advance for your help!! --Angela
  17. smoker1

    Creating a graph from exisiting data

    The best to do this is to create a report that has all your data in the report header. Then,use the chart wizard to create the type of graph that you desire (the wizard really makes charting simple for first-time users). At one point the wizard will ask you to arrange the data according to...
  18. smoker1

    Combo Box does not display the value I expected!

    In the control source of the combo box, reference the tblCompanyName (if it is available in the related query). If it is not available from the form's control source, use a syntax similar to this: SELECT DISTINCTROW [Company] FROM [tblCompany] ORDER BY [Company] This will pull the company...
  19. smoker1

    Access question

    Why not create a query from table 1 and table 2? Then use that query as your control source for the form.
  20. smoker1

    Problems Importing Reporte They Are HIDDEN ???

    Let me know if you ever solve this problem. Unfortunately, all of my research as the mgr of the IS department has proven that reports do not convert from any previous version of Access. Good luck.

Part and Inventory Search

Back
Top