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 strongm 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. postermmxvicom

    Trying to figure out a better way to group data together for display

    I am storing settings for different processes in a database. I have a table for my process names. I also have a separate table for each type of dialogue box that could store settings. Not every dialogue is used for every process. I need to compare settings used between all the different...
  2. postermmxvicom

    modifying a macro when there is only one column of data

    Thanks for your reply Skip, I have a basic knowledge of VBA and no experience using it in excel. I will try your solution and see if I can get it to work. I will report back with my success (hopefully). Most of the code I am using was generated by excel when I made the macro. I was able...
  3. postermmxvicom

    modifying a macro when there is only one column of data

    I have modified a macro I recorded to make it better. However, one bug I can't seem to get rid of is when there is only one column of data it tries to copy all the empty cells in the workbook to the right. I have made several attempts to overcome this, but have only proven I don't know what I...
  4. postermmxvicom

    Access 2007 and dumb header labels

    Sorry I misunderstood. (I do that). Didn't realize you were working with a tabular layout. Would setting their visible property to false suit your needs? And then make new, unrelated labels? I don't know what the proper answer to your question is, but I would also like to know. One last...
  5. postermmxvicom

    Access 2007 and dumb header labels

    *upper left* not upper right..sorry One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?
  6. postermmxvicom

    Access 2007 and dumb header labels

    You can move them separately. I don't know all the nuances, but try grabbing the gray-ish box in the upper right corner of the control (or the label) when it is selected in design view, and move it that way. If that doesn't work, move the label that way. One last thing: Sometimes I wonder...
  7. postermmxvicom

    Easy. Need to display name after keying in ID.

    I believe you can do this with the wizards access provides. Just make a form using the wizard (I would select justified in this wizard, but that's just personal taste). Then go to design view, make sure the control wizards are enabled, and make a combobox. When you are going through that...
  8. postermmxvicom

    Form layout for one table

    Could you just make an unbound form for the parent form? Then have controls for the 'repeated' data there, and use those values to set the default values for the controls on the child form. Perhaps, using the on change event of the controls on the parent and a little VBA. But, I have a hard...
  9. postermmxvicom

    Form layout for one table

    Yes, it is possible to do this. Without knowing your table structure, I can't say for sure, but, "duplicate information" has me a little concerned. Typically, you would want to set up multiple tables to avoid duplicate information. For instance, you would have a table which had the employees...
  10. postermmxvicom

    VBA code in Open Event causes print to silently fail

    Thanks dhookom! I wish I could give you two stars :/ I thought I'd seen something like that somewhere before, but I was unable to turn it up. Aaron One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?
  11. postermmxvicom

    VBA code in Open Event causes print to silently fail

    Thanks dhookom, That was the event I needed! I have another question for you though. Value gives me the Key which is stored in the combobox, not the human-important data that I need to show on the report. So, I called setfocus and then used text. Is there another way to do this? Can I get...
  12. postermmxvicom

    The dreaded apostrophe

    My apologies, I must have misread your reply. (I am really good at misreading things) One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?
  13. postermmxvicom

    VBA code in Open Event causes print to silently fail

    I have the following code in the Open event of my report: Me.LotNumber_Label.Caption = [Forms]![LotNumberTrace]![LotKey].Text I had this code in my Load event, but it would only run when the report is previewed and not when it was printed via a command from a form. So...I moved the code...
  14. postermmxvicom

    The dreaded apostrophe

    Drisconsult, I hate to butt in, but, I really think you should reconsider JoeAtWork's suggestion. It is very easy to implement. (I believe Access even sets it up for you this way when you run certain wizards.) I also think everyone here in this thread would agree. I can't speak for them...
  15. postermmxvicom

    When to make a field a number

    No, and because of the nature of the data - I left many things wide open while maintaining good design. However, the description of my project is essentially - "make a program that bends to us - not the other way around." And since that design was made, a key employee was replaced. This new...
  16. postermmxvicom

    When to make a field a number

    Interesting point. Funny thing is, I made it that way from the beginning. It is already two fields just like that, but now, the numeric part needs to have letter. Haha! Jokes on me :P How would you handle leading 0's as RoyVidar pointed out? Is using functions to increment a number that...
  17. postermmxvicom

    When to make a field a number

    This was actually a tracking number they already had for business, and I, regrettably, set the field to number :( But, as I said above, fortunately, did not make it a primary key :) Should have included this in the above post, but I am too quick to hit that submit button. :P One last...
  18. postermmxvicom

    When to make a field a number

    Thanks RoyVidar! I hadn't considered that possibility. I definitely agree with that. Fortunately, I learned that one (from this forum and other places) before I started coding the database. I believe it has saved me much grief. That and this business is so crazy, it didn't take long to...
  19. postermmxvicom

    When to make a field a number

    Don't make a field a number, just because you are going to store numbers in it. Because, one day, it just might need to store a letter also. Learning this the hard way, right now. Example: Numeric tracking numbers - sometimes, things get messed up and now they need #####A and #####B. And...
  20. postermmxvicom

    Group By or Distinct to return only unique results?

    I want my query to only return unique results. I have made acceptable queries using either Group By or Distinct. I read that you can't trust DISTINCT to de-duplicate correctly in some situations. Does Group By suffer from any issues? Is there any other differences that I should be aware of...

Part and Inventory Search

Back
Top