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

    Remote Server does not exist or is unavailable

    Hi, I am connecting to an application from a Windows 2000 terminal server but occasionally get the message 'Remote Server does not exist or is unavailable'. The application is SQL based and installed on a Windows 2003 SBS server. It uses COM+. Has anybody seen this before and could point me...
  2. Hargreavesk

    report not displaying local currency symbol.

    Hi Can anyone help. I have a crystal 8.5 report which shows $ and € symbols but doesn't show the £ symbol on it. The £ is my local currency. Am I missing anything Many thanks
  3. Hargreavesk

    printer server and local printers

    Dear All, I have a print server setup but when trying to connect to the printer, windows wants me to create the printer locally. Is there a way around this? Thanks
  4. Hargreavesk

    Network printer showing as 'missing' from one application

    Dear All, When I logon to my citrix session and try to print to a networked printer it is shown as 'Missing'. Unfortunately, this is only happening from one application. The application picks the printer from the print server and has a path of \\printserver\printer. The printer does not...
  5. Hargreavesk

    Can't export to pdf from crystal unless administrator

    Dear All, I am running a third party program that allows me to email a crystal report in pdf format. However, unless I'm logged on as 'Administrator', I keep getting the error message 'Missing or out-of-date export dll'. I've re-registered exportmodeller.dll and crtslv.dll and everything...
  6. Hargreavesk

    Can't see files under C:\Temp

    Can anyone help??? I am unable to see any files in C:\temp under Windows Explorer. However, when I go to a Dos prompt, the files are viewable. This is disrupting a number of macros and I wondered if anyone had come across this before. Any help would be appreciated. Thanks in advance. Kate
  7. Hargreavesk

    IE 5.5 crashes when opening PDF files

    Does anyone know why it would do this? It will open some but not others. I have checked the size of the files but they are not really big. The error is a memory error but I have 384mb in the PC. Is there anything else I may be missing? Any help would be appreciated. Thanks Kate
  8. Hargreavesk

    Disable spellchecking/F7

    Is there a way to disable spellchecking or the key F7 in Access? I have used the KeyDown procedure with KeyCode = 0 however whilst this does disable F7, it also disables Tab which I don't want. Is there a way of getting around this? Thanks Kate
  9. Hargreavesk

    disabling Esc key

    Hi, I would like to disable the "Esc" key from a form. I have set Key Preview to "yes" and put in Keycode = 0 on the "Key Up" event. However, "Esc" still works!!! Is there any other way I can stop it? Regards Kate
  10. Hargreavesk

    stop text wrapping at last space

    Does anyone know how I can stop my text wrapping at the last space? My text box is setup to "Can Grow" but and I am padding it out with asterisks. Unfortunately, it's wrapping at the last space regardless of whether it needs to or not. Is there any character that will replace a...
  11. Hargreavesk

    Chr(34) problems

    I'm trying to use Chr(34) as a line break within a text field. Unfortunately, it doesn't seem to be working and the text is continuing. Can anyone shed any light on this? Regards Kate
  12. Hargreavesk

    Character similar to space

    Hi, Can anyone tell me if there is a character which is similar to a space but isn't a space???? I know this may sound weird. Any help would be appreciated. Regards Kate
  13. Hargreavesk

    text wrapping

    Hi, I have a function which fills my text boxes with asterisks based on the amount of text I put in them. When I put in the following "JoeBloggs" it then fills the text box like this: JoeBloggs***************************** ************************************** However, when I put...
  14. Hargreavesk

    decimal point problem

    Can anyone help? I have a currency field called "Amount". I would like to convert the decimal point in this field to a hyphen in a field called "Amount1". My data is this £136.00 but I would like it to look like this 136-00. I am using a replace function with the...
  15. Hargreavesk

    Filling text boxes with asterisks

    Hi, I have a number of text boxes on a form. When I put in my data and print them out, I would like the rest of the text box to be filled with asterisks on my print out. I have tried to add this within my query as "*******" however, the text is wrapping and I don't know how to...
  16. Hargreavesk

    Replace character within a Query

    Hi, Can anyone help? I have a query that brings me details of a cheque from a form I have just completed. The cheque amount is in this format £00.00 or £000,000.00. This is ok as it's a currency field. However, when the data is in the query I would like the data to look like this 00-00 or...
  17. Hargreavesk

    Validation - No less than 4 characters

    Hi, I have been looking through the validation areas but have not come across anything that can help me. I have a name field on a form which should not be any less that 4 characters long. The field will include alpha and numeric characters as well as spaces. I don't want to limit the...
  18. Hargreavesk

    InStr

    Hi, I have a cheque which converts it's amount from £513.00 to "Five Hundred Thirteen Pounds". I then use the following code: FullAmount = Me.Amount_in_Words Position = InStr(FullAmount, "Hundred") + Len("Hundred") LeftAmount = Left(FullAmount, Position)...
  19. Hargreavesk

    InStr Query

    Hi, I have a cheque which converts it's amount from £513.00 to "Five Hundred Thirteen Pounds". I then use the following code: FullAmount = Me.Amount_in_Words Position = InStr(FullAmount, "Hundred") + Len("Hundred") LeftAmount = Left(FullAmount, Position)...
  20. Hargreavesk

    finding a word in a string and adding "and" to the right of it.

    Can anyone help? My database converts an amount to words i.e £513.32 becomes "Five Hundred Thirteen Pounds and 32 pence". Unfortunately, I need to have an "and" between the Hundred and the Thirteen but cannot figure out how to do this. I have tried the Left and Right...

Part and Inventory Search

Back
Top