Search results

thank you very much your replies are very helpfull

hi when creating indexes for databases what needs to be indexed? is there an article online that explains it??

but queries can also be made in sql oracle along with views. they are two different items in sql programs. is it possible to do the same with access?

hello :) how can i create a view in access? is it possible using any of the wizards or can i even use the sql coding feature?? is it possible to grant views to users???

thank you very much i couldnt open the file earlier but i just checked it and it works very well :D :)

hello is it possible to change the default primary key error message that appears when a duplication of the primary key is made in a form?? in other words how can i make those error messages more user friendly?? thank you :)

thank you very much for your reply :)

thank you for the reply :) really appriciate it 1, the composite key works well 2, the for the date i used a variatio of what u said: > =now() AND < (now() + 7 ) is that a valid way to do it? or is dateadd better?? 3, hmm u seem like u know ur stuff :)

sorry i got one more question how could i get the day of a given date?? eg if the user enters a date it says "friday" is there a function in vba that could do this???

hello how can i create compostie keys in access??? also how would validation rule for a text box which would allow a user to enter a date which between a certain range in relation to today's date. eg the date entered cannot be more than one week greater than the current date. i knew who i...