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

  • Users: Lunatic
  • Content: Threads
  • Order by date
  1. Lunatic

    Expression typed incorrectly/too complex?

    First, I'm dangerous, I have learned what little VBA I know in a very ad-hoc manner so I may have messed up some very fundemental steps. Problem: When I try to load a form with a sub-form, I receive the following error: It seems to be related to the subform, because the main form will load...
  2. Lunatic

    md .bat command in XP when path has spaces?

    Okay, 1. I'm not a programmer. 2. The last time I played with .bat files was somewhere in the late 90's and even then it was pretty low key as I never did get my door game BBS up and running, so I'm pretty out of the loop. In W95 and W98 I believe path names were truncated at 8 characters in...
  3. Lunatic

    Why Are Zero Things Plural?

    I've searched the forum and checked Wikipedia (http://en.wikipedia.org/wiki/Zero) but I can't find anything about this topic. I know Wikipedia isn't a definitive voice, but it is a good starting point to find out what you need to look for. Why are zero things plural? You have zero cars/things...
  4. Lunatic

    Event Procedure Timing and Logic Question

    This is regarding a sub-form that pretty much operates independently of the main form (other than to tie the PKs together). My problem is I can't figure out what order to run the event procedures to make the results of an update-query show in the sub form. *** Beginning - Dropdown combobox...
  5. Lunatic

    Can not, Cannot, Can't

    With the search feature down I'm reduced to a Google search of the entire website and checking every page of threads individually, so I appologize if I'm repeating this question (although I'm reasonably sure that any existing thread has been closed). My question deals with the 3 C's (no, not...
  6. Lunatic

    Using part of the Navigation Buttons?

    I'm working on a form that will be used for one year only (then a real programming team will take it over and integrate it into an online system), so I'm not looking for fancy, just functional (there will be only 1 user) What I would like to figure out is how to recreate only part of the...
  7. Lunatic

    Staff Hours Totals

    Help! The phrase "Staff Hours Totals" sounds wrong but "Staff Hour Totals" or "Staff Hours Total" don't make sense to me in terms of what is being reported. I'm working on a title for a report that reports Staff Hours, hence the first two words. However it also shows different types hours for...
  8. Lunatic

    Changing Control Source is a copy of a report?

    Here's the deal, I'm trying to save myself time but not smart enough. I've built a report that works for 1 table. There will be 9 other tables that I need to built reports for that are identical to this one. The problem I'm running into is I'm having trouble copying the report and the just...
  9. Lunatic

    Excel ActiveWorkbook.SendMail Dynamic Possibilities?

    In Excel I'm working on a macro that uses the ActiveWorkbook.SendMail feature and having some trouble finding the answers I'm looking for in the help file or in the archives. ***** Question 1) Using the basic ActiveWorkbook.SendMail can you send the e-mail to different people depending on the...
  10. Lunatic

    Flash capabilities question

    First, I have only seen/used other's flash projects, so I don't have any developer-end experience, just a hodge-podge of user experience. Please bear with me if my questions seem to asinine. Does Flash have the capability: 1) To export a datafile to a HD/portable drive or to an FTP site? 2)...
  11. Lunatic

    Laughable Business Proposals?

    First, my appologies if a thread like this already exists, I performed a few quick searches but didn't find anything similar. A post in another thread reminded me of a terrible proposal put forth by a company, in writing, to my high school. I'm interested hearing about those you all have...
  12. Lunatic

    OnDirty goto, but only after validated?

    Goal: In a series of fields on a form, user enters # in fields. If #: a) meets validation rule, focus is set to the next field. b) does not meet validation rule, error box appears informing of why (# =/= 1, 2, 3, or 9) and field is reset to null. What I've tried is to set the validation rules...
  13. Lunatic

    A #Deleted Question

    In a database I built for someone else I've run into a problem. There are 226 rows with data, however just a few minutes ago one of the rows of data suddenly displayed '#Deleted' in every column. A little more on the database Has 4 parts, 2 tables, 1 form and 1 subform. The form is has one...
  14. Lunatic

    Percent versus Percentage - A question

    Which one is singular and which one is plural? I recently came across a line that said something similar to: "What percentage of your chickens is new this year" Which apparently is grammatically correct (percentage and is go together, not chickens and is). I'm not disputing this, I'm just...
  15. Lunatic

    The idiosyncrasy of the English Language

    My applogies if this has already been posted, I searched for several of the phrases and couldn't find them in a search of MAI. My uncle sent these to me via e-mail, I don't know where they origionated from: *************************************** Have a problem with my spelling or grammar...
  16. Lunatic

    Quote versus Quotation

    This may be only the by-product of an over-zealous assistant forensics coach. In college he beat it into my head that you quote somebody and recite a quotation. I’ve almost posted this half a dozen times but the ‘favorite quote’ thread finally set me out to ask this question: Was my assistant...
  17. Lunatic

    Abnormal Enumeration?

    http://sportsillustrated.cnn.com/2006/writers/dr_z/12/13/rankings.part2/index.html Being a sports nut I read a number of online columns and Dr. Z (not the BMW commerical guy) is one of the best. He also happens to be a stickler for grammar (which should make him a favorite on this board)...
  18. Lunatic

    Adding the sender as CC?

    I've been requested to added the sender of an e-mail as a cc recipient. Unfortunately it could be one of 5 or 6 people from one of a dozen or more machines. Is there a way to have access look up what address is being used as the 'from address' and include that as a CC? I know there will be a...
  19. Lunatic

    strEmail As String

    I'm stuck again with trying to modify some code I'm borrowing from here... I'm trying to get Access send a message with the TO: address drawn from the field txtToEmail but that doesn't seem to be working... Private Sub cmdEmailTrackingNumber1_Click() Dim strEmail, strBody As String Dim...
  20. Lunatic

    Outlook.Application not defined

    I borrowed the following code from another thread: Private Sub cmdEmailTrackingNumber1_Click() On Error GoTo Err_cmdEmailTrackingNumber1_Click Dim strEmail, strBody As String Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem However I get a 'User-defined type not defined'...

Part and Inventory Search

Back
Top