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!

  • Congratulations strongm 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: *

  • Users: coldan
  • Order by date
  1. coldan

    Problem with combo propdown

    Hi Mike, I had this columwidths set to 250 in the propoerties of the combo as that is the chr in the field (254) to allow for very long path names. I tried Changing this value to 50 - no change Adding a line in the forms init - no change Cleared out the 250 in the properties with line in init...
  2. coldan

    Problem with combo propdown

    I have a table of paths used in my app which the user can access via a combo on the main form. When the down arrow is clicked the drop down 'panel' of entries is far too wide. How can I shorten this to the width of the control itself? See http://preview.tinyurl.com/y6cvjrv Thanks Coldan
  3. coldan

    OLd MS Access App and WIN 7

    I wrote an MSAccess app some years ago and haven't used MSAccess since. I have installed the app on quite a number of PCs running WinXP. I also can run it on my Desktop with WIN7 64bit. When I installed it on another WIN 7 PC yesterday the app failed to start with an error shown on this line...
  4. coldan

    Problem with Reports

    Problem solved... Mike's post led me to look at the actual reports which had worked in the distributed app. I found another variable which was not visible to the reports in this build. Thanks everyone. Coldan
  5. coldan

    Problem with Reports

    Sorry about the duplicate message... Tamar, Tamar, >First, I don't see why you have the window x. What's it for? This a snippet I was given some years to allow the report to run twice - I guess 'invisibly' the first time. This code has been in my pp for years and everything works well in the...
  6. coldan

    Problem with Reports

    MIke, Added your Private command - no different. I see the report in the debugger as you would expect. Running the exe I see the form open maximised The window at the top left -Window x From 1,1 To 20,20 Unlike in the debugger, this does not fill with the first run of the report and the...
  7. coldan

    Problem with Reports

    MIke, Added your Private command - no different. I see the report in the debugger as you would expect. Running the exe I see the form open maximised The window at the top left -Window x From 1,1 To 20,20 Unlike in the debugger, this does not fill with the first run of the report and the...
  8. coldan

    Problem with Reports

    I am putting my app together again after a 'botched' backup - 'nuff said. I am having problems with my Reports - which previously worked like clockwork. Now they work when debugging and not in the executable. I am showing the Reports in a maximised window with a Page n from nn in the footer...
  9. coldan

    Date format - is this possible?

    Thanks Mike for the explanation and Cetin for a very neat solution. Coldan
  10. coldan

    Date format - is this possible?

    I am decoding an Exif tag DateTime. The value collected is in the form 2009:12:19 14:07:30 in my example my code is <code> myvalue = ALLTRIM(Value) mypos = AT(' ',myvalue) mydate = SUBSTR(myvalue,1,mypos) mytime = SUBSTR(myvalue,mypos,LEN(myvalue)) thisform.txtdatetime1.value = mydate...
  11. coldan

    Looping through text file

    In attempting to solve the 'Unable to delete' problem in a previous message I am writing a txt file of the 'saved' (modified)image filenames so that they can be copied back after the Form with the grid is closed. I create a text file instead of doing the delete. Thus I have a text file with...
  12. coldan

    Trouble deleting file

    In my application I use the Imageviewer ocx control to (amongst other things) allow additional meta data to be written to a jpg file. The control requires a temp file to be written with the new Exif data included. My problem is that the original image file is used in a field in a grid that I...
  13. coldan

    Not allow changes in a grid

    I have a simple grid on a form. I want to allow changes to the data fields when the 'Edit' option is chosen on a 'selections' form via a checkbox. I am using mode as the variable name which I pass to the form. What property can I change in the init of the form to prevent or allow changes? Is...
  14. coldan

    SQL join on two colums

    Thanks Mike and Cetin What I'm saying is that the code I have given is 'similar' to the actual code required but for simplicity I have used other names. Thanks
  15. coldan

    SQL join on two colums

    In my app I'm trying to extract 2 names from a table (table1) which has two fields - lets say PNUM1 and PNUM2 in a record. The actual names for these these namenumbers are held in another table where field REALNAME is kept against a reference to a PNUM field SELECT * FROM table1 AS a inner...
  16. coldan

    Checkbox in grid column

    Hah! Sparse = .f. Coldan
  17. coldan

    Checkbox in grid column

    I have used the Alvechurch page to remove the text box and add a checkbox to a grid column. When I run the form the checkbox is not displayed until I click on the column. Someone helped me with this a few years ago but I've forgotten the solution - anyone help please? Coldan
  18. coldan

    Grid not accepting key strokes on a form

    I have created a simple form with a single column grid to accept numbers typed in. It's controlling table is a single field table with a n (10) to which I have appended 100 empty records. This table with added numbers is used in a SQL JOIN to extract the required number's records from a much...
  19. coldan

    provide the user with a listing method

    Mike, Thanks for your comments. Thus far to solve the problem I have appended 100 blanks when the table is created and then the Browse allows up to 100 entries ( more than enough). My user has also used the ReUse command to add entries to an existing table. It's not elegant but it has...
  20. coldan

    provide the user with a listing method

    I have a form on which a chkbox triggers the display of a container. This contains a text box and a chkbox. The idea is that the user can choose to enter a single product number or a list of numbers. In my code so far the single number processing works now I want to add the chkbox click()...

Part and Inventory Search

Back
Top