Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kerplunkitt
  • Order by date
  1. kerplunkitt

    Is it possible to save image scans into an access database?

    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
  2. kerplunkitt

    Adding up Durations(1.15 as 1h15m)

    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...
  3. kerplunkitt

    Access is changing my data upon entry!

    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...
  4. kerplunkitt

    Click event to open a specific record

    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...
  5. kerplunkitt

    Combo Boxes and Subforms

    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...
  6. kerplunkitt

    Access - Relationships/Parameter Values

    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...
  7. kerplunkitt

    Sales report details

    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...
  8. kerplunkitt

    calculating all records

    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]...
  9. kerplunkitt

    easy question

    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...
  10. kerplunkitt

    easy question

    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...
  11. kerplunkitt

    Can not enter data into field on form, help please

    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
  12. kerplunkitt

    Hardware monitoring

    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...

Part and Inventory Search

Back
Top