Search results for query: *

have you tried importing all objects from the corrupted database into a new blank database ? hope that helps Katho

Hi marlun, I guess if you don't use the NZ function, you will get no errors (you don't need that function probably if you set the properties for the control not to allow null entries). Greetings, katho

Hi sabavno, The workaround I use is to save the excel-file as a textfile and then import it into access (using code, but that shouldn't be necessary). If anyone knows how to control the import wizard built in into access, please let me know too - I have not seen anything on the web relating to...

Hi JeroenNL, you can avoid this by unclicking the option "pictograms in taskbar" in the options dialog (see access help type in taskbar). This way the tasbar will only display your database once - no matter how much form are opened... jazzy greetings, Katho

Hi Jennifer, you can use the docmd.closeform "Mainform" command in the OnLoad property of the subform (CustomerInformation ?) - that should work. Greetings, Vincent

dear icebergg, try the following function CalcAge: 'first, calculate the year difference between birthdate and 'date of death. ' next, calculate if day and month of deathdate are bigger ' than the ones of the death date: if so, age = age, else ' (boolean value) age = age - 1 Public Function...

you can use dcmd.openform "formname, openargs to pass a variable to the form you are opening. In the formopen state, you can check for the value in openargs and use it in the form itself... Check your help to find more information on using open arguments in the docmd.openform statement...

the problem lies probably with your security settings in outlook 2K. You might try to look these up (en check te help in oulook and on the web) to find an appropriate answer. I once had a similar problem and had to hack th registry to be able to send multiple e-mails (in outlook 2002) Hope...

simplest solution : get the entered text in a string and look in the string for the first blankspace. if there is one, break down this string in 2 strings. then look for the next blankspace and so on. Every time you encounter a blancspace, let a counter increment. Then, search not only on...

hoi thijs, je kan een ado- recordset creëren die de query uitvoert en met een integer het aantal rijen van deze recordset tellen. Indien dit aantal >= 100 dan kan je dit (als variabele) doorgeven en je msgbox tonen (of niet). Indien dit nogal kryptisch lijkt, lees dan eens de help na (best in...

if the control doesn't appear in the list, search for it supplying the patname. If yit still doesn't work, check your computer for the existence of this control and register it first.

you might try to downgrade the mdb into a prior version (save a 2000 version as 97). You might also try to use Visual Basic (or even another access db) to import the modules that were corrupted. Can you keep me posted on the result ? Good luck!