473,325 Members | 2,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Access 2007 locking fields

I apologise in advance if my previous question has got itself held up in a queue, but there's been no sign of it for over 3 hours now...

I have a MAJOR problem, that I'm sure has a simple solution, but I've been hitting my head against this particular "brick" wall too often and I need to find a solution.

I create a form, with a combination of text boxes and combo boxes. All the Add/Edit/Delete options for the form and fields are set to Yes. There's no record locking there's no select from list only option set etc.

My problem is, is that something is locking the form. The form pre-fills the fields with the first record from the query; dead straight forward, there's nothing on the query to lock the record; the form is then locked, none of the fields can be edited, none of the combobox drop down lists allow selection.

What is locking up the form?

The only way I've got around this in the past is to completely start the form again from scratch. I'm too far down the development route to waste time doing that AGAIN. So please is there anyone out there who knows the foibles of Access 2007 Forms who might know what's going on.

I've tried unlocking EVERYTHING (all controls/form/detail etc) using VBA on form_open, but that hasn't helped either.

It just seems as if once the form is locked, NOTHING can unlock it again...
Nov 15 '10 #1
7 1481
TheSmileyCoder
2,322 Expert Mod 2GB
A few things spring to my mind:
When you open the forms recordsource as a query, are you then able to manipulate the fields?
If NO, then the problem is in your query design (Post SQL for further assistance)

If yes, you can edit records directly in the query, then the problem is likely in the form. Try to answer the questions below:
Are you using the form as a main form or as an embedded subform?
Is the form set to only only allow new records? I.e. is DateEntry Only set to yes?
Is the form Continues, Single, or split?

With smiles, TheSmileyOne
Nov 15 '10 #2
Apparently because one of the queries embedded three levels down uses UNION, the query is ReadOnly.

I need to use the UNION to create a single record from a lookup on 3 different tables that each contain address fields (I know, but the client wants to keep historical data on the records), so the UNION select was the perfect way to go about this...
Nov 15 '10 #3
NeoPa
32,556 Expert Mod 16PB
I'm afraid that simply will not work Jane. Smiley is right on the button of course. See Reasons for a Query to be Non-Updatable for more on this.
Nov 15 '10 #4
My problem is, is that as long as the query attached to the FORM is updateable, I see no reason why the queries attached to comboboxes should be updateable. That is not logical at all. Why is Access trying to UPDATE the lists attached to a comboBox?
Nov 15 '10 #5
NeoPa
32,556 Expert Mod 16PB
Clearly I misunderstood what you were trying to say. There is a big difference between the query the form's bound to (The form's RecordSource) and any other queries that may be used within ControlSources of any of your controls (bound or unbound). Referring to queries embedded three levels down as using UNION can only be a reference to the bound RecordSource query. If you're now saying that wasn't what you meant then perhaps a few steps back and trying again from a point we all recognise would be a good idea.

Is the RecordSource query updatable or not?
Nov 15 '10 #6
Sorry. The form is bound to an updatable table. The comboBoxes are bound to queries that reference queries that are UNION statements.
Nov 15 '10 #7
NeoPa
32,556 Expert Mod 16PB
Jane Alford:
The comboBoxes are bound to queries that reference queries that are UNION statements.
I assume you mean these controls are populated by the said queries? They must surely be bound to fields from the RecordSource driving the form.

Your earlier instincts were correct. The population of these controls does not affect the updatability of your form.

The problem is, that if that isn't the problem, then something else must surely be! Check out Smiley's post for other ideas and provide us with some more information about your form and what you're doing. Remember, except for the obvious (where we can guess what you're doing without even being told sometimes) we can only answer from the information you provide.
Nov 15 '10 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Ira Solomon | last post by:
Hi: Any quick opinions on Access 2007? Has anyone got this to coexist with Access 2003? Thanks Ira
16
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might...
0
by: Cindy Huyser | last post by:
I have an Access 2000 database behind a threaded Java application that that can have have concurrent access to the same table (but not the same record). The database is set up for shared access...
2
by: ARC | last post by:
Just curious if anyone is having issues with Acc 2007 once the number of objects and complexity increases? I have a fairly large app, with many linked tables, 100's of forms, queries, reports, and...
3
by: ali3n8 | last post by:
Hello im using access 2007 my fields are not showing on a form in Read Only mode, I checked and the fields are selected to be visible any tips on how to resolve this?
4
by: lupo666 | last post by:
Hi everybody, this time I have three problems driving me nuts :-((( (1) I have a report with 20 or so Yes/No "squares". Is there a way to either hide/show the "square" or change the yes/no...
1
by: mvlt | last post by:
I recently made the switch from Access 2003 to Access 2007. The rest of our office is still operating on 2003, so the database is still a 2003 file. We're having trouble with a few forms that work...
5
by: Peter | last post by:
Hi, i've got an older Access program, which is written in the version 2000 and i'd like to use it with my new office 2007, so access 2007. In the program, there is an replication written with...
3
by: tbeers | last post by:
Good morning. Access 2007 creates a locking file when a project is opened by users. what info is in the file and how do I read it? Thanks -Tomb
3
by: brat33 | last post by:
I am trying to use a command button to automate a process for creating mailing labels from a query in Access 2007, going into word 2007. Current code looks like the following: 'Start MS Word Dim...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.