Search results

there are different users....for each user i will be storing these information on monthly basis i have one main form from where user will select the month. this will trigger a new form , where based on the selected month, number of rows will be shown (28/29/30/31).. each row is basically...

Hello i have a sub form, to which i am assigning (control source) a datasheet form, - i want to some columns to be of different back color, i am trying to put some back color, it shows in design mode but doesnot appear in datasheet any help !!

i have two table A , table B table A has ID(primary key), dept, .... table B has ID(Primary Key), type, date.... let say i have dept as D1, D2, D3 in 10, 20 , 30 numbers in table A ie count(D1) is 10.... table B might have a certain record corresponding to ID in table A let say it has 1...

i have a form which displays 2 charts, i am able to export them to word document but i donot know how to paste them one after the other. currently they get printed one over the other. here is the code : Private Sub cmd_Print_Click() Dim MyChartObj As Object Dim MyLineObj As Object Set...

i have continuous form having a source as table A. when i click a displayed field value from the table A in this form, a pop form is opened (by passing the Primary key) which displays all the details of that record from the same table A. Now i have a one more button on this popup form , which...

i have 5 departments DeptA,DeptB,DeptC,DeptC,DeptD,DeptE i have one material MAT1 now i have a form where i am setting some task, FROM date to TO date for the MAT1 in DeptA. after some days other user can also set FROM date to TO date for the MAT1 in DeptB. similarly other for other...

i have a mainform which has a subform. i am changing my subform dynamically using Me.objSubform.SourceObject = subformname i am using a resizing code suggested by ken getz in the form_open event of mainform on changing screen resolution everything in mainform changes nicely, but subform...

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

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.

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...

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)...

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...

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]"...

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...