Recent content by Penpoint

Hi all, I have had a general problem with connecting to an MS Access Database Table through MS Excel (both in version 2007). The connection is established. I am able to access the database data in MS Excel pivot tables. I discovered a persistent problem where the records retrieved from MS...

Did I mention this was for Microsoft Access??

Just a quickie. I have two tables. Projects - Project ID (12m) - Service Name (12m) - Service Location (12m) Activities - Project ID (m21) - Service Name (m21) - Service Location (m21) There are other fields in both tables. The basic thing I am trying to attempt is to have all three inputs...

I kind of agree with you on the OrgType field. The reason I split them up in the first place was to separate the data entry. It would be a bit of a task to go in now and merge the three tables together. However, having gone with the three-table setup I already have, is there a...

Hi, I have three tables which all have financial data stored inside them Expenses Table - Transaction Cost - Service Provider || Row Source = SELECT [Service Providers].[Service Provider] FROM [Service Providers]; - Transaction Date Revenue Table - Gross Pay - Company Client || Row Source =...

Thanks for your effort it's appreciated. In relation to gaps, that's not a problem because it's not for an invoice. The only condition is that it has to be unique so that I can reference it in other documentation, which when I do a search function across a series of indexed folders on Windows...

I assumed from all the posts already that a letter number combination Primary Key would be in the too difficult basket. In relation to the second portion of the question though, is there much scope to being able to auto-populate the highest number in a new field (similar to auto-increment but...

Hi all, In MS Access 2007 I've developed a form from a database. I have a unique identifier P000001 which I would like to auto-increment to P000002 and so forth. I've had a look around the forums and it seems there are no real straightforward answers. If that's not possible, I would at least...