Recent content by GODZILLA

The links are for Excel to access data links. When i open one of my workbooks on a different computer they do not like the datalinks as the odbc connections are not avalible. My plan was to set up the links via an app installed on vaious base units.

what a cracking site. I will have a look. Thanks

Hello, I am looking to build something to map ODBC connections on a few computers. I found this: Option Compare Database Option Explicit 'Const ODBC_ADD_SYS_DSN = 1 'Add a user data source Const ODBC_CONFIG_SYS_DSN = 2 'Configure (edit) datasource Const...

Hello, I am in the process of ordering some software to enable us to print reports etc from access to PDF. What i am looking to do is print reports from Excel and combine different excel SS in to one main PDF. I know there is the feature to do this in Excel 2007 however it is buggy when...

Hello, I have a module that references UBOUND. It is snaging on this. Is it possible to use this in Access? If so do i need to reference a reference? Thanks G

Hello, In an ideal world that would be possible. However this was overlooked by my predecessors and I have to work with what i have. The only uniqish data is the name, which isnt actually unique. Sure if i had more access to data i could work it better, howeve I do not. My biggest...

Hello, I have 2 tables. Table 1 contains details of accounts that are due for renewal. Table 2 has accounts that have renewed. The only link i have is the customer name. My problem is that i can have 1 record in table 1 and 3 records in table 2. So i start with 100 and finish...

To give you a bit more information i am currently left joining the initial and the surname to bring back protential matches then filtering that by my between values. However the amount of data bought back is minimal. I have a similar method for working with data from a different system. What...

Hello all, I’m not too sure anyone will be able to help but I wanted to see if you had any ideas what I can do. Ok, here goes. I have 2 tables from 2 different systems. Table 1: All the policies that are due to renew. (System_A) Table 2: All the renewed policies. (System_B) The main...

Right ok. That is very helpful. It shows i dont know as much as i sometime think i do. Thanks for taking the time to help! It is really appreciated.

Really sorry guys. I missed the opening ">". JJB's works perfectly. Ideal! thanks

The latter is a good idea. I will do this. Thanks for the ideas guys!

No luck! Same problems. I will look at tackling it from a different direction. If anyone has done anything similar please let me know. Thanks G

The only problem there is i need to look at both Friday & Saturday. Any idea if i create a function to handle the date that might work? Thanks

Good morning all, I have a table with loads of dates in and their relative data. Everyday i look at everything yesterday (Date()-1). That always works fine in an Access 2007 query. However on a monday i want to look at between date()-1 and date()-3. I ahve tryed using the below...