Search results

  1. H

    need to populate column based on combobox

    hi, i need automatically input date into separate column based on combobox selection. like , i select option "ASKED"= column "ReqDate" will fill up by present date. if i select opiton "Sent"= column "SentDate"will fill up by present date. ----------- please see the attachment for ref. thanks.
  2. H

    Query for latest date based on ID from another table.

    hello there, I am facing a problem while using query option. I need to get a result based on the latest date it will show me the job status. the product id came from a different table. Here the access sample database is attached. I need the result shown in the image but the result is not coming...
  3. H

    Multiple use of same combobox on the same form

    hi, i have a Form which contains some objects like Combobox, subform and Option Button Frame. i have written some code for this object. now these objects are working for data entry now i need the same object for data searching. please see the image attached.
  4. H

    Need a report based on filtered subform

    hello dear, i have some combobox which shows the column shown into the subform. i can filter the subform using the comboxes. now i need to build an instant report based on the current filtering. i can filter more or less. but i need the current position of the subform into a report. please see...
  5. H

    Need a delQuey based on subtable

    hello there, i have two data tables, one is depending on the other. now i need to delete the main table row depending on the subtable row if it is null. please see my attachment. :banghead::banghead:
  6. H

    Smart Filtering my subform

    hi, i have got a problem about filtering my subfom. i need a filtering system using combo box. the whole data of the table will be shown into the subform. and each combobox will populate each column of the subform table. i have given two attachments for instance. here the first combobox...
  7. H

    Filter my subform by updating combo box

    hello, i have a table contains 5/6 column. now i need to filter the table on a form randomly. suppose i have 6 different combo box for 6 column. Now on the sub form the control shows the whole table. i this case i have clicked the 3rd combo box, then it will show the whole column in its list...
  8. H

    Need to make a puzzle

    hi, i have a table that contains two field one is Fruit Name and another is Person name. i have attach the .accedb file. i need a form that shows the Field value randomly and while i click on the same ID value it will show green color or disappear. and every time when i clicked on the change...
  9. H

    Control form Command Button based on subform

    hi, i have some command button and some combo box on my form and also a subform. the subform contains some field. the fields used to enter numeric values. i need to disable my command button on the form based on the subform fields if they r null. i have enclose an image for easy...
  10. H

    need to lock button based on subform

    hello guys, i got a problem about form designing. i need to disable my Close Command button while my subform Price cell is null and enable the Delete button. and while delete button is pressed the delete action occured and close button enabled.
  11. H

    load my form on start up while hide everything...

    hi guys, i need to load my Default Form at start up of my database while office button,the Ribbon and the Navigation pane will be hidden. And when i go to form design view then i can use the ribbon and navigation pane please help me.:banghead::mad::banghead::mad:
  12. H

    Ribbon + navigation pane lock/Hide on loading...

    hi guys, i need to hide/Disable my ribbon and Navigation pane on loading. And my default display form will shown on loading. And off course a Security Warning!! shown on loading that Disable some of my content and my code. I need to stop the Security warning. and when i give Password to my...
  13. H

    Security Access Db..

    hello guys, i need to secured my access database through Code. How would i do that. i have several forms and i wish the user only can see those forms. they cant enter into the design view or any table or any where. and off course the navigation panel should be locked by code and ony i can enter...
  14. H

    Linked table Concatenation prob...

    hi guys, i have got a problem. Can anybody help me. :banghead::banghead: i need to Concatenate a fields data into one cell in a query according to linked table ID.... i m giving my project for instance. pls help me.:(
  15. H

    Edit record in form.....

    hello dear, i got a problem in making access form...... i have two lists which has the row source from different interlinked table now in the same form i need to select "ListBox" and the data of table will be shown in "Unbound"TextBox and then i can edit it and OnEnter the value will be changed...
  16. H

    Delete Command Button Prob

    hi, i got a problem see my attachment. i need to work my Delete Command button. Please help.
  17. H

    New Member

    hello, i am newly joined member in this group. In practical i am a hobbyist. learning ms access is one of my hobby. i got some problem and search the net to solve it and then i found this forum. this is because i have joined here to solve my problem. can anybody help me to solve my...
Top Bottom