Search results

Hello forum, I just can't seem to figure this out... I hope I explain well enough for you to help me: I have an access 2007 database which shows data from an SQL server (via ODBC) in a LINKED table (so not imported). I do not have write access to this so it only reads data. I would like to...

Hello, I noticed my subject has been discussed numerous times in this forum. I must have read nearly all topics, but I simply can't get it to work. I have a table listing: country | category | article | turnover I wish to make a query which gives me: country | sum of turnover | count of...

Hello people, Sorry for the lenghty post, I wish to be clear to get a fine answer... I have a database with all our company's products (more than 2000) and a wide variety of related data (quantities sold, purchase price, ...) Each of our articles have a photo somewhere on a server. Since I...

Hello people, Sorry for the lenghty post, I wish to be clear to get a fine answer... I have a database with all our company's products (more than 2000) and a wide variety of related data (quantities sold, purchase price, ...) Each of our articles have a photo somewhere on a server. Since I...

Hello Forum, I have a table which stores sales results per month. There is a field YEAR and and a FIELD month. But sometimes I want a query to give me the results per QUARTER. To define the quarters, I am able to do this with a Totals Query, by using the following formula: Quarter: [Year] &...

Hello people, Subject lines are usually cryptic, so I'll try to explain my problem in a lot of detail - don't be scared by the length of it :) My company has lots of articles grouped in families, stored in a table Article sales per month is stored in a table. table 1 (the one with the...

Hello team, My database window is hidden. I have a form with data about an article. When I click a button, another form opens showing a sales graph of that article. On the form with the graph, I have put another button to print it. The code behind that button is: Private Sub...

Hello all, I don't know if this should be in the Access or the Excel forum, but I'll try my luck here. I have an Access Database in which I made some custom functions (for example "weeknum(date)", which formats a date as yyyyww (year + week). I have a query in Access which uses this function...

Hello all, I have a table with article references and the absolute path to a picture of that article. For example: article 72812 has a picture on our server named: s:\pictures\72812.jpg I want to export this table (or a query on it) as an html document so I can view it with MSIE. But instead...

I have a database with a switchboard form with buttons that lead to other forms but also to some standard queries that I have defined and saved. From time to time I wish to create a different query (on the fly). I know I could just click the “new query” button on the database window but I have...