Displaying all Hours between user input start and end times

hi, 
I need to display all the hours between what my users enter as there start 
and end times.  Example Start: 7/13/2007 5pm  End: 7/14/2007 3am  I want to 
see 5pm, 6pm...1am, 2am, 3am in a column.  Is this possible?  I am familur 
with VBA but am stuck here.
-- 
Thanks
Vance
0
Utf
7/13/2007 3:56:02 PM
access.conversion 3037 articles. 0 followers. Follow

0 Replies
640 Views

Similar Articles

[PageSpeed] 3

Reply:

Similar Artilces:

Restrict users from entering duplicate items on POE
We have integrated Great Plains with Warehouse Management system which allows us to scan in PO receivings. Great Plains allows Users to enter duplicate items (skus) on a Purchase Order. Duplicate line items interfere with PO receivings and cause problems which are very frustrating and time consuming to resolve. So we would like the option of restricting dups. Thanks. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not...

Date Display on Report
I have read the many date display threads on this site but have a new question (at least I think it is new). I am running a report from a parameter query and am able to get the dates to display just fine, but I want to just get the month to display. I don't want the acutal dates from the parameter. I want it to display the Name of the month based on the dates from the parameter. Is there a way to do this? Format ([The Parameter],"mmmm") If the parameter is a reference to a form control Format([Forms]![The Form Name]![The control Name], "mmmm") Or if the cont...

Second UI thread not working properly if started from the main UI thread
Hi, My proj need to do some busy work and displays a progress bar. I designed the progress bar to run in a second UI thread. When the busy work is in progress, it will send message to the progress bar in the second UI thread to update the progress bar's location. The problem is, when the busy work is done in the working thread (case 1), the progress bar is working properly. However, when the busy work is done in the main UI thread without creating a work thread, the progress bar is not working correctly---the progress won't show up until the main UI thread finishes the loop ...

User can print check greater than invoice limit
We seem to have discovered a bug in Great Plains 8 Purchasing. In Vendor Maintenance Options, if you enter a maximum invoice amount, you cannot save an invoice greater than that amount (which is good). However, you can make a payables transaction entry which is greater, and while you cannot save it you CAN print a check from here for any amount you choose (including one greater than your maximum invoice amount). Should you do this, you not only get around the control, you cannot now close the window - you cant save the transaction because it is greater than the invoice amount (even thou...

Excel 2000 run-time error '7':
I am running Office 2K and just today, every spreadsheet I open I get the following error: "Microsoft Visual Basic" "Run-time error '7': " "Out of memory". Now I am running a 1.6GHz machine with .5GB RAM. I do not have any special addin's or anything non-standard from the normal office 2K professional install. As a note, after clicking "End" the spreadsheet opens. Occasionally, certain sheets only show 4 of the 8-10 worksheets. Any help would be appreciated. ...

Design time serialization!
Hi! My component has two properties which cause problems with serialization in the IDE: int Field1; MyObject Object1; The MyObject can be (binary) serialized and that works fine on its own. When this object is a property of a component, it can only be edited with the component editor (displaying separate form). When the component editor finishes, how can the designer know or be notified that that this property has changed and that it should update its value in the resource table? Currently the code generated by the IDE designer looks like this: this.myComponent.myChild....

Sum a calculated date/time field
When trying to sum the date time field I get a aggregate error that refers to the first field in the query that has nothing to do with the calculated field. I am able to convert it into integer format and subtract two date fields to get the total time. But when I try to sum the total time I get the aggregate error refering to the first field in query. This is the calculation I use to get the field I would like to sum. It works great but can not figure out how to sum it without the aggregate error. Elapsed Time: Int(CSng(([actual completion time]-[actual start time])*24)) & ":...

How to display inserted pictures with conditions?
Hi All Is it possible for me to write a code to display an inserted picture o my choice to only display when the value of a cell changes to what require for the picture to appear? I would really appreciate any hel provided. Cheer -- Message posted from http://www.ExcelForum.com Hi have a look at the following suggestion http://tinyurl.com/yulak -- Regards Frank Kabel Frankfurt, Germany > Hi All > > Is it possible for me to write a code to display an inserted picture > of my choice to only display when the value of a cell changes to what > I require for the picture to app...

Area chart display ENDS before data ?
Creating Simple area (test) charts - with data ending far before 'date', (hortz.axis); is no problem. Have the 'ending' section - VACANT.(to indicate future values to come). Does not having CONTIGUOUS data prevent that? -- Boswell ...

domain user with only Exchange/pop3
Hi, I'm moving from external mail provider to my own Exchange 5.5 / w2k srv. Some of my users has to use pop3 (not necessarily but anyway - offline access). Therefore I've got a question; what are steps to make domain user ONLY mail user, not allowing him to login, access files etc. Will it be enough to remove him from domain users group? thx, lunak ...

Preventing users fromm receiving the DB maintenance emails...
I have our Exchange server configured to run DB mainenance each Sunday night. Some of the users are complaining that they do not want to receive the emails that are automatically generated by Exchange after the db maintenance is complete. (Users eh???) Other than having them set up their own rules in their Outlook client to delete these messages, is there anywhere in the Exchange manager or Active Directory user accounts where you can turn those messages off for some users and not others? Thanks, Brad The ones that say they are over the limit? :-) I think they can fix that problem wi...

Time Reference
Can anyone help! I'm trying to enter a formula within a worksheet which references time. It should be quite simple but it doesn't work. eg =if(now()>q13,"do this",if(now()>q14,"do that","")) Both q13 and q14 are formated to the time format and contain the times 08:30 and 09:30 respectivly. I've been advised to use the MOD function, but this only provides the remainder, and produces an error within the formula. Lee, NOW() is date and time, so you need to strip the date =IF(MOD(NOW(),1)>Q13,"do this",IF(MOD(NOW(),1)>Q14,&qu...

how to handle tdate and time
I am storing two dates and times as a text value ie. "24/12/2009 23:54" & "25/12/2009 00:23" I need to evaluate the subtraction of these two values that are stored as text ( I need to secure they do not revert to a mm/dd/yyyy format (which they do despite my many efforts) when I sort) .... anyway.... I need the value as per example above to give me the result in hh:mm format.... 00:29 (29 mins) I need to do the calculations in VBA I have tried using DateValue and TimeValue in various arrangements but can't seam to find the magic words.... do ...

Stack Chart Legend Display
I'm making a stack chart based on a quality report. My X-Axis is displayed in Time (Weeks) The Y-Axis displays defect counts by week. There are close to 20 different categories a defect can fall into, however, most of the time there are 5 or 6 categories that have data week to week and some catergories that have not had a defect yet. How do I make the stack chart legend only show the categories that have data attached to it with a number larger than zero. This way the legend won't display all 20 categories, but only the ones that have a value. For Example, let's say I h...

How do I Time stamp individual rows in excel?
I have to use excel to update inventory. I don't know what formula to use. What I need to have is every time a record is added, a seperate column will put a time stamp there. I tried useing the NOW() command, but all the records changed when I added data in a row. Please help. "lost and confused" wrote: > I have to use excel to update inventory. I don't know what formula to use. > What I need to have is every time a record is added, a seperate column will > put a time stamp there. I tried useing the NOW() command, but all the > records changed whe...

Outlook appointments in extendend DST time frame are now off one h
I read through the prolific Microsoft documentation on the DST change. My interpretation on how to deal with my XP SP2 clients with Outlook 2003 on Exchange 2000 (on Win2K) was this. 1. Patch the XP SP2 clients 2. TZEdit the Windows 2000 server where Exchange 2000 is installed 3. Since most users do not have adequate privileges to run the Outlook tool TZMove, don’t bother giving it to them. 4. Use only the Exchange tool (MsExTmz.exe) (Also requires TZMove) to correct all the time zone issues in mailbox/calendars for all whopping 60 users. While the process was clear as mud, I though...

Delete Users!?!
My questions will surely sound stupid, but here we go : How do we delete a users in Microsoft CRM. It seam that none of the default Role as the right of deleting a users. Thank for folowing up, we are curently testing the product... Sorry David, but you can't delete users, only render them inactive, and revoke the license that you have applied against their account. "David Michaud" <anonymous@discussions.microsoft.com> wrote in message news:87d001c43254$9dd83350$a001280a@phx.gbl... > My questions will surely sound stupid, but here we go : > How do we delete a...

Excel suddenly started loading slowly
Excel has suddenly started taking 60-70 seconds to load, compared with (estimate) what used to be 5 seconds. After that, if I try to use it again, I get an option to start in it safemode as it did not start correctly last time. What can I do? Hi hsloane Check out this site's Opening/Saving Bottlenecks (Charles Williams) http://www.decisionmodels.com/optspeedd.htm#OpSave Troubleshoot Startup Problems(MS): http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280504 Some tips on overcoming slow response (David McRitchie) http://www.mvps.org/dmcritchie/excel/slowresp.htm -- Re...

messages will not display on Outlook Express
I cannot get my messages to display the text of the message. I can send and receive, but when I actually try to open a message the message will pop up, but without text. The hourglass icon is displaying, seeming like it's trying to pull the message up but it never comes. Does anyone know what I should do? anonymous@discussions.microsoft.com <anonymous@discussions.microsoft.com> wrote: > I cannot get my messages to display the text of the > message. I can send and receive, but when I actually try > to open a message the message will pop up, but without > text. ...

Run a query a few times
Is there a way to get a query to run 10 time. I would like a buttonthat will run a query 10 times.It would take a long time to expalin y i need to run it 10 times butthere is a reasonThanks Use a For..Next loop or a form timer and the DoCmd.RunSQL method....

User login problem
I have two users sharing a pc on my domain. When they open outlook it prompts them for their password. It takes five attempts then logs them on. If I login into the pc it works fine for me, I am in the administrators group if this may be why I have no problem. Exchange is running on Small Business 2000 server. ...

Vista changed Time Modified of files when the clocks went forwards
Coming to work today after the clocks had been put forwards on Sunday for British Summer Time and wishing to check if the files stored on my data pen were up to date, I saw that Vista had put the Time Modified of all its files exactly one hour forward. This is not a small problem with the program. Had I not realised this, I could have assumed that the files on that PC were the newer version (they weren't). It showed me as having ammended files after the time I'm supposed to have left the office. (I hadn't) I have XP at home and it did not do this to my files. Luck...

User Administration #2
I am working on an audit of Great Plains and I have a question regarding users with the ability to add/remove/changes users in Great Plains (Dynamics) 9.0. What privilege(s) must a user be assigned to give them the ability to perform user administration? I see that several users are assigned 'USER SETUP' but then when they go to create a user, it prompts them for a password. Thanks for the help. Tony Yes, that is how it works for us. The user has to have access to the user setup, but then it does have a separate "system password" to be able to enter that area. It is ju...

Order fulfillment by user
Is there a way to enquire on historical sales fulfillment to see which user fulfilled the order??? Thanks heaps Theo :) Theo, There is a last user field on the order that you can access using say SmartList Builder. A more reliable view may be the the CreatedBy Field on the invoice when it the order is transferred to invoice HS "Theo" <Theo@discussions.microsoft.com> wrote in message news:C2BA5162-7819-49FA-8139-B037BE99DD5F@microsoft.com... > Is there a way to enquire on historical sales fulfillment to see which > user > fulfilled the order??? > Thanks heaps...

Outlook 2003 on MCE using local user to auth against Exchange 2003
Hi, a user here is running MCE (thus NOT on the domain) and he's trying to connect with Outlook 2003 to an Exchange 2003 (RPC, NOT over HTTP). If he sets the check on "Always prompt for user name and password" he'll be asked multiple times to enter his Ex- change (domain) account once a while. As this is MCE, he can't store these credentials. This is quite annoying, that Outlook doesn't store these credentials at least for the time it's running. When the check is removed, Outlook always uses his local user account (HOSTNAME\LOCAL USER) to authenticate against ...