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

    List Box does not populate, but only on 1 user machine

    Yes, it is split I will check this Thank you
  2. nomus1

    List Box does not populate, but only on 1 user machine

    I have a form and it does not pupulate on one machine. I can log this user onto other machines and everything works fine. No user can log onto this machine and have it work. I have checked references and all are there. Does anyone have any ideas?
  3. nomus1

    Security on an MDE

    Thanks for all you help I figured out how to see what group others belonged to and got him redirected properly He is working ok now. Thanks again
  4. nomus1

    Security on an MDE

    Thanks for the response Yes, the user is on the same operating system as everyone else. He had some virus's and I quarenteened all the infected files. I reinstalled several things, but just can't get Access working. I am assuming that everyone is joining the system.mdw on the server. The IT...
  5. nomus1

    Security on an MDE

    Yes, when he logs on he gets a series of error messages that say that the groups are not recognized. I pointed him to the system.mdw on the server rather than on his local C: and that recognized his name and password, but it is not recognizing user groups. Hope this helps.
  6. nomus1

    Security on an MDE

    I put a copy of the MDE on the local users drive by comparing the date stamp on that version to the date stamp on the network version. I have one user who has lost his link to the network security tables. I have tried everything I can think of, but can't get it back. Does anyone know what I...
  7. nomus1

    Rotate text on report

    Help, Will this work for existing fields in an existing report I tried Dim rotatelabel As Object Set rotatelabel = Me.lbl1 rotatelabel.OleData = Me.lbl1.OleData rotatelabel.escapement = 90 Any suggestions?
  8. nomus1

    Change height of text box in a report

    Thankyou Yes, you have the idea. The address field grows as needed, but the other fields do not grow to match the length of the address field. So the borders that I have around these fields do not line up with the address field. This is making the report look odd, I know how to have a line...
  9. nomus1

    Change height of text box in a report

    Is it possible to change the height of a text box in a report to match the height of a text box in another report. I have one field that creates an address - it may be 2, 3, 4, or 5 rows high depending on the amount of data. I have a border around this box. I have another field that has a...
  10. nomus1

    What record were appended?

    An easy way to do this might be to add a time field to the table. Then you could run your report based on the time the information was added to the table. You could also add the user ID and then you could additionally report based on who added the record.
  11. nomus1

    Between Clause won't work

    Depending on how complicated the querry is, I have had trouble in the past using between in the sql statement and have had to resort to using and Instead of between 1 and 6 >= 1 and <=6 For some reason, that works when I can't get the between to work.
  12. nomus1

    I am having trouble with a query di

    One simple way would be to create a query that sums the information you need. Leaving the comment field out of it. For your report recordsource, build a query that uses the fields from the query you just created and add the comments. Make sure that you get all records from the query. Then on...
  13. nomus1

    IF Function

    The formula in lotus 123 would be very much the same I would still put in something for the remote chance that E4 <> 0 and F4 <> 0. Things that are not supposed to happen sometimes do. =if(E4=0,D4+F4,if(F4=0,D4+E4,&quot;Error&quot;))
  14. nomus1

    IF Function

    This appears to be an excel question and not a question for access. If I am correct the formula would look like this. In cell G4 type =if(E4=0,D4+F4,if(F4=0,D4+E4,NEED SOMETHING TO HANDLE E4 <> 0 AND F4 <> 0))
  15. nomus1

    Visual Integrator and Salesorder

    The file is saved as an Excel File. Most of the information is in the import file itself. The excel file has ShipToCode ShipToName ShipToAddr1 ShipToAddr2 City State Zip Item Number Qty Ordered Qty Shipped Qty BackOrdered Unit Price Extension Unit Cost Line Type Everything else is coded into...
  16. nomus1

    Visual Integrator and Salesorder

    I need to create approx 400 salesorders. All the same item, same customer, just different ship to codes. I have the list of ship to codes in an excel spread sheet. The ship to codes already exist in Mas90 for this customer. When I created the import, it runs, but it show 0 records imported, and...
  17. nomus1

    iif([Animals]![pet] in (&quot;dog&quot;,&quot;cat&quot;) doesn't understand [An

    I tried doing the same thing - can you view your code in SQL - maybe then you could see the difference. SELECT animals.*, IIf([animals].[pet] In (&quot;Cat&quot;,&quot;Dog&quot;),[animals].[pet],&quot;&quot;) AS Expr1 FROM animals;
  18. nomus1

    iif([Animals]![pet] in (&quot;dog&quot;,&quot;cat&quot;) doesn't understand [An

    Try [Animals].[Pet]
  19. nomus1

    Sending Outlook 97 Calendar

    This is a very old thread, but it is exactly what I am looking for. Were you able to successfully do this? If so, can you share the form with me?
  20. nomus1

    Help!! - Import Problem - Driving me CRAZY

    Thanks for responding M90 V3.31

Part and Inventory Search

Back
Top