Search results

yeah i know, but the problem is that i need to add the old data into this database too. For those some specific value already exists.. So its a pain adding those records if i'm gonna have to empty everything and add again...

Hi! I have a database which already has a lot of data. However my I need to add in a record for Warranty ID (which is an autonumber field) = 29. How can i do this? Please help.. I don't want to delete all data and key it in all over again!!!

Hey.. The code is working, as in it shows the error and all that but the data still gets saved. How do i make sure that it is rejected? Please help :)

Thanks a ton! :D

Hi! I'm a real beginner at this stuff. Can you please help me a little further.. I don't understand what i should replace "*", "SQL, table, or query" with.. and I tried using just the countAll part of the code to see if it works and used a message box to display the number or records that...

Hi! I have a mainform with a subform. The subform has a field called Reason Code. Suppose there are x number of records in the subform for that particular record. What i need to do is that if more than 30% of x have an entry of TBA in the Reason Code field, the claim should be rejected and the...

Thanks for the help! I'll try it out :)

Hey! Yeah this is working now. But I'm facing another problem.. My subform is like a table so it has many entries, each row is a different entry. this code only seems to show the error when the reason code for the last row i fill in is left blank. otherwise it allows the system to save...

Hi! I have a subform with a field called Reason Code, which i want to make mandatory. I know 2 ways to do so: The simplest one was to make the field in the table as required. This works perfectly, but the problem is that message box that is displayed when the field is left empty. It says...

Hi! Basically I'm creating a database in which i have 2 fields called "Product Code" and "Product Name" respectively in one table each with a number of entries. What i require is that in the form if someone choses a particular Product Name the corresponding Poduct Code should appear on its...

yeah! i know Edit Claims is working well.. the problem is with the Pending - Update Customer, Pending - Awaiting Defective goods, Pending - Delivery of Replacement forms. yeah i think i'll try using a filter! hopefully it should work :)

aaaarrrghhh! Well now, when i only keep the fields in my main form inside my query, they become uneditable! i need to be able to edit them too... any suggestions???? I think the problem is that in my query I had to use SELECT DISTINCT because of which it becomes uneditable.. please help!!

it does! :)

I tried that already :( still doesn't work!!

Umm.. that's the thing, I understand why the problem is happening. But i can't use the warranty claim directly. I need to use the query based on the value of the claim status. I have 3 other forms like the pending - update customer. Each of them has records only such that all of them have a...

Please try again... Dunno why you cant :(

There.. Hope its easier to understand now. You need to open the form : Pending - Update Customers. Try clicking on the next button 4-5 times. You will understand the problem :)

Hi, I don't think you understood my problem properly. I'm attaching a screen shot of the query as well as the form. Hopefully it'll be easier to understand now. Basically what i need it that when i click on the next button on the main form, the next page of the form (ie the record with the...

Hi all! Basically I have a form based on a query. The form has a Subform. The problem is that when i click on the next button in my form instead of going to the next page of the form, it stays on the same page but points to the next record. what i need is that when i click on the next...

Thanks a ton!! :)