Requery Error When Entering Design View For A Form

Jun 5, 2014

I am modifying the Students template for a student & alumni administration database for our non-profit Food Service Training Academy.

After making some changes recently, whenever I select Design View on a specific form (Student Details), a window pops up stating "The command or action 'Requery' isn't available now. The window further states that:

You may be in a read-only database or an unconverted database from an earlier version of the databaseThe type of object the action applies to isn't currently selected or isn't in the active view.And finally "Use only those commands and macro actions that are currently available for this database."

After exiting this window, a Macro Single Step window opens with the following info:

Macro Name: Student List : txtOpen : Onclick : Embedded MacroCondition: (blank)Action Name: RequeryArguments: (blank)Error Number: 2046

This form is usually opened via an "Open" button in a list of students form called Student List. It has 5 tabs on it, the last I created & copied 2 queries to it. The form opens in Form view OK and I can switch to Layout view OK. Once in Design view I seem to be able to do go back and forth OK, although often going back into Design view sometimes only the name of the sub-form is displayed and the whole header, detail, grid, and controls etc. do not show.

Further, you can open the Student Details form directly, but now it opens as a datasheet instead of a form. Otherwise, the normal use of the forms, from a user perspective, does not seem to be affected.

This may have begun after I opened the database in Access 2007. I have done all the development in Access 2010.

View Replies


ADVERTISEMENT

Error Message Displays When Trying To Close The Form/switch To Design View

May 4, 2006

I have a form with a subform in it. On the main form, I have a combo box with a list of program numbers to choose from. Once one is selected, the subform displays all the unpaid invoices under that program number. This part works fine. The problem occurs when I try to close the form, switch to design view, or scroll the subform to the right. Basically, the error message says that the record can't be saved because it would create a duplicate value in the index/primary key. However, this form is used to display information only. I have disabled the edit, delete and addition abilities, so I can't figure out why it thinks I am trying to change or add a new record. Any help would be appreciated.

I figured it might make things easier if I included a copy of the database, so here it is.

The form is called SETR, and the subform is AllInfo subform.

View 1 Replies View Related

Design View Keyboard Shortcut - Expand Columns In Design View Of A Query

Jun 5, 2014

I'm looking for a keyboard shortcut to expand the columns in "design view" of a query.

What I mean by this is rather than selecting all of the columns and double clicking to see the entire text, I'd like to be able to a shortcut.

The entire process as I see it involves 3 steps so I will need thesolution to the 3rd step.

(1) [ctrl+spacebar] to select initial column
(2) [shift+arrows] to select all of the columns I need
(3) [keyboard shortcut] will expand all of the columns "field" names to the size of the column heading

Alternatively, if you know of a shortcut that will expand the columns without having to select them first I'll take it!!

View 4 Replies View Related

Forms :: Text Boxes Showing In Design View But Not Display In Form View

Apr 19, 2014

I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.

View 1 Replies View Related

Forms :: Unable To View Object Properties In Form Design View (Access 2010)

May 16, 2014

Why the ability to view the properties of an object within a form is not available when you double click on it in design view?

I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.

I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.

Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?

View 3 Replies View Related

!!??? All My Forms Are Blank Under Form View - But Fine Under Design View!!!

Jul 13, 2006

Anybody ever heard of this before? I open a form, and it is empty, just a blank window. I open the same form in Design View, all appears well. :mad:

View 2 Replies View Related

Blank Form In Form View But Fields Present In Design View

Oct 19, 2005

After reading many of the posts here, I decided that one of the problems with the tables in the db I was working on was in the primary keys. I had used the same field name as the primary key in all of my tables. This was RecipID, which was a user entered textbox with an example in a label beside it showing the format to use.

After reading stuff here, I decided this wasn't a good idea. So I changed RecipId to be an autonumber in the parent table (Household_Info) and a long integer foreign key in the children. Also, I added some fields to the parent table to identify the head of household (lastname, firstname)

I already had a continuous form made with a subform and a pop-up form associated with it based on my previous tables. Reran the query underlying the form, and the new fields showed up in the field list box for the form. The fields are all still present in design view, but I get a totally blank form in form view. I checked the forms recordsource and made sure that it was set to the new query.

Can anyone give me an idea about what I'm overlooking? Do I have to recreate the form?

(Sorry if this is a repeat of a question someone has already addressed, but I couldn't turn up any relevant threads after several hours of searching.)

Thanks, Charlotte

View 11 Replies View Related

Subform Design/form View ??

Sep 13, 2005

I created a subform on one of my forms and in design view it looks all nice with a nice background and stuff. But in the form view it looks just like a regular datagrid. I'd like it to look like it does in design view. Any idea how?

thanks,

View 2 Replies View Related

Closing Form / Table While In Design View

Oct 13, 2014

I have several Access DB's that I work with and all of them have a close option(x in the upper right corner) on forms/tables/queries except for one. This is one that I did not create. So, when I open a form in design view to modify it, the only way to close it is to close down the DB?

View 1 Replies View Related

Forms :: Access Form Must Be Opened In Design View Before Use

Oct 1, 2013

I have a access form that has a text box that holds a search term. The search term is used as a variable in a query. The query results populate a list box. Selecting a result in the list box populates the rest of the form where the record can be edited. All of that works great...sort of. When first opening the form you cannot view any records. The search function works fine and the list box populates but selecting a record does not populate the rest of the form. Attempt to navigate (next, first, etc.) and you get a "You can't go to the specified record" dialog. There is a simple fix for this. Open the form as normal. Then switch to design mode. Do absolutely nothing. Switch back to form mode. All is well.

View 1 Replies View Related

Forms :: Design View - Reducing Form Size?

Sep 24, 2014

When I create a form in design view and then open it, the form fills the whole area. The Fit To Screen property is set to No, and Auto Resize makes no difference no matter what it is set at.

How can I reduce the form size (so it looks like an Excel form)?

View 6 Replies View Related

General :: How To Allow User Add Fields To Form (without Going Into Design View)

Dec 4, 2012

I got a form called "Make quote". In this form a user can select a product from a line of fields. This "line" contains: article code, product, price and quantity the customer requests.

Each single quote can contain a very different amount of products. Some quotes just have 1 product, other quotes have 25 products.

I'm looking for a way to let the user add as many "lines" as necessary for the quote. BUT I don't want him to need to go into design view.

I'm thinking of maybe adding a button to the form which does this, but I'm not sure how.

View 10 Replies View Related

Properties Sheet Window Does Not Appear In Design View Of A Form

Jul 13, 2012

I am working in the design view of a form, the controls properties sheet disappeared-gone and even clicking the properties sheet button it does not come back.

View 1 Replies View Related

How To Judge Final Layout In Design And Form View

Nov 2, 2014

How can I see what they will finally look like while I am formatting them? All the views on offer (form/layout/design) are all displays within the the context of the access programing screens, with other windows and menus and ribbons etc. I want to see how it will look full screen. I know I can change a lot of options, change to the form as a default to open with, resave, reopen and then reverse it all but that's not really any good for doing every time you make a minor change.

View 14 Replies View Related

Modules & VBA :: Prevent Form Closing Unless Switching To Design View?

Oct 18, 2013

I've got this form called mainmenu and inside this form I've got this code to prevent it from being closed.

Code:
Private Sub Form_Unload(Cancel As Integer)
Cancel = True
End Sub

Now then, when I try to switch to design view in this form it doesn't let me because of this code. Is there anyway to tweak this code so that I can get into design view without having to keep disabling it?

View 4 Replies View Related

Move Add Existing Fields Outputs On Form In Design View

Aug 5, 2015

[URL] .....

In the Lesson tutorial shown above I am clicking on tools and adding existing fields. I get a lot of output label and text box pairs for each field that I add.

However, they are all on right below the other. That is no problem just move them. No way.

Whenever, I move it a label and test box for say Order Status, I get ... nothing. It stays where it is.

They (label and text box) do not move together. So how do I get them to move together.

View 4 Replies View Related

Field In Design View Not Showing In Table View

Jul 2, 2007

I have a table called NewTransactions_tbl that I have been using for some time. I am trying to add a new field called CustomerProjectNumber. It's not being displayed when I look at the table view. I've attached an image showing the settings for the field. I am probably missing something obvious.

Any ideas why it is not showing?

I am using Access 2000.

View 7 Replies View Related

DATASHEET --- Allow Design Changes: Design View Only DOES NOT WORK

May 18, 2007

I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout

Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the column by dragging the column end line



Does any one know how to lock the design of datasheet ( I am using this sub form datasheet for data entry but do not want users to change the layout)



Thanks
Rahul

View 1 Replies View Related

Modules & VBA :: Referencing Parent Form On Requery - Error 2450

Apr 3, 2014

In short, here is what I am trying to accomplish:

1. I have a two-tier, tabbed Navigation form (Menu-Main).

2. One of the second-tier tabs opens a form (VendorMain) which displays a Datasheet based on [Query.Vendor_Query]

3. VendorMain contains a Command Button (EditButton), which calls a subform (VendorForm) used for editing.

4. Upon saving the edits, VendorForm's OnClose event is supposed to Requery the datasheet on VendorMain, so the edits are reflected when the user returns.

I have tried over a dozen different permutations of the following, but nothing seems to work:

Me!Parent.Requery
Forms!VendorMain.Requery
Forms![Vendor_Query].Requery
Forms!Main-Menu!VendorMain.Requery
Etc...

VendorForm opens, edits, saves and closes perfectly. However, I consistently get the following error and the parent form is not requeried:

Runtime Error 2450 - Cannot find the referenced form VendorMain

Code available upon request.

View 4 Replies View Related

Form / Sub Form Question In Design View

Mar 31, 2006

Hello:

I have a main form and a large sub form that covers alot of the main form fields. My question is when I'm in design mode, the sub form blocks the fields I need to edit. I've tried setting the sub form "sent to rear" and the fields "sent to front", but this does not seem to solve the problem. So I end up dragging the sub form
off to no-mans land and then place it back. Is there way to say hide the sub form in design view and then unhide it.

Thank you
dmh

View 7 Replies View Related

Forms :: Added Extra Tab - Form Showing Blank In Design And Layout View

Mar 30, 2013

My form was working fine but when I added an extra tab it started showing as completely blank in design view. When I deleted the tab I had added I still was left with the same problem!

I've attached an image of the form properties. I want to use the form to enter data so it needs to show even if there are no records.

I had read that it could be if there is no data but typing data in the tables hasn't worked either.

View 5 Replies View Related

Design View - Where'd The Table View Go ?

Apr 18, 2008

You know how normally in design view there would be a table at the bottom of the screen where you can drag your fields from the view above.

Well, I have a query where this table view has disappeared ?

I can edit the query in SQL view, the query works, just the table view is missing.

Ever happened to anyone else ? I've done the obvious and scrolled down as far as I can and nope, it's not there ??? :confused:

View 3 Replies View Related

Normal View -v- Design View

Jul 20, 2005

I am wondering why the alteration to my form in design view is not reflected in the "normal" form view. I have included the two views. In design view I moved "Staff In"/"Staff ID" to the top of the form believing that as I work left to right thay would appear on the left hand side in normal view.

However, in the image of "normal" view you can see that "Staff In" is way over on the right hand side of the form.

Any ideas how I can fix this?

Thank you
http://www.btinternet.com/~peter_paterson/Access/SubFormDesign.jpg
http://www.btinternet.com/~peter_paterson/Access/SubformFormView.jpg

View 7 Replies View Related

June 6 2006 Form View ERROR .. HELP

Jun 7, 2006

Hi all, (Please, no joke responses)Has anyone experienced this problem? Ver: MS Access 2002 (10.6501.6735) SP3On a Form; I change from Form view to Design view, when I try to change back to Form view it will not change. It stays in Design view.I did Compact and Repair Database to no avail.NOTE: nothing has changed in the database, the day before the 6th, I had no problem. NO update or patches have been applied to either the OS or the MS Access in the past 2 weeks.Thanks

View 2 Replies View Related

Design View...

Aug 18, 2006

I should know this but it's has me stumped at the moment - When I have a form open I can right-click and it let's me go into design view. How do I turn this right-click option off?

View 13 Replies View Related

Can't Go Into Design View

Sep 17, 2004

I am getting the following error when I click on design view:

FSADSAFASF can't run macro or callback function 'fdesign'

I completley removed Access and re-installed the application again and I am still getting the error.

Thanks in advance for the help - John

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved