Search results

Thanks for your reply. The developer passed away. A professional stable long term solution is being looked for but that will take time. In the meantime the application needs to remain functioning. There are 10 instances running of more or less the same application but there seem to be some...

Dear forum members, I inhereted 10 similar non splitted databases (A2013) of which I'm told they have differences in code and form design, not in tables design. My idea is to split all db's and create one generic frond end. I've looked at some tools to compare the 10 frontends but those are...

Wow, amazing how you did this! I don't understand exactly yet, but I will study on it. Thank you. John

Thanks, I wil try and see if I can adjust it so it will work per customer ID. Regards, John

Simplified, I have the following table: ID Registration* (primary key) ID Customer Registration date Registration type so where a customer can have 1-n registrations. I'm now looking for a way do calculate the average number of days between the consecutive registrations per customer, which of...

Sorry for late reaction. Although the True value works, your query doesn't give the right result. From my earlier post: "I want to make a selection query that gives me all persons (period) and.... the relevant addresses (that is: where the field Current is Yes)." With your query I don't get...

Thanks Gemma, NFK, I was aware of the Boolean value 1 in stead of -1. But that has no effect on solving the problem. Seems there's no other option than to use the extra query. John

Thanks but not sure I follow. The field Current is in the relation table and not the address table. b.Current doesn't seem right then. I tried the two LEFT OUTER JOIN's but then I get no records at all. John

Sorry, I'll try to explain with a simplified example. Table Person IDperson* Name Table PersonAddress IDperson* IDaddress* Current (Yes/No) Table Address IDadress* Street City I want to make a selection query that gives me all persons (period) and.... the relevant adresses (that is: where...

Hello, I have table A which is linked to table B via an additional link table AB. I'm trying to make a query which shows all table A's records but only certain table B's records which meets criteria that are set in the query in table AB's fields. If the criteria are not met, I get no table A...

Hi again, I have an additional question to this thread. Since I'm counting open orders per month I can't just add the rows' and column's values to get the total number of unique orders per city for one year and the total number of unique orders per month. I'd count orders double. Is it somehow...

This is about the table width and not about column widths. I'm working on a reporting application which imports data (there is no data entry) and presents them to the users via queries and reports. To build the queries and reports I often have to check the content of multiple tables. It's not...

Thanks CJ. John Spencer has a point, although I'd like to have this feature as well. John

When I open a table it gets automatically sized in relation to the Access application window. I would like some tables to open smaller (less wide) as they have for instance 1 or 2 fields. I can resize them manually but I can't find a way to save it. I hope this is more clear. Thanks.

Hello, Is it somehow possible to save a table's width while in table view in A2003? I tried several things and can't find it on the internet. Thanks in advance, John

Hi again, It took me a few hours but I got it working with your solution Plog. Even without VBA. Thank you very much! I can also use the dynamic report field naming like in the example of FMSINC. See below for what I did. Bye, John 1. Create a standard report month range table from 2005 till...

Thanks Plog and namliam for quick response! I have to process this the coming days and experiment with it to make it work. I'll post back my results.

Dear forum members, I need to make a report which shows the number of open orders (based on Orders fields Order 'Date Start' and 'Order Date End') per month, for 12 months (based on user input date). So, for example, the question is: how many orders were open (in progress) in september 2014...

Hi all, I'm a reasonably experienced Access user with a current focus on analysis and reporting. Hope to talk to you soon! :) John