I am using the following criteria to test if an order is Current. The problem I'm having is that I am getting duplicates. Ex. If an order is Current it can't be "Repair"
This worked fine until I added one more condition: [supplier_status]='55'
Any suggestions??? Thanks!
Current: IIf([supplier_status]='55' Or (nz([dayslate],0)<=0 And [cancelled]=0 And [delivered]=0 And [repair]=0 And [SNRCurrent]=0 And [SNRpastdue]=0 And [rejectedCurrent]=0 And [AwaitingDcccur]=0),1,0)
ID Type Count B12342 B11111 C15551 C16661 I don't want to see A, because is a classic duplicate. All I want to see is where ID is repeated (the same), but types are different and the count. Is this doable? Even if I have to write this in SQL will be fine.
Greetings to all,I have duplicate records in my table (i.e. there are two or more records that are identical, and I only want to keep one of them). Is there another way to delete the duplicate records other than one at a time? Assigning primary keys and appending only unique records to a new table is not an option because in some instances, I want to maintain duplicate values within a field (i.e. the desire to delete is based on more than one field)Any help would be greatly appreciatedCheers, Lori (An Access amateur)
I am getting unwanted duplicates due to a joining error, I think.
The goal is to extract a list of employees and their accosiated departments showing a field called [CTD] from qry_employee but there are employees associated with more than one department.. I have a qry_employee liked to another qry (“qry_employee_ctd”) containing the desired field [CTD] joined by [employee_name] but there are employees associated with more than one department. NOTE: Both tables contain the department.
Please let me know if more detail is needs to assist.
Any ideas? I am up for any suggestions and appreciate your help greatly Thanks T
I have multiple fields "STAF1" , STAL1" STAF2", STAL2" etc..
I have text box that calculate
"=STAL1-STAF1" "=STAL2-STAF2"
for exampe 27.250 - 27.24 the Result = 0.01
on a regular basis the result will = 0.0100000000
The fields STAF1 and STAL1 etc are text fields because the decimal places vary from instrument to instrument. Is there a fix for not having these trailing zeros show up?
Hi one and allI am basically trying to do what another member has detailed in this threadhttp://www.access-programmers.co.uk/forums/showthread.php?t=77802&highlight=add+dayswhere someone has suggested another link http://www.access-programmers.co.uk/forums/showthread.php?t=62570which the person states has solved the problem - however it seems this link is dead, perhaps as a result of the site hack.I am sure you can see my question coming like a rabbit in headlights - does anyone know how to do this?!?Basically, I want to add a certain number of days (as specified in a text box-(txtDaysToAdd)) to a date, where weekends and self defined holidays are excluded (I have already set up my tbleHolidays to enter such dates).Any ideas?Thanks in advance
:confused: I am trying to add a "now" field to my table and records.
I currently have 2234 records in my table (old records) and I would like to be able to query only new records, or records within a date perameter. I have tried the "Now()" function but I am getting an error in the field when I go to add new records.
I know this is something simple that is eluding me and it is frustrating. I am currently scouring the forums for an answer, but if someone has the answer before I find it in here, could you pls help me out. I am in the process of rebuilding my database and would like to get everything done before I move to the next level.
I added a field in the template that comes with access call service call management in the invoice screen . That went ok BUT when i try to print the invoice it does not show up . Where do I go to add it to the print ??? This is my first time at this BUT the add worked
I need to find out what has been added to a table and then add that for each record I have in a stringed list called "lstTasks". This is the scenario.
I have a table of file links with multiple entries for TaskId. As I enter a procedure I need to get a list of all file links for TaskId = 1 Then after the procedure does it's stuff I need to check all file links for TaskId = 1 again and if there are more records added, I need to add those records for each id in the stringed list "lstTasks"
I'm having a rather strange problem that no one can fix, apparently. My teacher is even baffled :S.
Basically, I created a custom menu bar, took off some of the defaults, but now I am having a problem. I deleted the original custom menu bar and now I am posed with the following error when my database is loaded (I am using an autoexec script that opens the switchboard).
Can anyone shed any light on this? Thanks a lot, again, guys :).
I have an ODBC link in an Access 2002 d/b to an AS400 table (with the ODBC refresh interval set to 10 seconds) and as the data changes, the data in form view changes just fine and dandy, thank you very much. However, when a new record gets added to the AS400 physical file, the recordset doesnt update to show this, even if I use records>refresh. I have to close the form down and re-open it to see the new record. Is there a method to achieve this?
just building my first database. Eventually I want to make it open to others/make changes as new research is done. Can I add change-tracking etc. later (perhaps once I know ANYTHING about code etc.). Basically - can I worry about that later, or--like structure etc.--does it have to be set up before I can enter any data to begin with?
(for the initial part in which I am the only one using the db I was planning on just having it stamp the date of the original entry)
Hello, I have created a form to enable data to be easily added to the database table, however does anybody know why the query that looks up the records from the table does not return the new entered records, only what was originally in the table? Thanks
I'm new to form design and do not know any VBA (but that won't stop me from messing with the code when need be).
I'm creating a form that will serve as the user-interface for viewing, adding, and deleteing data.
The product I want is a form with 3 items: a subform that displays data in a table (so users can see all the data), a button that links to a second form for adding data, and a button that allows users to delete data.
I've gotten close to accomplishing this with the exception of the delete option. The hang-up is due to the fact that the subform that displays all the data is the output of a query (can't delete data through the query). A friend who used to work with Access years back was trying to solve this issue by writing code that would identify the primary key of the record selected in the subform/query and then adding code that would use this extracted primary key to delete the record in the original table.
This seems like a slightly convoluted approach. Any suggestions how I can get the product I'm looking for?
I have a form where there are many users to enter or update data. I need to capture the username who created a record , then , on form load , I want system to check for username if it is same as the creator of a record , then allow update , otherwise don’t allow update , but allow only adding new records. How can I do this
I have two fields in my form contained Start time and End time. Currently, Both fields using default Time$() on form. However, End time always wrong because until we get our job done, It took atleast 20 or 30 minutes more than current default time. My question is, is there any way I can setup the End time to just click on it, and a new current default time populated?
I have a form that lets you add records to my table, it works well and I can see the records in my table but then once I use my search form, which also is working well, the new records won't come up when I do a search, it just keeps searching through the records that were there when I created the search form.
I have a subform that has 3 check boxes. If the record was an existing record in the SQL table and I want to change the value I can change it no problem. If I try to check the box for a new record added to the database then it doesn't allow me to save the change. I know that this is a problem with bit values in SQL when deleting so I made sure all 3 fields have a default value, but it still doesn't let me make changes to new records.
I have 2 sub-forms attached to a main form. Each of these forms are based on different tables. Whenever I input the record, it goes into respective tables. However when I try to delete the record, it only deletes the record from the main form. I tried cascade delete. However, since referential integrity has to be established, I cannot add the record to my subform because there has to be a corresponding record in the parent table for me to add the record in the subform.
I have this table that I built a form from . I added some fields to the table, most of which are look up. I added those fields to the form.When I try to test the form those lookups show nothing.I used the lookup wizzard.I removed those fields and added new ones (same problem).I compared them to the ones that are working - they are identical.I changed the control source to one that is working - didn't work.
I would like to export fields from Access 2003 with a comma pragmatically added between each field as a CSV file.
I am able to export the fields without the comma, but the Accounting Program that I want to use for the importing of the data requires a comma to separate each field.
I have recently started learning to use Access and all is going very well except for the date. As can be seen from the images below I have set up my date function correctly in Control Panel and everywhere I use a date it is displayed correctly. In Access however numbers are added which I cannot figure where they are coming from and don't want them there. In the second image you can see what the various Format options look like. When long format is used in a Form or Report it displays those additional figure. I cannot get 2015 to display but get 15316 or similar instead.
My main form was working fine (I could key in data) until I added two subforms. Now the main form will not accept data, but the two sub forms do accept data. I have searched properties of all forms and queries, and I cannot find any suspects.