Search results

Where do you put this code?

I don't know how to do what you want but I have an alternative that may help. Using a blank Database create a Form. Create 10 Buttons, one for each database. Then with the onclick event of each button write some code that opens a Database. Repeat for each different Database. You should be...

A date is a Date regardless of Short Date etc. There is no real reason to format the Date as far as I can see. Try doing this in VBA rather than using the Format tool.

Please tell us more about these 10 Databases.

Can you explain this. Also it might help if you wrote your statement in simple English for us to see. e.g. IIf([Table1].[Location]="0217",<>"075",Last([EmployeeMaster].[empno])) If Location = 0217, then ??????, Else empno. Look forward to your reply.

If you can convert your Database to 2007 we might have a chance to understand what is what. But you should do as jdraw suggested first.

Try creating a query using the query grid. Once you have that you can do a copy paste of the query from the SQL view.

Put a Message block in the middle of the code straight after it is supposed to obtain a value. Look at Access for help.

You have not answered my question from post number. Are you going to do that or not.

The decimal part is always Positive regardless of the sign of everything before the decimal point. Hence -1.5 is 12 hours before Midnight 12/30/1900 (I may have the date wrong. It could be a year earlier)

Test both IsID and IssuerID to see if they have a value. A message box will suffice.

Galaxiom As no one else is getting involved, I suggest that we finish this last point then call it a day. We could go on for ages otherwise.

Would your natural key still require to be indexed. You would be searching, filtering etc with the Auto Number. Sorting would not fit in with this. So only the one Index would be required. (Plus others depending on the table make up) I do not use your method as described in paragraph one. I...

A lot of talk has been about the failure of the Auto Number. This has not been my experience. I wonder how many of you have had real problems with the Auto Number failing. I am suggesting that you only count the Databases that you have written rather than those written by others and you...

If you are completely satisfied that it is unique then there is no reason why you should not use it. I would do something similar. I would use this as the Main identifier for all to see. However I would still have an Auto Number hidden away which is the real PK. An example of why I would not...

Is there any harm in hiding the PK if it were an Auto Number. I cannot think of a single problem. Can you? Is there any harm in showing the PK if it were an Auto Number. I think there can be. If you were Audited and Invoice Number 4321 was completely missing would that not raise an issue with...

Yes And it would be a good idea if you closed this one.

CJ Just to clarify my thinking. When you add a new record there is a slight delay while Access updates the indexing for that field. When you do a search or even simply open the records it becomes faster than a similar situation where there is no indexing. When we add a new record the...

Instead of using txt146 it would be better if you used txtMyDate or what ever is applicable. This may also help us to understand what is what. Thank You.

http://stackoverflow.com/questions/1108/how-does-database-indexing-work That was just an introduction and a link to the source. :) :) :) :) What I would like to know is when is the Index applied. A Field needs to be reindexed whenever a record is either created or edited. Is this index...