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

  • Users: mrdod
  • Order by date
  1. mrdod

    Question about splitting my database

    Will do thanks for the insight.
  2. mrdod

    Question about splitting my database

    Thanks lameid. So is it best to convert my mdb to mde and distribute the front end to each user and keep one back end? I'm trying to learn this as I go so please forgive the elementary questions. Thanks again!!
  3. mrdod

    Question about splitting my database

    I have a few Ignorant questions about the benefits of splitting my database. 1. Will it enhance performance? Or is performance in how I distribute the front ends? 2. If data is stored in the back end why do I still have my tables being populated in the front end? 3. I can think of a bunch...
  4. mrdod

    Drilling down charts ?

    I started looking into this then realized the reports I created in Access are based on selections in a form. I may try using Sequel Reports not sure how to use those but our IT guy said he could lend a hand. Is this an avenue I don't wan to go down ????
  5. mrdod

    Drilling down charts ?

    I'll give this a shot in Excel. Thanks. As to what am I drilling down? I have a defect table that has different groups(Machine, Operator, Process, Supplier). Under those groups there are reasons. So Machine has like 10 different reasons, Operator has like 15 different reasons etc... what I...
  6. mrdod

    Drilling down charts ?

    OK first, I'm trying to learn how to use Access without any official training so please be gentle. I've created a bunch of 3D pie charts and have been asked to have each category drilled down by clicking the piece of pie. Would this called a sub report? I'm not sure where to start or what...
  7. mrdod

    Keep getting a blank record returned

    Thanks PH I'll give this a try when I get back to work. I used WHERE Level1<>"" and that worked but yours is probably better....right?
  8. mrdod

    Keep getting a blank record returned

    This works except when I have an entry in the Dept field but no data in the Level1 Comments field. It returns a value of 1(because there's one Dept??) but it should be 0 or "" because there are no comments. I like what you have so far!! Thanks for the help.
  9. mrdod

    Keep getting a blank record returned

    Thanks a lot Jerry !! And thank you genomon for checking the spelling (LOL).
  10. mrdod

    Locking the text on an Microsoft 2.0 Textbox

    Hmmm I am populating my textbox through a Dlookup function and when I lock the control I can still mess with the text. Perhaps because of the way I'm populating the text box. I guess it's not that big of a deal but it would be a plus if this could happen. Thanks for the time.
  11. mrdod

    Keep getting a blank record returned

    I am attempting to build a paredo chart and when I run my query I get the resulsts EXCEPT I am getting a blank value (Level1) with a Total of 0. Why do I keep getting a second value of nothing? Any help would be great Thanks!! Here is the code from the SQLView SELECT tblcomments.Level1...
  12. mrdod

    Locking the text on an Microsoft 2.0 Textbox

    Locked only means you can't update the table using a bound control. My textbox is unbound. I wanted to have it so the user couldn't click in the box and "jack around" with the text.
  13. mrdod

    Locking the text on an Microsoft 2.0 Textbox

    I have an unbound microsoft 2.0 textbox (because it displays scrollbars without needing the focus) and was wondering if there was a way to only allow the user to view the text and not be able to change its contents. "Sort of like a label with a scroll bar (I don't know how to do that either)...
  14. mrdod

    How do I avoid writing conflicts here?

    I only bound it because it was easier to fill. I typically use the dlookup function when filling a form. There may be a better way but I wouldn't have a clue how. So yeah I unbound it and it works fine. I appreciate your help a great deal. And have a pink thing on me.
  15. mrdod

    How do I avoid writing conflicts here?

    After doing some looking I found a couple threads saying something about having write conflicts with bound forms. I did make the form unbound and it works fine. Thanks for the responses. I'm pretty much a noob here so what do you mean when you say update the field on the form itself?
  16. mrdod

    How do I avoid writing conflicts here?

    ...& intincr & ");" DoCmd.SetWarnings False DoCmd.RunSQL (strSQL) DoCmd.SetWarnings True strSQL = "SELECT * FROM " & strcompname & ";" On Error GoTo ErrorHandler Set db = CurrentDb() Set rs = db.OpenRecordset(strSQL) With...
  17. mrdod

    Linking to a .pdf file?

    Thanks John I finally got a chance to look into this using the links provided and got it to work. I appreciate your help.
  18. mrdod

    Linking to a .pdf file?

    I've been trying this from home and after looking on the internet a while I found some code (below). The problem is after clicking the button nothing happens...Nothing. What am I missing besides a brain??? Private Sub Command0_Click() Dim stappname As String stappname = "C:\Documents and...
  19. mrdod

    Linking to a .pdf file?

    Thanks for the reply. I'm using Adobe Acrobat 7.0 and yes it opens fine when I dbl click it in Windows. I can't seem to find the FAQ you are referring to. I will keep searching. Thanks you
  20. mrdod

    Linking to a .pdf file?

    When I click the button to activate my code I get a flash then it goes away. Why can't I get the file to stay open? Are there settings that need to be modified? Anyway here is my code. Any help would be great. Application.FollowHyperlink "C:\Documents and Settings\myname\My...

Part and Inventory Search

Back
Top