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

    Automatic a Data Import routine in Excel

    Hello, I have a data import routine that I have to do manually every day, converting a CSV file into Excel. Is there any way, I can automate the process? Your help will be much appreciate it. Regards
  2. safarijoe2000

    Returning the day of the week

    Hello, I was wondering if you could tell me how to return the day of the week on an Excel 97 spreadsheet. For example I have a column with the actual dates for the next few months, as in: 30/06/05 01/07/05 ...........etc I would like to see something like this: Thursday 30/06 Friday 01/07...
  3. safarijoe2000

    Exchange 5.5 slow sending and recieving emails!

    Hi all - Hope you can help! Our exchange server seems to be taking quite a long time for it to send emails to the outside world. Infact, one email took a few hours to the reach the recipient. Also it seems to be taking a similar amount of time for emails to arrive back to us. Emails sent within...
  4. safarijoe2000

    Changing users permisions to access a mailbox?!?!?

    Hi All I have just setup a new PC on our network here, and we are trying to access an email account which is also being used by another user! Whenever I try to access the mailbox, it comes up with the error - "You do not have permission to logon, unable to open the mailbox." Is there a setting...
  5. safarijoe2000

    blocking internet access

    Cheers Smah! That was much appreciated. Damien
  6. safarijoe2000

    blocking internet access

    I am from England and I am setting up an internet cafe type system for the company that I am working for. However, my company only wants this system to access its own website. I have tried downloading some parental control software, but obviously I am not able to block everything. Does anyone...
  7. safarijoe2000

    Email a report in VFP ?

    Hello, I'd like to know if there's anyway to Email a report in VFP. I have an application that produces a report, however it will be incredibly useful to actually Email this report. I was wondering if there are any features that will allow me to create some type of button that will bring up...
  8. safarijoe2000

    Setfocus on a Valid procedure

    Hello, I know I can't have a "setfocus" statement on a Valid procedure, but is there an alternative ? What else can I use to redirect my cursor to other parts of my form. Any help would be great. Thanks
  9. safarijoe2000

    Background on a grid

    Mike, Thanks for the info. Could I make my grid "see-through" instead ? So, I could actually have a layer underneath the grid, where I could actually add my background. Thanks
  10. safarijoe2000

    Background on a grid

    Hello, I was wondering if it's possible to have a background on a grid. Any help will be great. Thanks
  11. safarijoe2000

    Problem printing landscape

    Hello, I am printing a report which originally was designed to print in portrait (by default). However, I have increased the number of columns so now I would like to print landscape. The question is: Is there any way I can control the Printer setting from my form/report ? Rather than...
  12. safarijoe2000

    Comparing a table against a spreadsheet !

    Hello, I have a table (mytable.dbf) and I have an Excel spreadsheet (mysheet.xls). What I'd to do is to be able to exclude those records from the mytable.dbf that are present on mysheet.xls Say, mytable.dbf has field (fieldA), and the mysheet.xls has also a field (fieldA). I'd like to...
  13. safarijoe2000

    Question on REPLACE

    Hello, This is a simple one. In a table I have a column (columnA) where my data shows some "unwanted" characters. I would like to replace all these characters with some others. For example, I have on columnA some fields with the name: O'Connor, which I would like to change to...
  14. safarijoe2000

    Converting date format question

    Hello, I have a field (field1) in the format dd/mm/ccyy. I need to somehow convert this field into a month/ccyy format. For example: 01/08/2003 should be August 2003, 01/02/2002 should be February 2002. Any help will be greatly appreciate it. Thanks
  15. safarijoe2000

    Increment values within cells in Excel

    They both worked nicely ! Thank you.
  16. safarijoe2000

    Increment values within cells in Excel

    Hello, I'm sure this is an old question, but I need a bit of help. Basically, I have a value (Bin Number) that increases by one, both numerically and alphabetically. For example: Cell A1 = R1LA01 Cell A2 = R1LA02 .... and so on through to R1LA40 After that on: Cell A41 = R1LB01 Cell A42 =...
  17. safarijoe2000

    Printing problem

    Hi, I have a problem generating a report using C.R. 8.5. Basically, I have lines of data displaying, a product code, its description, its sizes (which can be up to 19, but varies upon each product), and some numeric fields (prices and so on). The problem resides in the fact that when I try to...
  18. safarijoe2000

    Setting max screen size

    Hello, I figure this one is an easy one. I'd like to know how can I control the max screen size. Is there a way to whenever I start up an application or open up a page ? So these will automatically open up to the maximum screen size. Thanks once again for any help.
  19. safarijoe2000

    Changing font size on Menu

    Hello, I would like to know if there is a way to change the font size on a Menu bar. I am adapting an existing VFP system to become a touch-screen system. The only problem is that the font size on any of the Menu bar, are too small to actually properly selected using a touch-screen. For...
  20. safarijoe2000

    Problem generating EXE

    Hello All, Got a quick question: I have made changes to an existing project (forms and menus), and when it comes time to build my EXE, I get an error "CANNOT UPDATE THE CURSOR". It doesn't provide any extra information. Providing that I have several cursor throughout the project...

Part and Inventory Search

Back
Top