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

    Calculate Date by adding numeric field

    I have a simple request that I can't seem to locate the right option for the calculation to work. I just need 3 simple fields. Due Date + 31 days = New Date The Due Date & the New Date fields are formated to display as mm/dd/yyyy, and the 31 days field is a numeric read-only field because I...
  2. VisaManiac

    Wireless Network Options

    I think there is a way to view the wireless network connection history on a laptop, however what else can be gathered from viewing that history? I have a laptop that I'd like to find the wireless networks it's connected to in the past, but also see if there's a way to dig deeper and find out...
  3. VisaManiac

    Dynamic Hyperlink for Excel Tab Names

    I have this spreadsheet with lots of worksheets that is constantly being updated. I'd like for my first worksheet to list the names of all the worksheets, as well as hyperlinks to each related worksheet. This is all I have so far to create the list of tab names when I run the macro, but don't...
  4. VisaManiac

    Opinions, input and suggestions for WMV to flash

    Can you please give me your opinion, input and/or suggestions for converting WMV to Flash? I've heard that google & youtube utilizes this conversion and just wanted more info on it; and all I'm able to find so far are the conversion tools. I have some training videos that I need to display...
  5. VisaManiac

    Excel SUM colored cells

    I've tried pasting that exact code into VB and then in my cell typed in =SUMIFBYCOLOR(C6:C21,3,D6:D21,FALSE) but the results is #NAME? I think if someone can briefly explain to me in the code what areas I need to change to reference the right location in my spreadsheet, and the formula...
  6. VisaManiac

    Excel SUM colored cells

    I hope I'm posting this in the correct place. I've done some research and everyone is pointing me to use VBA for my excel funtion I'm searching for. I have on column C my dollar values, and D ~ O are months Jan ~ Dec. In those monthly columns no value will be input, just blue colored cells...
  7. VisaManiac

    Link form field from query

    I have a query that lists my order number and order total... SELECT OrderNum, Sum([ProductPrice]*[Quantity]) AS OrderTotal FROM OrderLines GROUP BY OrderNum Now, I'm trying to pull the OrderTotal field associated with that orderNum into my form, and my control source properties has the...
  8. VisaManiac

    Calculated fields for main form from subform

    OK, now another problem. I wanted this OrderSubtotal field to calculate and show up on my main Customer Orders form. I have the relationships setup, I have the above statement setup as a Query, and inside my form field that I want it to show the OrderTotal, the Control Source properties have...
  9. VisaManiac

    Calculated fields for main form from subform

    Oh MY!!!! SO SIMPLE!!! I was over-thinking it!! THANK YOU VERY MUCH!!
  10. VisaManiac

    Calculated fields for main form from subform

    Thanks TheAceMan1, but I'm not very familiar with Access to know exactly what you're referring to test it out. Reading back on it I don't think I was very specific. Here's what I've dabbled with since posting the above... I think I need to put together a query first, then reference the main...
  11. VisaManiac

    Calculated fields for main form from subform

    I have a "Customer Orders" form that contains a "Order Lines" subform. Within the order lines subform it has the fields OrderNum (hidden field linked from the OrderNum in Customer Orders), Product Number, Product Price, Quantity and Line Total. Obviously Access knows to tie the OrderNum fields...
  12. VisaManiac

    Switch Problem

    Awesome! Both had valid suggestions and resolved my statements! Thanks so much guys!
  13. VisaManiac

    Switch Problem

    I apologize for bringing in such a simple question, but I just enrolled in a beginners C++ class, and here's one of our questions...what am I doing wrong? It won't resolve. #include <iostream> using namespace std; int main() { int a; int x; cout << "Please enter a number between 1...
  14. VisaManiac

    Excel formatting formula

    I have this formula but I'd like to include formatting certain words in it to bold & italic... ="Your monthly investment is calculated by multiplying the above Patient Encounters per Month of "&TEXT(C2,"#,##0")&" times the Cost per Encounter number of months chosen. Example: if five (5) years...

Part and Inventory Search

Back
Top