Search results

  1. P

    Button on two Forms

    Not sure if this is correct in the FORM area. I have two different forms. Want to a particular button from one form to another form. The button has the same vba code. However, on the original form the button runs with the vba code, but if I copy the button to a different form with the same...
  2. P

    Multiple Column Calculation Issue

    I have a query which displays "WEIGHT_VALUE" of a particular order in a column and the value is appended to a table later. Next to the column I have two columns called 'nr of cartons' and 'nr of pallets' Can I somehow have this table automatically adjusted to state the following: If weight is...
  3. P

    Form Click Button Issue

    I have a database when I click on a button it transfers data from a table to an excel sheet which has two tabs. The original database and button works. Database is in the same folder as the excel file. Now I created a new database and copied the same vba string command and now it is telling...
  4. P

    Short Text -> Long Text

    Hi, Any idea why the Data Type changes automatically from Short Text -> Long Text for a particular field. Even if I change it back manually and save it over and over it still changes it back. Rgds, Daniel
  5. P

    Querry Issue - No Refresh of Existing Table

    HI, I have a query running which creates a table. It automatically refreshes / runs the query every 5mins. it adds new data, but it doesn't seem to update data as I have orders which are created with status "Normal", but still have the same status after being shipped. The status should turn...
  6. P

    Listbox Issue - Current System Date

    Hi All, I have a Listbox and I would like to only display the orders which have been created and shipped on the current date (sysdate). In the table / query I have the ship date and time in one column. Is there a way I can alter the properties of the Listbox to only take orders which were...
  7. P

    Form Issue

    Hi All, question. when working in the design window of a particular form I can align all text boxes and buttons to look good. However once I open the form, the alignment is not correct any more. Also when I move the navigation pane left to right and right to left the alignment also is...
  8. P

    Report as Attachment in Outlook

    is it possible to click on a button in the form, enter a reference number and this then generates the report from Access 2013 as an attachment in outlook opening the mail with the file? PDF perhaps?
  9. P

    Setup Search Windows in SubForm

    Hi, I have a normal Form window Where I click on a Button and it creates a report for me after I enteredFrom it into a Parameter box which appears. At the moment it is in the preview which I can printer manually. Can I create a subform with a search function where I enter the exact same...
  10. P

    Hello from Germany

    Hello Name is Daniel and I am from Germany
Top Bottom