Search results

Mark, This in a control source will round you mins down to the ladt 15mins =Int((DateDiff("n",[DateTimeStart],[DateTimeEnd],0,0)-([Hours]*60))/15)*15 Garry

Hi Mark, As you have posted should work. =DateDiff("n",[DateTimeStart],[DateTimeEnd],0,0) What does it give you? nothing> error#? Let me know. Garry

Hi Mark, Calculate your hours, then calculate you minutes. Hours=DateDiff("h",[DateTimeStart],[DateTimeEnd],0,0) Mins=DateDiff("n",[DateTimeStart],[DateTimeEnd],0,0) then you need to take your hours * 60. and take this value away from Mins ie Mins =(Mins - (Hours * 60)) Now you should have...

Sorry, never mentioned Access 2003, MSCAL.OCX required. Garry

Hi, Start off by adding 2 new text boxes to you form. These text boxes (datetimestart & datetimeend)should have the control source as =[datestart] & " " & [timestart] =[dateEnd] & " " & [timeEnd] This will concatanate the date and time together. Now you can easily use datediff to get the...

Hi All, I know there are several examples of calendar date and time pickers about so I thought I would offer mine up for critique. No modules, very little code, code used is simple and can be called from subforms as well as forms. I used these forms in an application where the users find...

Hi B, In response to your first question the answers is no it doesnt matter, each client does not have to logged off. As for the second question i will have to leave that for someone else to answer as i never use replica or backup, I use VBA to create backups by transfering tables etc. Garry

Sorted :) Thanx

Hi All, I'm having a bit of a blonde moment on this and would like some help. I am openeing a form (using VBA On click event of a text box) and passing on using OPENARG the Form name and text box name. DoCmd.OpenForm "Calendar", acNormal, "", "", , acNormal...

In that case you need to use like ("*" & [Forms]![Formname]![Comboboxname])& "*") In the criteria of your query. If you leave the combo box empty the result we be all of your records. Garry

You could try putting a "*" into the combo box or put like ("*" & [yourcriteria] & "*") into your query. Garry

When the error happens, go click on debug. When the fulty code is showing press CTRL + F to find. Find and replace "F-add reservation" with "F-Reservation Calendar" Dont forget to save. Try that and let me know Garry

Hi In the on current event of your form there are two lines of code that set myset Try replacing them with this code. Set myset = CurrentDb.OpenRecordset("SELECT [T-Reservation Calendar].*FROM [T-Reservation Calendar];", DB_OPEN_SNAPSHOT) Garry

Hi, Within the past 3 weeks I spotted a post that was based around a diary type form, It is distinctive in the way that the guy had created an image using Photoshop or something similar and used it as a backdrop to the form. It looked pretty neat. Problem is I cant find it again and I think...

Hi Dunne, This will take a little VBA code to sort, i will try and have a good look at it tomorrow. Garry

Hi Bob, Thanx for that, I have already used that as a workaround but it starts to get a little messy if I have to have a combo box and then a text box to translate an option group just to use it in a query. Thanx guys, I appreciate your help Garry

Good thinking........ Will give it a try. Garry

OK forget the like, Oringinaly I was using it with "*"& etc etc but took them out when I got the error, I just forgot to remove the LIKE From posts I have managed to find so far I dont think I can use a combo column in a query. Garry

Just to add by the way, I can use =Forms![Form1]![Lookup].Column(1) as a control source in a text box without error. Garry

Hi Ray, Thanx for the fast reply but still the same error message. Garry