Search results for query: *

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

Hah! Sparse = .f. Coldan

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

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

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

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