Search results

  1. A

    Datatype mismatch in Criteria Expression error in Query

    Hi All, I have database in which I have data table called commentary table now I created a userform to input/modify data in the same table the form has 1 Combobox which contains a list of products populated from the product column of the datatable same way there is dtpicker which is updated...
  2. A

    submit the data entered in textbox to a table column

    Hi All, I have sharepoint linked table table name "table1" in my access database and a form .i.e. form1 which has one combobox, one datepicker and one textbox which are linked to that sharepoint table in the following way, the combobox is linked to table column which is product column so the...
  3. A

    How to break links of sharepoint linked list table in access 2003

    Hi All, I have around 6 to 7 sharepoint linked lists as data tables in my access database .i.e. access 2003 I them to make a local table directly with some shortcut. some VBA code or some other shortcut I know in excel 2007 there is option to make them work offline but in access 2003 we don't...
  4. A

    How to pass a column name as a parameter in a query

    Hi Everyone, I have a table in my database from which I am trying to query the data for a particular month. Now in that database table I have separate column for each month I want to come up with a query which will filter the columns and will give me only one particular month column in the...
  5. A

    Print reports to pdf

    Hi All, I have form in one of my mdb file which gets opened automatically when I open the mdb file. Now I have two combo boxes on that form first one is Region and second one is country and then I have command button to print. The first combo box gets populated with regions like USA, Asia...
  6. A

    Macro to click a command button

    Hi All, I have form in one of my mdb file which gets opened automatically when I open the mdb file. Now I have two combo boxes on that form first one is Region and second one is country and then I have command button to print. The first combo box gets populated with regions like USA, Asia...
  7. A

    how to print separate report for each record of query in access to pdf

    Hi All, I have access database with a form which gets open directly when I open the file. The form has two Comboboxes on it to select the parameters once we select the parameters we can click on the print button and then it opens the report is preview and then we need to hit ctrl + p and print...
  8. A

    find average between two dates with query

    Hi All, I want to come up with a query in which will find the average between two dates. Below is the data sample which I have : L1 L2 Retx Prd As of Date Amt ABC XYZ AFX XXF 11/29/2010 112123 IFA SDF BBS STR 11/28/2010 112841 SFS FDS KBS SDF 11/27/2010 154422 SLS SDR KSS SLF 11/26/2010 164222...
Back
Top Bottom