Search results for query: *

I am trying to create a view of a shared free table and keep getting this error: "File access is denied "FILELOCATION\FILENAME Is it not working because the file is shared and currently opened? If so, can I create the view when I can open the table exclusively and then use the view and the...

Thank you all. Olaf's method worked. Question answered.

Hello, I am trying to replicate a program I had used from memory. As I recall I had this issue when I first wrote it. The problem is that I am accessing remote data that has a datetime field and I want only the records for today. So, I used CREATED>date(). But, I get no records. Yes, there is...

Thanks everyone. I am up and running. I realized the problem last night as I was walking out the door. In my many attempts to get this to work I moved the table out of the database and used it as a free table. I later moved it back into the database. The field names truncated and it totally...

Olaf, yes that is what I meant. My bad. Gerrit, thanks for the heads up. I do get the records imported tot able to display in a grid. However, they are all blank records. baby steps it seams. I feel like a real newb.

Thanks, That seems to have solved the losing of the data. However, I am now struggling with displaying the results in a grid. Currently, this is not a hot item for this routine. But, this will be important in programs to come. I tried settign the grid record source as Alias and using...

Hello, This is my first time dealing with importing remote data via a view into FoxPro. This can be very useful for me if I can get it to work. However, I am running into a problem. The status bar shows the records appear in the table. The TableUpdate() returns .T. triggering a message that the...

Yes. Thank you. This saves a draft with the attachment. I can work with this and add multiple using other functions.

I have reviewed and tested many examples of adding attachments like the following: #DEFINE MAILITEM 0 #DEFINE IMPORTANCELOW 0 #DEFINE IMPORTANCENORMAL 1 #DEFINE IMPORTANCEHIGH 2 oOutLookObject = CreateObject("Outlook.Application") oEmailItem = oOutLookObject.CreateItem(MAILITEM) WITH...

I do not have that kind of access. However, the updated program will show me who is logged in. Combined with the auto shut down I am set. Now I just need everyone off one time to update the executable.

Well you sir are a genius. I placed the message box above the check against the shutdown variable (Control.LogOut) and the timer is firing. Makes sense now. I changed the buffering several times and get various responses. So, I think I am going to switch to the method I have heard others use...

I place a logical variable in Control.dbf to affect shutdown in two methods: 1. Every action requires a method to be run to update the main screen: which of 22 tables is showing, and which buttons, check boxes, etc. are appropriate. So, anyone using the program will shut down immediately upon...

Thanks all. I will keep trying then. I have about 40 users. All but two are read only. The two with write capabilities are my co-worker and me. So, I am not worried about shutting people down. Plus I precede the closing (attempt) with emails asking people to shut down. The updated executable...

Hello, I have an issue of users leaving a program running for days. This prevents me from updating table structures, indexes, and issuing an updated executable. I have put a timer on the main screen which checks to see if I have set a variable in the "Control" table which should trigger a...