Search results

Having ruled out all the reasons on Allen Browne's Read-Only Query page, I finally thought to search on the actual error message I was getting and found this page: rogersaccessblog.blogspot.com/2009/11/this-recordset-is-not-updateable-why.html I started working through the solutions to the...

Anyone? Anyone?? Bueller... Bueller... Got swamped at work for a week, but still no other responses?? Still need help!!

Anyone new on this morning who might be able to help me??

Started the video, but the text boxes in my form are "bound". I took the MedClaims query (design in pics attached to OP), went to the Create tab, and clicked Form. On that form, I clicked the new record button at the bottom. I tried to type in a Claim Number and got the above error. I...

I'm new to Access and Databases, but here's my stab at it... Given your Time Card Hours table: Hours for all entries for Tech1 that start and end on 10/21/2012 + (Hours for all entries for Tech1 that end on 10/21/2012 - Any hours before midnight that morning) + (Hours for all entries for...

I first encountered the problem trying to enter a new record through the form. Made sure "Data Entry = Yes", but still no-go. Back-tracked to the query behind the form, and had exact same behavior trying to enter a new record in the query. I figured my problem was in the query, not the...

Hi, all, Using Access 2010, and this is my first db ever! Thought I had the "simple stuff" down... See attached pics for table relationships and query design. Primary Key in InsClaims Table is an Auto-Number. I can easily add an entry to the InsClaims Table. Start typing in the Claim...

Augh!! No New Record row = Read-Only Query!!! I had mentally disregarded that part of Allen Brown's site!! Thank you SO very much.

My Access 2010 database manages my family's health claims to make sure we're maximizing our benefits. After a few rounds of re-work and some research on normalization, I believe my table design is sound. I was able to create the forms and sub-forms, and the queries behind them, to enter all the...

Feeling that I've conquered Excel, I've moved on to learning Access. I've had an interest in learning database design, ever since I learned it existed and realized I had no natural talent for it! To that end, I've purchased Access 2010 and started a database to help me organize our medical...