Recent content by bongbang

Kind of. It's not urgent because this will be a refactoring of an already working code, plus I have an idea of how to do it (using a before-update script), but any suggestions would be appreciated.

I'm using the following scheme to track how unique widgets come in and go out. Movement (m) ---------- - id (pk) - move_on - origin_id - destination_id Widget (w) -------- - id (pk) - model_id - serial_number - from_movement_id (fk) - to_movement_id (fk) The receipt form is related to its...

Pat, Thank you for your reply. I know that this move is unnecessary, which is why I asked the question and indeed acknowledged as much in my original post. I'm just hoping for (a) an easier time when dealing SQL code (I really hate Access's "Notepad"), (b) an learning experience dealing with a...

Visuals will not be a salient feature of my application. They won't be accessed very often. It's just that sometimes, pictures and even videos are required for documentation. A good analogy might be the police's records. Normally, they deal with texts and dates and usual database stuff (I...

JLeach, Thank you for your detailed response. After reading, I'm inclined to just split the FE and BE as you recommend. Still, since this project is supposed to be educational as well as practical, I would like to explore the possibility of SQL Server some more. If for a little extra work, I...

I have a working Access DB application with a fair bit of VBA code. It's meant for a single user on one computer (me) and it's not very large (under 10 MB at this point, although it will get bigger when I start adding photos and perhaps even videos to it). There's no compelling need to migrate...

Thanks for the follow-up, Doc Man. Here are my responses to the points you raised. 1. Service_case is indeed a table. 2. The only relationship between between the two tables is the very field that we're trying to update, so join wouldn't work here. (I've used join with updates before with...

Thank you, Doc Man. I think you're getting me somewhere. Interestingly, though, c.contact_name does have a unique constraint (indexed, no duplicates), but apparently that isn't enough.

Pat, No to both of your questions, but the "id" field in the subquery is auto-number. Does that make the query "non-updateable"?

On my form, the default value of a subform field shows up on the New Entry row, even the row is not being edited. This is not only unsightly, but also misleading and confusing. Is there a way to have the subform's defaults show up only when they're needed (i.e. the new entry row is focused)...

Thanks for the suggestions, but are we sure that my query (w/ the subquery) is valid for MS Jet SQL? I tried an analogous query on a different pair of tables and it doesn't work, either. Here, too, when I replace the subquery with a number, it works. So I still suspect that it's the subquery...

Trying to update a table with a (single) result from another table, I got an "Operation must use an updateable query" with this query: update Service_case s set s.owner_id = (select c.id from contact c where c.contact_name = "foo") where s.device_sn = "bar" Is the problem due to the potential...

My original code is not "incorrect" with regard to the use of "Form" or brackets. It is the abstracted result of Access's auto-completion and it works. (It did contain a small typo that occurred UG noticed and that occurred as a result of my own abstraction. The one missing matching bracket...

Ridders, That's hardly different from what I had originally. Since it also specifies the main form by name, it will also suffer from the same drawback, which is the point of this thread. By the way, brackets are actually okay. I wouldn't put them on were I to write the thing entirely by...

Doesn't work. Nor does the following: [Forms]![My_Subform].[Form]![My_Subform_Control] I guess I'll have to write a VBA script, which is not the end of the world. I just thought using query criteria was an elegant solution.