Search results

gOT IT! One has to define it as COUNTER not autonumber

I am running a docmd.runsql CREATE TABLE...... which works fine when I define text, number or date data types but refuses to recognise types like autonumber? Any ideas on why or a workaround Thanks

I would like a form to open up with 'n' number of textboxes based on a parameter provided elswhere. I know I could have many textboxes (and their labels) becoming visible etc but would I be able to space out those controls depending on how many there are. (similar to the command in access to...

Thanks ghudson. Glad "we" got this all neatly wrapped up!! I'm sure others will benefit greatly

found code! http://www.datastrat.com/Code/DocDatabase.txt Have checked this and it works! exports all objects except tables

Thanks for all the response (and judging by the no. of views, the support!) Pat - the documenter worked fine except it is a two stage process - first creating the report , then exporting it to txt. (also the export to html made a seperate file for every page! -admittedly hyperlinked but the...

Thanks for this Pat!

Thanks Pat where do I find this? The help file does not give much info?

I have been asked to provide a .txt file of all my code in a project. That includes code from forms, reports and of course modules. Is there an easy way to do this in one swoop besides cut and paste? Thanks

What i have done is written a query that looks for any related records. I then write code if dcount("*","queryname"....etc)>0 then ....action to be taken if theres is a related record else runsql(deletequery here) end if Might be clumsy but it works a treat If you're good at the dcount...

in the onchange event of the combo, why don't you put code to requery the form and its subforms me.requery me.subform1.requery (not sure of correct syntax to reference subform) me.subform2.requery etc

Ok Thanks again I will use "" so that it should work with both uk and US formats Happy YN

Having now downloaded your db and studying it I feel I owe you an even bigger appreciation for all the work you put into replicating my problem and trying out the various possibilities ;) ;) ;)

Jon your'e a marvel!!!! Sorry for the delay in reply I only picked this up Sat night I copied and pasted in your code and yes - it works brilliantly. I had to replace the # because the dates I need are UK format. What will happen if i run it on a US machine? Also what was the real cause of the...

What difference does it make which table youare saving it to? I got round the problem by using addnew method of dao Thanks anyway!:) :)

Identical problem? Hi I have the identical problem. loading too many characters in the text box screws up the sql. I downloaded the examples in this thread but the identical error comes up so does anone have a way round this? Thanks

I am sure I have sql's longer than 256? Anyway the contents of the field do not form part of the sql only the reference to the text control on the form here it is and as I said it works fine until I exceed 128 letters in the text control [Forms]![frmPopupPupilDetails]![txtreason] INSERT INTO...

I have an insert sql which picks up the characters in a text box and inserts them in the correct field (memo). It works fine but if I type too many characters in the text box it gets stuck.It gets stuck even if I just view the preview without actually running it. At about 120-128 letters it...

Thanks for your time! and advice My joy is short lived:( I now discover that I cannot even set the caption of these attached labels in code! They are more or less a non entity of their own. Being able to click was not crucial but why can't I set their caption using code? They don't even appear...

Just tried it Thats excellent and saved me alot of aggro! But I otice that attached labels have no click events (or any events) as opposed to labels created individually. Does that mean there is no way to click on the column header Thanks again for this brilliant advice