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
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 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 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
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 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
I have a PC that drops (for a split second) then re-connects the network connection at random intervals. I have changed the card, cable, port on the switch, the switch itself and still the error occurs GRRRRR. Any ideas? oh it was working fine one day then overnight it became broken. I...
Hello
I am trying to query a database using two dates and keep getting an "Object Required" error with no number. I get two dates from text boxes, format them and convert to srtings and use in an SQL select statement. Any help is much appreciated
eDate =...
Hello All
I had a query
strSQL = "SELECT Staff.StaffID, Staff.Lname, Staff.Fname, Staff.Address FROM Staff WHERE Staff.StaffID = " & forms![Setup]![Combo5]
that was causing the error "No given value for one or more of the required parameters" this was fixed by changing the query to
strSQL =...
Hello All
I have an access database that opens a word template as a word document, fills in some bookmarked textbox's then queries the database and adds and fills in row of a table. the problem I have is I cannot perform the document fill twice. if I close the document(saved or not) I cannot run...
Hello
I have a form with a drop down box (Combo5). Once selected I want to run sql in code but I keep getting an error at the recordset stage (rst.open...see below). The error says "Run-time error -2 2147217904 No given value for one or more of the required parameters" I have been round and...
Hello
I have a problem tracking a virus, the user sends mail via goldmine and the antivirus software on the server (where goldmine is running) detects a virus and deletes the attachment. I have performed full antivirus updates and scans on the workstation and server with no detections. If the...
Hello All
We have two hp8150 loaded with HP ps drivers running on NT 4.0. The problems we are having are when we print from Indesign the file balloon in size from 7-8mb to 50-130mb and transfer very slowly. This only occurs from Indesign if we PDF the file they print fine. I have test the pring...
Hello i have an issue with outlook express and the dial up connection. i removed a virus and ever since whenever outlook express is open and there is no connection, and i perform a send and receive there is a 20-30 second wait for the connection dialog to appear. any ideas ? when there is a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.