Search results for query: *

Hello, I am trying to build a subquery/correlated subquery in Brio, where it returns all the parent records, with the child records only matching based on a specific limit. I cannot do this in the standard query based on the relationships. I have tried both correlated subquery and a regular...

I will try that. I hadn't yet, as I have learned most of this by trial and error, not formal education :) Thanks for the suggestion

Thanks for your reply. It actually runs on all other PCs, but instead of filtering through all main/sub-folders and picking up all files, It picks up the .Zip file in the main folder, then loops through all the sub-folders and only picks up all files Except .zip. On the first PC it loops...

I have compiled a VB code, borrowing some, adding some. It's intended purpose is to get information about all files in a directory/disk. Originally I used the the msoFileTypeAll, until I read that it did not always pick up .zip's as files vs folders. I added a new section to pick up zip files...

Thank you for your response. I was provided with the answer on another board. Access has a limit of 255 columns. Which is why it is cutting off where it is. I have to now find a work around. Thanks

It is consistently stopping at the same spot the 257th field out of 449 fields. The naming convention is the exact same as those above it, and the datatype is the same as well: Long String; 15 characters

I have a table linked via an ODBC connection to an Access 2003 database. There are many other tables linked thru the same dsn connection from the same datamart with no problems. However, when linking this table, it only shows half of the field list. If I look at it thru a different GUI I can...

Thank you both for your help. I am feeling quite stupid right about now. I have been out of coding for several years, into the data aspect, so I am rusty. I added this code to a module, and redirected my table to use the same name's indicated in the code above. Created a macro to run the...

Hello, I am trying to create a SQL query or VBA code in Access 2003 which will allow me to find multiple records for an order, sum the interval between the start and end dates of those records. Where overlapping dates exist, it would sum the total days from the earliest day to the latest day...

Hello, I am trying to create a SQL query or VBA code in Access 2003 which will allow me to find multiple records for an order, sum the interval between the start and end dates of those records. Where overlapping dates exist, it would sum the total days from the earliest day to the latest day...