Recent content by waldemar

Cool idea ;-)

From MSDN: ---------------------------------------------------------- ACC: Use Append Query to Set Initial Value of AutoNumber Field Last reviewed: November 18, 1998 Article ID: Q94821 The information in this article applies to: Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97 SUMMARY...

So I have this ID being an autonumber field going up to 25000 right now. Now I need to add a table entry with a specific ID like 50000. How can I accomplish this? Once I convert the autonumber to a regular number and add the entry I am not allowed to turn it back to autonumber (but need that...

Hmmm; never mind, they seem to have the same name as in forms (just don't show up in the dropdown menu in code editor)

That's clear :-) actually I'm looking for the VBA equivalents... can not find anything there...

Thanks guys :-) perfect :-)

I just want to change a sub-reports link to the parent report... but I can't find properties similar to linkchildfields/linkmasterfields as in forms... anybody an idea?

Yes, but I think that doesnt apply since each header and each piece of data is a single detail-field. It's all in one normalization level; VBA is used to format the differences betweend header and data.

I am formatting table entries into a reports detail section where the entry can either be a header or some detailed data. Now I would like to create a page break inside the format-event similar to word. "If the header is the last thing on the report and the details wouldnt fit onto the...

Thanks fancy, that buffer overflow thing feels like its going in the right direction. I tried your modification but still no luck (access 2002) :(

Tried that birklea, thanks! Please see thread702-457578 new results...

For those who were following my miserable quest on why access 2002 form crashes for no obvious reason (thank you for all the tips already), I have a new theory. By removing some related code, so far I had no crashes any more. However this code is essential for me to display data in a sub form...

I have some extreme problems with a function inside a form that updates some of the displayed elements. The code ist here: http://www.midiport.de/problem.htm Has anybody a clue whats the problem here? Access crashes big big time with the code! (Not even an Error Message). I appreciate any...

Now it crashes also when I set and clear the form filter - but only sooooometimes.... what is going on here???? Nobody any similar problems yet?

Thanks for the tip... though I couldnt find any hints there yet. Interesting is, that I don't use any automation there; its just some simple form controls formatting stuff (chaning controlsources, forecolors, etc.) Also interesting, dll is the latest (some 3.5) and previous versions (tried)...