Search results

But how can I format a number entered into table using query based on another field I select? I now use this formula in my query: http://www.access-programmers.co.uk/forums/showthread.php?t=144666 But perhaps I can force access to do this: If I enter 0,5 and select kilogram it changes my...

I was thinking too complicated, I just needed to set format to currency in the Query Columns property sheet...

I have a query that calculates a sum like this: Sum: [table1]![field1]*[table1]![field2] I would like result to have 2 decimal places. I tried to use formatnumber like this: Formatnumber(Sum: [table1]![field1]*[table1]![field2];2) But I get syntax error. please help with the correct formula.

I use formatnumber formula to calculate in my query This is what I use now. My fieldsize is double, decimal places 3, Format general number. I use this to convert a value I enter into table to a proper case like 1 is for a pieces I enter number like 1 and get 1 2 is for a kilogram I enter...

Decided to post my sollution please do not hesitate to comment: To check the checkbox automatically add a save record button and befor save command like paste this line of code: Me.Sold = True Sold is the name of checkbox. To show correct record count add a textbox to form and set...

I tried to make default value to YES but the I get error. Anyone can have alook at this ?

Just remembered to implement this sollution in one of my projects and got a few questions: See form and answer these questions? 1.how to make SOLD checkbox default to TRUE when I fill new record? 2.Why incorrect record number is shown below? I think I need a code to check the sold checkbox on...

I'm building a report from multiple queries and get error that a field may refer to more tables. I wan't to make a report that gets data like this: Table1 field1 date1 Table2 field2 date2 Table3 field1 Table4 field1 filled by table1field1 lookup field2 filled by table2field2 lookup field3...

anyone ?

I was talking about not phisical goods, about a service. This DB should be used with online services. If someone orders service but fails to pay for it you do not need to keep his record in DB to begin with. Otherwise the DB will get larger and larger.

Yes I'm trying to keep intact sequence. The dates will be fine I think because each invoice needs to have a date when order took place. ID 1 invoice 1 will have date 2008-01-01 2 invoice 2 will have date 2008-01-10 3 invoice 3 will have date 2008-01-15 5 invoice 4 will have...

Yes that is the line it is painted red and shows syntax error: Set rs = db.OpenRecordset("SELECT Max(Mid([Pinigu priemimo kvitas Nr:],5)) AS MaxNum FROM ppk", dbOpenDynaset) If I write it on one line like this: Set rs = db.OpenRecordset("SELECT Max(Mid([Pinigu priemimo kvitas Nr:],5)) AS...

Replaced the line you said and got syntax error.

Thanks, for your help everyone

So went to my form and clicked on "Recordset source" then pasted your code: SELECT Max(Mid([Pinigu priemimo kvitas Nr:],5)) AS MaxNum FROM ppk But now the form is not working at all:confused: When I try to use the form I get Error: You can''t go to specified record.

Well I'm just making some invoice billing system here. If a client purchases some goods like: 1 chocolate 2 carrots etc..... All items using relationships are bound to an invoice with a unique number like INVOICE-006 I use auto number field in my invoice table Then I use actual Invoice...

You mean it can search 5 records back and select max value? Could you please update the code above cause I tried to fix it myself and it did not work for me. Thanks

You understood me wrong I need to increment other field in table not autonumber

found a solution here:http://support.microsoft.com/kb/209830 Now need some help to modify the code I posted my question at VBA section if can help please do. http://www.access-programmers.co.uk/forums/showthread.php?p=674257#post674257

Hi, I need to update this code to check if there are no first records (table empty) it should create it. Now it gives an error that it does not find first record and stops if table has no records. Function FindMax() Dim db As DAO.Database Dim mx As Integer Dim rs As DAO.Recordset...