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 SkipVought 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. brbarto

    Relative and Absolute Positioning on <div> tags

    <div style="position: relative; border-style: solid; border-width: 1px;"> I believe this line is equivalent to what was suggested.
  2. brbarto

    Relative and Absolute Positioning on &lt;div&gt; tags

    div.report h3 { background-image: url(/images/blu-gry-grad.jpg); background-repeat: repeat-y; background-position: left; background-color: #e1e1e1; border-style: solid; border-width: 1px; text-align: center; margin: 5px 0px; padding: 2px 0px; } <div...
  3. brbarto

    Relative and Absolute Positioning on &lt;div&gt; tags

    I am using 2 <div> tags within a <div> tag and I am trying to put a border in the outer <div> and it's not working. Instead of a border around the outside, I only get a thick line at the top. I am trying to float the inner <div>s to the left and right using relative positioning on the outer...
  4. brbarto

    Can't open applications

    Thank you everyone for your suggestions. Unfortunately, it may be a couple of days before I can work on this. I am using a Compaq Presario 2575 laptop - 80 GB hard drive-Pentium 4-2.66GHz-512 RAM. I haven't tried the Office setup and repair yet, since it involved other applications. If I...
  5. brbarto

    Can't open applications

    When I started my computer, I had a message something about a problem with the registry and it had been successfully fixed. Unfortunately, I don't know exactly what it said. Howerever, now I can't open any of my applications by clicking on them. I have to right click and open. I sometimes get...
  6. brbarto

    max text in an excel cell

    What is the maximum amount of text you can put in one cell in Excel? I would also appreciate if someone could give me a reference. Thanks, brbarto
  7. brbarto

    MDI child forms

    Private Sub cmdCategories_Click() frmCategories.Show End Sub Private Sub cmdInventory_Click() frmInventory.Show End Sub The above works if MDIChild is false for frmCategories and frmInventory, but does not work if it is changed to true.
  8. brbarto

    MDI child forms

    Any other ideas?
  9. brbarto

    MDI child forms

    I think so! I went to Add Forms and selected the standard forms from my A drive. I then changed the MDIChild property of these forms to true.
  10. brbarto

    MDI child forms

    I have created a couple of standard forms that I want to be child forms. Someone else created the MDI form. I have tried to add my forms and then change the MDIChild property to true, but this doesn't seem to work. We have command buttons that the user can click on to open these forms, but when...
  11. brbarto

    Updating a field

    I have an Account table. The primary key is account number. The account number has a hypen in it. The account numbers are now being changed. The hyphen is being taken out and a number is being added. I have the old and new account numbers in Excel. What is the best way to update the Account...
  12. brbarto

    Sum

    How can I do something like this in code? Sum(price*quantity) Thanks(very new to access/VBA)
  13. brbarto

    Rounding

    I was doing this calculation =[Gallons][UnitAmt] and was having trouble with it not rounding correctly. UnitAmt is Currency; Gallons is Double(fixed, 1 decimal place). To correct the problem, I think, I changed it to =CCur(NZ ([Gallons]*[UnitAmt])). I don't really understand why CCur is...
  14. brbarto

    Required info

    I have a combo box (LastName) on a subform (driver infomation). (The main form is the vehicle rental request.) The user picks a last name (or types it in). The SSN is what is stored. How do I make it required that the user must enter at least one driver? Thanks
  15. brbarto

    Required field

    I am getting the following message when entering data in a rental form. I get the message when I enter the VehicleNumber(combobox). The PickupDate is further down on the form and yes it is required. It will allow me to continue entering. &quot;The field tblRental.PickupDate cannot contain a...
  16. brbarto

    IN

    Can I use IN in an if statement? If so, how?? How would be the best way to do the following? If Me!VehicleNumber.Column(5) IN(&quot;820&quot;, &quot;822&quot;, &quot;824&quot;) And [EndMileage] - [BeginMileage] < 1000 Then Form!fsubPerMileCharge.Form![Quantity] = 1000 Else...
  17. brbarto

    Setting required field property

    Is there any reason the Required property in the field properties needs to be set to Yes for the primary key? Does it matter? It appears that if a field is the primary key, it is required, but the Required property is not automatically changed to Yes? Thanks
  18. brbarto

    grouping in a report

    I am trying to create a report that shows the acct to be charged, the acct that receives the revenue, and the amount, so I'm dealing with AcctNumber, RevenueAcctNumber, and ChargedAmount. The user wants it broken down by RevenueAcctNumber(there only 2), by AcctNumber (all accts starting with...
  19. brbarto

    macro can't be found

    When I try to open my WorkOrder form, I get a message that the macro 'WorkOrder Menu' can't be found. It was OK until, I think, I deleted a macro and replaced it with an event procedure. I had a macro(OnOpen) - GoToNewWO ( Maximize, Go to Record (Form, frmWorkOrder, New)). Then I deleted the...
  20. brbarto

    how many queries?

    A newbie question: I know you can query a query, but how many levels of queries can you do?? For example, can I do a union query on several queries, which some of them may be based on a query, and then do a query on the union query? Thanks for any comments!

Part and Inventory Search

Back
Top