Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

Hello, I've been working on a form for weeks. Things were going well until testers were involved. Well, all my buttons seem to be working fine, however when you press the up/down/left/right arrow keys, then my form starts to jump to different pages and I seem to loose my cursor. Anyway, I...

Hello, I have a question that's been bugging me for some time. Ideally I'd like to use a SetFocus while in a Valid method. However, VFP doesn't like that at all. Is there a way around it? I've been trying to set up a form, where I validate my initial field (myfield1). Depending on myfield1...

Hello, Got a grid(myGrid), which shows fields from a table(myTable). One of these fields is a numeric value(myTable.TotalMinutes). What I would like to do, is to convert myTable.TotalMinutes into a HH:MM format, so it will be shown on my Grid as that. Basically, I don't want my Grid to show...