Search results

i've got an asp page trying to create a table in an access database but when i run it, it says the db is read only. how do i change the permissions to allow the db to write. im running an iis server localhost with the latest access db set to access 2000 format

heres one that just don't add up from the beginning, i've got a form that puts data into a table from a text box named txtcomments, the table allows 255 chars to be stored the comments are show later using a copy of the input form, all this works great. now i'm taking this data and inserting it...

i have a form and was wondering if it was possible to take some of the fields and drop them into a template word document from inside access. so as to create a button that when clicked opens up the template and transferes the wanted form data. any idears how to automate this process would be...

got this code to get a record set and it works fine Private Sub Combo177_AfterUpdate() Dim db As Database Dim rs As Recordset Dim strSql As String strSql = "SELECT [Email] FROM tblAdvisorEmail WHERE (((tblAdvisorEmail.Client)= [Client]));" Set db = CurrentDb() ' Open pointer to current...

when i use an INSERT Sql function to update my database i get a popup warning telling me " You are about to append 1 row(s)". Is there a way of bypassing this warning so the database is just updated no fuss ? thanks in advance john

here goes im trying to count the number in a group between a time period. the query takes a time period from a form runs then reports who and how many heres what i get SELECT tblEstimate.Client, Count(tblEstimate.Recieved) AS MyCount FROM tblEstimate GROUP BY tblEstimate.Client...

Ill start from the dawn of time right all tables are like a 2d array so does any body know how i can access a field in a row of a table ie like in most languages it goes a bit like this ArrayName(1,1) with ArrayName being the name of the table and that access the first field of the first row...