Search results for query: *

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...

On my ASP page i have coded a insert query, the query is correct however when i check on the browser i get this error HTTP 500.100 - Internal Server Error Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an...

I have an entry form in Access where the use adds a new record to a table, i wish that before the entry is added, to run a query on the database, to check if that entry is already added, and to return back how many entries have been added of that name, and then to tell the user with a dialog box...

I have a SSL installed on my IIS version 1.1, i now have a new server with Windows 2000 and IIS 5.0, i wish to export my SSL over to the new server, i found help on the Microsoft site, but this only applied to IIS 5.0, can anybody help or advise? Thanks Kindi

I have a PDF that i wish users to download, at the moment when they click to download the PDF, if Adobe Acrobat is installed, the PDF opens in the browser, if Acrobat is not available, the user has to save the PDF to their PC. I wish the users to ONLY be able to save the PDF on their PC, how...

Our webserver went down, and the server was rebuilt with windows 2000 and IIS 4.0 as before. I have set up the websites as normal on IIS, however all websites that run with HTML files are working ok, but websites that are ASP scripts in the browser come up with a 'Object Disabled' error. Not...