Search results

Hi there Does any one knows how to stop formatting cells automatically? I didn't tell Excel to format cells into any category types but it changes the numbers of the other cell automatically. Please find an attachment. In the cell B29, C29, D29, E29, and F29, they don't have any formulae and...

Hello I don't know if I can explain well here but I have Access Database that someone designed and they have a report, which they run at certain period time routinely. Please find attachments (report design 01.jpg, report design 02.jpg and report design 03.jpg). The combo box contains (I...

I figured it out just now.. SELECT distinct h.family_name, h.address, h.suburb, h.city, h.phone_home, h.phone_work, h.ge_long, h.ge_short, p.contact FROM homestay h, [homestay people] p WHERE h.homestay_id = p.homestay_id AND h.city = 'Palmerston North' AND h.ge_long In ('maybe','yes') AND...

How about if I want to select two records? In my case, this field contains "maybe", "yes", "no" and "NULL". I need to retrieve all records that has "maybe" and "yes" but some records has nothing. SELECT distinct h.family_name, h.address, h.suburb, h.city, h.phone_home, h.phone_work, h.ge_long...

I see! Thank you! :D

sorry forgot to attache a file.

can you please tell me what do you mean by the lookup table? "category" is set as "text" as in data type.. my report appears like the attachment. for example, item id 100 should be writing but on the category column, all categories are there.

hi i have a report linked a query, which is pretty simple one. all fieds appears well but one of them shows everything inside of the combo box. please see the attachment file called Book List.jpg for example, item_id, 180, should only show "Testing" in the "Category" filed on the report but...

I am trying to use "NotInList" and debugger stuck in the middle of the code in the following. (The yellow shadow is over ".Update".) Private Sub cmbProgramme_NotInList(NewData As String, Response As Integer) Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb...

Hi I have a field that contains some kinds of the student status, such as "Current", "Alumni" and "Expire". The table has already got a lot of records. How can I make a new item available to the field, for example, "Other", without entering a new status? Like, "Student A" is "Current" but he...

Thank you! Thank you, Pat Hartman! I made it! :D

Hi I want to manipulate a few tables and make them into one table, but I don't want all of their fields. I heard that I could do it with "map table wizard" from the top of the menu. Where can I find it? Or, can anyone recommend me what I should do better? I use Office 2002. Thanx. Gaufres

thank you, Pat Hartman. my sub form is now transparent but so the main form is for some reasons..? and now i can't find where i found "transparent" option. but nevermind, i keep playing around it but i just want to say thank you. Gaufres

Border Property?? Is that "Border Style" on Format Tab? I've already selected "None" but the line still shows up.. Or am I looking at a wrong place? I attached a pic of the property window.

Event Property i just made it! :D i didn't know i had to get my form in design view and right-click on the properties of the combo boxes. then go to the Event Tab, look for AfterUpdate, and choose code builder.. just in case there are someone who didn't know this stupid basic skills like me...

sorry to ask but would the code go to the subform or the main form? would i have to have a separated "Save" button for the subform ("Enrolment" and "Intake" info)? also, how do you check the name of the form? do you check by the property of the form or the name shown on the panel where all...

hi i am not good at programming and it was 5 years ago when I did VB.. please find an attachment .jpg called "Student-Form.jpg". at the moment, when the user change either "Gender" and "Nationality" on the left side, the "Save" button at the bottom of the form will be available. if you just...

Sorry Sorry the above code that I posted is for the main form, not the sub form.. sorry I am newbie for Access VB Code and to be honest, I'm not sure what I am doing.. The sub form that has the "Campus" combo box doesn't have any code.. I have been googling but I don't know what the key word...

Yes, sorry I wanted to edit my post but somehow I posted twice.. I'll be careful next time. Gaufres

mmmmm I'm not sure about the code. but here is the code for the form what i have. I haven't touched anything though.. am I meant to? I just added a combo box and linked to the "Campus" query.. Thank you for a prompt reply! Option Compare Database Option Explicit Private Sub...