Database Updating But Not Showing Anything
Mar 24, 2006
I have a small form that when people fill in it should update their details intomy database. However the page seems to be working fine and completes corerectly. But when i go to the table in the database it just enters a blank line fo reach field.
Here is the code
Code:<%@ Language=VBScript %><% Option Explicit %><!--#include virtual="/adovbs.inc"--><html><body><%Dim objConnSet objConn = Server.CreateObject ("ADODB.Connection")objConn.ConnectionString= "TPVSite"objConn.OpenDim ObjRsSet objRS = Server.CreateObject ("ADODB.Recordset")objRS.Open "tblBrochure", objConn , , adLockOptimistic, adCmdTableobjRs.AddNewobjRS("fldInitials") = Request.Form("Initials")objRS("fldSurname") = Request.Form("Surname")objRS("fldAddress1") = Request.Form("Address1")objRS("fldAddress2") = Request.Form("Address2")objRS("fldAddress3") = Request.Form("Address3")objRS("fldAddress4") = Request.Form("Address4")objRS("fldPostcode") = Request.Form("Postcode")objRS("fldPhone") = Request.Form("Phone")objRS("fldEmail") = Request.Form("Email")objRS("fldAge") = Request.Form("Age")objRS.UpdateResponse.write "ThankYou For registering."Response.write "<A Href='login.html'> Login </a>"ObjRs.CloseSet objRS = NothingobjConn.CloseSet objConn = Nothing%></body></html>
Anyone any ideas why??
Cheers
View Replies
ADVERTISEMENT
Jan 12, 2012
I have a backend-database on a network disk shared by 6 users. All users have a frontend client wich they use to administer the datebase. Everything in the frontend looks ok and they can query the latest data. However if I open up the backend database tables nothing has been updated since the middle of december. If i make a copy of the backend I can open it up and create new posts with ID-numbers that has already been taken by the frontend.
Ofcourse I have doublechecked that the clients are connected to the right backend file (there's only on backend file in the directory).
View 1 Replies
View Related
Sep 12, 2012
Database: Access 2007
I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.
Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.
What is the best way to do this?
View 1 Replies
View Related
Jul 28, 2006
I've got a database with several users and we've had two people recently who rather than creating a shortcut to the db on their desktop copied it and then proceeded to enter their data there instead of into the one on the network.
I would like to be able to add a field on the first page they see when they open it with the complete file name / path information. I know how to do it in Word by adding a field to a header or footer. However, I can't seem to figure out how to do it in Access.
My hope is that if I can display the path and then include a dialog box when the database is opened warning users to verify they have the correct version before they enter any information.
Alternatively, is there a script I could write that would have the db check that it's the V drive copy not a C drive copy?
Any and all help will be greatly appreciated. Thank you.
Charis Wilson
Denver, CO
View 3 Replies
View Related
Feb 21, 2007
Hi All,
I have a database that is locked down with user-level security, and also have my startup settings set so Display Databse Window is unchecked.
This all works fine, and when the user opens the database, the form I want them to see appears, and everything else is locked down.
EXCEPT - if anyone minimizes Access, then maximises it again, the Data Window appears in the windows taskbar!! So anyone can click on it to display it in Access and can view all the macros, forms, tables etc that I've tried to prevent access to! :confused:
Anyone come across this before??
Thanks in advance, dglover
View 2 Replies
View Related
Aug 10, 2005
Would this work: Having a command button that opens another database. Cheers
View 1 Replies
View Related
Jun 2, 2006
Please help me fix my database
If you take a look at the tab called insurance i have a list box. How do i filter the list box so that it will only display the patients insurance based on the demo tab.
Also i have other records in the table called people. they are not showing in the people form. when i use the mouse wheel automatically creates new record please help
View 1 Replies
View Related
Apr 13, 2005
Ok, not sure whether this is an ASP error or an Access error, but think its more likely to be an Access error.
Right, heres my problem..
Have written an ASP script where you chose a 'week commencing' and it then displays all laptop bookings in a school in a table.
Now it does this by doing a query on the 'Booking' table WHERE the 'week commencing' = xx/xx/xxxx (Date)
Now having inputted all current dates of the current term, weeks commencing:
11/04/2005
18/04/2005
25/04/2005
02/05/2005
09/05/2005
16/05/2003
23/05/2005
Now, my asp script gives me a drop-down box where i choose my 'week commencing'.
If i chose weeks commencing '18/, 25/, 16/, 23/' the tables all appear fine.
However when i select '11/, 02/, 09/' no data is taken from the database and i get my message 'No Booking data found!'
But the data IS there in the database.
What am i doing wrong? Could it be the Language settings i.e UK/US settings (date format etc)
Is there something wrong with my code???
Please help me... driving me nuts!
Code:<<A href="mailto:%@LANGUAGE="VBSCRIPT","JAVASCRIPT">%@LANGUAGE="VBSCRIPT","JAVASCRIPT" CODEPAGE="1252"%><!--#INCLUDE FILE= "adovbs.inc" --><%' Open Database ConnectionSet Con = Server.CreateObject( "ADODB.Connection" )Con.Open "accessDSN"' Open RecordsetSET RS = Server.CreateObject( "ADODB.Recordset" )RS.ActiveConnection = ConsqlString = "SELECT DISTINCT book_week_com FROM Booking ORDER BY book_week_com"RS.Open sqlString, Con,adOpenStatic%><FORM name="formCategory"><SELECT name="qryCategory" onChange="getFilter(this.form.qryCategory)"><OPTION selected>Select a Week:<% DO WHILE NOT RS.EOFResponse.Write( "<OPTION value=" & rs("book_week_com") & ">" & rs("book_week_com") )RS.MoveNextLoopRS.CloseSET RS=Nothing%></OPTION></SELECT><BR></FORM><SCRIPT language="Javascript">function getFilter(listitem) {var object = "";var listValue = getListValue(listitem);document.formCategory.submit(listValue);}function getListValue(list) {if (list.selectedIndex != -1) {listValue = list.options[list.selectedIndex].value;}return (listValue)}</SCRIPT> <%IF Request.QueryString( "qryCategory" ) = "" THENResponse.Write("Please select a Week from the list:")ELSE' Build QuerySET RS = Server.CreateObject( "ADODB.Recordset" )sqlString = "SELECT book_day, book_date, book_period, book_teacher_code, book_room, book_number "sqlString = sqlString & "FROM Booking WHERE book_week_com = #" & Request.QueryString( "qryCategory" ) & "#"sqlString = sqlString & "ORDER BY book_date, book_period, book_date_booked"RS.Open sqlString, Con,adOpenStaticIF RS.RecordCount = 0 THENResponse.Write( "<H3>No Bookings found for Week Commencing: " & Request.QueryString( "qryCategory" ) & "</H3>" )ELSEResponse.Write( "<H3>Bookings found for Week Commencing: " & Request.QueryString( "qryCategory" ) & "</H3>" )' Build a Table Here Response.Write( "<table BORDER=4 align=left width=500>" )Response.Write( "<tr>" )Response.Write( "<td <strong><font size=4>Day:</font></strong></td>" )Response.Write( "<td <strong><font size=4>Date:</font></strong></td>" )Response.Write( "<td <strong><font size=4>Period:</font></strong></td>" )Response.Write( "<td <strong><font size=4>Teacher Code:</font></strong></td>" )Response.Write( "<td <strong><font size=4>Room:</font></strong></td>" )Response.Write( "<td <strong><font size=4>Number:</font></strong></td>" )Response.Write( "</tr>" ) DO WHILE NOT RS.EOFResponse.Write( "<tr>" )Response.Write( "<td>" & RS("book_day") & "</td>" )Response.Write( "<td>" & RS("book_date") & "</td>" )Response.Write( "<td>" & RS("book_period") & "</td>" )Response.Write( "<td>" & RS("book_teacher_code") & "</td>" )Response.Write( "<td>" & RS("book_room") & "</td>" )Response.Write( "<td>" & RS("book_number") & "</td>" )Response.Write( "</tr>" )RS.MoveNextLoopRS.CloseResponse.Write("</TABLE>")END IFEND IFSET RS=Nothing%>
Thanks
View 2 Replies
View Related
Jun 4, 2014
I have a database that is split - one central PC holds the back end, and then there are multiple end users with a copy each of the front end.We have updated a drop down menu on a field in the back end to add some new entries, but this is not showing up on the front end copies.Is there an easy way of updating the front end to show the changes?
View 3 Replies
View Related
Jun 5, 2006
Hi Everyone! I am a huge novice in database programming. I have a very basic database that I put together. I understand how to retrieve records and such, but I need to be able to perform mathmatic calculations in queries. I either need a new database written, or the one that I have ''tweeked''. I have no clue what the going rate is, but i am willing to pay. Just let me know what your cost is. Contact me @ davemayer@bellsouth.net or if you would like on the forum. Once you contact me I will give you my phone number and we can discuss the specifics of the database and whatever $ you will need to do the job. I am in a bit of a hurry to get this done, so let me know ASAP. Thanks a million. Dave.
View 1 Replies
View Related
Dec 6, 2006
I've set up a database for product tracking. It is going to be used by several users at one time. I'm going to implement it in stages as inevitably there is going to be some fine tuning to be done etc. I have a few questions with regards to editing.
1, I presume that I cant alter the database while it is being accessed by others?
2, Is it better to alter another copy of the database and the import the data being generated and then copy it to back the server in one go?
3, If so how do i do this as I’ve had a trial go and failed miserably?
4, Is there another way of doing this minimising the down time of the database?
Being relatively new to access your help would be gratefully appreciated.
cheers
EQ
View 1 Replies
View Related
Jan 17, 2007
Hello
I have a database which i am constantly updating and improving. I have a few friends who use the database in a current form. If i made an update say to a form or to some of the coding to make the DB more efficent, how can i update the dBs my friends are using without damaging or changing the existing data, or migrating it to the new design.
I.e going from version 1 to version 1.1
Any advise would be great?
View 5 Replies
View Related
Jan 17, 2006
Hi
I am having problems updating my database using a dropdown menu can someone see where I have gone wrong:
Error:
ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/update_style.asp, line 34
************************************************** *******
drop down form:
Code:<% 'Dimension variables Dim styConn 'Holds the Database Connection Object Dim rsstyle 'Holds the recordset for the records in the database Dim strstyke 'Holds the SQL query for the database Dim lngRecordNo2 'Holds the record number to be updated 'Read in the record number to be updated lngRecordNo2 = Request.QueryString("RemID") 'Create an ADO connection object Set styConn = Server.CreateObject("ADODB.Connection") styconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=ny database connection is here that's not the problem;" 'Create an ADO recordset object Set rsstyle = Server.CreateObject("ADODB.Recordset") 'Initialise the strSQL variable with an SQL statement to query the database strstyle = "SELECT memorial.pagestyle FROM memorial where remid=" & lngRecordNo2 'Open the recordset with the SQL query rsstyle.Open strstyle, styConn %> <form name="form" method="post" action="update_style.asp?remid=<%=lngRecordNo2%>"> <tr> <td width="50%"> <select size="5" name="pagestyle" style="width: 95%;" style="border:1px outset #5286A5; " style="border:1px outset #5286A5; " multiple style="border: 1px outset #5286A5"> <option value="Bible">Bible</option> <option value="boat">boat</option> <option value="candles">candles</option> <option value="child1">child1</option> <option value="child2">child2</option> <option value="cross">cross</option> <option value="diary">diary</option> <option value="footprints">footprints</option> <option value="heaven1">heaven1</option> <option value="landscape">landscape</option> <option value="music">music</option> <option value="ocean">ocean</option> <option value="ponga">ponga</option> <option value="rose">Rose</option> <option value="rose2">Rose2</option> <option value="sky">Sky</option> <option value="toitoi">Toitoi</option> <option value="valley">Valley</option> </select></td> <td width="50%"> <font face="Arial" size="2" color="#5286A5"> Click here to view what each style template looks like.</font></td> </tr> <tr> <td width="100%" colspan="2" align="center"> <input type="submit" value="Submit New Style" name="style" style="color: #FFFFFF; font-weight: bold; border: 1px solid #5286A5; background-color: #5286A5"></td> </tr> </form> <% 'Reset server objects rsstyle.Close Set rsstyle = Nothing Set styCon = Nothing %> ************************************************** * The scripted page after submission (where the error accures): <!-- #INCLUDE FILE="connection.asp" --> <% 'Dimension variables Dim adoCon 'Holds the Database Connection Object Dim rsUpdateEntry 'Holds the recordset for the record to be updated Dim strSQL 'Holds the SQL query to query the database Dim lngRecordNo 'Holds the record number to be updated 'Read in the record number to be updated lngRecordNo = CLng(Request.Form("Remid")) 'Create an ADO connection object Set adoCon = Server.CreateObject("ADODB.Connection") 'Set an active connection to the Connection object using DSN connection adoCon.Open Connect_String 'Create an ADO recordset object Set rsUpdateEntry = Server.CreateObject("ADODB.Recordset") 'Initialise the strSQL variable with an SQL statement to query the database strSQL = "SELECT memorial.pagestyle FROM memorial WHERE remid=" & lngRecordNo 'Set the cursor type we are using so we can navigate through the recordset rsUpdateEntry.CursorType = 2 'Set the lock type so that the record is locked by ADO when it is updated rsUpdateEntry.LockType = 3 'Open the recordset with the SQL query rsUpdateEntry.Open strSQL, adoCon 'Update the record in the recordset rsUpdateEntry.Fields ("pagestyle") = Request.Form ("pagestyle") 'Write the updated recordset to the database rsUpdateEntry.Update DIM strCustomerID strCustomerID = rsupdateentry("remID") 'Reset server objects rsUpdateEntry.Close Set rsUpdateEntry = Nothing Set adoCon = Nothing 'Return to the update select page in case another record needs deleting 'Response.Redirect "update_select.asp" Response.Redirect ("editmemorial.asp?REMID=") & strcustomerid %>
View 4 Replies
View Related
Aug 21, 2006
A client has had a database in operation for about a year. They requested some updates. I have been trying to figure out an easy way to update table structer with out having the client go into the backend and add a field or two.
I wrote an update program, that copies the table from their backend, and copied it to the updated table and tried to copy it back to thier backend, but since it is in a relationship, it won't let me.
Any suggestions?
View 2 Replies
View Related
Mar 15, 2007
Hi, im currently working on a database which is for someone else. Whe it is handed over to them, they will no doubt want some changes done every so oftern eg new reports, changes to forms etc.
What is the best way to do this? The database holds a lot of data, so I dont think its feasible for them to send it to me via email everytime they need something changed!
Ive noticed a few posts here about splitting the database into a front/back end. If this was done, would they just have to send me the front end; this would probably be a smaller file ye?
If this is going to be the best way round the problem; how easy is it to split a database which is basically already made?
Thank!!!
View 3 Replies
View Related
Mar 15, 2007
Hi, im currently working on a database which is for someone else. Whe it is handed over to them, they will no doubt want some changes done every so oftern eg new reports, changes to forms etc.
What is the best way to do this? The database holds a lot of data, so I dont think its feasible for them to send it to me via email everytime they need something changed!
Ive noticed a few posts here about splitting the database into a front/back end. If this was done, would they just have to send me the front end; this would probably be a smaller file ye?
If this is going to be the best way round the problem; how easy is it to split a database which is basically already made?
Thank!!!
View 3 Replies
View Related
Feb 9, 2005
Hi there,
I have a number of Yes/No fields in my database (their default value is False), and I am looking to update these via one of my webpages via INSERT INTO... statement.
What I have is a checkbox on the page, with checked value as true, and then before the values are written to the database, for the unchecked boxes, it converts all empty check box values (ie the ones which have been left unticked) to false, so the INSERT INTO statement will either write true or false for each checkbox, like this... true,true,false,true
The thing is, on executing the code, it add all the other details fine, and hits no errors, but NONE of the checkboxes get updated... these ALL remain unticked in the database, so ignoring any true values which are written to it. Please can someone help, I would be sooo thankful ).
View 1 Replies
View Related
Feb 21, 2005
Hi
Beginner at ASP VBscript. Hi I'm trying to update a Access database through a form using ASP VBScript. Kind of lost. I've looked at some sites and they all have complex ways of doing it. CAn anyone help with a simple little example. say a table with firstname and second name.
Any help would be great!
View 1 Replies
View Related
May 10, 2006
I'm having difficulties creating a sql statement which updates data in another Access database from a current database.
I'm able to do an insert and delete statement just perfectly, but not an Update. :confused:
For example, here is a dummy sample (which does not work):
Update tbl_test1 IN '\C:Tempabc.mdb', tbl_test2
set tbl_test1.Name = tbl_test2.Name
Where tbl_test1.ID = tbl_test2.ID
I tried a couple of variations, however, I keep getting an error.
Also, I don't want to create a database link (due to the sheer complexity of my project, which I'll spare you the details..)
Does anyone know how to do this? I searched the forums and came up with zilch! =(.. Help??!
View 1 Replies
View Related
Sep 17, 2013
I have been asked to add features (and fields) to an existing database containing private medical data. The idea is to add features to the empty database, test it with fake data, purge the fake data and deliver it to the user in another state with a simple update button. The Access 2010 database is in one piece (No front/back end).
I am looking for the best/shortest VBA method to move a lot of preexisting field data from the old database to the new version. I think I have it mostly figured out; I have code for counting, reading and writing the table names, field names and field data.
However, because the data types vary within the tables and there will be new fields in the new versions tables, my only idea, so far, is to code through the data table-by-table and field-by-field, a lengthy process with a large footprint. Moving entire tables or complete records may not be effective. Any faster way to transfer all these tables field data?
View 3 Replies
View Related
Jun 2, 2014
I have a split database. I have just created anew table in the back end and created a relationship to an existing table. All done in the backend.
I have opened up my front end and imported the back end end. But when I check the relationships in front end neither the table or link is there.
View 1 Replies
View Related
Sep 14, 2012
I would like to know if there is a way to update information in my Access database via e-mail.
I tried to do this, but when I collect from the e-mail, it creates a new entry in the database.
View 1 Replies
View Related
Feb 20, 2015
I am currently updating an old Db which rosters staff. One of the enhancements will allow the user to automatically allocate staff details to a Roster after a given date. i.e. Roster date 20th Feb 15, repeat for 3 days. 21st 22nd 23rd Feb 15. I have created a form with a medium date field and then a Combo box with drop down values of 1 thru 7 days. I want to link the combo box value to the Date box.
View 3 Replies
View Related
Jan 23, 2014
I am currently updating an Access database, any way to send an OLE Object (in this case an Excel Spreadsheet) as an attachment to an email address using VBA code? I made a form that shows the Excel Spreadsheet when the record is brought up, but I need to know how to send just the Excel Spreadsheet and not the other information on the form.
Also, if there is an alternate way to have an Excel spreadsheet embedded into an Access form, i'm open to change. The user wants to be able to see the Excel spreadsheet and send it to their supervisor without having to locate the Excel spreadsheet on the hard drive.
View 2 Replies
View Related
Jul 28, 2014
I have a MS Access table containing Dependent social security numbers but some of the dependents social security numbers are blank.
I have a MS Sql Database that contains a table with most of the missing MS Access table dependents Social Security numbers.
How can I take the Dependents social security number from MS Sql Database and copy/update the MS Access table.
I tried the sql code below created from MS Access and it matches 453 records out of 460 dependent social security numbers but how do I update qryGHIAccuracyFile_MissingDepSSN.SSN with the social security number from dbo_depfile1.dep_depend_ssn
Code:
SELECT dbo_depfile1.dep_depend_ssn, qryGHIAccuracyFile_MissingDepSSN.SSN
FROM qryGHIAccuracyFile_MissingDepSSN LEFT JOIN dbo_depfile1 ON qryGHIAccuracyFile_MissingDepSSN.MemberSSN = dbo_depfile1.dep_ss_nbr
WHERE (((dbo_depfile1.dep_first)=[FirstName]) AND ((dbo_depfile1.dep_last)=[LastName]));
Updating MS Access table dependent blank SSNs with SSN in MS Sql Database.
View 2 Replies
View Related
Nov 12, 2012
I have a Database that has been split into two.
Back-end for all the data.
Front end for all the forms and queries.
The front end has been saved in a accde format and distributed to 20+ users. They have all saved this onto there computers and this is used as an application.The users complete a form on a weekly basis on the application and then save. This then saves into the back end.For some reason I have noticed that a few users submission randomly do not save. For the life of me I cannot understand why.All users have saved them into the back end in the past but every now and then submission for users do not save.
View 5 Replies
View Related
