Bad Entries - Is There An Error Log?

Oct 10, 2006

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

View Replies


ADVERTISEMENT

Error 3022 Duplicate Entries

Aug 6, 2006

Hi,
I have a rather large database that was built in Access '97 and recently converted to 2003. I have a couple problems now. I get an error message about not being able to update the form because it would create a duplicate value in the primary key, index, or relationship. (Error 3022) I didn't build this particular database so I'm not totally sure why somethings are done the way they are. I've spent a long time going through everything to try to understand the relationships and I've asked lots of people at work to look at it, but no one seems to understand why it's doing what it's doing. The Access Help information has helped me understand some things better, but not this problem. I've gone through every table and removed all primary keys and set all indexes to allow duplicates. Then, when I was looking at the relationships and object dependancies, I think everything looks to be in order. However, when i add info directly to the table instead of using the form, the form is not updated with the new info. the table keeps the information, but isn't communicating with the form and i suspect reverse is true which is where the error is coming from. But how do I detect that for sure and how can I fix it with out starting over? I've gone through and added data to one field in the form at a time to try and narrow down what field is causing the problem, but no matter what i get the same error. Is there a way to find out exactly what field is causing the error? Thanks for any help you can offer!

Alicia

View 3 Replies View Related

Creating Two Tables - Old Entries And Weekly New Entries?

Mar 13, 2014

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.

View 11 Replies View Related

How Do I See More Than 10,000 Entries?

Dec 21, 2005

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 Related

Entries Sum

Aug 2, 2007

is 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 Related

Getting 2 New Entries In DB

Mar 29, 2006

When 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

View 2 Replies View Related

To Many Entries

Dec 13, 2006

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

View 3 Replies View Related

Multi Entries

Dec 5, 2004

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

View 2 Replies View Related

Limiting Entries

Feb 14, 2008

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 :)

View 2 Replies View Related

10 Most Recent Entries

Apr 6, 2006

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..:(

View 2 Replies View Related

Default Entries ?

May 8, 2006

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 ?

View 2 Replies View Related

Duplicate Entries

Mar 30, 2006

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

View 2 Replies View Related

Validating IP Entries

Jul 28, 2006

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.

View 2 Replies View Related

Entries To A Form

Sep 28, 2006

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

View 1 Replies View Related

Repetitive Entries...

Sep 24, 2007

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...

View 9 Replies View Related

Formula Between Different Entries

Oct 29, 2012

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.

View 1 Replies View Related

Report Using All Entries In A Combobox

Aug 10, 2005

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.

View 3 Replies View Related

Deleting All Entries In MS Access

Aug 23, 2005

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.

View 7 Replies View Related

Moving Entries From One Table To Another

Jun 12, 2006

So I have 2 tables, the first is for "open" orders (where entries get edited changed and deleted), and the Second is for "finished" orders (where once an order is completed it should move from the open orders table to the finshed one where it will no change and will remain for futre reference)

I need help with the transfering part of this problem. I would ideally like to make a form that allows you to pull up the info for the open order then edit it to finally add the finished order to the other table. Im not sure where to start on this one.

View 3 Replies View Related

Best Way To Go About This, (stop Duplication Of Entries)

Aug 8, 2006

Hi,

On our database, we have a form that has 2 calendars. A start date and an End Date. The users fill in the name, and a couple other fields. Then select the start date, and end dates.

When they hit submit, the form enters into the table this info for each date in-between the start and end dates. For example if the users enters they will be taking vacation, then they enter 8/1 as a start and 8/10 as a end date. It will make an entry for each day. This works pretty well for us.

But I would like to improve it if possible.

Let say, a user a month ago made an entry that they would be work 8/23 at home. So in the database it has 8/23 at home.

Well, this week they decide they are going to take a vacation 8/21-8/25. So they make the new entry with start date 8/21 and end date 8/25. The form enters all the info just fine.

But if someone runs a report they see 8/23 at home, and also 8/21, 8/22, 8/23 ect on vacation. So gets a little confusing to where they actually are

So I was wondering if there is a way, for the database to prompt the person making the entry, that there is already an entry for 8/23 and ask if they want to delete it or save it? Then continue on creating the entries for the rest (8/24 and 8/25 in this example?).

Has anyone seen something like this? I was going to search, but not really sure what to search for on the forum.

Thanks

View 10 Replies View Related

Chosing Specific Entries With SQL

Aug 11, 2007

I have following SQL statement:

SELECT TOP 10 tblPortCallList.Port, tblPortCallList.Arr_Date, tblPortCallList.Dep_Date, tblPortCallList.Security_Level_Ship, tblPortCallList.Security_Level_Port, *
FROM tblPortCallList
ORDER BY tblPortCallList.Arr_Date DESC , tblPortCallList.Dep_Date DESC;

As shown, it picks the top 10 entries in a table.

Is there a statement, which can choose specific entries in a table, in stead of the top 10? E.g. entry number 2 in a table? I have three text boxes, which need to show the previous port of call, arrival date and departure date. The table in question is sorted after arrival date and then departure date.

Thanks.

View 1 Replies View Related

How Do I Sort All Entries By Time?

Apr 22, 2005

How do I set my table to sort all entries by time? I have Auto Date formatted for a date field but I have a time field that needs to be sorted in ASCENDING order so that any entries are sorted by time.

This is a phone log file that calls need to be returned in the order received according to our phone system.

Thanks!

View 7 Replies View Related

Multiple Entries For The Same Field

Apr 22, 2006

I'm new to Access and databases so my question might seem dumb, but I need some help figuring something out. Well, I have this database where I'm storing information from different charities. So I created a table with their name, address, phone, contact person, and many othe things. Now I need to create a field with the services that they offer. Each charity could be able to offer more than one type of service. So for the services field, I cannot create a drop down list because that only allows me to choose one service. So what would be the best way to allow the user select more than one kind of service offered from a list and then be able to search that with a query? I have a list with over 50 different possible offered services and each charity usually offers 2 or 3 different services.Thanks

View 3 Replies View Related

Enable/Disable Entries

May 9, 2006

Hi there I am new to Access and I am currently modifying an existing DB. Currently this DB has a main table which holds a bunch of Patient info such as:

Name
Age
AssignedStaff
Condition
etc....

The assigned staff field is populated from another table (Staff), which holds all the staff members working at the institution. However a couple of these individuals have left and they no longer want their name to show up on the form when inserting a new record. However we do want there name to still be in the DB for historical reporting purposes......My intital thought was to create another field in the Staff table that would hold either a "Active" or "Inactive" entry. Then just have a simple If statement to see if the staff member is active or inactive. Does anyone see any problems with this solution or propose a more efficient method.

Thanks

View 1 Replies View Related

Prevent Duplicate Entries

Oct 25, 2006

I've set up a booking system and am looking to stop the system recording double bookings.

I've 3 fields, RoomID, Date and Time that need to be searched, however I can't just simply set the properties to No Duplicates (as this would mean a booking cannot be made on the same day at 9:00 and 12:00 for example).

How can I do this?

View 9 Replies View Related

Preventing Duplicate Entries.

Nov 26, 2006

Hi again, thanks to all for the help given so far.

Is there anyway (other than making that field a primary key) to prevent the same value being entered into a different record?

E.g.

If under 'Name' Radion has already been written, I want an error message coming up saying there is already a record with radion.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved