Prob With Many2many Dbase..
Dec 27, 2006
I'm trying to create a little dbase for personal keeping track of a number of companies I deal with, so that i store their details and also the products they distribute.
In more detail, I want to have 'fixed' product categories, which will be assigned to supplier, and each category will include the product models I have set, including their details (such as price, manufacturer, country of origin, etc).
My point is to be able to create several customised reports and listing:
1. All product models I have in a category including their details.
2. Report per supplier to view their details and the products they distribute
3. Certain product models in a list with their local distributor (companies I deal with).
I assume it involves a couple of many2many relationships, however I have created a file in MS Access but never managed to have it work properly.
Any1 have an idea, or template maybe?
Regards ;)
View Replies
ADVERTISEMENT
Aug 1, 2006
hi all, new member here and also new in access and thats why i need your help.
so, i have to make a project thing it called "many to many". i need one table named it for example A that will have 4slots(for customers,addresses etc) and another table named it B (for staff they buy). for example lets say that the staff that they buy are from A to Z. i want when i add a new customer in table A to be able to choose one or more than one of the staff(AtoZ) he buy. Also i want when i open the staff(AtoZ , in table B) to choose one for examble Z and then to see which customers had bought Z staff from me.
sorry for bad english or bad explanation.. :(
i tryed to make a project myself and i made:
table1: customer, customer name, address
table3 : staff, name of the staff , info for the staff
table2 : this one connects the customer name with the name of the staff.i choose of the customers i have added in table1 and one of the staff i added one table3 and just put this in line.
This way i have done it, after every add i make i have to go in table2 and connect the staff. i dont want to do this. i want to have one more slot in table 1 with what staff customer bought and one in table 3 which customer bought this staff. so dont have to go to table 2 and connect the customer-staff.
is there anything i can do? anyone has made something like this so i can take it ,rename it and do my job?
hope u can give me a hand..
View 2 Replies
View Related
Oct 27, 2006
i have two databases setup. the first is called "groups" and the second is called "people". i want to be able to view people by groups and groups by people. the problem i've having is that one person can hold several positions within a group. for example one person could hold the position "leader" of the group and also hold the position "host" if the group is meeting at their house. when i view the group i'd like to be able to see each postion that is being held by people and when i view people i'd like to see which groups they are associated with AND what position(s) they hold within that group.
does anyone have any suggestions how i should set this up and also what my forms need to do in order for everything to work smoothly?
thanks in advance.
john
View 10 Replies
View Related
Jul 12, 2006
in 1 table there are are 3 feilds
folwer_name
no_of_flowers
total_cost
another table (2 fields)
name
price
eg:
name price
rose 15
tulip 20
Now I want o make a form
with 3 fields
folwer_name
no_of_flowers
total_cost
eg: if some one select 'flower_name' 'rose' and quantitly '10' then total_cost = 150
How can I do this ? using query or anything else plz gimme detals
View 3 Replies
View Related
Jul 21, 2005
Hi, i have created two tables, containing the same fields. One table if for '1 day tests' and the other is for '2 day tests'. I need to keep these two in seperate tables.
At the moment i have two seperate forms, one for each type of test, but as the fields are all the same, i was wondering if i had a combo box, so the user could choose whether they wanted a one day or two day test and filled in the rest of the fields, the record would then be stored in the appropriate table. Ie 2 day test table, if the chose 2 day test on the combo box
Thanx
View 2 Replies
View Related
Sep 15, 2005
Hi all,
I have two date and time fields which format are like: 15/09/05 09:48:43,I have another field which calculates the time difference between these two fields. I am doing a calculation on the time difference field and want the time to be displayed as for example 03:00, but at the moment it just shows 3:00.
This is the control source which has some formatting in it:
=Int(CSng((([txtDateDel]-[txtdateRO])-[closed])*24)) & ":" & Format(([txtDateDel]-[txtdateRO]),"nn")
I have tried adjusting this but am having no luck.
I would be grateful of any help,
Thanks :)
View 1 Replies
View Related
Sep 30, 2005
How do I use a wildcard in a query, see attached .mdb
Table "myDATA"
Sam and Zeb have serial number 23a4224A and 23a4224 in their records.
I want to locate a serial number(s) in multiple fields of a table, based on the users input with a wildcard.
query "Serial Number query"
Enter Serial Number: the user enters: 23a4224*
What am I doing wrong?
Thanks
View 4 Replies
View Related
Sep 28, 2005
My combo box problem is still at large!
I've tried every way i can, and i cant get the rowsource query right.
If someone could look at this and post a fix, so that when one uses the "training record" form it allows you only to select course dates that are already in the tbl_course_dates table.
Thanks so much
http://www.suicidenotesmusic.net/nonworkingcombos.mdb
View 5 Replies
View Related
Dec 7, 2005
:( I changed my input mask in my form to 99/99/0000;0;_, but my form dates still look like 1/1 /2005. I want the 0's to be visible. Please help.
View 1 Replies
View Related
Jan 4, 2008
I want to delete a relationship temporarily so that I can delete a record. After the record is deleted I will restore the relationship immediately. But I am concerned that this will ruin any queries I have already established or ruin my other records.
Could you let me know if this is possible without making a mess of things that have already been established.
Thanks
Carrie
View 11 Replies
View Related
May 16, 2005
I have pasted the code that SJ posted on another thread that any changes to a record will ask the user to save before closing the form, this located in the beforeupdate event.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If MsgBox("Save changes?", vbQuestion + vbYesNo) = vbNo Then Cancel = True
End Sub
The problem i am getting is that if the user selects no it pops up another message saying "You can't save the record at this time" followed by a description.
How do i prevent this second message appearing i cannot find a thread with this in?
Thanks as always
Mike
View 1 Replies
View Related
Nov 28, 2005
I have created a form that with an image control called imageview with the following code.
Private Sub Form_Current()
Me.ImageView.Picture = Me.AlbumCover
End Sub
Albumcover is a text field containing the path of the bitmap.
All is fine unless i move to a new record in which i get an invalid use of null error on the code. Can someone help me remove this.
Thanks
View 1 Replies
View Related
Jan 25, 2006
Hi all, long timer viewer, first time poster
Any way, im not nearly as experience as all you, I have a small form, on the form I have a combo box, the form shows the relevant info with regards to what is selected in the combo box, the source of the combo box is a table, the data in the table is alaphabetical, but when you select the combo box the data shown to select from is not alphabetical its all over the place!
Hope that explains it, its driving me nuts!
View 4 Replies
View Related
Mar 27, 2006
Hi!!
I am creating a dbase which can be accessed through a lan
Would like to know whether it is possible to have a chat window EMBEDDED into the dbase; whereby multiple users can chat and modify database accordingly....
Prob simple, but the access help doesnt offer much support
Your efforts will be greatly appreciated.
P.S. Can u just create a small sample for the same??
View 2 Replies
View Related
Feb 12, 2007
Dear fellows
hi
I need sample access dbase records and retreive attendance of students in course
thank you for help
moheb morcoss
View 3 Replies
View Related
Feb 15, 2007
Hello there,
I'm trying to develop a database for an organisation for their partners....see attached. I would like you to take a look and tell me if what I've done is the right thing. Secondly, (I'm just learning Access) I would like to have a query that give a count of 3 how many CBOs, how many NGOs; by 8 (location). Third. Is it possible to have (sub) grouped into expertise?
The mission and vision field was a multiple answers field, is this the way?
Thank you in advance,
Samia
View 8 Replies
View Related
Sep 29, 2005
I need to export ms access table to dbase III format.
When I use export something is missing and the file format
is just not good.When I try to open dbf file with
program Dbase I get message "not a dbase database".
I find out that excel do the same, so if anybody know
how to export to dbase III using ms access or ms excel
please help.Ms access help is to install borland database,
I downloaded some from Internet but I don't know what to do with it.
PS: Even when I import dbase III file and try to export it back
there is a problem.
Please, please help.
View 2 Replies
View Related
Oct 12, 2006
Okay,
First I was thinking to write a little app in Access to work with a DBF file, that I assumed was a DBIII database. It was exported via a 3rd party software, and the primary interface up until this point has been Visual FoxPro. My problem is two fold:
1st:
When I tried to import it as a dBase III file, Access just closed. I mean, disappeared, no longer running, closed. I didn't even get an error message or anything.
So I tried to import via ODBC, using a "Machine Data Source" Microsoft Visual FoxPro Database (or table, either works) and selected the directory of the dbf file and selected the table listed once it scaned the directory and all imported fine.
So: If the Visual FoxPro Machine Data source worked, though I am confused why the DBIII driver just booted me, I am now concerned as to how I would write a connection string via DAO to access that dbf file at run time.
Basically I want to go to a static location on a network and access a dbf file, and perform query manipulations upon it. My connection will be READ ONLY to the actual DBF file and i would subsequently use MS Access to create any other relevant tables/queries based on the table in the dbf file. Since the Visual FoxPro MDS diver worked, do I need to write a connection string to access it, and if so, how would I do that?
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
View 1 Replies
View Related
Jan 24, 2007
Hi,
I've searched the forum for a sample code on how to automatically shutdown database at a given time of the day, but i can't find any. There are lots of codes pertaining to inactivity / idle users but none on scheduled time.
My idea is to kick-off all users every 12:00nn, Monday to Saturday and then compact / backup database after.
I hope someone could assist me.
Thank you!
Sheila
View 1 Replies
View Related
Apr 13, 2007
I have been married for 36 years. I really don't want a diorce, but I think I might have to in order to get access to work for me. It appears to get the best way to get D base to work with access it to get divorced and remarried, ha. We have tried several ways to get import data into access from a Dbase IV file. We have tried by a Dbase import and a text delimined file import. We get a subcript out of range. There seems to be several issues here. One of them is if you have numbers in a dbase text field, and try to import them intp access, the documentation and access says we have to put quotes around the numbers. That didnt work.
Actually, rather than going into great detail of what we have tried, let me just tell you that we cant import the file. Can anyone help? We have the folling type of filds in dbase: date fileds, text field with numbers, and numeric fileds. Please help.
:mad:
Bob
P.S. I am happily married, so i would prefer not to go the marriage route with dbase.
View 7 Replies
View Related
Feb 22, 2008
Hello guys,
I am working on a database that requires a user (with very little access knowledge) to export a table into .dbf (DBase IV Format) using a button and VBA.
I realize this can be done by right clicking on a table and click export. However I did not give the end user access to the tables (being a good DB Developer!) and also I don't believe I can teach this particular user how to do the steps to accomplish this.
The scenario: Third party software needs (SwissSys, which is a chess software) to grab information about players and ratings from a .dbf file (and will not work with access). I have developed a database for the association so that they can edit players information, and update the ratings directly off the website (www.chess.ca) and it automatically updates in the database.
The idea is, the Access Database updates the ratings from the website, and then the user exports that data into the dbf file (players table) that is directly linked to the third party software.
I am looking for a way to use VBA code to either 1. Create/Overwrite the existing dbf file when exporting the tblPlayers, or 2. Append/Update the current dbf file with the updated ratings, and creating new entries when necessary when exporting the tblPlayers.
Unfortunately I have had little success in finding code to export to a dbf file, anyone have any ideas?
View 3 Replies
View Related
Jul 20, 2007
Can anyone help please
How do you add a user to asecured database using vb
Thanks
View 1 Replies
View Related
Dec 19, 2007
I am trying to replicate a database for mobile working. When I attempt to 'create a replica' I get this error:
"MS Access can't convert to design master
Cannot make the Table "[TableNameHere]" object in tables container replicable."
The table in question is fairly large and has 248 columns and is linked to 3 other tables of similar size as well as 3 smaller ones. Got about 2000 or so records and set to cascade deleted and updated records. 248 columns should leave enough spare columns for replication though, shouldn't it?
Any suggestions as to what I should look for to fix this?
View 7 Replies
View Related
May 29, 2005
This mind sound like a pretty lame question to the pro's....
Is it possible to duplicate an Access database creating a new blank database - retaining only the database/table structure? I have a website content management system and I want to duplicate the database for each new site.
Also, is it possible to reset the 'auto-numbering' to zero?
Whilst I've build a reasonably advanced web-based system based on a database containing a dozen or so relational tables plus queries, I'm no expert on advanced Access functions.
Cheers!
Penny.
View 1 Replies
View Related
Dec 10, 2007
Hi everyone
I am just about to start a database project for the company. The last one I wrote was over 10 years ago in Borland's ObjectPAL and has served us well.
After doing quite some research I have decided (well... almost) to use Access as the basis for the new project as I need the most efficient and 'slick' solution in the speediest time-frame (don't we all!).
The downloadable Templates from MS seem actually quite good as a starting point, but we would need to 'glue' them together to prevent replication of clients, prospects, employees etc.
Has anyone had any success with doing this? For example, we would need to integrate Marketing Projects; Customer Service; Sales Pipleine plus our own custome stuff besides modifying these standard templates.
Looking forward to your replies
Regards
CD (UK)
View 3 Replies
View Related
Jul 27, 2013
I've been asked by a friend to extract approx 50 images that are stored in a dBase 5 'DBT' file.
I know Access can import dBase 'DBF' files, but is there a way that I can use Access to import the data in the 'DBT' files and convert to jpg format?
View 2 Replies
View Related
