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

    File xxx is not a database.

    Thanks, All. A useful tool which I hadn't yet discovered and can see I will use again! However, it didn't turn up anything (except sore eyes) :-) This morning, though, I rebuilt the PJX from scratch and that seems to have done the trick. Again, thanks, chaps.
  2. SimplyES

    File xxx is not a database.

    Experiencing a growing number of issues with a system I put in place in 2013 so I decided to start (almost) afresh. I started by copying the whole development folder to a new location (on the same PC) and have been rebuilding the forms using a new base ClassLib. I have also decided to make the...
  3. SimplyES

    Transfering data to amended database tables

    Mike: You did, indeed. Apologies. I obviously pondered the rest of what you said so thoroughly I forgot to read on! Tks
  4. SimplyES

    Transfering data to amended database tables

    A whole lot of really useful/helpful responses. Thanks to all - confidence boosted. One question still unanswered - can I have to DBCs open at the same time to manage the data exchange? Obviously the table naming needs to be retained throughout - I assume that if they are in different...
  5. SimplyES

    Transfering data to amended database tables

    In further developing one of my projects I have added a few extra fields here and there to some of the tables and changed the width of some fields in other tables. I am thinking, if I take a copy of the DBC from my development folder, open that DBC and ZAP all the tables, copy the 'live' data...
  6. SimplyES

    APPEND BLANK fails to move pointer

    I have now rebuilt the form from scratch, with all the exact same elements and code etc. I need to make sure I have all the intended functionality on board, but so far, all working fine. I guess I must assume there was something bent 'n' twisted lurking in hidden realms. My thanks for all...
  7. SimplyES

    APPEND BLANK fails to move pointer

    Not at all sure I'm getting the expected output from coverage log! Here is the INIT script - SET COVERAGE TO is in the gotfocus event of the first textbox on the form. As you can see, there really isn't a lot going on, so not many obvious opportunities for it to go wrong: LPARAMETERS tnLeft...
  8. SimplyES

    APPEND BLANK fails to move pointer

    I did give INSERT INTO a go but the outcome is the same. I have also tried refreshing the fields (rather than the whole form) after APPEND in the INIT. atlopes: Your point understood. Using IN with APPEND is a habit for me. However, I did pop a SELECT cursorName ahead of it as well - no...
  9. SimplyES

    APPEND BLANK fails to move pointer

    I have a very simple form, with a very simple INIT which (simply) does APPEND BLANK IN cursorName and then displays a half dozen fields - always with the contents of an existing poputlated record. If I set a break point just before the APPEND, and then step through, it does exactly what it...
  10. SimplyES

    Combining records from one table

    In the end I included the script to combine the Engineers initials as part of the main selection process as an optional path, with a button on the main display form so that the user can switch between the two. Works a treat and, now that I see that working, I think they will likely use the...
  11. SimplyES

    Combining records from one table

    Mike: Quite right, and I do plan to use spaces, for both the reasons you suggest. I just wanterd it to be clear in the text I submitted in my question. JRB-Bldr: I think I'm OK on normalisation (but I will review!) - The fields I showed are actually one level up, from an cursor SELECTed in...
  12. SimplyES

    Combining records from one table

    Thanks chaps. I pretty much thought that was the way this one would roll but I didn't want to miss a trick if there was one. Thanks for the suggestion - I'll work with that.
  13. SimplyES

    Combining records from one table

    I have a table that contains records of job allocations with fields for Date, Job number, Client name, Site name, Engineer's initials. Currently, if a job is allocated to a team of, say, three engineers, there will be three records for each day of the job duration - one record for each engineer...
  14. SimplyES

    File is not open error message when compiling

    Thanks, gents. I always [CLEAR ALL] before compiling and, if I still have problems, shut and restart VFP. On this occasion this didn't help. I am having a bit of trouble with class libraries - bad management of locations on my part - so perhaps this is throwing a spanner in the works.
  15. SimplyES

    File is not open error message when compiling

    OK, so a bit like when I take a toothache to the dentist, as soon as I posted my question, I tried again and it compiled without issue! Anyone have a comment? a clue? an idea what's going on?
  16. SimplyES

    File is not open error message when compiling

    I have seen some threads where this error (1113) is occuring but, in my case, this is happening when I compile. Up until now I've not had a problem with this project and its been compiled a good few times, of course. Now I can't seem to get past this [File is not open] error message. One of...
  17. SimplyES

    Disappearing form objects

    Has anyone else experienced this? I have a main form with about 25 objects,including 2 grids, plus labels and a 3 background shapes. Via one of the grids I call a new form to enter data items which fill a row on the grid. This little form uses the same data environment as the main form. That...
  18. SimplyES

    Date Problem exporting to Excel

    Thanks to all of you. atlopes - I suspected something like that was going on but couldn't see why. Tamar - Spot on. I'm a plonka! The bit I took out because it wasn't having any affect (oRange.EntireColumn.NumberFormat = "dd/mm/yy") I have now put back in. Only now I have put it in the right...
  19. SimplyES

    Date Problem exporting to Excel

    I have a date problem (please don’t tell me I should be on the ‘Lonely Hearts’ forum!) My main application form has SET DATE DMY in the INIT (I’m in the UK) and no other SET DATE called elsewhere. All the actions relevant to this query come under the management of this one form. In one of the...
  20. SimplyES

    Object class is invalid for this container

    With programming, there are times when things going wrong and being really hard to fathom out is the best thing that can happen, just because the feeling that comes when you finally win the battle is awesome (not to mention being a very great relief)! Thanks to you gents at Tek-Tips I now have a...

Part and Inventory Search

Back
Top