I am unsure about the relationships for this database, which is a big problem. Also, I created a query but some fields do not allow data entry, which in turn had the same effect when I created a form from the query. I think it's because i selected the fields from the wrong table or i donno. You will understand exactly what i mean when u see my database (attached). If u see disabled fields in my form i did that in purpose because i expect them to be displayed automatically when i enter the data.
If u have time can u please make the changes needed and send me the modified database attached, if not just give me a textual description of what i should do..
thanks a lot, please reply soon...... i need urgent help
Is this relationship correct (see attachment)? When i create an orders query with the fields:-Barcode number (source: orders/products table)Product name (source: products table)Quantity (source: orders/products table)Unit price (source: products table) Total (calculated - [Unit price]*[Quantity] )it does not allow data entry for barcode number and quantity (product name and unit price should appear automatically when barcode no. entered) why is that? and how could i resolve this? attached also is my database to see what i mean... if u have time can u please make the modifications NEEDED and send me the modified one, if not just give me a textual description of what i should do..... (btw it is actually a school canteen system databse, thats why i have customerID field as student administration number or staff initials)please reply soon.. this is urgentthank you
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.
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..
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.
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.
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!
I 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.
I was playing with passwords for one of my access db.
I tried opening the db with the password, but it won't work. So, I thought I forgot the password. I checked some posts on this forum that helped in retrieving the password and it's the same that I have been trying. I am not sure if the Name is correct, is there a way to retrieve the log on name?
I also noticed that when I try opening any other db on my system, it asks me to log on, I though I was only applying a password to one file.
I have been tasked with setting up a database for all employees the info contained is along the following lines:
Employee Number: Name: Qualification Status: Qualification Run Out Date:
To name but a few of the parameters
I have currently set up the start up screen, main switch board and the complete employee records table with form (for simple viewing/input).
My problem is this we have four departments that require access to the database
Admin - Require access to all employee records (View) 1 Dept - Require access to their employees (View and update records) 2 Dept - Require access to their employees (View and update records) 3 Dept - Require access to their employees (View and update records)
Currently i have created one complete employee record table (Admin) how do i break this down for each department so that when the info within each one is updated it in turn updates the main Admin table?
I started by copying and renaming the Admin table for each department but this never updated.
Any help and info would be appreciated.
On a slightly less important note for the time being at least can i password protect each command button on the main switchboard?
I basically started teaching myself how to use Access 2000 about a week ago. I am working on a project for work, that requires to have a report of all the training records. But my boss wants it to be color coded. He wants one color to show the people's training classes that are 45 days out from being over due, he wants another color to show what classes are due. And another color that shows classes that are over due. In my table, I have a column for the classes that show the date that they took the class, and I have another column that shows the due date of the class. But I have no idea how to go about getting the report color coded with what he wants. Any help at all would be great. Many thanks in advance.
I'm designing a database but it is turning into a bit of a state. :(
I Understand that my approach is probably poor but i am fairly new to Access. and realln need some advice/help
All other programs i have written have used inputs from list and combo boxes to wirte to a table. This is the first that reqires me to manipulate data already stored in a fixed sized datasheet.
I have two tables: tblMainProgressList and tblLog
The database is used to check the status of different 'line numbers' in a construction project. like a time line; when all boxes have been ticked, the project is complete!
the different Status's have been named STN1,STN2,STN3.. etc (Station1,2,3..) This will enable the program to be migrated to a different project by simply changing it's name instead of digging deep into and changing lots of code.
So far, when i click any STN tickbox, the reletive STNDate will be assigned with the current date. and likewise removed if the STN is unticked. (all from the Afterupdate event of the subform)
I have managed this with a large bunch of udate querys in SQL. However, this is just a prototype; the final design will have nearly 30 different stations! This means a huge amount of update querys that will probably make the operation of the program very slow.
surely there's a better method to handle this? :( (i'm all ears :D )
In a similar way, each time a STN is ticked, a reletive field (STN1Val, STN2Val...etc) is given a load value (percentage of project completion). A TOTAL field adds all STNVals to produce the total percentage complete.
Now, This all works (although the coding will probably be laughed at).
but my next taks is to send the data to a log each time it is updated:
So- for example . if STN1 is ticked on line-20000
i would like the last record in tblLog to store the data:
| Line No | Name | Date/Time | Total Load | | line-20000 | PIDNoRev | 06.11.06 12.00 | XX |
where name is the name of the station that was ticked.
I really need some advice on how to single out the STN that i was ticked last, and write it to the name field in tblLog . If this is solved i could work out the rest.
Also any help on my update query issue will be greatly appreciated..
I have attached the database to make all this a bit clearer (hopefully)
Hello, This is my first post here but I have been reading this forum for a while now. Just wanted to say I appreciate all of the shared knowledge everyone has given in this forum.
I am new to access and only know the basics of data entry and a small amount of VB. I post today to ask for some help, I am working on a database and I need to setup a series of categories and then select an option for that category and graph the % each one has occurred. For example:
Category 1: -Option A -Option B -Option C
Category 2: -Option A -Option B -Option C
Here are some examples of the graphing I need to do: Graph 1: What % in category 1 Graph 2: What % in category 1 are option A.
And so on from there. I am having trouble writing a from the get this dat organized into a table as well. I have tried for a few days and am looking for some tips or suggestions on a simple way I can get this data organized and into a bar graph.
I have tried checkboxes with a different numerical value for each category and option option and have tried graphing it based on the numbers I get but I am not sure how to do this correctly. I have also tried putting in a drop down with the different options but I opfen come up confused with this data in text form and do not know how to tell excel to count the number of times a certain word has occurred in a table.
Any help or suggestions would be greatly appreciated. Thank You in advance.