Search results for query: *

Does anyone have any idea? I've tried putting this into a macro: Goto where "contact.contact=contacttempstore.contact

Ok, I figured out what that means... Contacttempstore has only one field... that is the contact number so that I can use it to reference the number later.

I have tried, but within the wizard, it isn't working. I tried to write the code, but I don't know enough about coding to make it work.

I have one form, which I can use to look up a record. The way this works is that the form is linked to a table called contacttempstore. It has a lookup field to my main table, and a field that stores the contact number in the only cell of contacttempstore. Every time I change the lookup field...

Contacttempstore is a table that I use to store the current contact so my lookup field will work. Access does not work very fast with the find feature. My form uses that field to requery to find a person by name. In this code, I am using this table to record the current contact in the status...

I am trying to insert values into multiple columns within a related table through a button on my form. When I try to use this code, I get an error that says an "=" is expected. Private Sub Command13_Click() 'Add Contact Status Log Insert INTO dbo_contactstatuslog(Contact, Status, Date)...

This issue was resolved. We set the default yes/no value to "1" and now I have no more issues.

The option Group worked. Thanks!

Access does recognize the PK There are yes/no fields, but I have no way to set the defaults. I am currently working with my IT guy towards resolving this issue. Thanks:)

In my 'Contacts' table, I have a lookup field (named Status) to my 'status' table. I would like to have that field referenced in my form by radio Buttons instead of a combo box. I have 3 options. Is there a way to link 3 radio buttons? Also, can I link the group to the lookup field?

You are correct. I am using Access for the front end and sql for the back end. The problem is occurring in tables as well as forms or queries. When I open the table, I cannot update the records I created since the initial import. I can update the records that were initially imported.

I am working in access with an SQL database. I recently did a batch import of all my excel records. Before that, I had no records in the database. I have a form for creating new records, and another for editing records. I can edit any record already in the database, but when I add records, I...