Search results

  1. P

    Subforms autoupdate

    Dear All, I have a form that has a number of subforms on it. All of the subforms have the same datasource (a table) My problem is that if I insert a new record in one of the subforms, then insert a new record into another one, 2 new records will be added Could you please advise on how I...
  2. P

    Max of more fields

    Dear All, I would like to calculate the max of the sum of certain fields in one of my tables So eg. I have 4 fields, Sales1....4 If I do Sales1+Sales2 then Sales2+Sales3 then Sales3+Sales4 I need to know which one of these sums is the highest (with a query, or with VBA if possible) Could you...
  3. P

    Jump to a record based on a combobox

    This is a new Access X-files! I have just deleted the combobox, created a new one and now it works!!! Thank you very much for your help!!!!
  4. P

    Jump to a record based on a combobox

    It is Text
  5. P

    Jump to a record based on a combobox

    I did it: Private Sub CustCombo_AfterUpdate() ' Find the record that matches the control. Me.RecordsetClone.FindFirst "[Custname] = '" & Me![CustCombo] & "'" Me.Bookmark = Me.RecordsetClone.Bookmark End Sub still nothing... What do I do incorrectly? Thank you very much
  6. P

    Jump to a record based on a combobox

    Hello, I have tried it like this: Private Sub CustCombo_AfterUpdate() Me.RecordsetClone.FindFirst "[CustName] = " & Chr(34) & Me.CustCombo & Chr(34) Me.Bookmark = Me.RecordsetClone.Bookmark End Sub and still nothing happens Any suggestions please? Many thanks
  7. P

    Jump to a record based on a combobox

    Dear All, I have a simple form bound to a table I have a combobox on it and I would like the form to display the record that contains the value of the field I select in the combobox I tried the following but it does not work, nothing happens: Private Sub CustNameCombo_Click()...
  8. P

    Bind variable field to a text box

    Hello, I have already found a solution to the below, however you are right, but how can I store the data per year if I have hundreds of customers as well? The current setup is that there is a table with a record for each customer and each year new fields are added for the new year's data Could...
  9. P

    Bind variable field to a text box

    Dear All, I have a text box on a form, and what I would like to do is to bind not a fix field of the datasource (eg Result2004) to this control, but to bind a field that is a result of an expression eg. if the value of combo0 is 2004, then bind field Result2004 from the datasource, if the value...
  10. P

    Exporting to Excel without overwriting the file

    You are right, I was just not thorough with the testing Thank you!!!
  11. P

    Exporting to Excel without overwriting the file

    Dear All, I would like to export a table from Access to an exisitng Excel file to a specified worksheet I tried DoCmd.TransferSpreadsheet but that command overwrites the whole excel file How could I make Access overwrite only a worksheet in a workbook and not the whole workbook? (or even a...
  12. P

    Append remote database

    Dear All, I have a database uploaded to a Sharepoint site and I would like to run an append query to insert records to that database Here is the SQL code: INSERT INTO tbl_body_main ( RegDatum, Branch, Nev, PersCode, Date1, Date2, Sorsz, KonyvKod, CC, SzlaCC, Típus, Költségcím, Ossz, UanyagL...
  13. P

    Suppress error message on close

    Thank you very much, it works perfectly!!
  14. P

    Suppress error message on close

    Dear All, I have a form that has controls that cannot be Null (these rules are set as Form BeforeUpdate events) I have a button that has a docmd.close code On Click The problem is that whenever I click this button with certain controls being null I get the error message that I need to fill...
  15. P

    Increase field value incrementally

    Dear All, I have a field in a table that needs to get updated incrementally when a new record is opened in the table The first value needs to be 1 then for the second record 2 etc etc (integer values) I know that there is an AutoNumber field type but that does not get reset when data is...
  16. P

    Compare fields from two different databases

    This works perfectly!!! Many thanks!!! :)
  17. P

    Compare fields from two different databases

    Dear All, I have two databases with one table being the same (ie. same table name, same field name) and contains only one record How could I compare the content of those records (record has only one field) without linking the table to the database? I started to write a code but I am stuck here...
  18. P

    How to write field values next to each other?

    Thank you very much!!!! The reason is the same as dcb mentions, data needs to be transferred to another application Many thanks again!
  19. P

    How to write field values next to each other?

    Anyone else could help with the code please? Thank you very much in advance!
  20. P

    How to write field values next to each other?

    I am attaching a sample database, it contains the "before" table and the "after" table that I would like to create either with the help of SQL or VBA I know that doing so the table will not be normalized, but still for me it would be very important to do so ;) Many thanks in advance!!
Back
Top Bottom