and it works mainly except for two problems:
(1) I renamed all the forms on the Database main window. But when I open the forms, on the top blue bar, it still reads the old names. How do I change that to new names?
(2) I've changed the "Calls" table and forms to "Actions." I've renamed the "Calls" button on the main "Contacts" form which is now "Projects." The old key field "ContactID" is now "ProjectID."
When I click on the "Calls" button to go to the "Calls" form/subforms, box says "cannot find field "ContactID" referred to in your expression.
How do I fix it so that it recognises the new key "ProjectID"? They are linked correctly on relationship--or at least they're linked exactly the way it was linked in the template.
I'm using Access 97 and have merged the 'Event Managment' & 'Contact' templates. I thought that I would need to make 'Contacts' and 'Attendees' as the same table.
My knowledge is limited and attempts to change to 'AttendeeID' means I lose the ability to log 'Calls' to people.
Is there a simple way of combining the functionality of both databases given my limited ability in using access?
I used the Contacts Database Template to import a comma delimited txt file of contacts data. The template included a number of tables, queries, forms & reports which I did not require. I deleted them leaving only a Table entitled 'Addressbk'. I added an Entry Form using the standard access tools and this works fine with the table. However, on running the access database I get the following error message; 'The form named "Main" is mis-spelled or refers to a form that doesn't exist. My only form is labelled 'Entry Form', so it would appear that one of the forms I deleted must have been named 'Main'. If one ignores the error message the database & entry form function perfectly.
I want to use the "Contacts" template as a base for a Customer/Client database.
I need to remove the American orientated fields and replace with UK fields and remove business phone and fax etc.
I also want to add some more fields like: - Who reffered them to us - Who they have reffered to us - Our services they have in credit (like sunbed mins)
When I modify the "Contact Details" form (like delete the zip code part), it doesn't make the change in the: "Contact List" (which I think is a form) or the "Contacts" (which is a table)
And I have no idea what the "Contacts Extended" actually is, but if I delete it, it stops the other thing working.
All I want at the moment is to make those simple changes. Is there a place where I can edit the fields as I want and it will make the proper changes to the forms automatically? If yes, how? If no, then how should I go about it?
So I can easily enter details like in the pic below... http://img505.imageshack.us/img505/269/accesscontactsanddetailga8.jpg
I need to able to quickly find which the last records that have been modified. I have an invisible field "txtModified" on the main form and selecting when changes where made to the record on the main form is easy using a qry on that field. The problem I face is that the form with all details of a particular item contains 2 subforms. Changes to data on each of these subforms doesn't effect the time/date on the main form. However, each of the subforms is also time stamped upon change.The qry to select the last records changed therefore needs to look at 3 fields and select records with the latest date in any of the 3 "Modified" fields. How do I do that? I suppose I'll have to put an expression in the qry?Thanks for your advice.Walter
I have this code in a Query... [Type in your product, such as mtt20]
Once you type in the product it will go and find it and display it.
My question is : Is there a way to modify this so it will allow me to enter more than one product and then go and get the results. Preferrably the easiest way possible as I am a new user of access and no program training...
My problem is that somehow the PK of my [Orders] table got turned off allowing records with duplicate IDs. To get rid of the duplicates, I did the following: 1. create a new, test database. 2. copy the [Orders] table to it. 3. create a new field, [Delete] in the [Orders] table 4. write a query to find duplicate orders and make a new table[$Dup_Orders] with just the [IDOrder] field in it. 5. write a query , linking the [$Dup-Orders] table to the [Orders] table via [IDOrder]. Here’s the SQL of that query:
SELECT DISTINCTROW [$Dup_Orders].[IdOrder Field], Orders.DeleteDup FROM [$Dup_Orders] INNER JOIN Orders ON [$Dup_Orders].[IdOrder Field] = Orders.IdOrder;
With that query, I would like to go through the table, flag the records to delete, and then write a query deleting those records.
The problem is that Access does not allow the [Orders] table to be modified.
The database is completely independent with only an imported [Orders] table and a temp table created from a query.
I created a "BeforeUpdate" property on my form, which is meant to insert the date into the field DateModified when the record is modified. The code says:
Private Sub Form_BeforeUpdate(Cancel As Integer) Me!DateModified = Now()
End Sub
When I am running the form and modify a record then go to find a different record through an unbound text box which I use to locate records , it comes up with "run-time error '3020: Update or CancelUpdate without AddNew or Edit."
I'm looking for a way to update forms, reports, queries etc... by exporting them to another database with the same objects. Essentially, I'd like to export only those forms etc... that have been modified according to the mofified date.
I modified some reports in my music library database to have the composer first name and last name appear as one field. I'm not sure what is wrong with them, and request another pair of eyes look at them to see if the error(s) can be found. Please bare with me, this is my first post to this forum so I'm not sure if I am following the rules correctly, yet I have posted to the Java area before. I'm not sure what I should include for help, since when I try to include my database in *.zip format, it is saying it is too big to send. Any ideas on what I should send?
In my access database I am using a form and at times a record may need to be updated multiple times. Is there a way to track and count how many times a record has been modified? I already track the last modified date and time.I searched and was not able to locate what I am trying to do, and maybe my search term was not exactly correct.
I have a form with 4 subforms on it and I am trying to find a way to capture the last modified date for the record regardless of what form or subform they touched
Is this possible?
Right now I have a macro on before update of Now() on the form and all of the subforms but that is only showing when that form was last modified which is not exactly what I am trying to achieve.
I have over the last few months been building my own Project management system.This is based around A Phase task principle but the phases and tasks are used to create an estimate for a project depending on how much time is assigned to each Task.The system can use multiply Estimates with different billing codes plus their is a billing code system where billing can be done by a default list of codes (Rates 1-5) Or assigned rates for a client.I'm not after any money for it and will make it available to members hear.If anybody want to look at it and maybe make suggestions on improvements or let me know of any errors that would be greatIt would be an mde with an mdb back end.You should be able to update the back end that I don't think will be a problem LOL When it comes to new versions.As I said I don't want ANYTHING For you using it but would be nice to get it working better.mickp.s Ill Post some pictures if ya want. And It is a work in progress?Please use this topic from now on http://www.access-programmers.co.uk/forums/showthread.php?t=121117 this is where the beta 1 downloads available from.
Hi, I’m new to access and I have read through a couple of books but still struggling.
If I make a tables with my info in it say customer details, use quires to sort display and print that info. Now is that query saved and do I end up with lots of query’s (hundreds.) Or I’m assuming that that query is then lost (don’t know the correct term) and the only way of getting this info back is make a query asking for the same info criteria.
I’m thinking of an invoice made up of info from a contact table My invoices are very simple I only supply labor and materials and don’t have set prices for ether, so I need to insert prices that I input and text that I input Both will be manually inputted although some sort of auto text that can be edited to make each invice individual would be nice
Hope this makes some sort of sense, can any one point me to some key areas that I can read up on
date___ name 1_______1 2_______1 3_______2 4_______3 5_______4 6_______4
field date is unique while field name has what can i do to get the following such that there are no duplicates for the name field _________________________________________________ | name | date1 | date2 | date3 | date4 | date5 | date6 | -------------------------------------------------------| |1 ____|1 ____ |2 ____| ____ | ______| ______| _____| |------------------------------------------------------| |2 ____| _____ | _____|3 ___ | ______| ______| _____| |------------------------------------------------------| |3 ____| _____ | _____| ____ |4 ______| _____| _____| |------------------------------------------------------| |4 ____| _____ | _____| ____ | _______|5 ____|6 ____| |------------------------------------------------------|
Hi i have 2 fields order date and delivery date using a calender operation does anyone know how to make it so that the delivery date cannot be sellected on a date before the order date? cheers kev
I'm a novice Access user and I've been put in charge of changing this. The database is on a shared device. I copied a working frontend (access file) to another machine and used the link table manager tool to find the new database. Now when I open the table view mode I can see the table data, but when I open the form, it doesn't show the data at all and it only lists 1 record. I know this sounds like a really stupid question, but is there one more step or am I in insert mode?
How I can create a sequential number in a field that looks like this:
Year-XXX-00
(Example: 15-100-00 -- the next sequential number would be 15-101-00)
I don't want to hard code the year, and the last 2 numbers must be entered manually.
It gets even more exciting --> this number has to be able to be duplicated in a table. Those last 2 numbers is a revision number. We might have a 15-100-00, 15-100-01, 15-100-02, etc.
I'm just wondering if anyone has made a very advanced budget management program using just access?? I tried to make one for myself but I just want it to advanced for my little knowledge of access. I would love to be able to keep track of all my expenses including everything bought from groceries to hair cuts. I would love to be able to take my receipt from walmart and enter everything bought and the price for each item. Then I would love to be able to at anytime search for soap and thing with soap in the Item name will be displayed with the location and the date and price. This way I can keep track not just what I spend on groceries but what I spend on mountain dew or what i spend on hamburger in a given time. This is just way to complicated for me! I hope someone can help me out here maybe give me a shell and let me try to fill in certain parts or if someone already has one that works kind of like this maybe i could just change a few things to the way i want it! I really appreciate this!!
I am trying to create a access database system which will show classes, students, attendance, progress report, teachers, departments etc...
i have repeatedly failed in accomplishing this database as i dont have the knowledge.
the place that i get messed up is for example the attendance, i want it so that i can select a date and then all the students associated with that class showup. so 1 date and a list of student only on that class.
another problem was adding a progress report for every class and individual students.
this is for a community based school which teachings on saturdays, there are over 15 volunters who do not get paid to teach but are still willing to give something back to the society.
i beg you guys out there, you all are geniuses!!! please help us design this simple system. please if somebody already knows where i can get a system like this free of charge then let me know ASAP!
I would like to thankyou in advance for reading thins messge.
I have little experience using Microsoft Access, but am attempting to create an order management system.
I have designed a system to store customer details and allow the entry of orders. I now want to develop this so that the system can handle delivery notes.
There are currently two tables for order information, since each order can consist of multiple items. So, general information, like the order date, order number and salesperson are stored in an orders table. A second table, Order Detail lists the items and item specific information along with the order number of which they are a part.
A whole order (i.e. all items assigned to one order number) may be delivered at once, or in smaller consignments. However, every consignment must have a delivery note with a unique number. So, there may be several delivery note numbers associated with each order, relating to different shipments.
I therefore need to create a system which allows the user to select which items from an order are being dispatched and then get Access to do the following:
Create a new record in the delivery notes table. The delivery note number will therefore be created (it's an autonumber). The user should be prompted to enter the delivery date and this should be stored in the date column of the delivery notes table, alongside the delivery note number. Enter the delivery note number in the "Delivery Note Number" field of the Order Details table, for every item that the user selected as dispatching.
Once this is in place, I will then be able to pull all the required details together with a query and then print the delivery note.
Bearing in mind that I'm very new to Access and so don't have any knowledge of scripts/macros etc, can anyone tell me how I can achieve this?
