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 dencom 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: *

  1. drbtodd1971

    How do I get rid of this?

    I have 71 problems in Malwarebytes which it removes and then keep coming back. If I remove and boot in safe mode they aren't present but boot in normal mode they come back. I suspect they are hiding somewhere the anit virus and anti malware can't find them. Spybot finds the Haxdor trojan and...
  2. drbtodd1971

    Acer Aspire 1703sc Laptop won't switch on.

    I recently purchased an Acer Aspire 1703sc laptop second hand. It has worked for a few weeks with no major problems but now won't turn on. I have opened it up and if I remove and replace the battery I get some led's to light up green on the motherboard. If I press the power button without the...
  3. drbtodd1971

    Outlook 2007 Prints Truncating

    We have just moved over to Outlook 2007 and a few users are getting the email text truncated when they print or do a print preview. It is only happening on a few machines. Have checked the IE7 margins and they were fine. Changing the margins in Outlook had an effect but there is still...
  4. drbtodd1971

    In Outlook 2007 users get margins truncated

    We have just moved over to Outlook 2007 and a few users are getting the email text truncated when they print or do a print preview. It is only happening on a few machines. Have checked the IE7 margins and they were fine. Changing the margins in Outlook had an effect but there is still...
  5. drbtodd1971

    Checkboxes on Databound fields only working once then locking

    I have a 2003 sql server database which I'm pulling back data into Access, all is working fine except for the checkboxes, I'm binding all the fields. When I click on a checkbox it will check but then when you try to uncheck it nothing happens. If I make the checkbox unbound it works fine. Am I...
  6. drbtodd1971

    Loading files with a D00 file extension into access

    I'm writing a database which pulls in data from another third party sql server database. All works fine except for one thing, I have picture files which are saved as DIB (Device Independant Bitmap) but have the file extension D00. They are actually Jpegs but are saved as D00 files to save space...
  7. drbtodd1971

    Different Formats for Postcode field

    Hi, I've been given a spec for a new database and the Postcode field (Equivalent of Zip code in America) has to be a text string of 8 ascii characters which could be in any of the following formats: L = Letter N = Numeric LN NLL LNN NLL LLN NLL LLNN NLL LLNL NLL There must be a space in front...
  8. drbtodd1971

    Concatenating Addresses

    Hi, I've got three tables and have written the following code which brings back the data I require. However some people have more than one plot number so I need a way to create a tempoary table with the person details and all their plot details concatenated into one field with a carriage return...
  9. drbtodd1971

    Combining Records in Access to Word Mail Merge

    Hi, I'm trying to create a Word mail merge based on Access Data which will produce letters. The letters need to display the personal details and then any houses the person has which can range from 1 to any number. The data is sorted on PersonID from three tables. tblPerson - Main Key is...
  10. drbtodd1971

    I'm trying to append the date to the filename of the worksheet

    I have the following code and keep getting errors because it appears to be defaulting to the default date setting which includes slashes. How can I append the date without the slashes, I've tried formatting it in various ways but with no luck. Dim dtMyDate As Date dtMyDate = Format(Date...
  11. drbtodd1971

    Converting True False values to Yes / No on report

    I have several reports where the Has claim been settled field is set to either true or false, I would like to be able to display this as Yes or No on the report. How can this be achieved, if at all? I also have a problem with dates which are being stored in two variables @startdate and @enddate...
  12. drbtodd1971

    Trying to stop overflow error in function

    I've written a function I want to return a total and I'm getting a runtime error 6 overflow when I access it. I know this is because a field is too big or of the wrong type but I can't seem to identify where it is overflowing. Function code is as follows: Public Function...

Part and Inventory Search

Back
Top