Recent content by Kindi

Hi I have 2 fields called start and end time, they are date/time datatypes, and when i have created the form i have put the short time input mask. BUT when i run the form it is the long time input mask (which includes seconds). This is the input mask code in the property sheet for the 2...

Hi I have 2 fields called start and end time, they are date/time datatypes, and when i have created the form i have put the short time input mask. BUT when i run the form it is the long time input mask (which includes seconds). This is the input mask code in the property sheet for the 2...

Hi gol4 Thanks yes it did work for me, just that by using the "h" i got difference in hours and i needed minutes. Everything works as it should now. Many thanks

I have 2 text boxes, starttime and endtime, when the user enters in start and end times, another third box populates with the total time take between the start and end times, the control source of the total time is set to this: =DateDiff("h",[startTime],[EndTime]) All of this works...

Hi When a user enters in text in 2 text boxes on a form, i wish them to click a validation button. The validation button will then run a query and the query will comprise of information added in the text boxes above, the results will then appear on the same form on a label. To do this a...

It seems like that Access does not know what a DAO is, or the keyword DAO. In Access i can use the recordset keyword without the DAO, but the keyword database is not available, please help! Thanks

Hi Instead of using "h" in the datediff function i used "m", this doesnt work either.

When designing the form, in the toolbox is a command button that you can put on the form, this then runs a wizard, in this wizard you can create a button to delete the current record on the form. You do not have to do any coding the wizard does this for you.

Hi Thanks i used the above code as suggested, but when i run the button i get this error box: Compile Error: User-Defined tyoe not defined and the db "As DAO.Database" is highlighted in blue. How can i solve this? Thanks.

Hi Thanks as you suggested, that is what i am trying to do, and it works! thanks. But if the start time is 09.29 and end time is 9.36, the total is still 0. If i input start time 10.00 and end time 14.00 this brings up 4 hours which is correct. How do i bring up the time difference in...

Hi Thanks for the help above, but what i did was in the text box was in the control source i called the expression builder and added as you instructed above: =DateDiff("h",[StartTime],[EndTime]) But when i run the form, and the start and end times are entered nothing happens, what...

Hi A user has two input time boxes one for start time and one of end time, once the end time is clicked i wish the total time to be work out between the start and end time, and then to enter this total time in a text box on the same form. On the expression builder how can i do this, i have...

Hi When a user enters in text in 2 text boxes on a form, i wish them to click a validation button. The validation button will then run a query and the query will comprise of information added in the text box above, if the query returns data, i wish this data to appear on the same form on a...

Using a NetWare Client Thanks Kindi

I have created a virtual directory on IIS 5.0, and i map the virtual directory to a folder on my netware server which is running Netware 3.0. In IIS i see an error symbol next to the virtual directory, but when i click at the virtual folder it shows me the contents - which are all correct...