Search results
-
B
Need help with a VBA Macro - replacing value
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... -
B
This is so weird - why is this happening??? how to fix it?
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... -
B
Another duplicate thread - with a twist
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... -
B
calculated field doesn't show approp. value
:( 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... -
B
Almost done...
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... -
B
List boxes and reports
Here is what i want to do... but it ain't happening... I created a report which works fine. It lists employees who belong to an employer based on a workID. On my order's page i have a button which i press and it gives me the needed history on the employee or the employer. but... on the... -
B
simple question...
:eek: I currently have a subform in the main form which is connected to a quiery. The quiery has [InitialBalance], [Payment] and [Total]. Everything works out great, i enter the Initial balance, enter payment or prepayment, and i get the total (e.g. 280-180=100). The problem is i need this...