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?
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?
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
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
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?
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!
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.
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
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".
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?
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.
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.
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.
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.
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
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.
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.
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.
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.
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!!!
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
