Recent content by bbznyc

acutally the way i get the data is as follows: there can be multiple spaces in the quotes... ="392094 "

Hi, It must be a piece of cake but I can't figure out how to do this: Current Code: Range(("A2"), Range("B65536").End(xlUp)).Select Selection.Replace What:=" ", Replacement:="", LookAt:=xlPart Current Problem: I have numbers in a cell with leading zero's and spaces at the end. I need to...

anybody still got an idea what kind of a problem my dbase might have?

Here is 2000 version of the db, thanks ! Here

Hello Guys and Gals, I have a problem. I have orders form which is filled out by a user but when payment field is not touched (no payment is entered), I can't run a report on employer's history or view employee's history - I get an error message. I enclosed a sample! Please help me - I am...

anybody got an idea?

Is there another way I do a "Save changes" ??? This way I can implement the BeforeUpdate event. Thanks,

Here is another one for you guys... I have a form which feeds the table, standard setup - autoID, LName, FName, and 19 other fields with text/number variations about an employee and similar info about employer. I want to know if there is a duplicate entry being made. There are quite a few...

thank you!

Thank you so much for replies. Situation #1 is completely solved. For Situation #2 I have attached the picture for a better explanation of blank lines. Thanks for your help again !!! YOU RULE! :) In this case a user can remove the values thus leaving the lines blank. I want the user to be...

:( I have a problem on my hands. My DB is complete but now all sorts of problems begin to arise. Situation 1: I have a box that calculates TotalBalance using this formula: =[InitialBalance]+[Commission]-Forms!Orders.Payment!Text8 to break this down, i have an initial balance, a commission and...

doh.... did it... :)

guess what... i totally forgot to mention that I have multiple payments. What should i do then?

dude, this is sick... thanks a lot!!! why didn't i think of that??? :rolleyes:

Is it true that when you think your project is done - it's not even close to being over?! Here is my list of questions: On my orders page i have an unbound box which calculates [field1]+[field2]-[payments] to give total balance owed. Q 1. How can I make a report to show which balances are...