Search results

I found a solution... I made a MAKE TABLE query which copies all the unique ITEMIDs from the SQL table in a new table. Now I can make a relation between the read-only table and the editable table. I just need to write a procedure to add new records from time to time, so the ITEMIDs are always...

The recordset cant be updated. so I cant fill in the ITEMID in the 'editable' table, nor can I add comments... This puzzles me!

There is the catch. I don't want to do that. I want Access to be smart enough (hahaha). I did the one/many change. Like I described, it shows all records. But the comments field is blank and can't be changed. I want the parent child behaviour to make the necessary joint data.... Don't know how...

Thanks for your input. I went ahead as follows: I went into design mode of the SQL-linked table (I get a warning that I can't change things but still it lets me see the fields and field types). In the SQL-linked table there are two fields Primary Key, field type is TEXT. I guess this is how...

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

I don't NEED to store the path in a table thanks to that custom function I made (the less data, the better). The function looks at the article number (eg. 12345987) and "builds" the path as being I:\articles\images\12345987.jpg. The only thing I need to know is how I can build and store an HTML...

You could make a unbound field "startchar" in which end-user can enter a character, upon clicking a button, you can requery the source of the dropdown so that only names starting with the letter in field "startchar" are shown.

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

Faaaantastic Dear, It worked perfectly. Thanks for your crystal clear explanation. If you're ever in Antwerp, I'll buy you a beer or two. Greetings, S.

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

Still not clear to me try putting what as a macro where??? If I use a built-in function in my query (eg. Left(fieldname;2)), it works just fine. But custom functions (written in VBA) are a hastle to rewrite in the Expression Builder... Some of them are really complex. And I don't want to use...

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

Ranking weeks (or months) I had the same problem with months. I have a table with sales per month. In that table I have defined the month field as Double, Format: 00. That way it always appears as 01 (for january) 06 (for june) or 11 (for november). If you then sort on this field in a query...

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