Search results

Hello: You would need to construct a UNION query to do this. Regards Mark

Hello: Use the DateSerial Function DateSerial Function Returns a Variant (Date) for a specified year, month, and day. Syntax DateSerial(year, month, day) The DateSerial function syntax has these named arguments: Part Description year Required; Integer. Number between 100 and 9999...

Hello: Roughly, no points to you for your observation! Regards

Hello: Use "Null" Private Sub Frame1_AfterUpdate() Frame0 = Null End Sub

Hello: I tried Bobs solution and could not get it to work when I ran the query and exported it. YourNewColumn: "000" & [YourNumberField] in a query does work though Regards Mark

You need to make sure that the column in Excel that this item goes in is formatted as "Text" Regards Mark

Hello: Put the above code in the AfterUpdate of your Purpose control. Regards Mark

Hello: =DCount("[ArticleID]","YourTableNameHere) Place this as the ControlSource in a text box on your form or report. This should count all the articles.

Hello: =DCount("[ArticleID]","YourTableNameHere","StudentID = 7759") Place this as the ControlSource in a text box on your form or report. This should count all the articles student 7759 has. Regards Mark

Hello: In your query window, right-click on the query and select properties; check the Hidden box. Be advised a savy Access user can defeat this. Regards Mark

Your welcome and good luck with this.

Hello: You could put the code below in the AfterUpdate event of your "Money" control: If InStr(YourTextboxHere, ".") = 0 Then YourTextboxHere.DecimalPlaces = "0" Else YourTextboxHere.DecimalPlaces = "2" End If Regards Mark

Hello: !\(999") "000\-0000" Ext.: "0000;;_ would be the input mask syntax for what you ask. If you need to tweek it. Search online help for the input mask characters. Regards Mark

Your welcome and good luck with this!

"EXT":\ 99999;;_ Regards Mark

Hello: In your query design, insert a new column, and add the following in the field section: MyYear: Year([YourDateFieldHere]) This will extract just the year portion of your date. Then, enter the year for the criteria you want to query out. This can work for month, and day as well Regards Mark

Hello: Your welcome, and good luck with this. Regards Mark

Hello: place this in the format section for your field: $#,##0.00 Regards Mark

Hello: You want to use the Hours, Minutes, and Seconds function along with the Now function to extract the time. Syntax Hour(time) Regards Mark

Here it is.... http://support.microsoft.com/kb/307216/en-us Regards Mark