Search results

Hi!! This thing has been driving me mad.... I've tried a lot of different things but ntn seems to work! Please help.. I have a sheet(sheet1) with about 1000 entries in column A. Each cell in column B must have a check box. When any checkbox is selected, the value of the corresponding cell a...

Hi! I created the checkboxes from "control" in the "developer" tab.

to clarify! Actually what I need is that as and when I select a checkbox, the value in Column A for that row should get copied to "Sheet3". When I uncheck the box, it should get deleted from "Sheet3"... Please help! I'm clueless...

Hi!! I don't have much experience with macros and need help!!!! I have checkboxes in column G. The user can select as many checkboxes as they wish. Once he/she has checked all the boxes they want, the values corresponding to them in column A should be copied to another worksheet. eg.. just...

Hi! When I export a report based on the a query with a memo field in it, the formatting in that field is not carried forward to excel. Meaning that if someone has pressed "clt+enter" and the memo field has text in two lines, it appears as one in the excel file. I have to then double click on...

Hi! something very weird is happening in my db. I have 2 fields Product Code, Product Name such that when i enter the value of either one, the value of the other one appears on its own from the Products table. I have 2 entries in the product table, both with product name = name2, And product...

Well that's why I'm using the report for printing. I tried playin around with the query its based on but I can't figure out why this is happening.. Please have a look at it if possible! thanks

Hi! something very weird is happening in my db. I have 2 fields Product Code, Product Name such that when i enter the value of either one, the value of the other one appears on its own from the Products table. I have 2 entries in the product table, both with product name = name2, And...

Thanks for all the help everyone :)

Hi! I have a database which multiple users must have access to at the same time. I read online about splitting the database to allow that, so i went ahead and did that. In my database there are buttons to generate reports based on certain queries. After splitting the database for some weird...

Basically the data in a form should get saved only when the user clicks on the SAVE button. I have seen a lot of posts online about this but i still haven't got a clear answer. please help!

however it doesnt show the runtime error anymore :)

i think that runtime error was because countAll = 0. So i just put another if condition countAll>=1. But now the code doesn't seem to be working at all! it doesn't even show my coded message box... Private Sub Form_BeforeUpdate(Cancel As Integer) Dim countAll As Long, count30 As Long, siteID...

No.. It isn't coming up with my coded message box. Its showing the runtime error: Overload...

That's strange.. I'm attaching it again. Please try once more if you can open it! And nope haven't used any software to empty it, just deleted them from the table. yeah, it shows an error : Runtime Error 6 : overflow...

alright.. I have attached my database.. Just open the Edit Claims form and try to create a new record in it. Start by entering data in the main form first, then move to the subform. You'll see the problem. :) However you will not face his problem when you try to enter data to the already...

I tried using it in before update already. The problem is that it doesnt let me create a new record. In the sense that if i wanna add more records in the subform for an already existing value of warranty ID its fine. But it doesnt let me add records in a new value of warranty ID... I think its...

And how do i do that? thanks a ton for all the help... :)

Basically I meant that its working fine.. Displays the message box when entries with TBA exceeds 30% but the problem is that it still shows allows the data to be saved. I need to prevent the data from getting saved in that situation. I have used the following code: Private Sub...

Ohhh!! Thank you sooo much... :)