Recent content by coldan

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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