Search results

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...

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...

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!!!!

It is Text

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

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

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()...

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...

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...

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

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...

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...

Thank you very much, it works perfectly!!

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...

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...

This works perfectly!!! Many thanks!!! :)

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...

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

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

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!!