Search results

when i created my form, a subform was automatically created. the main and subform are based on a query( 2 tables combined). when i enter data in the main form, it displays on the form after i enter the data and reopen it. when i enter data in the subform, it disappears when i reopen the...

after update in event tab

when i enter the name , get an error message about macro not found to new etc....

ok thank you both. chrissy....(she lol)

i havent created the form yet, creating table right now. i dont see events in the properties.

i get this function from the expression builder? can you tell me physically how to do this??

I place > character in the format box ,but as i enter data it doesnt not make the data in uppercase. can anyone tell me what i m doing wrong. i need for the first letter in uppercase, not the entire word. can anyone help me

combo box followup ouch!! can you tell me specifice how to take do this? learning from a book and this great forum, sorry make the primary key a foreign key?

changed property i changed it to no but still getting same error message

hi whenever i try to enter data on the form which i created, i get error message that states you are trying to enter data not on the list. how do i correct this?

i guess what im trying to say about problem one is that the table is displaying the bound value as oppose to the display value.

thank you. problem number one is when you dropped the combo box it displays what looks to be the autonumber from the field of the first table- instead of the other two columns. i did checked off "hide" button. i also changed the bound column in the combo box property to the number of columns...

followup lookup column thank you for all the help but im truly having trouble understanding lookup boxes. i am new to access, and im trying to teach myself from a book and this great forum. anyhow, can you explain if i would require two tables. the first table would require the list of...

Lesson learned fortunately i did not create the table with the lookup column. i ve learned from past mistakes to just put in enough data to test drive my tables or anything im creating. plus, it didnt make sense to have the lookup column in the same table. but what also doesnt make sense to me...

any other solution i tried that solution but didnt work. are these master/ child link field properties found in at tables or form objects? do i type in the fields or do i should i see a drop box, something similar to the expressions builder, to pick my field to link.

i am having trouble understanding lookup columns. is the lookup column (field) in the same table or is the lookup column (field) in a different table which then connects(relationship) to where the lookup column is?

i created a form with a subform. when i try to enter data into one of the combo boxes, which contains valuves from a lookup column, an error message stating you can not add record or delete record because a related table (202tble) is required. does this have to do with the relationships or the...

i created a form with a subform. when i try to enter data into one of the combo boxes, which contains valuves from a lookup column, an error message stating you can not add record or delete record because a related table (202tble) is required. does this have to do with the relationships or...

what does it mean when the I try to enter data into a field and the error message i recieved is ,"cant enter null value in field

it is based off a query.