Newbie - Hope I Don't Have To Start Again.
Jan 24, 2008
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?
Thanks.
View Replies
ADVERTISEMENT
May 28, 2006
Hello, Really hope someone can help me.
I have 2 lots of info in 1 table - nameley customer address & posting address
I need to print a form that always has the posting address on the same side. but in some cases if the postal address is the same as the customer address then it is not filled in. hope this makes sense:
Please Im Really stuck
View 2 Replies
View Related
Dec 12, 2007
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.
View 6 Replies
View Related
May 10, 2006
:eek:
--------------------------------------------------------------------------------
I have made a reasonably simple database, for some reason I am struggling to send of reports by Emails.
The piece of code I am using is:
Private Sub cmdEMailRptPastNonCon_Click()
DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "frmSwitchboard", acNormal
On Error GoTo Err_cmdEMailRptPastNonCon_Click
Dim stDocName As String
stDocName = "rptPastNonCon"
DoCmd.SendObject acReport, stDocName
Exit_cmdEMailRptPastNonCon_Click:
Exit Sub
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?
Thanks for any help recieved.
Mat
View 3 Replies
View Related
Dec 15, 2005
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.
View 5 Replies
View Related
Sep 6, 2006
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]
But it didn't work. Any suggestions.
Thanks for the help
View 1 Replies
View Related
Aug 17, 2006
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?
View 6 Replies
View Related
Jan 15, 2006
hi there
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
any help would be greatly appreciated
View 1 Replies
View Related
Nov 28, 2007
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?
:(
View 8 Replies
View Related
Jul 16, 2005
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.
-Jim
View 3 Replies
View Related
Nov 14, 2006
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.
Thanks in advance.
View 3 Replies
View Related
Nov 11, 2005
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.
J
View 4 Replies
View Related
Sep 10, 2005
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.
View 7 Replies
View Related
Dec 19, 2007
This is my first project using Access so take it easy on me. I'm trying to convert the Excel application to Access since I think Access is more flexible/powerful. I'm not sure if this requires programming (VBA-over my head) or just need some complex formulas to get the mission accomplished.
The objective is to be able to copy and paste data from a customized form directly to Access. These data will automatically be added into a summary sheet based on volume and amount.
Thank you in advance.
AccessNewby
View 13 Replies
View Related
Feb 8, 2008
Im looking at creating a database which includes some sort of diary system but I havent got a clue where to start, how to structure the tables, etc.
I am new to our company so I am looking to streamline some of their processes. Basically there are 4 people in our department and at the moment we use Excel as a mini diary system for our work on a day to day basis (our company uses Lotus Notes not Outlook and the diary system is a load of cr*p, plus also I want to integrate this into a database I have already written for our developers). Going down the page we have a section for each week which contains 4 rows (1 for each person). There is then 5 columns in each section which represents Monday to Friday. Our office administrator then goes in each month and updates the dates manually for the entire month.
Do I need to have a row in my database for every day of the year or is it done in weeks? I did a search for Access diary threads but there doesnt seem to be much info and the example one on iSam seems to have been taken off :(
View 11 Replies
View Related
Dec 7, 2006
Hello all,
I am new to Access and I could really use some help to point me in the right direction. I want to organize my tables properly from the start so I do not run into problems down the road. If anyone can give me some advice on topics to read it would be a big help. Here is what I am doing so far.
My database must record warranty claims. A customer could have multiple warranty claims with multiple parts that failed. Each part can be linked to multiple failures but in a claim one part and one failure must be selected.
Example: A motor can fail in many ways but I need to know how it failed for this customer.
I would like to be able cascade the combo boxes so when a part is selected the failures related to that part are updated.
TblClients
ClientID AutoNum PK (1-many with tblMain)
CustomerName text
Address text
(rest of the customer data fields)
TblParts
PartID AutoNum Pk (1-Many with tblMain)
Part text
PartDescription text
TblFailure
FailureID AutoNum Pk (1-many with tblmain)
Failure text
FailureDescription text
TblMain
ClientID
PartID
FailureID
I guess my question is when I make a form based off TblMain, do I need a partfailure table to let me cascade my combo boxes?
Thanks for any help,
Mark
View 2 Replies
View Related
Jun 8, 2005
Is there a way to set where the different forms will start, like location wise on the screen, when they are loaded?
View 1 Replies
View Related
Jul 20, 2005
I've downloaded and installed the new SQL server 2005 express edition CTD (June ed.) along with the Express Manager.
How do i get an access database into SQL server?
Now that it's installed, what next? When i try to upsize, it asks me to choose a server, and gives 3 options, and i'm not sure where they come from. Where does this list come from? are they previous installations of the MSDE on my computer? are they servers that ar available over our LAN?
i read that the default name if an instance of SQL server express is SQLEXPRESS but that's not on the list...
do i need to create a new instance of SQL server on my computer to house the database?
I really just want to try it, to see if it's something we should do, but i can't get it to do anything at all. i don't know where to start...
I've done some searches, but nothing tells me where to start. I'm getting really frustrated with this....
Please help me...
View 2 Replies
View Related
Jun 12, 2006
Good day all. A bit of back ground, I've built a data base (with much help from the folks here) to track the training of my people. Someone way higher then me has decided to completely revamp our field training. There are now two "tiers" based on rank and training level. My first thought is to make two seperate tables for the information in each tier. What I would like to do is make the training specific to each tier show up on the form that I use to track this training based upon the persons rank. Ie an Airman would only show the tier one tasks and a Master Sergeant would show the tier two tasks. I'm thinking this could be done with a quiery but have no idea how to go about it. Any input or suggestions are welcome. Thanks in advance, Tim
View 6 Replies
View Related
Sep 5, 2006
Hi,
I unticked all the boxes in the Tools > start up window. I closed my database then reopened it. Now, I can't put these settings back again as I can't see the Tools tab.
Any help will be very much appreciated.
B
View 5 Replies
View Related
Apr 3, 2008
I have created one access application which will reside on server and many users will access it from there local PC. But whenever we start the application on local PC, it displays worning message that "Code is unsafe , it may harm your PC do you still want to run the code?" and another message box asking same question.
CAn we supress this worning? CAn we design the application in such a way that it will not ask such aquestions and will open application immidiatly when we double click the file.
Please reply ASAP. It's very much urgent...
View 3 Replies
View Related
Oct 4, 2005
Hi
This is probally really easy........
I have data with dates like 15/05/2005, 30/09/2005.
I need to convert the dates to 01/05/2005 and 01/09/2005
Can anyone help!
View 2 Replies
View Related
Jan 18, 2006
I have a query that is generating two colums, one the states the Start Date and the other that States the End Date. I need to display another column that displays the time difference between the two. Any ideas how?
View 10 Replies
View Related
Apr 20, 2006
How would you make two prompt boxes which ask for the start and end date so you can select all the data between the two dates...
[Start Date?] And [End Date?]
E.g., 01/01/2006 And 07/01/2006
So I can select all the data between that week. I also need to use this for the remaining weeks in January and February. This is really simple...gah. Thanks guys.
View 8 Replies
View Related
Oct 15, 2007
Hi All:given a table with, let's say, Job Numbers that start with a letter (such as RES2345) or just plain numbers (such as 253180001 or 9817) how can I set the criteria in the query to just give me jobs that start with a number?I first trimmed the field to eliminate blank characters and then I used the Not Like "A - Z" but it still gives me jobs with letters at the beginning of the name.thanks for all your help in advance. :D
View 1 Replies
View Related
Dec 14, 2005
Hello,
I have a button that runs a macro to delete records in 12 tables. I want to create a message box before that macro runs warning that you are deleting records in 12 tables and are your sure you want to run the macro.
I need a message box with an ok and cancel button. Where do I put the msgbox funtion in this code?
Thanks !!
This is my code:
Private Sub cmdRunDeleteMacro_Click()
On Error GoTo Err_cmdRunDeleteMacro_Click
Dim stDocName As String
stDocName = "mcrSemesterStartRecordDELETE"
DoCmd.RunMacro stDocName
Exit_cmdRunDeleteMacro_Click:
Exit Sub
Err_cmdRunDeleteMacro_Click:
MsgBox Err.Description
Resume Exit_cmdRunDeleteMacro_Click
End Sub
View 5 Replies
View Related
