Hello Adezii,
I tested it and it still updates all fields in the from. No big deal though....
deewe
Last Activity: Jun 25 '09, 09:36 PM
Joined: Jun 9 '09
Location:
-
Thanks for the highlight!
I guess it's the same for the Requery Method then....Leave a comment:
-
Found the solution, posting it if it can help others:
So I finally made an unlinked ItemMats table with the following fields:
[ItemID] [MatsID] [Quantity]
- [ItemID] is a combo box that gets its data from the TableItem table
- [MatsID] is a combo box that gets its data from the TableMaterials table
- [Quantity] is filled in by the user.
In the main Form used to fill in the TableItem table I added a subform...Leave a comment:
-
Design Q?
Hello again,
I'm stuck at a design issue, I don't know by witch side to grab it...
I have the following scenario- TableItem populated with unique items Item
- TableMaterials populated with unique materials Mats
Each Item can be tied to 1-n Mats and each Mats can be bound to 1-n Item.
I would have used fields with multiples values but later on I need to add a specific Mats quantities to... -
How to update only one field in a form? (DLookup / recalc / requery)
Hello,
On an LostFocus event I'm trying to update another field that is tied to a DLookUp query.
I'm able to update all the form fields but I don't find a way to update only one field.
The below tests update all the fields
...Code:- Me.Recalc - Me.Controls("Txtbox_RatioDev2").Recalc - Me.Requery - Me!Txtbox_RatioDev2.Requery - Forms("Description").Controls("Txtbox_RatioDev2").Requery -
Thanks a lot ChipR, it worked like a charm.
I have to admit before posting I spent over 3 hours trying to make this working
No big deal, your help is very much appreciated, I'm the one that needs to learn all the language tied to Access.
Ok so I get that I'll have to make the query then run the report.
I guess I'll have to use some VBA as there will be a few parameters...Leave a comment:
-
Thanks NeoPa.
I have to admit I read your post more than 3 times to understand it, sorry for being a noobie ;)
I'd like to avoid making a query and have the system automatically calculate the field in the form. As if I update any price (or currency ratio) I don't want to have to re-run the query. (Maybe I'm wrong though)
Am I obliged to link the tables, even with an outer join?
Maybe...Leave a comment:
-
Back again ;)
I have some issue I can't solve with calculated fields.
I have a table with 1 row only and constants that would be updated by the user from time to time. For example currency conversion ratio from US $ to Euros .
In my main data table I store the price of items in US $.
As you can guess, in a form I'd like to display the price in US $ (easy) and the calculated price in Euros....Leave a comment:
-
Once again thanks NeoPa but I"m still learning the basics for now, like how to get data from 2 different linked tables make a form with tabs and have the joint table field 1 in tab 1 and show the relative field 2 data in tab 2.
Then I have to find how make it so when someone enters something that isn't in the list allow them to add an entry in the related table and even better open a new form to fill all the fields.
...Leave a comment:
-
Thanks NeoPa,
I'm not as far in my access knowledge yet but I'll surely try to understand your code later when I'm ready!Leave a comment:
-
Thanks a lot for your inputs!
Now I have to find how to detect edit mode and change the background color;)...Leave a comment:
-
Surprisingly it worked, thanks.
Although I don't understand why I wasn't able to move directly the controls on the tab pages without having to copy paste them first.
On a side note I'm learning the hard way: try & errors... I just discovered even if your tables are well linked you still need to make queries to get the data in the forms. ;)
Q?:
- I have a table with items and one with...Leave a comment:
-
Honestly you lost me... thanks for trying though!...Leave a comment:
-
Thanks a lot to hjozinovic, DonRayner and NeoPa.
I used the form footer trick as I was still able to scroll down the form with the mouse wheel even having disabled the scroll bars.
I'm getting stuck on other things now ;) but I'm going to mess with them and see if I can do it by myself.
I wish it was possible but is seems you can't directly add fields into tabbed control field.
...Leave a comment:
-
Can't set a form size... feel dumb :(
Hello,
I'm unable to resize the visible part of a form only to display what I want to show. (upper left)
Here what I did:
- I made a form with a tab control that has 3 pages
- Added all fields I needed below the "tab page"
- Copy/pasted each fields in each appropriate "tab page"
=> The tabbing control works and display the pages, but I can still scroll down the...
No activity results to display
Leave a comment: