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!

Register Log in
  • Congratulations derfloh 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. Puebles

    Is it possible to create a view of a shared free table?

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

    Create SQL View no records returned

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

    Create SQL View no records returned

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

    Data disappears even though TableUpdate() returns .T.

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

    Data disappears even though TableUpdate() returns .T.

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

    Data disappears even though TableUpdate() returns .T.

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

    Data disappears even though TableUpdate() returns .T.

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

    Can I add attachments to an open Outlook email without sending?

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

    Can I add attachments to an open Outlook email without sending?

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

    Timer in executable on network

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

    Timer in executable on network

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

    Timer in executable on network

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

    Timer in executable on network

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

    Timer in executable on network

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

Part and Inventory Search

Back
Top