RE: [ms_access] Time calculations for flight operations

Hi Dave, I have done something similar, but not to this extent. This is a great application for Access Basic of which I don't know very much, so I used querys instead. For each group/range of data I counted I had a separate query and eventually I linked all the query results via a common key

RE: [ms_access]MsgBox Error Help Please

Ilona- I assume this code is running in frmAssets. If so, then use the Exit event instead and do: Private Sub ReplacementValueDate_Exit(Cancel As Integer) On Error GoTo ReplacementValueDate_Exit_Err If (Me.ReplacementValue 0) And _ IsNull(Me.ReplacementValueDate) Then Beep MsgBox Please

RE: [ms_access] Batch Import Question

Gary- Short of writing some nasty code to open the text files directly, no. What's wrong with issuing several TransferText commands back-to-back? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for

RE: [ms_access] Code Help

Garry- How did you construct the switchboard? With the Switchboard Manager? Or, is it home grown? If the latter, open the form in Design view, select the command button you want to investigate, open the Properties window, and on the All tab scroll down until you find the On Click property. You

RE: [ms_access] Time calculations for flight operations

Dave- How about: SELECT Hour(OpsTime) As OpsHour, Count(OpsTime) FROM MyTable GROUP BY Hour(OpsTime) I thought the Partition function might also work to give you a range, but Help says it works only with whole numbers, and a time value is a fraction of a day. John Viescas, author Building

RE: [ms_access] Time calculations for flight operations

Yep, I tried partition because it seemed the best solution for what I am trying to accomplish. I was even trying to think about returning whole numbers for times and then accomplishing the partition. Will try your solution. Thanks again! Dave -Original Message- From:

[ms_access] Re: Cursor Type

adOpenDynamic = allow updates, MoveNext, MovePrevious adOpenStatic = Read only, MoveNext, MovePrevious, Bookmark adOpenForwardOnly = allow updates, MoveNext only adOpenKeyset = allow updates, Bookmark LockType adLockBatchOptimistic = Indicates optimistic batch updates. Required for batch

RE: [ms_access] Time calculations for flight operations

One last questionI have tried to do this...is there a way to break down from hours into 15 minute increments? Dave -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dave Moreau Sent: Monday, May 01, 2006 8:23 AM To: ms_access@yahoogroups.com

RE: [ms_access] Re: Code Help

OK. What is in the On Click property of the command button that you want to investigate? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For

[ms_access] Re: Code Help

Thanks again, Dawn. That tot my new report going. Now, for some reason, the command button for the Artist report that you helped me with is not working. I don't know. I don't think I touched that one. The command button still says to open that form, but nothing happens. --- In

Re: [ms_access] Re: Code Help

Which button? The one on the switchboard? Or the one associated with the combo box? Did you happen to rename the report? Dawn Crosier Education Lasts a Lifetime This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. -

Re: [ms_access] Max Size

How many fields are you importing at one time? If more than 255 then you are exceeding the capabilities of the Table Design, not the number of records. Dawn Crosier Education Lasts a Lifetime This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that

[ms_access] Re: Code Help

That info was already there. I redid it anyway. It still doesn't work. I created a new button with the same stuff, and this one seems to work. --- In ms_access@yahoogroups.com, Dawn Crosier, MVP [EMAIL PROTECTED] wrote: Go into the Switchboard Manager. Select the Reports switchboard.

[ms_access] Re: Code Help

I don't know. It seems like everytime I do something, comething else gets disabled. Now my new button doesn't work. Maybe I should make a new switchboard. --- In ms_access@yahoogroups.com, Dawn Crosier, MVP [EMAIL PROTECTED] wrote: Glad to hear you got it working. Dawn Crosier

[ms_access] Pls Recommend Access Class in SF Bay Area

Does anyone recommend a MS Access class in the San Francisco Bay Area? Thanks. [Non-text portions of this message have been removed] SPONSORED LINKS Microsoft access database