Search results for query: *

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

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.

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.

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

mistake: input musk: 00/00;0;#

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

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

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

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

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

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

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] =...

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

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

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.

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

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

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

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

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