Recent content by hamidreza.sajjadi

Wouldn't it better off if a create this said table with select query ? Would you mind taking a look at the file for me? in my access file there is only one empty table and an empty form with vba code

not necessarily. for example i can create a select query by which i can filter out the results which have Dcount>1. raw idea

good idea. i also have considered using a complementary query by which I can group records or use some Dcount ac criteria. but i am looking if a VBA Based solution could be exist.

thank you very much for your respons. sorry but i am a kind of naive in vba. in your first code, should i create T1Only Table with subquery? because i don't have such a table with uniqe rows.

would you please explain in more detail or refer me to some articles about it? i can't use a normalized table as a row or control source for my form. it is matter of making simplified data entry form for users. @Pat Hartman

yes. but you know? there is big problem here and it is that users are not supposed to enter year and month for each sales prediction!. for example if they are predicting sale budgets for 12 months, they are supposed only to minds entering the sales value, not months names and at the form there...

I have a data entry form in which there are two text boxes named "NameTxtBoxAt1" and "NamesTxtBoxAt2" . I have wrote a VBA code which gets value stored in them and then insert them into table "UnpivotedName" in column named "UserName" along side with constant value of "1403" in column Year. the...

hello. I have designed a sales budgeting system using "MS Access" in which users can assign sales Value in addition of sales price for different months along with some other functionality. Here is the schema of the main table (tbl_SalesMonthing) over which numerous forms store data. As it is...