Search results

The link above to store calculated results in new field. But my question how to store results or values of the new fields into existing fields?

I have a form that is created based on a table. Three fields on the table are: date Type Recd Used I added another 6 text boxes sub_type1,2,3 and Used1,2,3 into the form. These added boxes have iif statments and forumlas which display a value. I need the value of the sub_type to be stored...

Access will not allowed me to change filed type in access if it's linked table. I created make-table-query and then I can change the filed type which will solve my problem. The field in excel file is mixed letters and numbers and the type is general. I changed to text and access still assumes...

I have a table in Access databse link to excel file in the network, the format of the fields of this file are set to general. When I create a link table wizard the fileds formats changes to numbers for some of them. It's wierd, I spent a lot of time figuring out what is the problem and creating...

I have a table in Access databse link to excel file in the network, the format of the fields of this file are set to general. When I create a link table wizard the fileds formats changes to numbers for some of them. It's wierd, I spent a lot of time figuring out what is the problem and creating...

Even if you put the whole email address in the user box, it still not working. I have tried it at home yesterday with outlook2003, is doing the same thing.

Thanks for the info, I tested the account settings, can't login onto incoming server(pop3). I get the Network password window but is not taking my infromation. I guess maybe is due to our network security.

Thanks for the info, I tried it in my outlook, I kept getting network login to the yahoo server. I already have another exchange server account in outlook. I dont think so this is the issue. Can you please help

work great, thanks wware

i got it working with the wild card Like "*" & [7000] & "*" but, how can I have the result displayed without entering a parameter.

using what you said is not bringing anything. I just want to select parts contains the middle part which 6000 or 7000.

can anyone help please, I haven't search this forum for function or anything relatated to contain criteria... I want to have criteria search for parts contains specific characters. For example in a query, i have part like QS7000A and another part QS6000A. I want to have creteria to return parts...

Sorry I was away all last week on vacation. Thanks guys for the reply, I already did half way what Doc Man says, I have appended query to updated marked records into history table. At the moment i filtered selected records and delete one by one. I created a macro to open both queries in the...

Thanks Moniker for the tip. Just wondering what is the different between the delete query i created and the the built in delete command using the wizard I use in the form to delete current record. Why would this allow deletion when form still open? I will try to run the delete query once user...

I don't know if this is the right place for my post. Since is in regard to queries... I have data that I want to archive from one table to another table within a press of a button in a single form. The append work fine for me, but i tried adding the code to run the delete query to the same...

I have two forms with same fields properties, I select the record and moving it into the other form by using cut and paste. Is there a way where I can have command button to click and just move the record from form 1 to form 2? thanks for the help.

Thanks, I found error in the code of one form that i dont need anymore. I delete it. it work now....

The size is 1.12MB, 18 tables, 12 queries, 11 forms, and 16 reports. How would I compile the code? Do I need to do that for every object seperately?

I checked the application event log, and found this message "Hanging application MSACCESS.EXE, version 11.0.6355.0, hang module hungapp, version 0.0.0.0, hang address 0x00000000" I tried it again today and still doing the same thing. Maybe I need to do it in another computer or my home computer...

Thanks guys for the great help in here, i have spent few hours reading in these forums which is very benefitable for everyeone. back to my subject, mani posted this thread asking what is the problem not getting mde created. I have the same issue, i have converted the mdb from 2000 to 2002-2003...