Search results

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...

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...

Thanks rich... it's just that i wanted to stay away from using the ID# :)

not really. I already have a report which lists everything as needed (for example where each employee worked). I want to have a preview/print button which will stay on the "order" form. Then as the name of the employee pops up during order i want to run the report but only for this employee...

follow up I am working on the same thing, the only twist i have is that i need to apply a filter (e.g. ID #) on that report. How can I do it? Thanks

from one problem to the next I did everything fine... Now i have the form in which i have 3 subforms. 2 subforms run quieries and the 3rd does summation and posts total on the table. All nice and pretty. However, when i close the db and reopen it, the information is gone from the main form...