Search results

but when i do this i can't write to the fields at my form. :confused:

i have already set the Record Source to another table but i want to use some values from more than one tables. Is there another way to do this?

How can i refered to a table value through a form? Thank you!

the reason i want to have all the values in one form is because i have a form event (before_update) with code builder (Me.x=Me.y where x and y are in diffrent tables). is there another way to assign values from one table to another?

Hello all, If i have a query as a Record Source of a form then i can't write to the fields i want, only if i have a table as a Record Source i can. Any suggestions why might this is happening? How can i add fields from diffrent tables in one form? Thank you in advance!

Based on some fields of my form i want on submit to get a calculation result based on a formula. I guess i must create a module, but i haven't write a module before so i don't know how. Any suggestions? Thank you!

It works!:) Thank you!

I have a form in MS Access and i want when the users modifies data of tis form the field EntryDate(in the table) to get equal to Date()(todays date). I guess it's easy to be done but i have no idea of VB ... I will be gradefull to any suggestions. Thank you in advance!

...how can I create a duplicate check query from wizard?I didn't find such an option.

maybe some stupid questions.... How can i create a query based on duplicates values of a field? and another question... Is it possible to create a query based on the sum of some fields? Thank you :o

How can i create a menu bar and hide my database in order the users enter the forms from the menu bar? Thank you!

I get all rows but in some fields of these rows i get empty spaces, even though I get these fields at the query. (and yes the report's recordsource contains the right query name :) )

I have a report that gets data from a query. When i execute the query i can see all data but when i execute the report same data are missing. Any suggestions in what may be wrong? Thank you!

Can i import just the data of a database(not the whole tables) to another database? (Both databases have the same tables, fields and relationships) I want to merge 2 databases is it possible? The databases have a lot of tables and relationships it's not simply a table. Thank you :)

I did it with a query and worked.... tnx :)

I have a report of a table in which some of the fields are comboboxes with values (etc 2,3,...). These values are attached to values in antother table.(etc 2->User, 3->Admin...) If i want to have a report with the User,Admin values (of the given record)instead of 2,3 how will i do it? Thank...

another stupid question.... how do i do all these? :o

Thank you guyz! This is what i did and worked in case someone else has the same problem: I added a new field for password and when a user tries to open a form, he enters his password and the form is retrieved from a query based on password. It was simplier than i thought ;)

I have a database in which a lot of people are inserting data and everyone can have access in all records. I noticed that some records are changing so i want to add security control to my system. Is it able to prevent one user from editing other users records?What i mean is to have only one...

Thank you all! I used the TABINDEX property and i fix my problem :)