Search results

in fact my question is that how can i define the Button Click even to call a Function/ Subroutine? what shall i write there? the module will compile a table on which a final query will be made. the final query is what i want. shall i provide the module and other information? thank you

I have made a module, named module1 whose function is to make table1 on which a query1 will be built. 1-What code shall I write in a bottom to run module? 2-Can I make the whole process by one bottom? I mean can I get the final query by just one click, or do I have to run the module to first...

i made a field in the original table, and bound the check box to it. now they can be checked in dependently. When i check one of them, the above code is run, but all the [jobdate] records are filed at the same time. Is this because the form is in tabular layout?

I have made an unbound check box, named “myckeck” in a form which shows data from a table in tabular layout. 1- When I check one check box, all check boxes are checked. How can I solve that? I mean I want to check or clear check boxes independently. 2- I made a text box, named “jobdate” to sow...

hi, thank you for your time, well, the above query shows the latest lecture of each student&lecture subject. there is another field in the table (not provided here) that is a number attributed to each student activity that might need to be changed in the table. i was hopeful to be able to select...

Both tables are the same, with different names as the following code: ( table name: lectures) SELECT lectures.ID, a.studentname, a.lecturesubject, a.lecturedate FROM Lectures INNER JOIN ( SELECT Lectures.studentname, Lectures.lecturesubject, Max(Lectures.lecturedate) AS lecturedate...

I have selected some records of a table by a query, and then opened a form over this query. But I cannot edit data in the table through this query as the data in query does not accept to be edited. This query is built by inner join between two tables. How can I solve this problem? Thank you

thank you very much for your time, i rebuilt it again and now it is working, i could not find what caused that problem though.

Thank you, I am confused as I have always used this code in similar situations and it has been working. I used those unbound textboxes and referring merely to a number to simplify the problem and see that it still is not working. In other words “afterupdat” or “change” does not work. It seems...

form properties/event/oncurrent is blank. Textbox.delay1 properties/event/afterupdate: [event procedure]. When i press the button on the right, it goes to visual basic window where I can see the code that I had put. I expect the textbox.delay2 to show “4” automatically when I write in...

I made a form over a query and added a button to go and view next records. Then I added two unbound text boxes named: delay1 and delay2. Then I put this code in the visual basic: Sub delay1_AfterUpdate() Me.dealay2 = 4 End Sub The above code works only for the first record of the query but...

I have made and designed a form on a table. I want to make another form totally like this one to be bound to another table. Can I make a copy of the current form and change the table to which it is bound? This way I will save a lot of time to design a new form.

Lectures presented by all the students during the last year has been stored in a talbe named: studentlectures, with these fields : ID, studentname, lecturesubject, lecturedate For example: 1, john, mathematics, 2/3/2012 2, jack, chemistry, 10/3/2012 , 3,john, engineering, 15/3/2012 4,jack...

How can we make an access or excel file to be dependent on the current computer. In other words the file will not work if it is copied and moved to another machine. thank you

thank you very much, your guide was really help full, i will post specific questions later best regards

Thank you very much for you time, Well I have three questions, 1- It worked with jack, 1234. But it seems it can be logged in with any other name and password. check JOJOBA, 567654. 2- How can we design it so that after jack logs in with his user/pass, all data are entered by...

thank you for your time, please get the file from the following link. http://rospina.com/passprotected.accdb i want the form loging check for the username and pass to match and then the user will be able to open the other form, employees, to insert the data.

dear mugman, could you please let me know how did you made that form ( frmPassword) protected by password? thank you

Thank you, I made one table named: Check. It has these fields: ID, username, password, and records: 1,jack,1234 2,james,3245 , 3, amanda, 7654 I made a form named login. I put two unbound text boxes named "user" and "pass". Then I put a command button , and used macro builder...

can anyone solve this problem?