Search results for query: *

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.

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

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

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

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

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

...can see, there really isn't a lot going on, so not many obvious opportunities for it to go wrong: LPARAMETERS tnLeft, tnTop, tnMode, tnBackColor ** Set varying screen position of form WITH thisform .Left = tnLeft .OTLRowHeight = 18 .OTLTopRow = 83 .Top = tnTop ENDWITH ** If not in edit...

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

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

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

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

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.

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

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.

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?

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

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

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

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

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