Search results

  1. K

    Correct Syntaxt for Data Access Pages

    Hi, I am trying to create my first data access pages so please be patient:o I was able to successfully create an access application and now am trying to generate dynamic pages out of it. Why this is not working? Upon change one field, reload the query on the other field... <SCRIPT...
  2. K

    How to safely deploy an access application

    Hello, I've finally finished an Access application and now am having trouble deploying it for multiple users... There are 2 types of users, each type should have different permissions. Data Entry group should be able to add/delete and edit records. Costing group should be able to only read...
  3. K

    Event - Next and Previous buttons

    How to have code when next and/or previous buttons are clicked. I am trying to refresh data in a field every time the next or previous buttons are clicked.
  4. K

    ON VB, How to call the result/value of a query

    When I try to prepopulate a text field with the result of a query, I get the query string and not the result of the question. How to load the answer in a text box? ********CODE BELOW************* Private Sub DestinationList_AfterUpdate() Dim db As DAO.Database Dim qdf As DAO.QueryDef...
  5. K

    Refresh Combo Box (Drop Down List)

    Hi, I have a combo box in which it's value changes according to user input. It is working but it is annoying to have to click the combo box for it's list to refresh. How to make it seemless? Thank you
  6. K

    How to call Form values in a SQL Query

    Hi, I need to build a query where upon form input a different table gets queried. SELECT * FROM ((Forms!DCL!PortDropDown)) WHERE ((Forms!DCL!DestinationList=(Reg_Dest.Destination))); The "FROM" is my problem. The "WHERE" is working. I am getting a "SYNTAX ERROR IN JOIN OPERATION" error...
  7. K

    Pre-populate combobox according to user input

    Hi, I have 2 dropdown menus. The main one "Regions" has a list of continents. And the other will display list of contries in that continent. I want to have a different list available according to what users choose on menu1. If they choose Asia, the 2nd dropdown would list only Asian...
Back
Top Bottom