Search results

When I run this query I get an error message: TRANSFORM Count(tblZahtev.txtSkala) AS CountOftxtSkala SELECT [tblMestaPohadjanja].[txtMestoPohID] & " - " & [tblMestaPohadjanja].[txtNazivMesta] AS Mesto, 0000 As SortOrder FROM tblMestaPohadjanja INNER JOIN (tblDete INNER JOIN tblZahtev ON...

Thanks again for the advices. Cheers.

Here's the scenario. I have a table that is populated with data. In the meantime I've added one (and maybe I will be a couple of more fields). I tried using some of the import/export features of access, and the one that really worked was with excel (I tried append data option but it didn't work...

I've created an .asp web page http://users6.jabry.com/mcdhappy77/index.asp that holds the current date in the html table. My idea is to import that that when resides there when You open the page, and then do some comparison with it. When I choose import XML option and then type website address...

On both machines the location where the database was is in trusted locations. I solved the problem. The problem was that I needed to compile my code before making .accde. I don't know how could I oversee this. Thanks.

Thanks David for such thorough explanation. You mean composite PK consisting of two fields where one part of PK is, lets say, autonumber field, and other could be number which identifies from which user the data comes. For example: 0101 - first record from first workstation 0102 - first record...

Will replication encounter problems if the users on two locations only add new records, not edit the existing ones? I think that users won't be adding records with the same data in it. What do You think? Thank You

I tried using this code http://www.access-programmers.co.uk/forums/showthread.php?t=177441&highlight=disable+shift but it doesn't work in my database. Do You maybe have some other code or am I doing something wrong here? How do You check if runtime mode is being used? Thank You ================...

I've tried this code, and it connects the BE that is password protected and that was what I was looking for. What I noticed is that when I open it the second time I'm getting error message, that Table already exists. That is true, but I want to know what would be the right thing to do about...

If I understand this code correctly, if I would want to link more than one table from the back end I would need to call this function that many times and each time provide table name for different table? Where In my front end database should I put this code? Maybe in On Load Event of the form...

You are right. When I moved them it works. I've solved this problem by passing the values from form to report and then storing them in controls. When I run this query I get an error message: Syntax error (missing operator) in query expression 'tblZahtev.txtSkala UNION .... up until .... FROM...

Are You talking about Office or Access SP? Where can I see which version of Office (Access) I have and where can I get the latest SP ? Thank You.

I've created this with controls on form that are calculated fields. When I try to create a report from that form the report doesn't show totals. Here's what I mean: So, the form works but the report with same settings doesn't: As You see the controls on report are set the same as those...

That also came to my mind but I wanted to ask if there is maybe a way to do it all in the query. Thanks Banana ;)

No, I don't have jctPlacesVales. What does jct abbreviation stands for? Here's what I've created using the design view, not wizard: Here's the design view of the query: And here's the SQL code: TRANSFORM Count(tblZahtev.txtSkala) AS CountOftxtSkala SELECT...

I'm gonna show the picture of what I need and then I'm gonna explain and ask a question(s): So, I need to create form (table) that will count how many Values are there for each Place. Values are stored in tblValues and there are six of them for now but that number might increase in future...

It works, thanks Bob ;)

I have a split form with a combobox. How can I filter the records displayed in a form based on a combo box selection? Can someone explain how to build this mechanism and write a sample code? Thank You

I have a very large query that JOINs 3 tables and I was thinking that maybe I could split it into two queries, one will hold all the data necessary for some VBA calculations and the other will hold some descriptive data that will only be used for reference. The both queries will have one PK...

It means that I have two HDDs, one is 640GB and one is 80GB. On both HDDs is installed Windows XP SP2. 640GB HDD is my main system which I use for every daily work. 80GB HDD system is a system which I use to install and play games on, and sometimes test something, like installing a new...