Search results for query: *

Hello dhookom Tried the code and it worked a treat! Thanks for your help pingIT

Hello All I would like to loup through a recordset setting three label captions with results. I cant attach a counter to the label in a loop (if that makes sense) lCnt = 1 Do While Not RS.EOF Me.Label3 & lCnt & .Caption = RS("record") RS.MoveNext lCnt = lCnt + 1 Loop The labels are...

Hello I have a client with an interbase database i want to shadow. The database is mission critical and I only have a short window 12.00am to 3.00am to backup. The server through a disc and I have had to restore from the backups losing 8 hours of data. The client wants to be able to restore to...

Hello All Thanks for your reply's. I think I have solved the issues. I have added ' to each end of the strings as I build the SQL and it appears to work Thanks v

Hello Glenn Thanks for the reply. I would like to keep all strings with all chars. I just need to know to let VBA know it is a string and for VBA to process it Cheers V

Hello All I have a query that returns values. Those values are then used in an insert query. The problem seems to be that some of the values returned are strings with "()" included. Im getting 3075 missing operator listing the string as the issue. Here is the insert query strSQL = "INSERT INTO...

Hello all Can a Windows 2003 server configured as the DC with DHCP serve DNS and IP's for non Domain PC's?. There is a Domain and a workgroup on the same physical network

Hello tsuji Yep that did it thanks very much

Hello All I am building a webpage using asp. The code puts a text box named ASSdate on the page then a button which launches a date picker to set the ASSdate value. Problem is when I go to access the value from JS I get the error "Object required" Here is the asp code: response.Write("<td...

Hello All I have a java function that creates a form with a dynamic number of "inputs" and sends it to an asp page The asp page is surposed to cycle through and Response.Write the elements The asp only shoes the first two words of the first element I have included the asp code and the...

Hello Feherke Thanks for the example. I have a couple of questions to get my head around this. 1.In the second example does the html address = the "where" variable and the array = the "what" variable. 2.Again in the second example does the function append seperate variables for each array item...

Hello All I have an ASP page that connects to an access db through IIS and displays the results of a query. There is Javascript on the page to verify user input and stores it in an array. I now want to pass the array to an asp page to input the data back into the database. I have tried and can...

Hello All Thanks for the replys. After some more investigation it appears you have to change the terminal server from application mode to install mode. thaen you can install software Thanks

Hello All I have a 2003 SBS R2 server which is the DC and another 2003 server which I think (but not sure) it is a terminal server. The problem is im trying to install AV on the DC and keep getting an access denied error no matter where I run the installer from Is there something im supposed to...

Hello All I have an ASP page that connects to an access db through IIS and displays the results of a query. There is Javascript on the page to verify user input. How do I insert the user data back into the database? I am new to this and have managed to bumble my way this far but am now stuck...

Hello Thanks for the reply. In the end I ran a repair from the XP disc and it sorted out the issue

Hello All I have and XP Pro installation that has had spyware removed. The problem now is when the user logs on explorer will not start (no desktop). This happens to all users. My guess is the registry is broken. Which keys need to be looked at to start explorer? Thanks

Hello I have a database where the user inputs dates in non american format. If they put in a date that is before the 10th of the month e.g. 02/11/2008 access turns it round in the table 11/02/2008. after the 10th all inputs fine e.g. 12/11/2008. Can anyone shed any light on this? any help much...

Hello All I am inserting a date collected from a text box into a table. when the date is inserted using an access query the date appears in the table dd/mm/yyyy. When i build the query in vba and use DoCmd.RunSQL strSQL the time is inserted Access query 25/08/2008 DoCmd.RunSQL 12:02:14...

Hello All Turns out the switch was failing. I was just a bit to impatient and needed to wait for about 5-10mins for the error to occur. Thanks for all your reply's