Ok, I think I have it narrowed down. When I received the error message the first time it highlighted both lines. Now when I do it is only highlighting line 16. This is so weird! Let me know if that helps....
Thanks!
Lori
loonette
Last Activity: Mar 13 '12, 02:54 AM
Joined: Apr 5 '10
Location:
-
NeoPa,
I apologized in my previous post. It WAS giving me an error message originally, I just wasn't looking in the correct place for the error message. I thought the error message would come up when it highlighted the code, not before I hit the debug button. Sorry for any confusion.
To clarify, when I try to filter for the exact match it is giving me an error which says "Runtime Error 2001, You canceled the previous...Leave a comment:
-
NeoPa,
I tried compact & repair the database and it didn't fix the error. I apologize, it is giving me an error message it says "Runtime Error 2001, You canceled the previous operation" Any more thoughts?
LoriLeave a comment:
-
It doesn't say anything, it just goes into debug and highlights those two lines.
LoriLeave a comment:
-
NeoPa,
Thank you for your help. I put the code in that you gave me and I am now getting an error on Line #15 & #16 of my code. Any thoughts?
Thanks!
LoriLeave a comment:
-
VBA to Filter for exact match
I need help with some code. I am using this code to filter for a catalog number([SEitem#]) in a form. I would like it to filter for the exact match. When it filters right now if you put a "1" in the [filtercat] text box it filters for everything that starts with "1", how do I change the code to filter for the exact match?
...Code:Private Sub CheckFilter() Dim strFilter As String, strOldFilter
-
Code Help to make a Check Box Functional
I have created a continuous data entry form to enter information in. I use the following code to make certain information entered in the previous record repeat in the next record.
...Code:Private Sub Form_Current() Dim rs As Object Set rs = Me.Recordset.Clone If rs.EOF Or Not Me.NewRecord Then ' don't do anything if there's no records or it is not a new record Else -
You described it exactly. Can this be done?
BTW, are you married? Cuz if you are your spouse is a very lucky person! LOL!
Thanks!
Loonette...Leave a comment:
-
Populating a Field in a Table from a form based on a query
I have been searching through this forum for hours and I can't find anything that will help me.
I have a query "qclerking" that is based on a table called "tblbiddersales ", this is then popluated by entering information in a form called "frmbiddersales ". There are several fields that information is entered into, but I have a field that populates itself called "ID". It populates from the... -
Thanks a million guys, I used Smiley's formula in post 13 and it worked! I didn't realize I was going to start such a debate, but I really appreciate all of your effort to help me fix this problem. Take care!Leave a comment:
-
Neopa,
I made the change to formula that you suggested, but it is still rounding down to .05, instead of rounding up to .06.
This is very frustrating. I guess I will go back to the original formula it was at least rounding up to .06.
Thanks for you help.Leave a comment:
-
Okay, here is the formula I have in my query right now:
The result that I get when [finalprice]=$1.00 and [taxrate]=.055 is $.055.Code:tax: CCur(Round((Switch([taxable]="y",([finalprice]*[taxrate]),[taxable]="n",([finalprice]*0))),2))
What am I doing wrong? I need the tax to be a whole number and for it to round up.
BTW, How do you do the tag thing? Thx!Leave a comment:
-
Which formula did you try? Was it the first or second? Because the first rounds up to .06, the second rounds down to point .055. Below you can see what is going on on my form, it is calculating .605 and giving me a remainder of .01- when calculating the balance. Thanks!...Leave a comment:
-
Rounding Problems Calculating Sales Tax
I am calculating Sales Tax in a query. I need the sales tax to round up, but I've tried everything I've found on the internet and in this forum and I can't get anything to work. Here is what I am trying to do:
The Tax rate is set at 5.5% and say for instance the item sells for $1.00, the tax calculates to .055, which rounds up...Code:tax: (Switch([taxable]="y",([finalprice]*[taxrate]),[taxable]="n",([finalprice]*0)))
-
Thank you so much for your help. I worked on the code using the form filter and it works! I am so grateful!Leave a comment:
-
Topher,
Thank you for the reply, but I didn't make myself 100% clear. I would like to have a text box at the top of the form in which I could type a last name, for example "smith" and the form would then populate with all the customers whose last name is Smith and each name is hyperlink to it's record in my form "frmbidderinfon um". I have the name fields in "frmbidderinfor num" split between first and...Leave a comment:
-
Creating a Clickable list
I'm sure that this has been asked on here, but I have been looking for the last hour and couldn't find anything that quite answers my question. I need help with Access 2000 and creating a clickable list. I have a table that lists all of our customers called "tblbidderinfo" . I would like to create a new form that allows you to search by last name and when you click on the person's last name in a list it would pull up their record in the...
No activity results to display
Leave a comment: