I'm trying to create a database that deals with both Pounds and Euros currencies. On the form there is a field that enables the user to choose whether they want, for that particular record, to enter the information in Pounds or Euros. I was hoping to use that field's value then to change the format of each subsequent currency field in the record. For instance, if the user chose '£', then the Cost field would store £500 and the Invoice field would store £500, rather than €500. However, I am uncertain how to do this. Changing the format of a field causes the format of all records to change, which I obviously do not want. Any ideas?
What is the best solution to deal with different currencies in an Access Application? After creating a table that includes currencies codes I want to use them in the form to present and calculate prices. After choosing the currency from a combobox, the price field must be presented in numeric values with the chosen currency code.
I have 3 fields in my db, valueUSD, ValueOther, Currency. Obviously, valueUSD will always be shown in the US Dollar format $#,###.## however, I want to create VBA code so that when the user selects a specific currency (i.e. GBP or EUR), the number in ValueOther is formatted using the correct currency symbol.
I just recieved a call from a customer who is having trouble with a database that I did not create for her.
She says that she modified a form in design view and saved it. Now when the database is opened using he shift key, the changes show on the form in form view. She says if she opens the database normally (without the shift key) the changes do not show on the form.
This does not make sense to me. Can anyone give me a clue as to what might be going on?
We use a device called a site master to test frequency levels across a system. This device stores plots onto graphs which are then downloaded onto an Access (95) database. When the plots are captured before they are put into the database they are time and date stamped among other things. When I open the Database in access I can go into the fields and physically change each of the dates. Yet when I use the site master software to open the database the Time and Date stamp appear at the bottom as the original values and not the changed values that I have assigned. Also when you right click the plots table and go to the properties. The created and modified dates have stayed as the originals. What I would like to be able to do is adjust this date. And what I would like to know is this possible??? Is it like a Windows File 'System' that is giving this date or is it a function in Access that can be changed?
I'm pulling my hair off with this situation. I have an excel file that was given to us by the payroll department of our company, but my manager doesn't like the layout in which was given to us. I've attached a sample of the file, the file has two sheets the first one is how the original file looks like and the second sheet "final look" is how my manager want the file to look.The original file is pretty big, it's for 33 different employees and it contains 93,500 rows. I think it will take forever to do this manually, any ideas would be really appreciated.
firstly thanks to all the guys here without whose help, I would not have been able to finish my database. However, there remains one question to which I havent found a satisfactory answer. I have checked through all the threads here.
I have made an .mde for my application and I want to customize my application icon to my company icon. The DB by default shows the access icon which I would like to change.
The threads here deal with issues of changing the desktop shortcut icon or changing the icon for forms. These threads do not address the problem I am facing.
I want the icon to be changed from access icon to a customized icon. I am using MS access 97. Any help will be greatly appreciated. If there is a thread which I may have overlooked, plz point me out. Thanks in advance FXP.
There is an Access (2002) database used at our company covering its different tasks; different mdb files are used for different tasks (storage, invoicing etc.). All of them are linked to a central file that holds the tables.
Some of the users use more files; the same colleague uses for example the storage module and the service module.
I'd like to keep it this structured but I'd like to make it easier to change between the files so the user don't have to quit manually from the storage moduel and open a service module, giving his password for the tenth time per a day.
Could you help with an advice how I could do with VB that by clicking on a button the presently used file closes and another preprogrammed one opens. (For closing I'm using DoCmd.Quit but no idea how to open something)
i am doing a computing project using access 2003 and vba. i have designed 2 forms A and B, form A is where a user to logs in to my system (with four main items: username (combo box), password (textbox) and two buttons) and form B is where the user can change their password (with four items: username (username (combo box), new password (textbox) and password verify (textbox) and a button that checks everything and updates the password). Form A has two buttons, one button can log the user into the system after typing in their correct username and password credentials, and the other button gives the option to change their password also after typing in their correct username and password credentials (and the opens up form B for the user to change their password) My question is, when the user presses the button to open up form B, what code could i use (or methods in access) that would set the username field (in form B) the same as in form A automatically without the user having to select it again? All help would be much appreciated
Hi, I'm in the process of making a super simple database (3 - tables). I have run into a problem with two of the tables. The relationship between them is one -> many. Say, I have a record in the (one) table which contains a primary key that is also part of a compound primary key in the (many) table.
Ex:
tblEx1 - (1 side of relationship) red(pk) blue yellow etc...
tblEx2 - (many side of relationship) red(pk) purple(pk) orange etc...
If I create a record in tblEx1 and type in some BS for the "red(pk)" field, and I then go to tblEx2, fill in all the fields, and also type in the same BS for the "red(pk)" field, and come back at a later date, and want to change the value of the "red(pk)" field in both those tables for a certain record, it will not allow me. It doesn't matter which one I go to first. Would I have to delete the relationship everytime to be able to change the value for the "red(pk)" field in either table?
On a related question. In the above example when your doing data entry I'm not sure if I'm doing this right. It seems odd to me that I would have to type in the field for "red(pk)" in both tables, isn't their a way it can automatically figure out to put the same value from the first table into the next one since thier in a relationship.
Sorry if the above is confusing, and stupid. I'm just asking cause I did a whole bunch of records and I have to modify the name of the field which is the primary key, and I don't want to have to delete all the records and re-enter them; that would be a big time waster. Any help is appreciated.
in my assignment, I am told to change my prior query by continuing to display the sum, average, and pledge numbers. what is required, is for me to display these totals by the names of the pledges, not just a grand total. how can I sort the query by name?
Are there any tricks or formats out there that make updating a time easier. I have a date field (Formatted: short time and input mask: 00:00;0;_)
When I put in the original time it does great. When I try to change the time I have to delete the old time, go to another field then come back and put in a new time. If I do anything else it rejects and beeps (annoying) and tells me that I am not using the proper format.
Well, problem I should know how to solve! Or at least be able to find in the "search" But...... niether..... So this should be a simple one... Have a form with a ClientID combo.... If this record is changed I want a warning message before... So I decided to do it as a function then call it on change...
Private Function ChangeClient()
Dim Msg, Style, Title, Response, MyString Dim Cancel As Integer
Msg = "You are about to change the Client for this Project!" & Chr(13) & "Do you want to continue ?" Style = vbYesNo + vbCritical + vbDefaultButton2 Title = "WARNING" Response = MsgBox(Msg, Style, Title) If Response = vbYes Then MyString = "Yes" ElseIf Response = vbNo Then
MyString = "No" Cancel = True Undo End If End Function
Now the problem is.... What event to call this on!?!? It works fine on several events on a current record... BUT... when it is a new record, and you pick the client from the dropdown, it sees a change and runs the function. That clear? I was thinking of running a "If ... Then" statement so if it a new record the function will not be called. Got to be an easier way to simply warn of a field change! Ideas??? Thanks
sddd i need some help. about my problem i cant figure it out how i can change some values in the table by using a form or vb script. the problem goes like this.
"If one of the entry in the table is blank then the script will change it to zero." i wish you could help me guys. thanks!!
I have a table Client-Details,in which i have a record namely "bharti-chennai".this table is associated with aother table "release-details". bharti-chennai has records in relase details.i want to change the name of bharti-chennai to bharti -mumbai ..how to do it.
I'm trying to make the backround color of a text box "prova" (short date value) changing according to the values of other two different text boxes "StartDate" and "EndDate" (both are short date values). I'd like the backround of prova to be blue if its value is between StartDate value and EndDate value. So in the code builder I made this function:
Private Sub prova_AfterUpdate()
If Me.prova.Value > Me.StartDate.Value & Me.prova.Value < Me.EndDate.Value Then
Me.[prova].BackColor = vbBlue
Else Me.[prova].BackColor = vbWhite End If
End Sub
Is that correct? Thank a slot for your help :confused:
I want to know if I change the menu bar in an Access db (such as take out every thing, edit, view, format, tools, etc. except file and exit) would it remain that way in every other db that was opened on that pc?
I want to restrict access to every tool except file, exit on only one pc (a public pc) and I am afraid to mess around with this in the event I screw something up again like I almost did yesterday...Security on that one pc is all I need, because the program needs to be accessible to managers for reports. This pc is in an out of the way place that allows employees to "play around" in it and I am not sure enough about how to secure it any other way. So, I reasoned that if I could restrict ability to roam on that pc then that is all I would need.
I am re-working an old database that 'grew up' the wrong way. It is a medical patient database and has 4 main tables. Primary key of main data table is Medical Record number (MR#), a user entered field (I know...). This links to 3 other tables: Diagnoses (indexed by MR# as well, 1-to-1 relationship with main table), Consults (indexed by a compound key of MR# and date, 1 to many relationship), and Procedures (indexed as well by MR# and date; 1 to many as well).
Here is my plan, and I want to know if I'm going to go about it the right way:
I will first delete the relationships between these tables. I will then give the main table an autonumber field called PatientIndex, and each other table their own autonumber (DiagnosisIndex, ConsultIndex, ProcedureIndex). I will also give each of the other 'daughter' tables a PatientIndex field as well. I will populate the PatientIndex fields of the daughter records with a VBA routine that matches their MR# with the MR# in the main table, and then inserts the corresponding PatientIndex.
Now that each table has no relationships, and has all the right fields, I suspect Access will allow me to change the Keys for each table, and create new relationships, and it should all work cleanly. The goal is to have each table indexed by an autonumber field that is unrelated to user entry, and to link them by the Primary key.
Does this sound like the right approach? As to why do this if it works OK, it's a matter of maintenance. It's simply too buggy as it stands, and it's torturing me. Will my plan work without crashing the db?
I did some BAD planning before I started creating my database and I set a text field ("field1") of a table ("table1") as primary key, then I linked this field to a field in another table ("table2", one-to-many relationship). Now I wan't to change some values in table1 in "field1" defined as primary, but I can't (Access refuses to do so...).
Because I have a lot of data entered allready I would like to know if there is any way for me to change values in "table1"/"field1" and that all the linked fields in other tables ("table2") would change correspondingly??????
I am making a database that requires a list of all the crew people in our company. This list is not sorted by alphabetical order but by order of significance (or frequency of) crew person. This list is rather lengthy and if I add a crew person it can only be added to the bottom of the list. The only way I have been able to do this is by manually resorting and retyping the list. Is there any way to add a row in the middle of a table (like I can in Excel)??