Search results for query: *

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

Has anybody expierenced similar problems? When I change the controlsource property of any form field in VBA, Access crashes big time!!! (Problems with the "oleaut32.dll") Anybody?

Does anyone know of a software tool, that allows editing users and their passwords in the mdw? I am programming a dbi-web interface so the users can NOT access any access-internal functions (like password change, etc.); but the administrator MUST be able to view and change these settings...

Another interesting problem: If have a table containing text entries with a category and a position number, like this: [intPosition] [intCategory] [intText] 1 CAT1 Text1 2 CAT1 Text2 3 CAT1 Text3 4 CAT2 Text4 5 CAT2 Text5 6 CAT2 Text6 7 CAT3 Text7 ... and so on...

I guess Conditional format doesnt help me here, since these checkboxes are *unbound*. I am using the values of these checkboxes to influence another variable (an integer) which is saved in the record. So *that* sounds like I can't get around putting the function call in the controlsource...

When I put the code into the form's oncurrent event, it will be only executed ONE time (for the first recordset). When I click on one the checkboxes ALL record's checkboxes are affected (hey wait a second, there is something really wrong here; this means I can not edit the record at all?? Sound...