I have a database the keeps tracks of printers by serial number. There is a form for doing this, the form has a serial number field, and a status field "example move, add, remove" , effective date and a location field. Here is what I want to do, lets say that the current location for serial#ABC is in location C and then the user opens the form and tries to move serial #ABC to locaiton C, how can i display a message saying that Serial#ABC is already at location C, maybe I can do this by a DLookup or by a record set, but the only thing that i'm struggling with is how do I make it look at the latest record by the effective date. Thanks.
Err_cmdEMailRptPastNonCon_Click: MsgBox Err.Description Resume Exit_cmdEMailRptPastNonCon_Click End Sub
A box appears with the options [rich text,html,snapshot etc] I choose an option and a message box appears saying: "The database engine could not lock "tblMain" because it is already in use by another person or process., I know this is probably a simple stupid error ive made but being a complete beginner I am stuck, any ideas of where I should look to find any errors?
Could someone tell me how to change the border colors on a form. There are lots of posts on changing txt border colors and such but i want to change the form border its self.
I have a form that I has a password field that matches the employee name. I want the employee to enter in a data field their password. If it matches I want another field (verified) (yes/no field) be marked as yes if it matches and no if does not.
I did IFF([Text5]=[Password],[Verified],= -1, [Verified]=0]
I know how to do this and I think it is simple I just cant remember right now. I have a field in a query called LastActivation. I also have another field called DateEntered. In the query I want to have LastActivation=DateEntered. How do I do this?
Hi there. I created some forms using the wizard. But I set up the properties on my form so that the navigation bars don't appear. I only want them to be able to input new records. I also added code on the form_open event to default to adding a new record. But I noticed that if i use my scroll wheel on my mouse, I can still view previous records. How do i prevent any previously saved records from loading?
Also, where do I add a message box to say that the data has been saved? i noticed that when the form is closed by using the X button or when they navigate to another form, data is automatically saved. would this be the after_update method?
could somebody help in the query design in order to query table 1 (image attached), by showing the maximum weight for each component_id, but also include other details such as the date when the maximum occurred and the event_id, the result as query 2 (image attached)
if i just select component_id and weight, i can do this by selecting max weight, but when i add the date and / or the event_id columns then i get duplicates in the component_id column
Action: 1) Update the blank fields in a table + add newly imported records but...make sure that there are no duplicates. I need to Append the records from a table called: XLS_Imp_11_27_07 to my main Table " Invoice Tracking for A/P 10_30". The fields found in the XLS _ table: Release Dt, Entry Dt, Liquidation Dt may have been populated by a live report found on Internet. Since it's a live report, when Appended, to the other table, it will create numerous duplicates. The fields found after the 7 first fields in the Invoice Tracking Table may have been updated by users
Is there a way to avoid duplicates and get the data from one table to the other without wiping out whatever is already filled-in? :(
Let see if I can explain my goal. I've been fighting with this for some time with no resolve. In the included DB has a table that represents the fields that will be queried in the real DB. It shows records of one of many employees that were "tested" (shopped) on a date and whether it was a successfull shop or not. My goal is in three parts.
1)A query that goes through each employee and returns the records with the check box in SuccessYes checked (Yes) back to the last unchecked box, not including the unchecked box. In the example given the last (most recent) 5 records would be returned. If the shop of date 1/18/2005 was not checked, it would only return the last 2 records. Basically, I'm looking for a way to have a report that shows everyone's current successes in a row. It could be any number.
2)A query very similar but it returns only those employees that have the current successes in a row totalling 5 and where the field "Award5_Paid" is NOT checked (they have not been paid their reward). From there it should be easy to do one for the 10 in a row.
3)If I've got a form open (or...?) where I can place a command button, that when clicked, it appends the selected records with checks in the appropriate boxes for being paid. Example: If a set of employees come up in the query with 5 successfull shops in a row because the "Award5_Paid" field is unchecked, then I need to pay them. Click the button and the Award5_Paid field gets checked in THOSE RECORDS ONLY so that the next time I run the query, they won't show up and get paid twice. Issue? What's the coding or SQL or ??? that's run when clicked.
I hope that makes sense. I've been running around in circle trying to figure this one out. Maybe it can't be done, but if it can, I know some of you know how. As always, thanks for the assistance.
Hi, newbie here to this forum, been looking about for ages to try and find an access based forum.
I am not a great coder, have not really done it, nor remotely understand it, but I have still managed to write a database in access for the office.
We run a residential care home, where we had 5 databases (MS Works) which held different information of the residents within the home but duplicated name, dob, etc. I have successfully writen a access database which works well. But now I want to start pushing it a degree further if I can.
We took delivery of a HP officejet all in one printer, and it has a scanner with document feeder which we scan letters in so we can share them with head office, but what I would really like to do, is scan letters in relating to a specific client, and be able to save the file name as a link, so an other user on an other PC can open the document on their PC. Basically, I want to avoid us going to the filing cabinet to refer to a letter which was written to us.
I am using XP Home, with Office 2003 Pro, and Acrobat 8 Pro.
Any ideas where to even start looking?? I did do a search, but have no idea how to start.
Hi - I am writing a small form that has a calculated field. I want to convert feet and inches in length to metres, and vice versa - so user inputs 10.45 metres, and I will have two fields giving the answer (I suppose) - one with the whole numbers before the decimal place (the feet); the other taking just the numbers after the decimal and converting them from /10 to /12 for inches. Think I can work out the reverse if anyone has a nifty way of doing this - thanks very much; I'm new to this site.
hi guys I hope to get help on this, I have an excel sheet which is like a letter with fields that I need to copy from mainframe. Does anyone know how to do it. Please help if you can, this is important for me. I need a macro in excel to copy fields from the mainframe system to the excel defined fields. I just need to get started. Thanks a lot.
