I am just wondering how good of an example Northwind is?
I have been playing with the database and noticed that the number of units in stock doesn't decrease after I have created an order. I am trying to build an inventory database and would like this feature.
Am I wasting my time with Northwind?
A while back a colleague at work (who has since left my company) showed me an example of a graph within a Data Access Page in the Microsoft Northwind database. The Northwind database that I've downloaded doesn't contain such an example. Does anyone know of a Northwind DB with an exmaple of a graph embedded into a Data Access Page?
View 2 Replies View RelatedHi,
I have a problem with form design,
I want a form like in Northwind sample database: Summary of Sales by Year Report.
It use Sorting and Grouping for Footer that I can't find it in Form design.
Is it any other way to do it in Form design so I can get the same result like in Report design?.
The reason why I want it, because I want to control the size.
thankyou in advance for your help.
Gunawan.
I have been working on some financial projection software for distribution to our organisations licensees. A question has been raised as to how we have verified it's accuracy. Does anybody have any suggestions as to where I could go to have an independant audit of the software. This would really only apply to an Australian situation.
Cheers
AWB numbers consist of 8 digits. The rightmost digit is a Mod 7 check digit. For example: 1234567 returns a check digit 5, so the AWB number is 12345675. How do I design a query to validate the accuracy of an AWB number?
View 3 Replies View RelatedHi
I am re-visiting access for the 1st time in a couple of years to develop a quotations system and I am just messing around at the moment with Northwind trying to work out how it all works.
I have come across a problem that is baffling me....
When displaying the order details table (referenced from products), the product ID is disoplayed in text form, not as a number. Whenever I try and do this with 2 similar tables using the query builder I always get just the other tables number. I have no idea what I'm doing wrong as every field, attribute, join etc seems to be just the same as the sample tables.
Please could someone help a duffer? :)
In the Northwind DB, there is a query of the "Ten Most Expensive Products"
After looking at it, I can't figure out where or how it knows to only pull the 10 highest price products. It's probably right in front of my nose...but it's making me crazy!
Thanks for any replies...
Wow! I just looked at the Access 2007 Northwind database sample and they have revamped it and given it some cool stuff. It is definitely not the "old" Northwind.
http://downloads.btlarson.com/AWF/screenshots/NW/NW1.png
http://downloads.btlarson.com/AWF/screenshots/NW/NW2.png
Hi There,
I want to synchronize 2 comboboxes (actually 3, but let's start with 2)
On a form I have 2 comboboxes:
- CompanyType (FK fkCompanyTypeID in table Contacts)
- Category (FK fkCompanyCategoryID in table Contacts)
Let's say we have companytype CT1 until CT10.
For CT1, CT2 & CT3 I want to choose a catagory, so the combobox must be 'enabled'.
For CT4 until CT10 the Catagory combobox must be disabled, so that I cannot choose a category value.
Actually I want to choose 2 catgories (2 comboboxes) for CT1 until CT3.
But I think that an explanation for the example above is sufficient for me.
Both comboboxes are filled by a Select Query, and the values are filled in a separate table. (Table CompanyType (PK pkCompanyTypeID) & Table CompanyCategory (PK pkCompanyCategoryID)).
Can someone please help me on this issue? :confused:
Thanks in advance for your reply,
Greets,
Quinten
When attempting to select a letter in a form copied from the Northwind's Customer Phone List Form, I am now getting an error message that says "The object doesn't contain the Automation object "RecordsetClone'".
I never had that problem before.
Appears to be something in the Option Group that has gone awry, but I cannot access the Visual Basics behind the Macro.
Is there a way to suppress this message? It does not appear to be a problem in bringing up the sought after page.
:confused: :confused: Please help!!
Hi guys,
As you all know, in the Northwind sample database there are the Invoices and Invoices Filter query. The Invoices Filter query adds a criteria to select only items that belong to the current order. OrderID is integer.
However, if I change OrderID to Replication ID, it stops working.
Any idea how to make it work? Currently I work around this problem in my DB by adding a criteria to filter by Date and Customer ID, but IMO this is less than ideal.
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
Hello All...
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
Thanks in advance..!!
i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
View 4 Replies View RelatedDatabase: Access 2007
I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.
Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.
What is the best way to do this?
I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets.
There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?
I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.
I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.
Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.
Thanks!
I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.
Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.
I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!
View 1 Replies View RelatedIs it possible to access a table in one Database (Database A) from a separate Database (Database B) and if so how. I should clarify that this is an Access Database.
View 2 Replies View RelatedI created a database with forms, querys, etc. Now I was thinking of creating a exe so everyone can use this database without having access to all the design functions.
the only problem I see about doing this is if we need to use the same database for different project, we need to always create a new exe for each project.
Is there a way to make a empty database exe with just the layout, querys etc but with no data on the tables and have a save, open and save as option. So we can have several projects using the same database?
I was thinking to create a VB code for the database to delete all data on the tables when the database is open.
and before closing the database exporting all the data to a txt file or something.
Then the next time someone opens the database goes to the main form which has a open bottom which imports the txt file into the tables.
This way we can have several txt file for several project and use always the same exe database.
I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.
Does anyone know how this is done?
Thank you in advance for your help,
~Kilch :eek:
The menu for make a MDE file is blanked out or grey’d out. The database is partly made using access 2000 then xp
Jabez
I have a series of unrelated access databases and I would like to have one 'super menu' where i can click a button to go to different databases.
View 3 Replies View RelatedI have a car dealership database and have a servicing section.
I want to create a form to service these vehicles.
The only vehicles which will be displayed on the from are the sold ones (because you cannot service a vehcile which hasnt been sold) which i have a query for.
I also want the form to display the customer who owns the car the service details (eg what they need), the parts availiable and the parts required for the service.
The calculations i need to make in this form are as follows
quantity needed (parts required table) - quantity in stock (purchasing customer parts table)
quantity needed (parts required table) * price (Parts Table) + labour (servicing table) = part/labour costs (servicing table)
http://pic18.picturetrail.com/VOL885/3178839/6480291/97832270.jpg
any suggestions on how to do this would be fantastic
i havent been able to figure out how to get my subform to work properly....
i've posted in the forms section (http://www.access-programmers.co.uk/forums/showthread.php?t=99624 )
it is really important that i figure this out so that i can keep my job..
how else can i obtain help? even if i have to pay for it?
what do you guys suggest?