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

thats if you want to spacificly target a collum to enter the data into i;m entering data into all the collums so as long as your aware of that it doesn't really make much differance. the problem im having isnt with the sql command syntax its with the amount of chars the db will let me enter...

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

Big shout to EMP Thanks that was spot on john

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

im going to start from scratch i may be some time thanks for all your help but i need to just go away and come back to it with a clear head laters, john

yes it was a spelling error and yes im compering two enties on a form. im trying to narrow down the record set to just 1 email so i can put it somewhere else i have a table with 3 collums Client, AdvisorName and Email and the form contains 2 combo boxes named Client and ClaimsAdvisor. the query...

tried that still getting the same error its doing my head in, i carnt see whats wrong and when i take the AND part out everything works fine.:confused: thanks john

run time error 3061 two few parameters, expected 1 that the error message and i copied and pasted carnt see the typo myself could you point it out thanks john

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

Thanks to everyone john

cheers mate nice one john

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

cheers pal that hit the spot thanks for your help john

to jon K thankyou alot this might sound cheeky but i was wondering if you could maybe explain your sql in a little detail as im interested in how it all works, bought the books but that no substitute to the man. thanks for the code anyway it works atreat john humbled.

did that but just got an error that tblEstimate.Recieved was not part of the aggregate fuction 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...

Thanks pat nice one john

hello ken got any good sites for the sort of info i need thanks in advance john

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