Search results

Thank you very much, well, I have already made a table to input the data. But I specifically don’t know how to make the other form to prompt user for a username and password. in other words, I know how to make a form in different ways, but I don’t know how to make a form ask the user for a...

Thank you very much, The form is to put some information into a table. I want it to prompt the user for a password and/or username. But I don’t know how can i design such a form, neither I know anything about VB. Your help is appreciated. Thank you.

Is it possible to make a form protected by password? Thank you

There are two tables. One table is the student name and characteristics from schoolA during the last 20 years. The second table contains the student names and characteristics from California university during the last 20 years. Obviously, some but not all the university students have come from...

thank you very much, can you please give me more help? please imaginethe table 'student lectures' has more fields like , "studenthight" or "fathersname". These do not contribute to any condition but we want them to be put into the resultant table: 'MonthlyLectures'. how can we do this?

running module 1 of the access file on the following link: http://www.rospina.com/Database1.accdb results in this error: run-time error ‘94’, Invalid use of Null, highlighting to a line that i dont know how to resolve it. can anybody help how to resolve this. i a know nothing about modules...

how is this mudle error solved ? :( i still see the same error

anybody here to still help me? :(

i could solve both problems. tnx :)

dear plog, Thank you very much for your time and attention, Sorry I have been too late, i hope you still remember this case, Well, i did them all, I saw this errors when the module is played: run-time error ‘94’, Invalid use of Null, then the error points to this statement...

this is the DB: Table1: fields: ID, jobname, jobcats , managergender, rural, productsold Records: 1,jacksons, pharmacy, male, yes, cosmetics 2,stevens,pharmacy,male,no,cosmetics 3,robert,doctor,female, yes, therapeutic, 4, George, pharmacy, female, yes, complement 5, cyrus, pharmacy, male, no...

the query shows, studentname, lecture, and date. but if a student presents the same subject in less than 30 days, the query will not show that record. if this query works on your example, we will see: 1,john, politics, 1/1/12 2,john, politics, 31/1/12 4,john, politics, 1/3/12 the third one is...

hello, You have already helped me when no one else could instruct me. I wonder if you can still help me on the following link: http://www.dbforums.com/microsoft-access/1687288-how-run-dlookup-query.html#post6574425 thank you very much

could you please confirm that Dlookup will not help in such case and i should only try to fix it through inner join?

thank you, but i am so confused in joining queries. it is too complicated for my level. so isnt that possible by Dlookup?

table name: student lectures fields: ID, studentname, lecture, date records: 1, john, politics, 1/1/12 2,steve, politics,20/1/12 3, jack, economics,21/1/12 4,jack,politics,22/1/12 5,john,economics,22/1/12 6,john, politics, 25/1/12 7,john,politics,3/2/12 based on our definition the query will...

There are two tables: Table1 and Table2. A query is built on Table1. In an Dlookup expression We want the query show us the record of filed3 from table2, if filedA from tabl1 equals Field1 from table2 and fieldB from table1 equals field2 from table2. Thank you

There is a table where we record student name, lecture subject and presenting date since last year. We need a query to show all the students who have made a lecture. We want the query to remove a lecturer who has presented less than a month on the same topic. For example, John made a lecture...

what kind of machine specific things can we make?

There is a form with blanks which are bound to a table. we put data and press the record button and go to the next record. In the next record, blanks are empty. How can we make the form to still keep the previous data in the blank? For example, there is employee name: Jack, we press the...