Search results

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

Hi.. i need a bit of help here.. i'm currently doing a contacts mailing list.. in the database, there are office address and home address.. a contact can choose either addresses as their mailing address.. i want the mailling list to display something like this.. [member ID] [Title] [Name]...

my database is quite big.. ill try to shrink it and post 2morrow.. anyways.. i kept on getting this error.. compile error: user-defined type not defined and it highlights this line of code" Dim loqd As QueryDef

yes.. i know about the qryMultiSelect query.. i've changed the table and the source.. but the report still displays all of the addresses... :(

hi IMO.. i have a problem with your example.. lets say that i have transferred the wanted ID's/Names to the textbox separated by a comma.. LMH 004, N 005 e.g.. how do i open the report where the addresses are the people whom their ID's is in the textbox?

hey guys.. thanks a lot.. it works perfectly..