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 IamaSherpa 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: GreekPatriot
  • Order by date
  1. GreekPatriot

    Display Month and Year Only

    What PHV suggested is what you requested. Mine works with the following alterations. 00/"01"/00;0;_ Cheers
  2. GreekPatriot

    Display Month and Year Only

    MAYBE IS BECAUSE YOUR MONTHS AND DAYS ARE REVERSED. For example mm/dd/yy dd/mm/yy Good luck. Sorry for not finding a solution. I am 99% sure that it does not exist.
  3. GreekPatriot

    Display Month and Year Only

    HMM i TRIED IT OK THERE IS A MISTAKE. WHEN YOU CHOOSE A DATE/???? THE LEAST INPUT YOU CAN INSERT IS THIS ##/##/## So I will correct the input mask to: 00/00;0;# 00/00/00;0;# This works not sure that this is what you wanted.
  4. GreekPatriot

    Display Month and Year Only

    IN DESIGN VIEW CHOOSE Date/Time AS THE DATA TYPE. HMMMM MINE WORKS
  5. GreekPatriot

    Display Month and Year Only

    mistake: input musk: 00/00;0;#
  6. GreekPatriot

    Display Month and Year Only

    field properties of table: format: mmmm yyyy input musk: 00/0000;0;# Regards Greek Patriot from Cyprus.
  7. GreekPatriot

    is it better to convert macros into modules?

    OK guys since you agree I have to agree too. Although one think that readily pops to mind is, if a module is assigned to a command button using the expression builder on click =myquit() where is the result?????? Where is the Null value?? ok this is where I get confused. Propably I am looking at...
  8. GreekPatriot

    is it better to convert macros into modules?

    PHV you are really helpfull, appreciated. This worked. Michael Red quote "Functions ALWAYS return a value" Does this function return a value??? Public Function myQuit() Application.Quit End Function Are you trying to confuse me more? I think a function always uses an equal sign...
  9. GreekPatriot

    is it better to convert macros into modules?

    Can I ask one more question??? How do you run a module from code builder??? say a module is called quit with a code as: sub quit() application.quit end sun The easy way is to copy paste the application.quit code. Assume that you are pressing a button on a form and on click you want to run...
  10. GreekPatriot

    is it better to convert macros into modules?

    This is what I understand (maybe I am repeating). I can have a module to contain both codes such as the one you have quoted (PHV) or a function. So a module can contain both. As I understand it is better to convert a macro into a module (function based), and best to convert a function to a...
  11. GreekPatriot

    is it better to convert macros into modules?

    this is a general sort of question. What are the advantages and disadvantages of converting macros to modules (functions)??? Another question is. What are the differences between modules and subroutines? Can a module be converted to a subroutine????? For example can this be converted to a...
  12. GreekPatriot

    how to update a some fields from a query to a table

    UPDATE [work items] INNER JOIN [Unscheduled Tasks Q] ON ([work items].[Package ID] = [Unscheduled Tasks Q].[Package ID]) AND ([work items].[Work Item ID] = [Unscheduled Tasks Q].[Work Item ID]) SET [work items].[Client Qty] = [unscheduled tasks Q].ClientQty, [work items].[Control Qty] =...
  13. GreekPatriot

    how to update a some fields from a query to a table

    the /b make table "work items" \b is based on the query with the sql I have mentioned above named variance table. This table would have been ommited if an easier way can be deviced without creating the temporary table "work items temp" mentioned in the sql above. But now things are compicated I...
  14. GreekPatriot

    how to update a some fields from a query to a table

    What I have is a macro on a command button which when pressed does the following: 1) opens the append query: make table "work items temp" 2) opens the delete query: delete "work items" 3) opens the append query: make table "work items" 4) opens the delete query: delete "work items temp" The sql...
  15. GreekPatriot

    how to update a some fields from a query to a table

    They say if its working dont fix it. Ok I have done the procedure I have described above and it is working. Just wandering though if there is an easy way to update data in a table.
  16. GreekPatriot

    how to update a some fields from a query to a table

    Is there a VB code to save a table as "save as"???? Thanks
  17. GreekPatriot

    how to update a some fields from a query to a table

    I forgot to mention that the delete table will be deleted using the delete query, which does not delete the field headings.
  18. GreekPatriot

    how to update a some fields from a query to a table

    Hello guys, Is there a way to update a few fields from a query to a "table"? I tried the update query but I get violation problems since I only have two fields to update. I could copy the "table" and named it "table temp". Then delete the "table". Do query calculations on the "table temp"...
  19. GreekPatriot

    Form doesn't recalculate

    ok I got your drify now. Hey this is excelent. It works the way I would have never imagined. Private Sub Quantity_AfterUpdate() Me.Requery End Sub Cheers TheAceMan1
  20. GreekPatriot

    Form doesn't recalculate

    sorry it should start like this Private Sub Quantity_Change() End Sub

Part and Inventory Search

Back
Top