Search results

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

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

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

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

hi.. i want to display the names of all the people except those who are deceased.. below is the sql query that i used but it's not working.. i just get an empty result.. SELECT IIf([Membership]="LM","LM" & [ID_No],[ID_No]) AS MbrShp, OPA_Contacts.Name, OPA_Contacts.RegtNo...

hi.. need some help here.. again.. i have a report that will display the addresses of my contacts just like in the northwind database.. but i want to be able to select the addresses that i want to be sent to the report.. i know that i have to use a listbox and set it to multiple select enabled...

hi.. a little help please.. on my form theres a textbox named profession.. and the next texbox named rank.. the rank txtbox is disabled.. how do i automatically enable the rank txtbox and set the focus on it when the profession entered is equal to "army officer" and just go to the next txtbox...

hi.. some help please.. on my form there i a cascading combobox with 2 cbxes, the 1st is homestate and the 2nd is homecity.. there's a textbox for area after the comboboxes, where the user will enter an area from street address.. i need to open a report according to the area that the user...

hi.. i need some help here.. i have a contact database where all the data is in uppercase.. how do i change/normalize the case when i want the data to be displayed in a report? it's quite hard to read a report in uppercase and doesn't look nice....

hi.. i need some simple help here.. How do i send the value (string) of a textbox on a form to a textbox on a report?

hi.. i need some help here.. i have an unbound combo box with values A-H, WAT, DET, etc.. In my table, there's a field named company with the values A to H or WAT or DET or any combination of both like A / H or Det / B.. etc.. currently, when i click on the values in the combobox, it will only...

Hi.. I'm in a fix right now so if anybody can help me, that'll be great. I'm currently doing a Contacts form.. in the form, there's a list of names, id no, membership type, locations and such from a query.. I've just created 2 option group, 1 for filter by Initials from the field names and 1...

Hi.. I'm in a fix right now so if anybody can help me, that'll be great. I'm currently doing a contacts form.. in the form, there's a list of names, id no, membership type, locations and such from a query.. I've just created 2 option group, 1 for filter by Initials from the field names and 1 for...