Recent content by DannySeager

basically take a copy of your database, delete anything not relevant, delete any data if it's confidential (for this issue I'm not sure any data is required anyway. then upload it here by going into advanced mode (button next to "post quick reply" and attach the file.

a sample of your database - i don't need the files you are trying to attach

You're welcome

you're welcome. glad you got it all sorted.

Change the field from text to number

can you post a sample?

So does the field called NCRNumber just contain the incremented number or does it contain the year as well? can you post a sample?

the first thing I would do is add some debugging code lngFlags = ahtOFN_ALLOWMULTISELECT Or ahtOFN_EXPLORER Dim result As Variant result = ahtCommonFileOpenSave(InitialDir:="C:\", _ Filter:=strFilter, FilterIndex:=3, Flags:=lngFlags, _...

Do you get an error?

As far as I am concerned a user specifies how they want the system to work.. and they have no need to know how you achieve that. Most users don't have a clue about table layouts and normalisation... they don't need to know... just like I don't know how to do thier jobs. As for the junction...

I am an MVP but that doesn't mean that I am not capable of being wrong... but in this case I still hold that 1 table is the most flexible way of doing it (and generally the most flexible way is the right way). No - you have a seperate junction table which will allow you to add seperate company...

Here's an example (it's not pretty :) )

I'm not exactly sure what you are trying to do (I don't know your data structure or report layout) but have you tried =Sum(Nz([Outstanding Bal],0))

The ID field in the inserted table should match the ID in T1. The data in inserted is a match of the inserted data - I believe that the field in the inserted table will just be a long integer. (i.e. no identity auto increment)

Sorry I missed your edit or you were typing it when I was typing my message. As I say you can do it the other way.. but I wouldn't recommend it. I am welcome to hear any other opinions on the subject but I honestly can not think of a good reason not to store records of the same structure in the...