Search results

i have 2 tables one having primary key and other having secondary key TblA pkey info1 info2 TblB pKey_Rk info3 info4 i want a resultset having all the records present in tblA plus records in TblB (if present) pkey----info1----info2----info3----info4 value---value---value---value---value...

how to make application such that only a form is opened (not as a tab in access) just like pop up feature of a form. i have only one form in my applcaition

thanks every one for sharing your knowledge...

i have built an application , all i have is one main form and every action take place inside it. Before making it as .accde file for code protection, i want to hide table pane, navigation ribbon, the Main form Tab. i.e only Main form should open like a applicaiton and not inside access as a tab.

sorry i am not familiar with the terms, staging table means--> replica of master table ? will staging table satisfy all the relationships of master table ? VbaInet : can you please explain option 4 with through a code ... thanks

user imports data from Excel to a table but i am not sure that the user will import right data into the table. so in case a error comes due to a record, i want to cancel all the changes/updates done because of that excel file. i.e if there are 10 records to be imported and error comes while...

CJ and Namliam, as i have already informed, there is no relation b/w valuexx and valueyy so how AA gets CCC and not FFF is not related , they are just displayed for our understanding that valueyy has 2 values, CCC and FFF that must fall across c1 rows so for your example output...

sorry for the misunderstanding.. but there is no relation of AA with CCC or FFF they are just values..... for column name(Valuexx or Valyeyy) i. e valuexx is not related to valueyy the only relation the two tables have is that they have same 'column names' like c1 c2.... yes i have tried...

SELECT tablexx.valuexx, "c1" AS Heading, tableyy.valueyy FROM tablexx, tableyy WHERE (((tablexx.c1) Is Not Null) AND ((tableyy.c1) Is Not Null)); this will not yield right result what it will give is as follows : valuexx ------ Heading --------Valueyy...

let me explain what those tables are. there are two different table connected to each other by same 'column names' i want to get value's in VALUEXX AND VALUEYY from these two tables for 'c1' (lets say) then all the NOT NULL fields in tablexx and tableyy for 'c1' will be selected ... so the...

i have two tables: [ignore the dash(---)] tablexx valuexx--c1--c2---c3 .... (Column names) AA-------1-----0----1 BB-------1-----1----1 CC-------------------1 DD ------------1 EE -----1------1 FF------1------------1 . . tableyy valueyy---c1---c2---c3 .... (Column names)...

thanks for your reply's i think i will use Query now...

i have a linked table(tblxyz) having property set as ORDER BY ID DESC, ID is autonumber, so my table view gives me latest record on top. now i have a subform , where i am calling this Table..... [Forms]![MainForm]![Sub_DisplayFm].SourceObject = "Table.tblxyz" this gives me datasheet view of...

thanks ...it's a great trick..

i have a table where i am maintaining the status of the record as completed or not using Yes/No. now to generate the report i need to show (#record completed)/(#record), and there are some where clause also. can i write like SELECT [(Count(tbl_status = -1)/Count(tbl_status))*100] AS [Rate]"...

thanks JHB problem solved !! u got it right ..actually i have a subform in the mainform. the recordsource of which changes dynamically. so the last call form inside the subform was permissionFm which was getting called before the mainform. thanks JHB again can you tell me how to avoid the...

Hi i have login screen from where i am moving to my mainform using DoCmd.OpenForm "MainForm", acNormal, , , , , [Forms]![Fm_LoginScreen]![txt_UserId].Value but instead of opening form_load() event of mainform , this line is opening another forms form_load() event and then mainform form_load()...

I have a treeveiw in MS Access 2013. When I open the form with the treeview all works perfectly. After the form opens, the very first click on the Treeview does not expand the node I clicked. The very top node expands first. Then I have to click the one I want again. I prefer they all stay...