Search results

Hi, I created a delete query based on a duplicate query. For some reason access tells me I can´t delete the records when I run it. Has anyone had this problem? I´m sure I´ve done this in the past several times. thanks Fuga.

Hi, I´m trying to create an append query that I need to append only new records. This is done on an hourly basis, which means that the date should be an inner join and the hour should be an outer join, right? However, access can´t handle this so I need help. If I do an append at 12 today, the...

Hi, I´m trying to execute an update query on a table that's in the db. The comparison records, ie the ones that are not supposed to be updated, come from a linked text file. Access is telling me that the isam doesn´t allow update to linked table, but like I said, that´s not what I´m doing...

Hi, I´m going to include a real monster of a table into an already large database. The table will hold at least 10 million rows, provided it fits with access limitations. One of the fields is a date field, and I was thinking of turning it into an integer to save space and gain performance...

Hi all, I´ve had this problem for a while but it only just recently became very annoying. I have a chart on a form displaying data over time. I´m using two comboboxes to select start date and end date. There are A LOT of data in the underlying query. However the problem does not seem to be...

Hi all, I would like to have a function in an access query showing the slope of a trendline (the linear one in excel). Do you know how to create it? Fuga.

Hi, Is there a difference between the statistical functions in access and those in SQL server? For instance, is there a median function in SQL-server?

Hi, I´ve linked an excel sheet to a table in my db. The sheet contains some statistical functions. However, the value of those functions do not link properly. in stead I get a #num! in those columns. How do I link the value of those formulas? Thanks Fuga.

Hi, I´m trying to build an application for my db. I´m using a datagrid control and I want the Autonumber field(PK) to work. As of now, the field is not incrementing numbers, making it impossible to add records to the table. What do I need to do to make it work lika a table in Access? Should...

Hi, I´m using the open for append method to write to a text file which is then converted to an xml file. I loop through some lines in excel and for each line I´m writing it to the text file. The problem is every string begins with " in the xml and ends with the return character. This means...

Hi, I´m thinking of building a program in VB that uses an access db for data. what programs does the user need on his computer? Does he need access? How should I distribute the application? Fuga.

Hi, I´m developing my first web page using visual studio. I have connected to an access db, and it works fine. But now I want a text field that can display blank rows, so that the user can identify sections in long texts. I´m not at all used to having text fields to deal with, so this might be...

Hi, I have a graph which uses the value of two combo boxes for beginning and end parameters. In order to work, the datevalue() function is used. When i design the rowsource, it works. But when I exit Access and open it again, it doesn´t. Then the rowsource is either wrong or too complex. What...

Hi, I´m having trouble with an automated process. First, access exports a table to a text file. Second, excel opens the file and runs a macro on a workbook that contains linked data to the file. The workbook is linked back in access. A few days ago I started having problems. Sometimes the...

Hi, I´m trying to pass a variable (integer) from access to excel. I´ve tried both public and global in the declaration sector of a module, but it´s empty. I´ve tried searching the forum but I couldn´t find it. I suspect it is a fairly common question. Fuga.

I´m trying to create a report. I have a few questions: 1. I´ve understood from this forum that there is no automatic table of contents function like in word. Is this right? 2. You cannot export your report to word if it contains charts? So you have to create your own table of contents? This...

Hi, Is there a way to have the same printing options for a chart in access as in excel. I need to be able to print in high resolution. Fuga.

Hi, I use a few combo boxes on a form, and I would like to make them look better. Is there a way to change the way they look, apart from the obvious stuff? Are there som themes I can download? Fuga.

Hi, Is there a good developer tool for turning an access db into a webpage? Or should I go about it in a completely different way? I want it to work just as it does, but I would like to have it on the www. Fuga.

Is there a way to have a picture with a clipping path on a form, so that you could have, say, a round picture? Fuga.