Search results

What are attached labels?

Thanks arvidn But unfortunately the label captions have no bearing in datasheet view, only the names of the textboxes appear as column headers

user can change column widths and even their order

Thanks Rich your answer basically amounts to the fact that I cant do what I want in datasheet view but there are other considerations which force me to use datasheet view. also you have not answered the fact that there are programs which allow clicking on the header. I thought of pasting a label...

One of my forms is in datasheet view. The column headers display the "name" of the text boxes. I want to be able to display a different column header under certain circumstances so it would seem i have to change the name property of the text box. I have put in the open event of the form...

I wish I could but I've no idea where to start. Any pointers? Thanks

Thanks -Thats good but it involves an extra field for the thousands of records.Wouldn't it be more space economical to make a small table with only 2 fields and keep it don to 10 records? thanks again

My user types selects a unique record number (not autonumber) from a combo to dislplay its details. How can I keep track of the last 10 records examined so the user can click a 'previous' button to return to it and another forward button to do the opposite? obviously when an 11th record is...

Thanks Pat for quick response. Actually Crystal reports are now included in the conversion software if I understood correctly. also isn't the compiler included in vb6? I enclose the email I received in response to my query to them: At 09:05 AM 10/31/2003, you wrote: >Hi >We are MS Access...

Has anyone tried and had success with "Diamond edge" software for converting access to vb? I need to convert an access program to an exe and this seems to be the most feasable solution. Client does not want to buy Access and runtime is just not realiable enough in my experience! Thanks

seems clumsy especially since you never know the number of pages its going to turn out to be. I'm sure one can do it by putting the same field name twice in the report but I want the records to run through once and then a second time Thanks

Thanks for quick response. I thought of two reports but then I want the pages to be numbered 1234 not 1212

That would give me no control over when to start a new page for the second lot or the propeties of some of the fields etc. I feel I need to control this from within the report Thanks

I want to print all records twice in one report. I.e. have 50 or so records print across the page (takes about 2 pages) and then have them starting on a new page all over again but the second time I want to miss out a field (or make it invisible). I want to have a different footer for those...

Thanks for your reply which seems exactly what I wanted but I am getting errors opening the recordset error 3061 too few parameters. expected 4 this is the sql of the qry. (I know its based on other queries but I am hoping we'll catch the fault here since the sql of the ones its based on is...

I need to pop up a message box which includes information from many records as a string e.g The following subjects do not have a teacher assigned to them Science History Maths I don't know how to loop through all records of one field of a query and create a string from them I would seperate...

Just discovered that *london] brings out the requred records since I have the LIKE operator in the SQL Thanks everyone for your help

Thats good but as far as the user is concerned they want to be able to type in [london] in the textbox and find all the records whose city field is identical i.e. [london] (not london) so what do I tell them to type in? Thanks

I have a search run from a from which uses text typed by the user in a textbox as its criteria. However if the user chooses to search for a string that includes a '[' or ']' then the sql runs into problems since by its nature the sql contains many '[' and ']' e.g. around tablenames and...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bapp2000/html/mdbdownload.asp?frame=true use the developer download