Search results

i am not sure that i know what the word "split" means here. well, i have made new forms and queries in the copy file. the i put some data to run tests and make sure they are working. as a result the data in the copy file is not the same as original one.

I have created a copy of an access file to make some changes to tables, forms and etc. Some of them are deleted, new ones created or the codes are changed. Is there a way that I can apply all the changes to the original file? Thank you

thank you, and would that also add the query1 data? plus, how can i make a dlookup? i am not good at writing such things. thank you

Query1 has one result like the following ID studentname lectureplace lecturesubject 23 jack A Geography Query2 has results like the fowloing: ID studentname lectureplace lecturesubject 12 jack A Biology 18...

We have the following table. ID studentname lectureplace lecturesubject 1 jack A Biology 2 steve A politics 3 jack B math 4 steve A math 5...

thank you, that was great :)

can we make a form to prompt for a password before opening so that only those who know the password can open and use that form? thank you

thank you :)

How can we design a button in a form, so that when it is pressed once, it will be inactivated until the form is open again? Or the button is inactivated for a certain time for example 10 seconds?

those IDs (155 - 187) have not yet been created yet. they are supposed to be created automatically when the query puts the data in. will this "update query" do that? how can i make an "update query" then?

Student lectures, subjects and locations are stored in a table like this and now we are in record ID number 154. ID studentname lectureplace lecturesubject 1 jack A politics 2 steve A politics 3 jack...

Table ‘studentlectures’ is comprised: ID studentname lectureplace lecturesubject 1 jack A politics 2 steve A politics 3 jack B math 4 steve A politics...

Dear plog, Your answer to the main/first question was the best and helped me a lot so far. Thank you. You created a query named MonthlyLectures_sub to put records in the correct order to be used by VBA. Now i need to limit this query to a student name. I directly put the student name in the...

Dear plog,Thanks a lot, for your very constructive adviceWell, now I am facing a new problem,I want to narrow the result of the created table only to lectures presented by a specific student, for example "jack". So I made a Form named studentselect where I can select a student name from a drop...

Table1 Product quanity A 50 B 22 D 11 C 31 B 43 D 8 C 13 A 43 1- How can we get the following table/query from the about table. As you see the sum of each item is shown. Query1 Product...

I suppose this is a hard question and I hope you could help to find a solution, In a flower store there are two tables. Table1, goods properties and table2 showing the number of goods /products bought and sold in/out of the store. The store sells flowers in baskets, so the baskets are considered...

thank you, but i was am so naive.. can you let me know about the sql to run this query? tnx

In table1 students lectures data are stored as: ID studentname lecturesubject lecturedate 1 steve politics 3/2/2013 2 jack politics 3/2/2013 3 steve math 5/2/2013 4 steve...

and, one more question, now, when i push a button, a module is run that puts data into a table ( table1) i also want to make a query to be created on table1. can i also add a code to the same button to make both functions? i mean put the data into the table1 firstly and then run the query.

thank you all guys for your time, it is now working :)