Quick Q Regarding Format Of Subforms (datasheet View):

Jul 12, 2006

I have a subform on a Customer Data form for Phone Numbers (in order to normalize the data). Is there a way to display a subform in a format other than datasheet view? I only want to have space for 3 phone numbers, so a datasheet isn't necessary - I would rather the subform blend into my form instead.

I have read this: http://support.microsoft.com/?kbid=216675 , but it is not what I am looking for, (or I can't get it to work) I have searched the forum - with no luck, formatting subform posts all seem to do with conditional formatting.

Thank you!:D

View Replies


ADVERTISEMENT

Forms :: Toggle Subforms To Datasheet View

Jun 6, 2014

I have a form. On this form is a tab control with 5 tabs. Four of these tabs have subforms on them. The 5th tab is sort of a "settings" page. What I would like to do is have a button on the 5th tab, that toggles the subforms on the other four pages between the regular form view, and datasheet view.I know I can use the "DoCmd.RunCommand acCmdSubformDatasheet" to do this, however I am unsure as to how to apply it to the subforms on the other tabs. They aren't "in focus" so the command won't work properly.

View 1 Replies View Related

How Do I Show The Subform As Form View Instead Of Datasheet View :confused:

Jul 19, 2007

See title :)

I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.

Maybe someone can help me with this, probably very simple(?), question?

View 4 Replies View Related

Forms :: From Pivot View To Filtered Datasheet View

Nov 14, 2013

I want to "zoom" to the underliyng data from pivot view. When in excel someone doubleclicks a field in a pivot table, it automatically creates a table containing all the lines that field were made up from. I want to achieve the same behaviour in Access.I started to think towards a VBA coda, that could be initiated from the form's double click event. It should go to datasheet view with the prpoer filter criterias.

View 1 Replies View Related

Quick View Open Incidents

Jan 31, 2006

Hello All!

I think this will be a difficult question but im going to ask it anyway. Ive tried several ways to open 2 forms. Ok, ive achieved this one by letting a code to open up the Main menu (like where you can press buttons) and the second one is to open a field with the open incidents of the person that is logged in.

First question:

How can i achieve that the form will open with the employee name and its incidents?

So what i mean if i login with the name Michiel and a password of it that the main menu will start up but ALSO the form start up with MY open incidents and ofcourse when i login underneath someone else that their open incidents will open.

Second question:

How can i create actually this kind of of good form with the open incidents in it? Do i need to create lets say 5 special forms with all of his own name in it? Or can i create query's that are looking to the login form and that the right query will be loaded?

Can someone help me out please? :) Im getting desperate...

I will update the first post because i think more people will like this idea!?

View 1 Replies View Related

I Want Datasheet View... Why Does It Keep Showing Form View?

Apr 6, 2006

I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.

If u kno how i could resolve this please offer ur help

thanks

View 6 Replies View Related

Quick Table Format Question

Dec 16, 2004

Hi guys, hope you can help.
I have two fields (that I'm interested in) in my table: Insurance Policy End Date and Reminder Date.
I would like the default value in the reminder date to be exactly six weeks before the value entered in Policy End date. I'm not at all sure how to do this with the expression builder. Could you guys nudge me in the right direction?
Eternally grateful.

View 2 Replies View Related

Subforms In Design View

Jun 24, 2006

Using Access 2k in form design view, I sometimes get a blank, white section in place of a subform. Sometimes if I toggle back and forth a few times between design & form views, the subform may finally appear in detail. I've applied all updates to office 2k and can't seem to figure out why the design view would behave erratically this way.

View 1 Replies View Related

Datasheet View

Nov 3, 2006

when you select the Data sheet View you display error messages in the Accounts Sub reports fields.

The database has been included as a reference:
Forms- Double click Accounts Form By Discipline -data sheet view

Under Current balance,Spent, and Encumbered Columns you get error message instead of the actuall totals.

Please tell me how to correct this prolsdms

View 1 Replies View Related

Datasheet View

Aug 20, 2004

Is it possible to switch the view of a subform to datasheet when a command button on the mainform is selected?

I know it is something involving acFormDS...but I cant figure out the rest of the code! I appreciate your help in advance!

(P.S. I know you can right click the form and select datasheet. Unfortunately there are not many people here that are familiar with MS Access and I dont trust that they will know this)

View 1 Replies View Related

Datasheet View

Jun 18, 2007

I am reviewing a program that in datasheet view has '+' signs in the left-hand column -- it displays rows of companies. When I select a '+' another 'sub-datasheet view' of employees of that company appears, partially covering the original datasheet view of companies.
Is this the way sub-forms look in datasheet view or is something else involved?
Thanks

View 4 Replies View Related

Datasheet View In Subform

Jul 17, 2006

Hi. I am trying to create subform in datasheet view with one column (total 3)as drop down list. Is this doable? Thanks.

View 3 Replies View Related

Querying A Datasheet View

Apr 25, 2007

Is it possible to do a query of the datasheet view of a subform? If so, how does one go about it.

Thanks.
eileen

View 6 Replies View Related

OnLoad View As Datasheet

Mar 9, 2005

hi

i have created subforms and set the Default View to Datasheet
Now i have a form where i am adding command buttons on it to load those subforms but They are not Loading it as DATASHEET VIEW.
Any Clue?

Thanks

View 5 Replies View Related

Subform Datasheet View

Jan 5, 2006

I have a subform that is in databsheet view. When the user logs in to the db it sets the global variable with the group level they have.

I would like a column to be hidden for a certain group of users and have tried the following.

On the subform opening event i have

if vlevel = "engineer" then

me.Hours.columnhidden = True

Else

me.Hours.columnhidden = False

End If

And i have done the same on the Main Form open event identifying the subform by Form!Subform![Hours].columnhidden = True

But neither worked.

Can any suggest something.

View 4 Replies View Related

Datasheet View In A Subform

Jul 25, 2006

Can anyone tell me how to manipulate a single cell in a datasheet view, or if it is even possible?

View 3 Replies View Related

Mimick Datasheet View

Mar 10, 2006

I have two Access files. One is just forms which I use as a front end app. The other is the database that I store all my tables/data/etc...

I want to run a query to display data from these tables and display it in like a datasheet view. I know how to do this if it was all the same Access file, but not how to do it with two separate files.

Thanks,

JMH

View 14 Replies View Related

Getting Rid Of The Row Header In Datasheet View?

Nov 17, 2013

I am trying to get rid of the row header (the little square next to a record) when in datasheet view.

View 1 Replies View Related

Change The Datasheet-view Properties

Oct 24, 2005

I created some forms in datasheet view. Now I want to change the datasheet properties (background color, text color...): the problem is that the forms I create with the new properties are displayed as I want, but the old forms are displayed with the old properties.
Does it exist a command to open the old forms/subforms with the new properties or do I have to re-create all the old forms?

View 1 Replies View Related

Datasheet View Not Displaying Properly

Apr 21, 2006

I'm using access 2003 sp2 with all the current updates. I've got several tables linked to a sql server 2000 DB. We use it for an app called Altiris. Most of the queries i've written from these various tables work fine. However, a couple of them for no apparent reason, do not display the correct data in the data sheet view when the query is ran.

for example, I have a simple query with two tables linked. The first field is asking for the "name" column of one of the tables. In the criteria of that column, I put something in to limit the names of the programs i'm looking for. Lets say I use LIKE '%adobe acrobat 7.0%' When I run the query, it returns a certain number of records, but in the name column, it has all wrong info. I just ran it and it came up with 4 records: "webcast....", "abacast client", "Ibm websphere", and something else. Nothing even close to "adobe...."

So then I export the query to an excel spreadsheet and then open. Guess what? It has the correct info. Four records of adobe acrobat. The other column I have is from the other table and is just listing pc names. They displayed properly in both datasheet and excel file.

does anyone have any ideas what could cause this? I've deleted the table and linked to it several times. I've used this table for many other queries and it works most of the time. I just have no idea what is causing it to do this for only a few queries.

Thanks in advance for any help.

fisk

View 8 Replies View Related

Prior Record In Datasheet View

Mar 1, 2007

In my db I am tracking different stages for an event. I have a subform that is in datasheet view. The last field (current) is a yes/no check box that says that this entry is the current stage of the process. In one of the fields I have a afterupdate event that says me.current = true. But what I need is to change the previous entry to show that stage's current to be false.Does that make sense?Date Event Location Current02/01/07 Drying Dryer X (when next event added this =false)02/05/07 Bagged Warehouse XUp until I enter the 02/05 entry the 02/01 entry was the current stage and I want a check in the current box. But when I enter the 02/05 entry that now becomes my current stage so on the 02/01 event then current = false and on the 02/05 event current = True. I can get the 02/05 event to show current = True but how do I make the 02/01 current =False?Thanks,Rick

View 4 Replies View Related

Show Field Name In Datasheet View

Sep 6, 2005

Hello,

I am trying to find out how to view the field names for variables while in datasheet view in Access. Or, alternatively, I would like to know how to toggle between datasheet and design view for a particular variable. Basically, I have a huge database and I need to be able to find the field name for a variable that I have identified in datasheet view, but right now all I know to do is go into design view and guess which field name it is, click on it, see if the caption matches what I see in datasheet view, and keep doing this until I find the match. I did not create this database which is why I am not familiar enough to know what goes with what.

Thanks in advance!

View 1 Replies View Related

Datasheet View Table Error

Apr 17, 2008

I have a table that I was in the process of cleaning up when I got the following errors: "type mismatch in expression" and "microsoft office access can't open the table in Datasheet view." What does this mean, and how can I get rid of these errors? Thanks.

View 1 Replies View Related

Fields Different From Form To Datasheet View

Dec 27, 2006

hello,

I also posted this in the report section, but it doesen't seem like the readers over there have any answers. I'm hoping maybe query people will.
I'm working on someone elses database, and I'm not too familiar with access.

He's got this form called Customer_Select, and when you click on a check box for a customer, it's option value is recorded in a field called Product, which then corresponds to the product/customer id located in a table called CustomerCharacteristics.

The problem is that I just realized that this Product field existed. When I view the form as a datasheet, I see the fields: Product, Lot_Nr, Version:, and Last Update:
However, when i look at the field list for the same form in Design view, I get: DateTime, VersionDisplay, and Description.

Does anyone know what's going on here? I need to reference the Product field in a query I'm modifying, but the expression builder can only 'see' the fields that are visible in design view.

Any help would be greatly appreciated.

Thanks

View 1 Replies View Related

Run Time Error In Datasheet View

May 4, 2005

Hi all - I am getting a runtime error when changing a form from form view to datasheet view. The reason it's happening is that I have code in the OnCurrent of the form which populates a text box with information calculated from subforms on the main form. Obviously, with the form in datasheet view, the subform is not there, hence the error.

Any ideas on how I can stop this error from happening?

Cheers

Chris

View 1 Replies View Related

Cascading Combos In Datasheet View

May 5, 2005

OK, here is the problem. I have the following tables:

Customers
Consignment
ConsignDetails
Employees
Products
Suppliers
CompanyColors
CompanySizes

and I am creating a form to view the items currently on consignment with the customer. I have the main form 'Consignment' that holds the CustomerID, ConsignID, DateStarted, Employee (SalesPerson), Inventory Interval, and Closed (Y/N)... The subform lists in datasheet view the records in form 'ConsignDetails' that have the same ConsignID. The controls on the subform are :

ProductID
UnitPrice
Quantity
Color
Size

The ProductID is selected in a combobox from all products. The UnitPrice defaults to a DLookup() from the products table based on the ProductID, but can be changed and stored. The Quantity is a manual entry field. Color and Size are both supplier-dependent fields, in other words, the supplier of the product has unique Size and/or color codes or descriptions. I have no problem creating a combobox either in the AfterUpdate event of the ProductID or in the MouseDown event of the Color or Size field to limit the drop-down list to only those Colors/Sizes from the CompanyColors / CompanySizes tables with the same SupplierID as the Product in the first control.

So far so good, but here is where I am beating my head against the wall. Every time I choose a product from a different supplier, the Color and Size controls display ONLY the items from the current Supplier, not the items from the Supplier of the Product on their individual records. I have seen ways to make the combo popluate a locked textbox, hide the combo, and display only the text, but in a data entry application the user will be primarily on the keyboard, and the solutions seem to make it almost impossible to do without using the mouse over a continuous form.

I am using Access 2002 (ver 10.6501.6735) SP3 to create an ADP using MSDE to link to SQL7 tables....

Any help will be appreciated, I have spent almost two weeks trying different approaches and may be too close to the forest to see the trees.

Thanks,

Bruce Davis

View 14 Replies View Related







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