Hello All, I was wondering when you use a find command, if you can make it so it searches two tables from the form your currently viewing, not just the data from the table that is tied to that current form.
Second question is I am thinking about maybe taking some "1 day" classes on access. My question is how many people have taken these & are they worth the money, or is it easier just to buy a book & if buying a book is better what is a good access book to buy.
I am new to Access and have just designed a new database and was wondering if anyone could help with a few questions.
1/ I am setting up a Macro to send an e-mail on the change of a form. When the e-mail is generated by Access I get a message from Outlook stating that "A program is trying to automatically send e-mail..." and asks you to confirm that it is ok to go. Is there any way to bypass this check or alternatively send the e-mail from a specific e-mail address rather than the database user.
2/ I have changed the background colours on a number of my forms but the Record Selector's and Scroll Bar stay the standard Access Grey. Is there anyway to change these?
3/ I have used the User Security Wizard to setup users, groups and access but I can't seem to see a way to limit the number of simulateous logins a person can have i.e. I can log in more than once with the same user when I only want to be able to login once. Any ideas?
I'm currently stuck with 2 issues with my database.
1) I have Team (TeamID), Player (PlayerID, CurrentTeamID) & Transfer (TransferID, PlayerID, PrevTeamID, NewTeamID) tables. I got this addTransferRecord form to add transfer records. The Player table has a currentTeamID attribute which is a foreign of TeamID from Team table.
What I'm trying to do is when adding a transfer record via a form and after selecting a particular player from the combobox, I want the prevTeamID combobox.Value to automatically reflect his currentTeamID. Next, after choosing his newTeamID from the combobox, I want the value to be stored in his currentTeamID.
*CurrentTeamID, PrevTeamID & NewTeamID are foreign keys of TeamID
2) I have this LeagueStandings (TeamID, Wins, Losses) table. I've added an expression into the query to calculate the PCT (those basketball fans would know what i mean :) ). The thing is I've been trying to find a way to sort the position and assign rankings to each team where PCT is descending.
Hello everyone, im new here and i have some basic access knowledge, little knowledge about VB. Im looking to create a access database using access 2000 -- I know what I need and how to create most of it, however, I do not know how to do a few things, input for improvement or recommendations are more than welcome... Heres the design
Im doing a fairly simple inventory control database, it will have about 8-10 fields: FAX# (date) DATE (date) NAME (text) EMP# (number) UNIT (text) SIZE (text) (this is static and will be combo box drop down) GENDER (text) (same as size) POSITION (text) (same as size) SENT (date) AMOUNT (number) RECEIVED (number) PO# (text)
I need all of that in a form, which I can do, what i also will need on the form is the current amount which be determined by RECEIVED - AMOUNT, which I need to some how show up on the form (this i dont know how to accomplish) ive been trying to put a formula into a text box like =SUM([RECEIVED]-[AMOUNT]) ... it works okay, unless i copy from excel to the table which the form uses, then it doesnt see the items i copied into the table, only the items that were typed in using the form. I also I need to put like a box below the text boxes which will display a query (which i dont know how to do) -- this box will display a query (ie. if i wanted to filter out all , and only see SIZE = xl GENDER = male and then the box will show up in 'table' form all the people who meet that requirement.)
First, if I have a table, and I want to combine two records together, how would I accomplish this? For example, say I have the following table.
NAME SALES Bill 2000 Jim 500 Ted 1000
And by some miracle of science, Bill and Jim are able to fuse together to become Jill, combining their sales together. So the new table would look ilke this.
NAME SALES Jill 2500 Ted 1000
My second question is, say I have an extended list of the same table with 30 names and corresponding sales. However, I want to find out Ted's percentage of sales of the TOP 15, not all 30. How can I accomplish this?
Thanks so much in advance for helping out a complete newbie. :)
In the right hand portion of my dialog I use a subform to display key words for the code. Is there a way to turn off the column and row headers for the form? Also is there a way to have a transparent background for the subform?
In order to add key words I need to open up another form, enter the words there, close that form and then select them from this dialog. It would be nice to be able to add keywords from this form. FYI, there is a many to many relationship between the key words and the code.
Is there a way to show just my dialog when the database is opened and not the rest of the Access application space? I have unchecked everything in the startup options already.
The last thing is I would love to be able to format the code section so that certain pieces of text are formatted. I am going to start messing around with the some of the free rich text controls but is there an out of the box solution that can handle this task? I was thinking about formatting the code in html and then displaying the html. Is this possible from within Access?
Hi all, I've played a bit with MS Access 2003 the last week. I've made a form wich should contain information about stores (phone numbers, locations e.g.).
I'm trying to imagine myself (what could be a real) scenario, that way it's easier to give myself practice and tasks :)
As I'm new to MS Access, I'd like you to take a look at my forms. I want to know if there's better ways to do what I have done, and if I have done something wrong.
I also got a couple of questions; Lets say I want to print one post by clicking on a button, is that hard to implement? Is it possible to make a button, which exports the form to an .xls -file by clicking on it? I did make these forms on a computer that had the resolution to 1280/1024, when I tried to open the form on a computer with 1024/768 resolution, the forms won't be displayed in the center of the screen :confused:
I think that's all.. Thanks! :)
Here's the access -file (http://www.home.no/f00b/stores.rar) (180kB) (use winrar to extract it) I've tried to transalate to forms into english, sorry for the bad english :o
I have a find command button that appears to call the find and replace message box. It should be a search for anything in my query. The code behind the button looks like the find and replace message box in the office suite. I believe I am trying to create a message box where you add an entry and it searches then lauches a subform with my entries.
When I checked the button it had the following code: Private Sub cmdFind_Click() On Error GoTo Err_cmdFind_Click
I read a few of the lookup queries but they only give me a drop down. Is there some way to customize the box comes up without altering all of Office or do I just sound lost.
I know you can create a find record command button really simply, which when clicked will display the find and replace window.
What i want to do is create a command button that will search a specific field that i specify in a report for the criteria i enter.
i.e i have a customer information form, which contains
AccountNo CompanyName Address Postcode Tel etc
what i want is a button that when clicked brings up an input field that allows the user to type the name of the company into this field, then when either the enter key is pressed or another button on this pop up window the matching record will be displayed or a error window stating that there are no matching records. Can anyone help me with this.
Is there a way to use the find command in access in one report to search throughout the whole database. For instance, I am designing a database that in a report it shows the number identifier of an item, and the actual detailed information is located in a separate form. What I want it to do is to be able to find the detailed information from a command within the report that only has the number identifier.
I created a form from a query that before loading all the controls asks for the Item ID (parameter). This form has two subforms that depend on another two queries; since I want them to show the info for the same item, all three ask for the Item ID, which can be kind of annnoying and does not look too professional. Is there a way I can get rid of two of the pop-ups and still have the three forms display the info of the same item?
And my second question: After the Item ID is entered 3 times, all the info is displayed on the forms. But, if I click the arrow on the bottom of the form (to supposedly go to the next time...but it should not be possible to do this), a "Enter parameter value" window pops-up (one just like the Item id one), and I have no clue where it came from. I cannot find it in the code; and I really want to get rid of it. I could use all the help I can get.
I'm building a db to catalogue my prints collection. I'd like to group them in categories. With the examples I found on this site I've been able to include cascading comboboxes in a form and they cascade beautifully (3 categories: maincategory, Subcat1 and Subcat2). Problem is though, I cannot get them to work in combination with a unique record! I have tried all sorts of combinations to link the cascading boxes to the print but they either don't change at all, or my qry returns 0 records. I must be doing something simple wrong but I'm not very experienced and just don't see the solution. I've spent all evening so far and I think it's time for some help.
I've got these tables (there are more tables and fields, but these are the main ones)
Tbl_prints PrintID PrintTitle
Tbl_Category CategoryID Category
Tbl_SubCat1 SubCatID SubCat1
TblSubCat2 SubCat2ID SubCat2 PrintID
The tables are linked by the printIDs.
Now, when I fill in the details for print #1 and then advance 1 record to print #2, (or #3 etc) the comboboxes don't follow.
Right so I have a database which is split. I have two values which are universal and only change occasionally so I don't want them in a table against every record in the database. I have currently set them up as globals in a module I want to set it up so I can draw the values in from the backend database rather than having to edit every single copy of the front end each time.
Debugging my VBA code. I'm trying to track/display the content/value of a couple of variables to make sure they have the right value at a certain point.
What is the VBA code to say "display content of variable Var1" ? Where exactly will it display the value when instruction is executed?
I know I can just hover the mouse on a variable to see its content but some string varables like SELECT commands are too long and you cannot see the whole string.
On mij registration form I have the option to fill in the name and day of birth, email and GSM number of the partner off the main contact.
But to keep the form nice and clear, I only want to make the fields acceseble when the checkbox from [couple] is checkt OK.
How to make the fields and the Box around it Light Gray, so its very clear it issn't clickable.
The main coller is white BG and Green strokes. (see attachment) When the field [paar] 1 (couple in englisch) is OK then the fields in de eclips 2 are available And I want the collors of the stroke 25% black and de fields disabled.
I need to update a table at a client's site to change a couple of fields, and would like to be able to send them something that they can run on their end to perform an insert query.
I cant update the tables via RDP etc. because the database needs to be in Access '97 format, and they all run access 2003.
I also cannot get them to send me the file for updates since it needs to be online basically 24/7.
I would like to enter a couple of alphanumeric groups into a field on an input form. After I enter an alphanumeric group, I hit the enter and the data will add into the field and refresh to empty box ready for next entry. If I continue to enter another group and hit enter, the next group will be added to original field with a comma and a space in between. build the VBA in after update event to accomplish the task.
I have a couple forms with Combo boxes that look up data in queries. I noticed in testing that I could accidently type a "~" (and other characters) in the field and once I do, it causes a runtime error that shuts down the entire app (as opposed to letting the user backspace out of it or resetting the field). Before I put in some "Before Update" code to prevent the system from crashing, I want to make sure I am on the right track. I have already set the combo box to just show the list, not allow edits, limit to list, etc. Is there a way to prevent the user from doing this either by preventing the keyboard from working on combo boxes (not preferred) or by trapping it before the system crashes? I would think I could validate with a recordset, and create my own path out for the user, but I was hoping the combo box would have sort of done that work for me.
I am rewriting an old Access 2003 database in Access 2010. When creating new command buttons, the current theme gives them a default appearance. I need to apply this appearance to old command buttons. I know there is a way to select the default button and apply its properties to others quickly. I have done it before but didn't write the process down .
1) There are some databases here at work that I can open in BOTH A97 and A2K. I thought A2K won't open in A97, and before you can open an A97 in A2K, you have to convert? At least that's been my experience thus far. Any idea what is happening and how I can determine which version these databases are currently in?
2) With those same databases...assuming some were A97, the option to Convert them under Database Utilities is greyed out. Is this most likely a rights issue? Could it be anything else?
Recently I created a database using MS Access for the company and I am the Admin for it. The database is in the share folder and many employees are using it but if I want to take backup or modify any thing a message is appearing saying that one user open the database.
Is there any method to know which user is opening the database and in which PC (workstation) it is open. --------------------------------------
Is there any way of adding export fuction to the toolbar using modules or macro
Is it possible to have a table of 10 random questions and an inital form created with those questions in the form of checkboxes. When you chose random questions from that pool of questions a new brand form and table have the option to be created.
Basically, I have many external databases to research and some of the questions are the same in each database. Each database must be saved as individual tables and forms.
I have few questions so please bare with me 1- i want the text box to change automatically according to date so i tried this: if date>text14.text then text30.text=sea else text30.text=port but nothing happens 2-i made a form but not all the data rows in the table are in the form(there`s still some rows) so if i delete a data that are in the form how i can automatically delete the data that are in the other row ?
3-this may sound stupid..but is there a way to stop the access logo from apearing when loading the database?and how to make access directly open a specified form?
I am designing a database and have a couple of questions.
I have designed a form that I have opening at startup. How do I force this to maximize on opening?
I have set up a report based on a query. It works fine. The query requires a parameter to be entered when it is run. The parameter comes from a list (of teachers in my school). How do I set up the query so that the 'Enter Parameter' dialog box provides a drop down list of teachers from which the user selects their name?
