Search results

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

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

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?

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?

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

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

What's... What's AFAIK?

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

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

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.

Where can I find good tutorial VBA?

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.

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

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

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?

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.

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

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

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?

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