Search results

Hi, How do i display the SQL login name in my Access 2007 front end.? Is there a function i can use as the control source for a text box? Thanks!

I use many tables as Row Source / type for Combo boxes. All these tables consists of an unique identifier (ID) and two additional fields of Text Type. What is to be considered the best practise, bounding column 1 when inserting a new record (a numeric value) and when displaying / editing...

I will try out both suggestions; i much appreciate your effort! I see i have a tendency to complicate "things", beginners ignorance i suppose.. :-) Thanks!

Table A and Table B are related in "one to many" relation. I want to show all records in Table A and IF there are related records in Table B, i want to display a Yes, IF not a No, and the number of related records to a specific records in Table A. How to do this? Thanks!

I understand, no i do not need this particular example. I will look into the sample databases in my Access..Good idea. Sorry to disturb. Thanks!

A question: Does the "protocol" allow anyone to take part of the attached example? Thanks!

Appologies for "dropping in" like this, but this filter by form method sounds great..reminds my of how the "larger" systems like Siebel / Oracle uses one "form" that can take the shape of a "filter"..or data input etc etc.. are there any examples of this method..would save me tonloads of...

Thank you for the code suggestions and further explanation of the "house" rules.. Much appreciated! I will announce the outcome of the testing...

"You must spread some Reputation around before giving it to ..... again."..what is this..how does one say thank you in a simple way just by clicking on the balance?

Thanks for your suggestion pbaldy..i will try this out. The search criteria often includes text and numbers in comination..i iwll see how this wokrs for a wildcard search will try, thanks again both

This search function serves to finde Company names and related records, unfortunatly they are not always correct entered in the db by the user, not by format but by "spelling" Co in english S.R.O in Italian etc etc the Like cures this and returns one ore more related results Currently the db...

Hi all..and thanks for all patiance :) Currently performing the "basic" migration to SQL i ask my self if below code is correct..should i use the Dcount..and should i filter the form or should i "filter" in the tables..i am looking for all means to increase performance.. On Error GoTo...

Ok..here it is...

I am using NT...i am sitting on a corporate platfform, PC..perhaps encryptions etc does not allow it to run..difficult to say..what db do you want me to send you..your attachment or the db i am devloping?

I am using NT..i am sitting on a corporate laptop..could be that too..

Now it functions !...Had to restart Access... I do recieve the time zones..but i donot recieve the "Current time is in that country"..

so does your listbox demo..a nice demo it is too :-)..

Its a mystery, your calander demo functions..no..nothing helps..

I do not receive this data, i tried the same from the website linked in your posting

Its empty Drake