|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 12th, 2006, 03:32 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Using query in form?
I have a table with a lot of columns. I have two columns i want to prepair to
be used in a tablesheet form. One with sizenumber and another with productnumber. I have a datasheet form where I want to use the data from sizenumber and productnumber writen as one ex. "3-345767" (first number is size and the second is productnumber). Well I succesfully done this in a query table but I can't get it to work or sort in the form. Its greyed out. Any suggestion? Can I do this on another way? I gonna get greyhaired of this.. ANY suggestions would be help full! 
|
|
#2
September 12th, 2006, 04:54 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Using query in form?
You had to do the combining of the forms in a Calculated field in your query,
no doubt. The problem is, you can't update a calculated field in a recordset. "JerkerPihl" wrote: I have a table with a lot of columns. I have two columns i want to prepair to be used in a tablesheet form. One with sizenumber and another with productnumber. I have a datasheet form where I want to use the data from sizenumber and productnumber writen as one ex. "3-345767" (first number is size and the second is productnumber). Well I succesfully done this in a query table but I can't get it to work or sort in the form. Its greyed out. Any suggestion? Can I do this on another way? I gonna get greyhaired of this.. ANY suggestions would be help full!
|
|
#3
September 12th, 2006, 04:59 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Using query in form?
Well that is not a problem. It just for viewing the products.
"Klatuu" wrote: You had to do the combining of the forms in a Calculated field in your query, no doubt. The problem is, you can't update a calculated field in a recordset. "JerkerPihl" wrote: I have a table with a lot of columns. I have two columns i want to prepair to be used in a tablesheet form. One with sizenumber and another with productnumber. I have a datasheet form where I want to use the data from sizenumber and productnumber writen as one ex. "3-345767" (first number is size and the second is productnumber). Well I succesfully done this in a query table but I can't get it to work or sort in the form. Its greyed out. Any suggestion? Can I do this on another way? I gonna get greyhaired of this.. ANY suggestions would be help full!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
