front

Hi Everyone I think this will be a simple one, but I cannot find exactly what I need. I need to trim values (all text) in column H to 8 characters. I can't seem to do this in VBA. I tried on the front end but I can't use this as the clear we have wipes it out. I just need it to keep the LEFT...

In a1 i have a variety of single variable equation such as : -3 -6x = -15 .... I need a way to separate the three parts in the next three columns showing the following: b1 "-3" , c1 "-6x" and d1 "-15" the other type of equation is where the <tbody> x variable is at the front such as 3x +4...

Is there any way to bring a table to the front (like an inserted object)? I want to be able to move it around, and not have it resize the cells. Thanks!

I have two worksheets in my workbook. Sheet 1 is called Front and sheet 2 is called Details. Cells A5-A57 contain events and Cells B5-57 contains the next date of the event in Column A. Column B gets the data from the Details Sheet. The formula I used to get the date of the next (future)...

For a split database, do each of the users have to have a copy of the front end on their desktop or can they all just use the one in the shared folder? I'm concerned about each user having a copy on their desktop as each time I make a change to the forms, queries, reports, and code, they have...

I have over a 100 lines like this.... Male Run Tee 10mm Tubexmale Bspt They all are different numbers in front of the "mm". Each string is a different length. I want to pull out the number in front and put into the next column. So in this case, the next column would show "10mm". Thanks...

Is it possible to write some VBA code for: Insert an aphostrophe' in front of all cells which are selected.

Hi guys, I have to alter my front end to point to postgres instead of local access tables. The table names will be identical except that postgres will include "_public" in the naming convention. I will need to switch the front end back and fourth between local tables and Postgres so I was...

I know how to do this within excel but now I need to do it with VBA and im not sure how to approach this. I have a series of numbers for example 0409-792-1 I need to make sure that the 1st set always has 5 digits the 2nd has 4 and the 3rd has 2. If it does not then I need to add zeros on the...

I'm trying to make a commission structure for Excel and it's pretty difficult So we get paid 30% of the front gross + 10% of the back gross = total commission. Example: $2,000 front = $600, and $2000 back =$200 grand total $800 if the front is negative, subtract that to the back gross x...

I'm trying to add a commission structure. front and back gross. back gross is paid 10% if the front gross is negative, the you subtract that from the back gross, then multiply x 10% if the front gross is positive then no deduction needed. <style type="text/css"><!--td {border: 1px solid...

I have copied a column of values into a workbook, but am unable to apply a formula to it (get #VALUE) as it has a space in front of it. If I remove the space I can apply the formula. How can I remove these spaces to the column, other than individually please?

Hi im in trouble, <tbody> Name Total Adsmi 1 Adsjj 2 Adshh 3 Mahh 4 Makk 57 Maiis 9 you 900 Yopp 6 Yodd 42 </tbody> Hi all, i need to sum up all the amount for the same name in front. For example, first three row same name in front which is "ads****" which total will be 6...

Hello all, I have in cells G9 the formula G9 = "0208888"&H9 So in H9 is a lookup formula. Then this is what I wanna do: When the number in H9 is one digit number , then place two zeros in front of it in the formula above. If two digits then place only one zeros in front of it. Thanks in...

I would like to figure out how to write a formula that will find and display the right-most cell in a row that contains a number in front of a "c". [/IMG] Note, I wish for the "CO" to be excluded from the search.

Hi, I have this formula that separate a whole number into individual cell, this number have a total of 10 digits always but sometime the the number start with zero so my formula doesn't return those zero from the front number ( in green ) and I need it to be, keeping the same formula if...

How can I show plus (+) sign in front of the subtraction output if it is positive? Lets say A1 : 2 and A2: 6 = and I want to make a calculation in A3 =A2-A1 =4 I would like it to be displayed as +4. I don't have problem with minus results obviously. thanks.

Im looking to create count sheets from a list of data that I have. I have about 15,000 locations that have stock in and I want to create count sheets that have around 100 records in. Is there any way of doing a drop down menu and selecting a count sheet number and it brings up that...

I want column A values to be red text if column C has -2.45 or any other - in front of a number in Column C Thanks

Hello, I am trying to change the date formate. right now it looks like 01.01.1111 I want it to look like 1/1/1111. I tried uisng the number formating, but it wont work. when I select an example the formula bar has an apostrophe in front of the date so I don't know if that has something to do...