Trouble Saving Sub Data Sheet Name

Jan 21, 2008

Hi

I always feel as though I'm asking a stupid question but here goes. I am making a database with sub tables and sub forms, and working from "Access 2003 inside out". When I open table properties and enter a subdata sheet name and fill in child and master links everything seems fine until I try to save it. I open the table properties window again and the sub data sheet option has returned to "auto". Am I doing something stupid or is there a bug in my system?

View Replies


ADVERTISEMENT

Trouble With Saving Changes

Oct 26, 2005

:confused: Hi,

I've put a button on a form (lets say form 1), that when clicked opens up form 2.

Both forms are connected to ONE table each.

There is a sub table on form 2 that displays records with the same Id as on form 2.

The Problem is when I open The table that feeds the subtable. If I change the A to Z ordering on this table, whenever I close form 2 (not from design view, from user view), it asks me whether I want to save the changes to the design of the table feeding the sub table (the subtable that is on form 2, that is)?

When form 2 is closed there are calculations that are made and data is updated on form 1. I don't know if this is part of the problem? or perhaps I have set up the subtable incorrectly?

Please help!

Thanks

Peter

View 5 Replies View Related

Modules & VBA :: Copy Data In Sheet1 Using Sheet 2 And Access Table Data?

Aug 5, 2014

I am using Excel/VBA as a frontend and Access backend. The sheet2 stores the queue name and Queue number. We have to update the sheet1 from column L to column O by looking for the values from the Access table for the date selected from the comboboxes. Now In sheet 2 , it says Queue number and in actual in access table it is the combination of Type & Type1 & Type2. So we have to look for Type & Type1 & Type2 in the table and find out total Batches ,Total Envelopes,Total documents and total pages and then store the values in the ExcelSheet1 from column L to column O.

The following formulas will be used in the select statment:

Total Batches = count(BatchNo) for date selected
Total Envelopes=sum(Envelopes) for date selected
Total Documents=sum(Cases) for date selected
Total Pages=sum(Pages) for date selected

View 14 Replies View Related

Forms :: Display Data In Form As Select Record In Subform In Data Sheet View

Nov 11, 2013

i have a main form named(EMP) i have a subform named(SEMP)with EMPID i have an another form Named(SDetail) with EMPID i want to open form Sdetail with filter records for data select in subform (SEMP) ,EMPID field Subform SEMP in as datasheet view. i can open sdetail for selected records only

View 14 Replies View Related

Last Record In Data Sheet

Jul 16, 2006

In my database I have all my clients information in the [Main] form and all their transactions / debits / etc. in a subform [Transactions] in datasheet view. My question is how can I have the subform automatically scroll down to the last record (or to a new record) so the user doesn't have to scroll down everytime a new client is viewed?

-Alex :o

View 5 Replies View Related

Form Sub-data Sheet Question

Dec 15, 2005

Is it possible in a sub-data sheet to have the column headings appear as two lines instead of one?

View 2 Replies View Related

Editing Data In A Linked Excel Sheet

Mar 28, 2008

Hi all. I have an excel spreadsheet that pulls company information off of our internal system that is linked to an access database table (let's call it "General"). The General information is current and is updated within our internal system (but through the Access side will not need to be updated), however, I have a separate table (let's call it "Detail") that has information (employment, revenue numbers) that I want users to input through access. The two tables are joined through a relationship, however, b/c General is a linked table I am a) unable to assign a primary key and b) unable to edit the Detail information in a form view. I know this is related to Microsoft's limitation on excel linked table, but I was wondering if there is a way around it besides copying the General data into an access table. Would be grateful for any help!

View 2 Replies View Related

Opening Forms In Data Sheet View

Jun 30, 2005

I have a main menu that I select things to open. Most of the things I open I open in form view but some I want to open in data sheet view.

Without recoding my menu code is there a way to specify in the form to be opened that it should open in data sheet veiw?

Right now I have the default view as data sheet view in the forms but because my calling code is not specifying any view they default to form view, and again I don't want to edit that code in my main menu.

View 3 Replies View Related

Changing Form From Modular To Data Sheet

Sep 14, 2006

Hi all, :D
I have built a form in tabular mode with a combo box named "STAFF NUMBER" I have a code for a NOT IN LIST event and when double clicking on it It will open the STAFF form in adding mode.... it works OK... I have now changed the properties of the form to data sheet wich gives me a better view of all the information but I have lost the NOT IN LIST and the DOUBLE CLICK option...
How can I get these features back??? :confused:
Thanks
Marco

View 2 Replies View Related

Forms :: No Option For Data Sheet View

Jul 27, 2015

How can it be that from Design view I can go to data sheet view, but from form view there is no option for data sheet view? On form property sheet "allow data sheet view" is "yes".

View 1 Replies View Related

Forms :: Get Data From A Linked Excel Sheet?

Mar 6, 2013

I have a excel table (lets say the format is as follows)

col1 col2
dataset1 value1
dataset2 value2

(where col1 and col2 are the column names and dataset x and value x are the respective data values of each column) I have a access form and it has a combo box and a text box From Combo box I need to retrieve data available in col1 o excel once a particular dataset in col1 has been selected by Combo box the respective value in col2 should be displayed in text box in access form.

I was trying to create a linked table in excel to access ( I don't want to export data from excell to access since my excell sheet is getting changing time to time. so i don't need to change the access table every time)

for combo box a simple query like below works to select the col1 values from sheet 1

select col1 from Sheet1 (where Sheet1 is the linked table name in access)

I wrote a code similar to below using DLookup to get respective values from col2 however it gives a error '#Name?

=DLookup(col2,Sheet1,col1=[Forms]![FormName]![ComboBox Name])

(here sheet 1 is the linked table name in access, I didnt give the absolute path of the excell file)

this returns the above #Name?

View 1 Replies View Related

Trouble Getting External Data

Oct 23, 2006

I'm trying to import about 18 excel spreadsheets into one database in Access. I've been using "get external data" to import the spreadsheets as tables, and the first 8 of them worked fine, but now I cannot import any more excel files. The only error message I'm getting is "An error occurred trying to import file 'C:....xls' The file was not imported." And this error pops up after I have gone through all of the importing steps. Did I exhaust Access's resources? It's not a format issue, and I've restarted, etc. I'm at a loss.

View 10 Replies View Related

General :: Adding Photos To Data Sheet From Within The Form

Oct 17, 2012

I have created a DB to store my students records, eg: Student Number, English Name, Chinese Name, Birthdate, Class Number, Age, and exam scores, I also have a photo frame to display the students photo.

In the data sheet I have an ole object field where I add the photos, the thing is it means I need to manually add this to the data sheet, whereas I can add all the other details directly from the form "Add New Record" and also search, delete or edit all from the form.

I have searched and searched but I cannot find any info that accurately explains how I may add the photos to the c where I have placed a button "Add Photo". I assume I need to create a macro and assign it to the button (on click) then this would need to open a search file location box where I can find the photo and select it to be added to the file.

The point is I wish to be able to do all the adding, deleting and editing from within the form and not have to enter into the data sheet at all.

I am using Office 2010

View 6 Replies View Related

Scroll Wheel Does Not Function - Data Sheet View

Mar 3, 2014

Had to reinstall OS system. Upon reinstalling Access 2010, and my data, scroll wheel did not move the screen. Previously, worked in typical fashion. Now, have to use the scroll bar. Just plain old Datasheet view. Cannot seem to find any "setting" for this behavior, e.g., Navigation, or in any of the other options screens. Merely want the scroll wheel to work like it does in any other program, alternative to the bar. Recalled the same thing happened on installing Access to my lap top recently. Scroll wheel didn't work. Then, all of a sudden (i.e., I didn't think that I did anything, such as a setting, to change behavior) it started working as a typical scroll wheel.

View 1 Replies View Related

Exporting Data From MS Access Form To Excel Sheet

May 9, 2014

I am trying to export certain values which are in combo box of MS Access to excel sheet. But what's happening is its populating ID of the field instead of Field Name.

View 11 Replies View Related

Forms :: Saving Specific Data From Data Entry Form Depending On User Selection

Dec 18, 2014

I am trying to save specific data from a data entry form to a specific depending on what the user selects from a dropdown/combo box.

So if the user selects "test company from the combo box, that data (from that form) will save to the Test company data table.

View 5 Replies View Related

Having Trouble Editing Data In Form

Jun 20, 2005

I have a form to edit records. When I open the form I am not able to change any of the fields until I edit a date field that has a calendar popup on the "on click" event. After that all of the fields are available for editing. Any ideas??
Thanks,
Pat

View 11 Replies View Related

Big Trouble: Lose Data In Synchronizing

Oct 22, 2004

This is very bad. We're losing data changes when we run a synchronize on an Access database.

A client wanted to use replication so he could have several people using the same database and then update everyone's changes. (It turns out that he's not used that feature.)

The client was unable to get the replica to work on his machine, so he uses the master version.

Instead, we've used replication to allow me to make changes in the database structure while he makes changes in the data. (Obviously, it would have been better to split the database in two parts, but it's too late for that now.)

Here's my process when I need to update his copy:
1. Synchronize between my master and replica.
2. Copy master to CD-R. (We're not on a network.)
3. Synchronize between client's master and replica.
4. Send a copy of master to client.
5. Open my new version of master on the client's computer and synchronize with his replica copy.

When we do that many of his recent changes disappear.

Why is that? They don't even show up as conflicts.

What are we doing wrong? Are we totally abusing the concept of replication or what??

I'm stumped. I appreciate any suggestions or thoughts.

View 2 Replies View Related

Forms :: Location Of New Record Line When In Data Sheet View

Aug 19, 2013

On a subform that records notes in datasheet view (columns: Date, Note; sorted in reverse chronological order with newest at the top), is there a way to get the blank new record line to appear at the top? Otherwise, you have to counter-intuitively scroll down below the oldest entry to enter a new line.

We could sort in chronological order, but then the most relevant notes would sometimes be scrolled off the bottom of the form and not seen.

View 2 Replies View Related

General :: How To Add Combo Box Field To Data Sheet View In Form

Dec 29, 2014

I created a new field as a text box, converted it to Combo box, then the Values are pulled from a query and all that works fine.

I have a form that opens and displays these Fields in a Data Sheet view and the new Combo box doesn't drop down and is flagged as a text box in the property bar but no way to change it??

I need the drop down like the other Category field I have, that works but this one doesn't.

See screen shot.

You can see in the Category field, there is a Drop down, but in Category II there is not, even though this is a drop down field. - BUT in this data sheet view it doesn't show it as a drop down.

[URL] ......

View 5 Replies View Related

General :: Filter Data Sheet To Show Records With No Date

Mar 20, 2014

I am having trouble with a datasheet its ran from a macro button using BrowseTo command.

I am having trouble with the where condition; I would like to show records where the [FittingDate] is blank...

I have tried isnull() and [FittingDate]=""

View 1 Replies View Related

ODBC Driver - Fetch Data To New Excel Sheet According To Query

Oct 26, 2011

I have oracle ODBC Dirver which easily connect and fetch data to a new excel sheet according to the query.

But I want to fetch data to a access table from a remote server database which will automatically update the data, through the query saved.

Excel is working good with automatic update option but can't fetch data to access table.

View 2 Replies View Related

Trouble Importing Zipcode Data From Excel

Sep 15, 2005

I've got a large Excel spreadsheet with contact information that I want to import into Access. Everything seems to import fine except for the two zipcode columns (a 5-digit zip and a 4-digit zip, both have leading zeroes in many entries). The problem is that in Excel the data are formatted with a special input mask that allows for the leading zeros to show. When I import them into Access, this formatting is not recognized and the zeros are lost. I've tried a few things, such as saving the Excel file as text and Dbase 4 and then trying to import them. In these cases the leading zeros are present during import, but are again dropped as soon as the import completes. Any help would be greatly appreciated.

Cheers

David
Somerset, NJ

View 3 Replies View Related

Refreshing A Data Entry Form After Saving Data

Jul 6, 2005

This has most definitely been asked before but I really cant find anything on the forum! Ive created a data entry form which has a save button which the user must click each time to save the record. However how do I refresh the form i.e. empty all data from the previous record without exiting the form. Ive tried to combine the undo macro but that simply deletes the previous record. Any help please!!!

View 3 Replies View Related

Queries :: Importing Data From Excel 2007 When File Path And Sheet Name Always Same

Sep 29, 2014

I have an access file in which have a table name dataupdated

I have an excel 2007 file(Datanew) which have a sheet name data

I want to update table dataupdated at regular period

How can I create a query to import data from excel while file path and sheet name is always same and other steps to import data is same every time...

View 5 Replies View Related

Modules & VBA :: Store Data From Access Table To Excel Sheet In Corresponding Cells

Jan 28, 2015

I am writing the following code that will first of all display column headers dynamically using "Headers" field data from Access table and then find out the sum(volume) using column header and first column values. The following code works fine to display headers dynamically in Excelsheet from Access table but doesn't display sum(volume) in all the corresponding cells. As I can't attach the Access table so I have stored data from Access table to sheet named "Access Data" as attached. The sheet2 named "Report" should populate total volume .

Code:
Public Function Inputdata()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim r As Long
Dim i As Integer

[code]...

View 2 Replies View Related







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