Search results

Anyone know how to store the value of a calculated control in a table? Could really use that ability when it comes to doing a search. Thanks in advance:p

I knew it was something simple. I just created this db but had not records. Added a record and guess what!!. Thanks

I have an Access 2003 mdb with table & forms that work fine. I have a test .adp file that connects to Sql 2005 no problem. I can open the mdb file and export the forms to the adp with no problem. When I then open the test.adp it shows me the forms except when I want to view it it's a grey blank...

Figured it out and it works by using 4 fields as Primary key. Thanks

Thats sounds like it could be the solution but not sure the process to create a compund key. I am investigation now but so far Access 2003 help isn't cooperating.

All of the fields are set to "Required"=No. So I went in to the form and added data to the 3 field which then showed up combined in the field I have set as Primary but then when all the fields had data and I went to create new record it still tells me that I cannot add the last record because...

I have a table with only 5 fields right now but I am having issues getting a Primary key to do what I want. I have an expression for this field that simply displays the contents of 3 other fields together. The trouble is that I cannot get the field to hold it's data. When I input data into the...