Recent content by keybearer

the option group has another purpose, that is to show which address the person will be using as his mailing address..

sorry for not replying earlier.. i was away for a while.. about the third part, i'll explain it in more detail.. i have a textbox containing the home address (HomeAddTxt) and another containing the office adress (OfficeAddTxt). Then i have an option group box that contains 2 checkboxes to...

a little help please.. 1. is it possible to enter a date with the format : "MonthName-Year" such as "June-03"? if so, how do i do it? 2. I have a multiple select listbox, how can i empty the selections made when the listbox is disabled or after it lost focus? 3. I have an option group with...

no, the data is missing in the table.. i'll try to explain more clearly.. i'm doing a contacts database.. there is about 1800 names and i have it sorted/filtered alphabetically. the problem is with the 1st filtered record, the MbrName keeps on dissappearing! I'm not sure how it happened but i...

hi.. i have a weird problem.. i have a table, in which there's a field named MbrName and others.. the problem is, the first record keeps on missing the data entered in that particular field.. i have to reenter the values again and after sometime, it'll disappear again! and it happens only to...

hi.. i need some simple help here.. how do i refresh comboboxes, tectboxes or listboxes? lets say i have an option group where if the option is selected, a combobox/textbox is enabled. after selecting something from the combobox, and then choosing another option without doing any other actions...

hey wayne, thanks.. just finished changing the sources and it works!!!!! thanks a lot..

so wayne, what's your suggestion? the data needs to be taken from the MailingLabelQuery.. or is the multiselectQry needs to be changed? if so, can you help me?

err... wayne.. the queries work fine, but the report still displays all of the records.. i just need the selected names..

hi again.. sorry for the late reply.. this is my database after i did some shrinking.. i think where i'm doing wrong is in the queries.. any help on that will be helpful.. if possible, i need the confirm button to just send the values to the textbox and the preview button to open previewed...

thanks for the tip..

thanks a heap.. now i'm understanding more n more.. thanks again..

hey wayne.. thanks a lot.. works like a charm.. though i'm a bit confused about the " and ' :) just a little more help here.. is it possible to turn off the warning that access gives before updating data in the table? if so, how can i do this?

hi.. i need some help here.. i'm currently trying to insert/update data from a form into a table.. if the record exists in the table, it'll update the data and if not, it'll insert new data into the table.. i have no problem with the queries, but my problem is that i cannot do a lookup whether...

hmm.. thanks.. that's solved.. now i have a new problem.. theres a run-time error '3075 syntax error (missing operator) in query expression 'MbrShp IN (A 005, LMH 012)'. when i looked at the code.. it stopped at loqd.SQL. the pop up is too long and i cant read where im making a mistake.. im...