Recent content by isabel2005

Hi, I'm wondering how I can create a query that will read a CSV file. Here's the scenario. User browse the directory on the computer or network drive, then select a .txt file to query. sample txt file: "Bob Dolan", "Dallas", "TX", "789-456-7896" "John Smith", "New York City", "NY"...

Hi there, I'd like to filter out so that the name only appear once base on LastOfDate. Sample data in query Customer_____Date__________Product John_________02/02/2008_____A John_________05/03/2007_____B John_________03/06/2006_____A Nick_________04/04/2006_____A Nick_________04/04/2007_____B...

Thank you very much!!!!!!!!!!!!!!!!!!!!!!! Muah!

Hi, How do I query the last 2 years vs. current date? Basically, I want to see the record from today date back to 2 years. Please assist... Thanks, Isabel

---------->>> Need Help Quick With Generate A Simple Report<<<<----------- Hello, Attached is my db which I'm unabled to generate correctly. The db has 9 records so far, with 2 primary languages. With couple of records, the first and second page should list only English on the top of each...

It worked awesome with conditional formatting. Thank you!!!!

Hi, If my language fieldname is English, I want the report text in Blue. Otherwise, black. I did this but got errors. Any help? Private Sub Report_Open(Cancel As Integer) If (CategoryName = "NONE") Then [CategoryName].TextColor = "000000" Else [CategoryName].TextColor = "FFFFFF" End If End...

Hi there, I managed to figure out how to add the record. This is how I wanted. (see attachment) :p Thanks again for your help. Isabel

:mad: nooooo... I won't promise :D Can you please look at the frmMember in the Form tab? It displayed the language name and not the ID. With the one you created, it showed the ID. I don't want the ID because I won't be able to know which languages once I add more records. Thanks, Isabel

Hi there, Thank you for the quick reply. I love the form you made. However, I wanted to be able to select the dropdown list of primary and second language and add the record to the tblMember table. I attached the file again with the Form "addMember". It has dropdown list of language but it...

Hi, I want to be able to add/edit/update record into the tblMember using Form. How do I do that? I created a relationship between this table already. I just need to know how to add the record into the tblMember table. Any assistance is greatly appreciated as I'm a newbie. Thanks in...

Hi, I've attached a file that allow me to populate droplist. I have 4 tables. It worked well. Check it out. My problem is I want to make only 1 table as shown below and be able to populate droplist like the I attached. Please suggest. Thanks. tblAttendance DateID 1 1 2 UserID 1 2 3...

Relationship & subform problem Hi, I believed I did the relationship correct now. I also added subform. However, I get into problem. I can't select the combo box in the subform anymore. I had one that work without main/subform and it's called "selClasses". I then copied it to...

Problem with relationship and can't make subform Hi again, Yeah, I realized I have to make a subform, but unsuccesfully. Like I said, I followed one of the tutorial and got that far (my schedule2.zip) and I also got to select multiple selection. I guess the problem is I didn't draw the...

My Problem Hi, Attached is my db file. I was able to select multiple field but I can't update the record. I'm not doing something right. Basically, I need a form to allow me select a student and assign him/her to multiple classes in that day. I think I need to create another form (subform)...