I made a delete query. In the query the from table is linked to it's child table. I dragged down a field from the child table and specify Is Null as crieria
If I view the query it shows all the entries with no children, which are exactly what I want to delete. However when I run the query it gives this error:
Could not delete from specified table.
Could any one please help. thanks in advance.
ad
Well, my newbie status in db development has reared its head. I knew from the beginning I didn't want to have cascade delete when deleting a clinic (parent) from the db. Problem is some queries in other areas need some clinic info and if the clinic is deleted, it won't be available. Right now I'm thinking that an easy way out is only allowing a delete if it has no attached records. If the clinic is no longer used, they can just write in the memo field that this clinic is no longer used. It's not a large db and there won't be hundreds of clinics so it may not be too bad. Any other suggestions?
scratch
I'm using Access 2010. I have a form that has a combo box. The combo box lists all employee names and one has to be selected. I've been adding employees over time as new employees come. This DB is 3 years old so there are many employees showing in the combo box selection that are no longer here. I'd like to only have the current employees visible but I do not want to just delete them from the Table because then the historic data wouldn't be complete. How can I only show the current employees in the combo box and maintain the data in the table?
View 1 Replies View RelatedI am currently working on a database and I am stuck. I have a form which accepts the company's information and the company's reference number. Now if I want to keep different jobs from this company in the database I know I have to reference them to the Reference number. Does this mean I have to create a seperate form to take the job information or can I just add to the main form. I noticed when I tried to add the job information in a seperate form, I wasn't allowed to use the reference number due to it being a primary key. Does this mean somethin about me having to let my table have children?
Sorry for sounding like a mad man but can someone help me. I have looked at the northwind example and it ain't helping me here. I also noticed if I try to create a form to allow data entry, it is never blank, it always starts off at my first record of the table
I have a database that keeps tracks of the orders that clients make and when I do a search from my search form, if the client is in the database but haven't made any orders. A solid blank screen opens up. Is there a way to stop this to show a message box if there are not orders?
View 2 Replies View RelatedI have a parent record and child records. After creating the parent, there must be at least one child record.
On closing the form I could, in principle, delete the parent and child (or children), if the user changed his mind.
Or, I could presumably wrap this entire enterprise in a transaction, something along the lines referred to here: [URL] ....
I have a table in access which is updated weekly; I need to create two tables from this updated table.
1st table will consist of all the new entries for the current week
2nd table will consist of all the entries from the previous week - an amalgamation of all the entries which are not from the "current week" (table) For example; the table below shows the two entries from last week.
ID
Name
1
Adam
2
Ben
This week I have three new entries New entries
ID
Name
3
Charles
4
Richard
So when I run the same query next week I will get something like this.
Old Entries
ID
Name
1
Adam
2
Ben
3
Charles
4
Richard
[code]....
How do I get a query /queries which divides up the weeks new entries and also all the old entries.
All I am trying to do is insert to have a form with a "Delete Record" button on it. The problem is I don't want anyone to be able to delete a record, I would like someone to have to insert a password to confirm the delete.
View 13 Replies View RelatedI have a query based on two tables, joined on one field (this field is the primary key in Table A. Table B doesn't have a primary key). When working inside this query, it gives me the option to delete records. However, when I try, the row disappears from the query but then if I save and close and either re-open table A or the resulting query, that record is back. It doesn't actually delete. If I go to table A directly and delete it, it's gone for good.
How can I make it so that when I delete the record inside the query it actually deletes? And if that's not an option, can I make it so that it doesn't seem like I can delete records inside the query so that people don't make the mistake?
I have two simple tables. I want to delete the records from Table1 that are on Table2. I've created a select query that gives me what I want but when I change to a delete query, I get this message: "Unable to delete from specified tables"
I think my problem has something to do with security but I can't figure out what to change.
I am looking into a database that has become very large (20,000+ entries) and access only allows me to look at the first 10,000. I am sure there is an easy way to check this out, but I am new to access, any help would be appreciated. Thank you.
View 2 Replies View Relatedis there a way to total up the number of rows i have in a table/query and have that number show up on a new seperate row kinda like the way sums are shown in msexcel. using access2003 btw, thanks
View 2 Replies View RelatedWhen I try to add a topic to my database it adds the topic twice (using Internet Explorer). When I use Firefox it only adds one (as it should).
I realy don't know what's wrong
Anyone an idea?
Code:if Process="AddToDb" then'Add to DBset conn=Server.CreateObject("ADODB.Connection") conn.Open "w002399556_db_new" sql="INSERT INTO tblReview (TopicID, ReviewActiv, FieldName, ReviewTXT, Autor, Editor ) VALUES ('" & PlantID & "', True, '" & FieldName & "', '" & strMessage & "', '" & LoggedInUserID & "', '" & LoggedInUserID & "')"conn.Execute sql,recaffectedconn.closeSet conn = Nothingresponse.redirect(domain & "/db.asp?id=" & topicID)end if
hello,
I have a Database table that was pretty big, there is a little over 18k entries, so many that the form I was using won't display them all, so I had to split it into several tables, and made forms for each, now the database users want to make a mailing list out of all these different tables, they want to be able to display the entries from sertain fields with checkboxes and not others, but I can't figure out how to make a query and/or report that will look into all the different tables and pull information from all of them to make into one.
In case that wasn't clear, basicaly I have:
DB A-H
DB I-M
DB N-S
DB T-Z
and I want to make a mailing list that will look into all the tables and print only those which have the "member" field check box marked.
is there any way I can do this? do I sound stupid for not being able to figure this out? I've tried google but can't get any information that helps me, maybe I'm typing the wrong thing.
if anyone can help it will be greatly appreciated
I have a small access db in a network which has started to crap out far too often lately. The main table records job entries and inserts a date stamp. Every now and then, an entry has a ridicuous ID (auto inc field) and/or a bad date stamp and i can't delete the record (instead i have to output everything to ecel as best i can, reimport it to a table and reset al the fields..)
i don't know what the problem is but i'm wondering if access writest to a log file somewhere (that might help) or if there is a way to make it do this?
cheers
jg
Hi everybody
I have an assesment and need to create a database, I'm just starting with access and I need some little help if anyone has time.
I'm doing the database for an interim managment company and i have problem with the experience category. Basically because every candidate has got at least 3 or 4 different experiences, I don't know how to design the table. All I know is that I probably will have to create a separate table for this.
Thanks to anyone who will help me.
Ilan
Hello, I need help. I have two tables.
horse_entries
ent_HorseName (PK)
ent_entries
horse_information
inf_HorseName (PK)
inf_Ground
inf_Notes
It is a many-to-many relationship. When I open a table and enter a record there is a small + sign that allows me to open up the rows from the other table to enter directly into it. Can this be turned off? Also I can enter more than one record through this way. I only want one entry in inf_Ground, inf_Notes and inf_Entries for each HorseName. How would I do this? As you can tell I am completely new to Access and trying to learn. Thanks :)
Hi,
I am trying to set up a query which will filter out the 10 most recent additions by date.
My table contains a 'Title' field and a 'Date Added' field. I am trying to get the 10 most recent titles up in a query so I can then create a report based on this.
So far I have managed to single out the most recent date simply by using the MAX function but am a bit lost from there on..:(
Say I have table called "project" that hold info like project name, project date, # of project, etc.
And I have a table "employee" that hold info like name, salary, # of employee, etc.
Project and employee are linked together ( many to many ) on a junction table. Basically "# of project" and "# of employee" are connected in a junction table.
As such it is easy to add or remove people off a project.
However many people are present in nearly all projects. As such I'd like to make it so that each time a new project is created, it assign those people to the project by default.
Is there a way to do this ?
hello,
Currently i have a database that holds information about computers. Each computer has a Service tag and is associated to a person. I need to be able to prevent duplicate service tags from being entered. I am using indexing and don't allow duplicates from the table design view. But, if a duplicate service tag is indeed entered, i want to inform the user who that service tag currently belongs too without having to search through the DB manually. I need then to give the user the option to delete the duplicated record they just entered or change the service tag that they just entered. Thanks.
Jared
Hey,
In a form I am trying to complete, I want the user to be able to enter in an IP address like so
192168<user hits space bar>0<user hits space bar>1
Would convert to - 192.168.0.1
Is there an input mask which allows this to happen?
Thanks.
I have two forms "Enter_details" and "sendemail"
on typing txt in "enter_details" forms txt field " checksum" i want it to be updated in "BODY" field of "Sendemail"
"SendEmail" form may be open or may not be open. I put this code on "Sendemail" but its not working plz help
Private Sub txtBody_BeforeUpdate(Cancel As Integer)
[txtBody] = Forms!Enter_Release_details.[Checksum]
End Sub
I have been working on a Query to sort through a list of companies. I am trying to query the company name to include ALL entries that have the include key(from another table) anywhere in their company name... It is supposed to exclude all entries with ONLY the exclude key(from another table)... If it has the exclude key AND the include key or neither key then the entry should be included... Then it is supposed to use all of the entries added from the previous sorts and include ONLY the entries where the zipcode matches one from a ZIPCode list.
Below I have listed the tables with their variables and my attempt on the query:
Include Table (tblinc)
ID
Inckey
Exclude Table (tblex)
ID
exkey
List Table (list)
ID
Company
Address
City
State
ZIPCode
…
ZIPCode Table (ZIPCode)
ID
ZIPCode
Query withZips <--- my attempt... doesnt work 100% ALOT OF REPETITIVE ENTRIES
SELECT DISTINCT tblinc.inckey, tblex.exkey, ZIPCode.ZIPCode, *
FROM ((list LEFT JOIN tblinc ON list.company Like "* " & tblinc.inckey & " *") LEFT JOIN tblex ON list.company Like "* " & tblex.exkey & " *") INNER JOIN ZIPCode ON list.ZipCode Like "*" & ZIPCode.ZIPCode & "*"
ORDER BY inckey DESC , exkey;
This has become urgent... If you can help, please respond asap...
I need a built an expression to do a normal sum between a current entry and the last entry made for a specific item.
exp. Sum of [Start Kilometers] (Current Entry) minus [End Kilometers] (Last Entry) for a truck with specific fleet no.
Hi,
I currently have a report that is driven by a combobox. I was wondering if there's a simple way to create a report for each of the entries in the combobox through a "All" combobox entry. (i.e. instead of selecting each entry, one by one)
Any help would be much appreciated.
hi,
i'm building a MS access DataBase for my customer. in between i'm always testing if it works fine (VB code, DB connections, etc.). But at the end, i would like to have DB empty of those test entries.
what is the best and savest way to delete these entries (so non of the traces are left behind)?
thank you.