Hi there.
Don't think it can do it direct - but you can attach files as bitmaps by scanning them first and then linking or embedding them as OLE objects.
Linking is better though unless you have a terrabyte hard drive handy..!
Hope this helps
Regards
'viper
Hi there
i have done exactly this for a friend and it works fine..
i created 4 text boxes - one called minutesworked and one called hoursworked, which show the hours and minutes, the other two are calles timestart and timeend - into which the user enters the start and finish times.
Make sure the...
Hi Ken
Change the field Data type to Number.
Then change the field size to Decimal.
Then set the scale to 6.
Make sure the decimal places is still at 5.
Then it will work..
If you have a form then you can set the text box of the form to display in currency if you wish.
Hope this helps
Regards...
I have done this in my database - what i did is search for a customer by name and then when i clicked the name field it opened the customer form and jumped straight to the customer record... This can be used with a command button too:
Here is the code i used - note the "customerID" is my Primary...
Sounds like you need to create a query and then base your combo box on the query.
In the query itself you need to specify in the criteria, the form name and the header field, so when you get to the vendor name and then click on the combo box, the underlying query looks at the vendor name and...
OK, Let me see if i have this correct:
You created two tables and related them together?
Then you deleted a table because one didn't recognise the other?
(If this is the case how did you create the relationship to start with?)
Then you recreated the table again?
Have you created a relationship...
hi there - i think i might have done something similar, but i don't quite fully understand what you are trying to do.. It sounds like you may need to change this into a make table query and then run another query on the newly created table to get the sub figures - it's only a guess as i cannot...
I don't quite understand the calculation method regarding Duration and the time.
However if you have a formula that works then yes you can use an update query.
The cost field would have something like the following typed into the 'Update to' box:
[Price]![Cost]=[Price]![Duration]*[Price]![Time]...
I have done a simple update query that updates table 2 with the contents of table 1.
Just paste this SQL statement into a test query to see how it is setup. To do this you will need to select SQL under the 'view' tab and then paste this in. Then you can change the view back to design view as...
Have i got this right?
You want the second table - with no numbers in it, to have the same numbers in it as the first?
If this is the case then use an Update query.
If you need a 'how to' for this then let me know - i know how hard i found access first but it gets better.I will not explain how...
Hi There.
it could be that the field is unbound and the font colour is white? - this could explain why you type and you cannot see anything and nothing is being entered into the table..
Just a thought
Regards
'viper
Hi there,
your Athlon 900 - i assume it's a socket A and not a Slot A?
It might be that the temperature sensor is not making contact with the underside of the processor..
Lift off the chip and if there is a small probe on the motherboard underneath, just lift it up a bit so it has a better...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.