Search results

Many thanks Paul. I really appreciate you taken the time to look at my issue and to confirm that my DB is stable in both 32bit and 64 bit environments. Cheers jon.

Sorry Paul, in my haste of typing the email i probably didnt explain myself correctly. They have not tested my DB out its from experience they have had with a different cad program that used a database. so theroefer i assume that database they used had script like declare sub, declare function...

Hi Paul. Thank you. I have never tested the database in any other environment other than 32bit. so am i right in understanding it opens fine in 64bit then? do i need to make the corrections, i.e. End If, End Subs for them to work in 64bit? I think there are some statements that are redundant...

Hi Paul. I have re-checked the vb file in comparison to my main DB VB file and it appear much shorter. is it possible you could check the main DB for compatibility as im not sure if when i deleted the queries and tables that i deleted most of the script.

Hi PR2, Sorry I haven't been in touch before now. I had taken a long weekend. I hae ripped out all the tables and queries and attached the DB in a zip folder. If you do get the chance to test this in 64 bit. that would be great.. can you also advise what Access version you are running too...

Does it make sense that when I have searched declare sub or declare function that I have no occurrences?. Sorry I am basic skilled on MDB so my apologies for my lack of understanding. I will keep on with it and investigate further. many thanks for the advice

I think I would also benefit from setting up with the if else directive as i will be the person responsible for the initial setup. I have just checked through parts of the design and queries and cannot find reference to kernel 32 libraries, can you please indicate where I will find this. many...

Many thanks PR2. I am so confused now. I am far from an MS ACCESS Expert. Good old MS does it again. Im glad I didn't instantly cast doubt over what the guy was telling me in the meeting in Germany the other day. They suggested they struggled that much with it that they completely changed...

Hello all, In the company I work for we use an AutoCAD package that has a pluggin called CADWorx that simply transports information to an access database. As we are an international company and have partners in Germany we are currently going through an integration process to ensure everybody...

Hi Red Alert I have posted a part of the database including one table a query that pulls the info from the table in a manner that I want then the query and and the generated table. The Cad Package uses the table Component valves as a link from that table i run a query that pulls out the exact...

Hi Redalert, unfortunatley it does filter the count even further. I have had a play around with different parts of the string but cant seem to find a way of adding any additional fields without them being grouped. Is there a way I can create the table with only grouping a few fields of the table..

Hi RedAlert I Just have one additional question is it possible to add extra fields to the output table that are not a part of the grouping. i.e. my original table shows description, connection, manufacturer and model. Therefore if i wanted it to display all fields these fields in the output...

Hi Red Alert, That is excellent. I have just added the code with all the relevant fields as per my table and it work great. Many thanks again. jon

Hi Red Alert, Many thanks for the response. I think I kind of understand the query. If I was to give you an example for you to look at it may give me a better understanding. The original table is called "General Valves" in this table I have have Tag, Description, connection, etc. Now tag...

Hi All, I am using a software drawing program that intelligently link information from a drawing to a database and vice versa. I have many tables and queries that I have created over time that enable auto populating of tables, creation of tables and so on. All of which enable me with tabular...