Search results

  1. D

    Calculating total prices only for specific records

    Here... Here's my SQL for this query: SELECT tblUvoz.intUvozID, tblUvoz.dteDatumUvoza, tblSpediter.txtNazivSpeditera, [txtNazivProizvodjaca] & " - " & [txtNazivModela] AS Auto, tblAutomobil.intCenaModela, tblUvozAutomobil.intKolicinaUvoz FROM (tblSpediter INNER JOIN tblUvoz ON...
  2. D

    Calculating total prices only for specific records

    but I don't use spaces in my field names these are captions for better display. When I tried this syntax acces throw syntax error missing operator at me. Can you explain this in little more detail? I've never seen this construction of SELECT statement
  3. D

    Calculating total prices only for specific records

    Look at this query: I wan't to calculate the price totals but for each instance of Uvoz ID separately. I've sucessfully used Dsum function but I managed only to calculate all price totals for all instances of Uvoz ID. Is it possible to do it for each number of Uvoz ID separately? How do I do it?
  4. D

    Controling the Deletion of records

    Yes Yes, thats one of the possibilities and it's interesting, but I wan't to know how to do this the way I wanted because I need to do it that way. Thnx P.S. - Does this has something to do with the way Join type in the relation is specified?
  5. D

    Controling the Deletion of records

    I have two tables which are connected with one to many relation, here are these tables: tblCars PK. intCarID txtModelName intManufacturerID intModelPrice...
  6. D

    Edititng Pages For Switchboard

    Hi. I used Switchboard Manager in Access 2007, and created couple of pages and made one of them default. When I start my database it opens the default page of the switchboard but I cannot access other pages. I tried putting some buttons on the default page and creating some navigation but I...
  7. D

    Access 2007 Add-Ins

    What's... What's AFAIK?
  8. D

    Access 2007 Add-Ins

    Well.. I don't need anything specific yet, I'm just asking because I don't know. Thnx for the Info.
  9. D

    Access 2007 Add-Ins

    Can someone tell me which add-ins are there for Access 2007 and where can I find them?
  10. D

    Load Specific Form on Database Opening

    I have a main form in my database which holds buttons that open all other forms, what must I do so that form can open each time I open that database? I saw this in a other database I have but couldn't figure it out. Thnx.
  11. D

    VBA Programming Tutorial

    Where can I find good tutorial VBA?
  12. D

    Adding Data to a Refference Table

    Oh, no... Oh, sorry, :), the # sign represents the primary key field (I mark it that way when I create database on paper), I forgot to specify that. Thanx for advice anyway.
  13. D

    Refering To Another Table Field

    I have a form in which I need to calculate total price for the selling car. I'm ccalculating by this formula Total=intCarCost+[inCarCost*(intTaxRate)/100]. My intCarCost and intTaxRate are fields from other two tables, tblCars and tblTaxex. How do I reffer to those fields, I tried various...
  14. D

    Table on a From

    Yes I tried that, man, and I got another form but only this time its tabular, but I don't want another form to enter data, I wan't a table just to view all the data. All the tables I created so far were displaying only one record (depending on which record page I was) I want, no matter on...
  15. D

    Table on a From

    Yes Exactly like that. The only difference I had in mind to do it in Tabular order not stacked if its possible. How do I do it?
  16. D

    Table on a From

    No.. No thats not it, I want to display data not to enter, I have for entering. If you built Admin areas for Dynamic applicatins you know what I mean, a simple table that will show up on form and hold and show all the data (including those I enter) in it.
  17. D

    Table on a From

    Clarifying Ok, Imagine that you have a form from where you enter data in one of the db tables, now you wan't to go somewhere beside the tables and queries to see all the data from that table in one place. So, can that data (from that table) be displayed (in table like manner) on that form? Was...
  18. D

    Adding Data to a Refference Table

    Hi I have a refference table in my database which is connected to two tables. These tables are: tblCars #intCarID txtModelName tblSaleLine - Refference Table #intSaleID #intCarID intQuantity tblSales #intSaleID dteSaleDate Now, I have forms for entering data in tblCars and tblSales and I...
  19. D

    Table on a From

    Hi. I have forms for each of my tables to enter data in tables. Can I and how, build a table on a same form where I'll be viewing all the data from that table that will be updated each time I enter a new data?
  20. D

    Combo Box orList Box

    Ok.. Ok, I'll use a combo box because it looks like selection menu and doesn't take too much space, but what about my other questions? Also, I want to create links on forms to other forms, I done that sucessfully but I want to add a fancy rollover effect like HTML Hyperlinks have, can I, and...
Back
Top Bottom