I'm trying to create a form that has several categories and sub categories. Is there a way that i can create a relation between what is chosen in the first drop down (Main Category) to what is displayed in the second (sub category)? I don't want to list all the sub categories at once. I only want the ones that relate to the specified ...
I'm trying to use the built in Make ACCDE functionality in access to make a standalone application that interfaces to an SQL-Server 2008 back end. When I run the Make ACCDE I receive an error that states that too many TableID references are being used (the limit is stated to be around 2048). Through trial and error (deleting forms unti...
Our program has an option for users to export data into an access database. The user then downloads the database and uses this for reporting, so on and so forth. Recently, we upgraded to Office 2007, and in testing, when downloading this database, we get the error message: "Cannot open database "filename" It may not be a database ...
Good day, In ms access, I created a form with a combo box that list all products, a subform(datasheet) that list all companies that sell that product.(the data) I want the company names(data) to become (in datasheet-subform) the actual field names, in the datasheet, so i can have other details for that company in that column. Like How ...
(This doesn't look like a programming question but it might boil down to a programming question.) I'm using MS Access 2007 to view tables in a database (through an *.adp file) that lies on SQL Server 2000 and SQL Server 2005. I use the Copy Database task in MS SQL Server Management Studio to copy the data from SQL Server 2000 (the "liv...
Good Day tables: authors, books, chapters; I have created a form(form_A), with a combo-box listing all authors. Created a sub-form that is binded to the combo-box, it list all books by that author, and within that, I created another sub-form displaying all chapters within that book. The info is from 3 different tables. when I manuall...
Good Day newbie to reports in ms-access 2007. created form and a combo-box listing names. a sub-data-sheet with minor details to the item selected in combo-box. just needed to know, How to create a report based on this from... When I create a report all information is displayed, I only need selected info from that form Thanks A mil. ...
My organization is in the process of upgrading from Access 2003 to Access 2007. One of the apps I am tasked with upgrading is returning very odd errors while opening and closing forms that have nested forms. Have the events changed between Access 2003 and Access 2007 ? The events seem to be firing in a different order in 2007 then they d...
Good day ms-access 2007 I have 2 sub-Datasheet's on my form, One display a list of items. the other is blank. Is there a way by placing a button on the form "Copy/Add", it copies the highlighted field to a field in the blank data-sheet. both field's are of the same type. Thank you ...
Good Day I have created a program in ms-access 2007, (in house program), Is it possible to create a stand alone program from access (.exe) thank you ...
Good Day, I have 2 sub-data-sheets on a form, "products and trolley" the products sub-form displays all products. I need the trolley sub-form to display all selected products, I need a macro of some sort that when a product is clicked (in sub-form) it saves/copies that product to the items field in the trolley sub-form(Duplicates OK)....
Good Day Is it possible to create a 'COPY' and a 'PASTE' button in ms access 2007 on a form or is there any code i could use, or a macro to copy a field and paste a field thanks it will help me alot ...
I'm re-casting a question I asked earlier now that I have an idea of the cause of the problem I'm seeing. What I have: Tables in a DB on SQL Server 2000. I view/edit the tables with Access 2007, with SQL Server Management Studio 2005, and occasionally with SQL 2000 Enterprise Manager. What I did: I tried to copy the DB from SQL Serv...
good day I have successfully (Thanks to much help from stackoverflow) sync'd two combo-boxes on a form. NEW PROBLEM... I created a from, with a sub-form. The one combo-box(A) is in the form, while the other(B) is in a sub-from. (combo 'B' must be limited to combo 'A') ie..(it works when both combo-boxes are on the form, but when the ...
Similar question was posed, (didn't understand it) the field.value in one sub-form, how do copy it to to to a field.value in another sub-form with a simple copy and paste button Thank you ...
I have a table containing reports and the date/time they were created. I'd like to create a graph to tally the number of reports created during intervals of ten minutes between two time periods: 8:00AM-9:00AM and 1:00PM-2:00PM. Here's an example of a query I'd like to run: SELECT s.StudyStartDateTime AS "8:00 - 8:10", s.StudyStartDate...
I'm trying to display the sum of a field in a text box in the form footer. The field is not calculated in any way. Here are a couple of the things I've tried: =Sum([txtWeldInches]) =Sum([WeldInches]) =Sum(CDbl([txtWeldInches])) =Sum(CDbl([WeldInches])) ...well you get the idea. Each iteration I've used results in the Text Box displ...
good_day created combo-box to view suppliers, sync'd it to another combo-box displaying all products(Product_Name) for that company I need the Product_Code for the Product_Name(that was selected)(same table), in a text-box in the same form ie..Products combo-box I have to view Products by name and once selected the closed combo-box mu...
good_day On my form, created a combo-box with properties (Limit to list = No, Allow Value List Edits = Yes) when I enter data into the combo-box, it does not add a new record but replace's the old one, Therefor I created a button to add new record, And then tried it, and it works beautiful, Now the problem is when the add_new button i...
I have a table that looks like the following: StudyId StudyStartDateTime ============================ 1 01/01/2009 08:45 AM 2 01/01/2009 08:53 AM ... I'd like to return a query that contains the StudyId, as well as the ten-minute interval during which it was started: StudyId Interval ================== 1 8:40...