please help; lost credit card transactions
my register went offline yesterday because of a networking problem, at the end of the day I tried to run an x report but the computer said that I was not able to do this on an offline database. I closed the pos program and reopend it online. I understand that at this time is when it should have said that the databases where going to synchronize but it did not say that it opened as it normally would and showed a total sales of what we had sold prior to going offline. I have the receipts for the sales that we did and the cash recipts are not a problem, the problem is all of the credit card transactions that we did for the day apparently are lost from the database. I tried swiching from my online database to my offline database to see if the transactions would show but they did not. I made the system go offline, ran a couple transactions put the system back online and the screen to synchronise did show up this time I don't know what happened. I also went to store ops manager/ journal/ update batch info to update the blind closeouts but it is only showing the two times that I went offline and back online with my test transactions, the one I am looking for is not there. I also pulled up a few of the customers that we sold to yesterday to see if the missing transactions would show on their history but no history is showing for yesterdays transaction, after going offline. I sent an email to microsoft and ultimatley the tech responded by saying this " 7/27/2005 8:42:00 AM EDT -- Christian Sureta Hi Victor, Thank you for your response. All the transactions that are missing should be in the [Transaction] table of the offline database. When the system would go to offline mode, a new batch would be created for the offline transactions so the transaction are possibly in the same batch. I would suggest that we check the [Transaction] table from the offline database: 1. Launch Store Operations Administrator and connect to the OFFLINE database. 2. Run the following query: select * from [Transaction] There is a TransactionNumber column we can use to see if the transactions are there. The unfortunate thing is that once the transactions are gone from this table of the offline database it is not possible to recover them. Regards, Christian Technical Support Engineer - RMS Microsoft Business Solutions" I cant believe that there is no other way of finding my lost credit card transactions. Please help Victor
Victor
pos
14173 articles. 
0 followers.
1 Replies
375 Views
Victor, Have you tried setting your offline database as your primary database and connecting with the Manager? This might allow you to settle the credit card batch within the manager application on the offline database. I believe the problem might be that the syncronization betweent he online and offline database does not syncronize the visanetauthorization table. This is the table that holds all the credit card authorizations. Casey Hanson New West Technologies Amazing RMS Add-ons: http://www.newestech.com/POS/extensions.htm
chanson
Similar Artilces:
CToolBar Help
Hello, I've been trying to add a toolbar to my dialog following the example from MSDN a http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcmfc98/html/_mfc_ctoolbar.asp But for some reason I just can't add the toolbar I created. Here is my code: CToolBar m_toolbar; if (!m_toolbar.Create(this, WS_CHILD | WS_VISIBLE | CBRS_TOP | CBRS_GRIPPER | CBRS_TOOLTIPS | CBRS_FLYBY | CBRS_SIZE_DYNAMIC, IDR_TOOLBAR1)) { MessageBox("Error -1"); } m_toolbar.LoadToolBar(IDR_TOOLBAR1); Could somebody please tell what, if anything, I am doing wrong? Thank you, V...
Outlook 2003 Messages and Calendar Appts Received as PLAIN TEXT
SGVsbG86DQoNCkkganVzdCBnb3QgYSBuZXcgbGFwdG9wIHdpdGggVmlzdGEgSG9tZSBCYXNpYyBv biBpdCBhbmQgSSBjb3BpZWQgbXkNCnBzdCBmaWxlIGZyb20gbXkgb2xkIGxhcHRvcCB0byB0aGUg bmV3IG9uZS4gRXZlcnl0aGluZyB3b3JrcyBmaW5lDQpleGNlcHQgYWxsIGUtbWFpbCBtZXNzYWdl cyBhbmQgY2FsZW5kYXIgYXBwdHMuIEkgcmVjZWl2ZWQgYXJlIGluIHBsYWluDQp0ZXh0LiBJJ3Zl IHNlYXJjaGVkIGV2ZXJ5d2hlcmUgZm9yIHRoaXMgZml4LCBidXQgZm91bmQgbm90aGluZy4gDQoN CkRvZXMgYW55b25lIGhhdmUgYW55IHN1Z2dlc3Rpb25zIGZvciBtZT8gDQoNClRoYW5rIHlvdSEN ClNwdWRkeQ0K me@cox.net <me@cox.net> wrote: > I just got a new laptop with Vista Home Basic on it and I copied my > pst file...
Office 2007 Professional: Help Files Issues
Gents, I cannot find a solution to this odd issue and before I submit a support ticket I thought I would ask the community. We have office 2007 professional (volume licensing) on a Window 2003 terminal server. We have a few users out of a bunch that get the "This page is unavailable" I have tried the Refresh and back. I've tried online and offline modes. In offline I get the table of contents to the left but same unavailable message when I click the links. I noticed on testing some other users, that apparently never used the help. That there are some prompts...
Missing Transactions #2
Hi, When I update my transactions after downloading from the web site some of the old transactions start missing. I have to check and update the acount register to get the balance same. Why is it happening like this? Once downloaded should I reconcile so that they would not miss or how should I do? -- Chanikya ...
Help with Regexp, please
Hi, The regular expression (\d{15,16}) matches a substring in a cell. I want to extract the remaining part of the cell ie. from the character after the matched substring till the end of the string in the cell using a regular expression. Is it possible to do this? Thanks in advance for the help. Regards, Raj Raj, with abcd15,16xyz in a cell the code below abstracts abcxyz. Maybe you can use this as a basis to develop your code Function GetSubstring(S As String) As String Dim re As Object Set re = CreateObject("vbscript.regexp") re.Pattern = &quo...
Spell Check Help
I have this code in the AfterUpdate in a TextBox set for a memo: If Len(Me!casefacts & "") > 0 Then DoCmd.RunCommand acCmdSpelling Else Exit Sub End If everytime the spell check executs, it check the whole form. How can I get it to just check that one textbox and not everything else. bladelock wrote: >I have this code in the AfterUpdate in a TextBox set for a memo: > >If Len(Me!casefacts & "") > 0 Then > DoCmd.RunCommand acCmdSpelling > Else > Exit Sub >End If &...
Balance changes when selecting reconciled transactions only
I have a problem with Money 2003 where the account balance changes when switching from "view all transactions" to "view unreconciled transactions". Anybody have a fix?? I am having the exact same problem in Money 2004 and it is driving me crazy. Does the problem you have trickle through to your Account Summary and Portfolio...it does with mine and if I dig deeper I think I will find that it messes with the way a Budget is created...Can someone at Microsoft help us on this one??? -Matt >-----Original Message----- >I have a problem with Money 2003 where the a...
Publisher 2007 Trial Help
I installed the trial version of Publisher 2007 and want to uninstall it now. I have tried to remove in the "add/remove" programs section. And I have also tried a suggestion I found in an earlier post about going to the "installer" and trying to uninstall it there. Oh and I tried repairing it and then trying to uninstall it. I can't even open the program from my programs menu and I can't get into the language section to check the language. It tells me that the language isn't compatible with my version or something to that effect. Nothing has worked...
Default Value on Form Help
I have a query that calculates the total of a field in my table - Field Name in my Table is Total Value which calculates the total for a series of records that has the same invoice number. Field in in my query is Aggregate Value. I now have a form where I bring in the Aggregate Value. I need to create another Text box Value Verified where I bring in the Aggregate Value as a default, but I may have to change it if the Value has changed - but the Aggregate Value has to remain the same. I tried using default value on the form for the Value Verified Text control that brings in ...
PLEASE PLEASE HELP
I Have an emergency... I deleted a macro !!! I have 60 rows with checkboxes on cells A1 trough A60 that automatically as checked were inserting current dates on the cell next to it. for some reason a disaster happened and the macro was deleted or messed up. I tried searching for help in these groups, but none so far. I found one, but it is not a macro besides when I use that function all the other previous dates keep changing when other checkboxes are checked on in different days of the week. If you can please guide me to the right answer I will appreciated. Hope I made sense with my explana...
Cannot access a file -- HELP
I have this problem at work (using Excel 2000 Windows 2000) and at home (Excel 2003, Windows XP Pro). SOMETIMES...not always, I try to access a file on a network drive I get the message: "path..filename could not be found. Check the spelling of the file name and verify that the file location is correct". Once I get the message on that file, I always get it on the file....but there might be 27 others in the same folder that I can open. And I get the message if I try to open the file via explorer or via Excel. If I copy the file to my C: drive it opens fine. I even tried t...
Sum Function Help Please
I have created two Option Groups, setting up values against the radio buttons. The output from both boxes works fine (thanks to the Wizard), however when I'm creating a formula on the report, I'm unable to add the two returned values together. If I type in =([Q1]+[Q2]) then I get both numbers concatenated together (ie returned value from Q1 is 1 and returned value from Q2 is 2, the answer I get is 12 !!!!.) Interestingly if I enter =([Q1]-[Q2]) then I get the correct answer. Any help would be greatly appreciated here. I could be wrong, but it seems like access i...
2nd request for help -PLEASE PLEASE PLEASE
went through a windows update and was asked to reboot which I did. I had Outlook open and closed it before rebooting - it was opened to contacts. when I tried to access Outlook I got an error message saying "your personal address book could not be opened. the file is either not accessible or not a personal address book. choose retry to access your personal address book, or choose cancel to not open your personal address book with this application." I have no other application to open this address book with! my contact info is detrumental to me as well as my Calendar ...
In Word How do I switch off auto date insertion please
How can I disable? ...
Remove template help task pane from startup
I created an invoice using one of Microsoft's templates. The help template appeared when I was designing the invoice. Now that the invoice is finished, I would like for the help template to NOT appear. I went to Tools-Options and unchecked "startup task pane" and also went to Tools-Customize and unchecked "Task Pane". This made the task pane go away, but only until I opened it again. Is there any way to make it not show up every time I open the document? ...
Can't SEND SSL email out!! Please Help... it HURTZ!
OKay... being a bit silly about he hurting part. I have a strange email issue with some of my computers at home that I use for work. We have 4 computers. 2 of them work FINE, the other 2 have issues. I know the email accounts are working correctly because if I run them on the 2 *good* computers they work like they should. Configurations: (GOOD Notebooks) 1 - HP AMD-XP notebook with WinXP-Home SP1, Office 2000 2 - Sony P4 Notebook with WinXP-Home SP1, Office 2000 (Bad systems) 3 - Dell P3 notebook with WinXP-Pro SP1, Office 2002 4 - Compaq AMD-XP with WinXP-Home SP2, Office 2000 ALl ma...
Help with formula #3
I need to edit this formula 2 ways =COUNT(J1:J5) first way I need it to count any cell with a value lower then 10 as 1 and any cell with a value of 10 or higher as .75 For example if cells j1 to J4 are all valued at 6 but cell J5 is value at 11 the total I get would be 4.75 Second formula I need is to count J1 to J5 only the cells with a value of 10 or higher as .25 For example if cells J1 to J4 are all valued at 6 but cell J5 is value at 11 the total I get would be .25 Hi Leave Alone! First problem: =COUNTIF(J2:J6,"<10")+COUNTIF(J2:J6,">=10")*0.75 Second pro...
Please Please Please help
Hi I have a Worksheet with option buttons and I need the users to be able to click on the options but not be able to drag or move them. I don't want the users to be able to click into or type anything in any of the cells - only these options buttons???? How is it done. I have tried unlocking all cells and then locking the individual ones, but the user can still drag the option button around and they could do this by mistake thus upsetting the design of my sheet! I have tried protecting the sheet for Objects - but then I can't click on the option at all ....Please someone help...
I need help with SQL please
I have a form with a group box on it. The code for it is: 20 Select Case grpPlan.Value Case 1 30 strMon = "WorkRec" 40 Case 2 50 strMon = "IntRec" 60 Case 3 70 strMon = "FinalRec" 80 End Select After I select the one I want then the SQL is build based on the selection and a report is generated. strWhere = "EmpSuper.WorkRec=""" & strMon & _ """ or EmpSuper.IntRec=""" & strMon & _ &quo...
Help with series data
I am trying to create a sheet.. But In A1 i need to to look like this: TOTE20000 TOTE20000 TOTE20000 TOTE20000 TOTE20001 TOTE20001 TOTE20001 TOTE20001 BUT i need to keep this series up to TOTE24999 Can anyone help me with a simple solution? It wont see the pattern with TOTE infront but will with just the numbers, But when I do a Replace it starts chunkign the numbers to decimals. I appreciate any help! I have to read between the lines a bit because I'm not really clear on what you want. Let's say you want to enter 20000 in the cell, but you want it to be displayed as TOTE20000...
conditional formatting help please 07-19-07
Hello, I am having trouble using the conditional formatting. I want the background of the "End Date" to turn red when the "Start Date" is entered and then for the red background to go away after an "End Date" is entered. I used the expression ("Start Time" Is Not Null) and that made my background red but I can't seem to figure out how to get the red background go away. I tried a couple of diffrent expression like setting another condition ("End Time" Is Not Null) but it didn't work. Can some please help me find the right express...
Help with vlookup results for summary
I gotta vlookup table and on tha other worksheets people enter the info from dropdown boxes. I need to show the books sold and the average of looks at it after being chosen to be listed as a summary. A B C red book $15 x Blue book $10 x red book $20 w So if a "red book" "$15", a "blue book" "$10" and a "red book" "$20" was sold, and I want to list red book or W books, how can I display this summary info? It should look something like this so i can use the figures for sums and division. Red Book | 2 | ...
formula help #34
cell J2 has starting balance of 500,000 cell J3 has running sum from column D column D has both positive and negative entries The running sum in cell J3 is 25% of total entries in column D I need to subtract cell J3 from cell J2 but when I enter too many negative numbers the initial amount goes past 500,000 in J2. How do I keep cell J2 from going past the initial 500,000? Excel 97 SR-1 Thanks, Steve T If you're saying you don't want it to SHOW less than 500,000, then you could use something like: =IF(MYFORMULA<500,000,500,000,MYFORMULA) If you want to be ALERTED when it's ...
modify macro
Hi everyone I'm VBA dumb so please bear with me. I have a macro that inserts a row at the selection and then I want it to copy the cell below the selection and paste into the new row's cell. Here's what's in the macro now Selection.EntireRow.Inser Range("D23").Selec Selection.AutoFill Destination:=Range("D22:D23"), Type:=xlFillCop Range("D22:D23").Selec When I run the macro, a row is inserted above the cursor's location (no matter where it's placed) but the AutoFill is always to D23. My question is how do I get the cod...
lost toolbar in win word and outlook
i could use some help. my toolbar has disappeared in word and when i use word as my email editor in outlook. i have tried a couple of online suggestions, but to no avail. i want to remove office then do a reinstall. it seems like my only choice right now. Hi - I can't help you (sorry) because I'm having the same problem as you are. I just posted my subject earlier tonight also. -".... Can't edit a forwarded message when using plain text ...When forwarding a message using plain text, I can not edit, underline, change,font, etc". I haven't rec'd any replies ...
Hello, I've been trying to add a toolbar to my dialog following the example from MSDN a http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcmfc98/html/_mfc_ctoolbar.asp But for some reason I just can't add the toolbar I created. Here is my code: CToolBar m_toolbar; if (!m_toolbar.Create(this, WS_CHILD | WS_VISIBLE | CBRS_TOP | CBRS_GRIPPER | CBRS_TOOLTIPS | CBRS_FLYBY | CBRS_SIZE_DYNAMIC, IDR_TOOLBAR1)) { MessageBox("Error -1"); } m_toolbar.LoadToolBar(IDR_TOOLBAR1); Could somebody please tell what, if anything, I am doing wrong? Thank you, V...
Outlook 2003 Messages and Calendar Appts Received as PLAIN TEXT
SGVsbG86DQoNCkkganVzdCBnb3QgYSBuZXcgbGFwdG9wIHdpdGggVmlzdGEgSG9tZSBCYXNpYyBv biBpdCBhbmQgSSBjb3BpZWQgbXkNCnBzdCBmaWxlIGZyb20gbXkgb2xkIGxhcHRvcCB0byB0aGUg bmV3IG9uZS4gRXZlcnl0aGluZyB3b3JrcyBmaW5lDQpleGNlcHQgYWxsIGUtbWFpbCBtZXNzYWdl cyBhbmQgY2FsZW5kYXIgYXBwdHMuIEkgcmVjZWl2ZWQgYXJlIGluIHBsYWluDQp0ZXh0LiBJJ3Zl IHNlYXJjaGVkIGV2ZXJ5d2hlcmUgZm9yIHRoaXMgZml4LCBidXQgZm91bmQgbm90aGluZy4gDQoN CkRvZXMgYW55b25lIGhhdmUgYW55IHN1Z2dlc3Rpb25zIGZvciBtZT8gDQoNClRoYW5rIHlvdSEN ClNwdWRkeQ0K me@cox.net <me@cox.net> wrote: > I just got a new laptop with Vista Home Basic on it and I copied my > pst file...
Office 2007 Professional: Help Files Issues
Gents, I cannot find a solution to this odd issue and before I submit a support ticket I thought I would ask the community. We have office 2007 professional (volume licensing) on a Window 2003 terminal server. We have a few users out of a bunch that get the "This page is unavailable" I have tried the Refresh and back. I've tried online and offline modes. In offline I get the table of contents to the left but same unavailable message when I click the links. I noticed on testing some other users, that apparently never used the help. That there are some prompts...
Missing Transactions #2
Hi, When I update my transactions after downloading from the web site some of the old transactions start missing. I have to check and update the acount register to get the balance same. Why is it happening like this? Once downloaded should I reconcile so that they would not miss or how should I do? -- Chanikya ...
Help with Regexp, please
Hi, The regular expression (\d{15,16}) matches a substring in a cell. I want to extract the remaining part of the cell ie. from the character after the matched substring till the end of the string in the cell using a regular expression. Is it possible to do this? Thanks in advance for the help. Regards, Raj Raj, with abcd15,16xyz in a cell the code below abstracts abcxyz. Maybe you can use this as a basis to develop your code Function GetSubstring(S As String) As String Dim re As Object Set re = CreateObject("vbscript.regexp") re.Pattern = &quo...
Spell Check Help
I have this code in the AfterUpdate in a TextBox set for a memo: If Len(Me!casefacts & "") > 0 Then DoCmd.RunCommand acCmdSpelling Else Exit Sub End If everytime the spell check executs, it check the whole form. How can I get it to just check that one textbox and not everything else. bladelock wrote: >I have this code in the AfterUpdate in a TextBox set for a memo: > >If Len(Me!casefacts & "") > 0 Then > DoCmd.RunCommand acCmdSpelling > Else > Exit Sub >End If &...
Balance changes when selecting reconciled transactions only
I have a problem with Money 2003 where the account balance changes when switching from "view all transactions" to "view unreconciled transactions". Anybody have a fix?? I am having the exact same problem in Money 2004 and it is driving me crazy. Does the problem you have trickle through to your Account Summary and Portfolio...it does with mine and if I dig deeper I think I will find that it messes with the way a Budget is created...Can someone at Microsoft help us on this one??? -Matt >-----Original Message----- >I have a problem with Money 2003 where the a...
Publisher 2007 Trial Help
I installed the trial version of Publisher 2007 and want to uninstall it now. I have tried to remove in the "add/remove" programs section. And I have also tried a suggestion I found in an earlier post about going to the "installer" and trying to uninstall it there. Oh and I tried repairing it and then trying to uninstall it. I can't even open the program from my programs menu and I can't get into the language section to check the language. It tells me that the language isn't compatible with my version or something to that effect. Nothing has worked...
Default Value on Form Help
I have a query that calculates the total of a field in my table - Field Name in my Table is Total Value which calculates the total for a series of records that has the same invoice number. Field in in my query is Aggregate Value. I now have a form where I bring in the Aggregate Value. I need to create another Text box Value Verified where I bring in the Aggregate Value as a default, but I may have to change it if the Value has changed - but the Aggregate Value has to remain the same. I tried using default value on the form for the Value Verified Text control that brings in ...
PLEASE PLEASE HELP
I Have an emergency... I deleted a macro !!! I have 60 rows with checkboxes on cells A1 trough A60 that automatically as checked were inserting current dates on the cell next to it. for some reason a disaster happened and the macro was deleted or messed up. I tried searching for help in these groups, but none so far. I found one, but it is not a macro besides when I use that function all the other previous dates keep changing when other checkboxes are checked on in different days of the week. If you can please guide me to the right answer I will appreciated. Hope I made sense with my explana...
Cannot access a file -- HELP
I have this problem at work (using Excel 2000 Windows 2000) and at home (Excel 2003, Windows XP Pro). SOMETIMES...not always, I try to access a file on a network drive I get the message: "path..filename could not be found. Check the spelling of the file name and verify that the file location is correct". Once I get the message on that file, I always get it on the file....but there might be 27 others in the same folder that I can open. And I get the message if I try to open the file via explorer or via Excel. If I copy the file to my C: drive it opens fine. I even tried t...
Sum Function Help Please
I have created two Option Groups, setting up values against the radio buttons. The output from both boxes works fine (thanks to the Wizard), however when I'm creating a formula on the report, I'm unable to add the two returned values together. If I type in =([Q1]+[Q2]) then I get both numbers concatenated together (ie returned value from Q1 is 1 and returned value from Q2 is 2, the answer I get is 12 !!!!.) Interestingly if I enter =([Q1]-[Q2]) then I get the correct answer. Any help would be greatly appreciated here. I could be wrong, but it seems like access i...
2nd request for help -PLEASE PLEASE PLEASE
went through a windows update and was asked to reboot which I did. I had Outlook open and closed it before rebooting - it was opened to contacts. when I tried to access Outlook I got an error message saying "your personal address book could not be opened. the file is either not accessible or not a personal address book. choose retry to access your personal address book, or choose cancel to not open your personal address book with this application." I have no other application to open this address book with! my contact info is detrumental to me as well as my Calendar ...
In Word How do I switch off auto date insertion please
How can I disable? ...
Remove template help task pane from startup
I created an invoice using one of Microsoft's templates. The help template appeared when I was designing the invoice. Now that the invoice is finished, I would like for the help template to NOT appear. I went to Tools-Options and unchecked "startup task pane" and also went to Tools-Customize and unchecked "Task Pane". This made the task pane go away, but only until I opened it again. Is there any way to make it not show up every time I open the document? ...
Can't SEND SSL email out!! Please Help... it HURTZ!
OKay... being a bit silly about he hurting part. I have a strange email issue with some of my computers at home that I use for work. We have 4 computers. 2 of them work FINE, the other 2 have issues. I know the email accounts are working correctly because if I run them on the 2 *good* computers they work like they should. Configurations: (GOOD Notebooks) 1 - HP AMD-XP notebook with WinXP-Home SP1, Office 2000 2 - Sony P4 Notebook with WinXP-Home SP1, Office 2000 (Bad systems) 3 - Dell P3 notebook with WinXP-Pro SP1, Office 2002 4 - Compaq AMD-XP with WinXP-Home SP2, Office 2000 ALl ma...
Help with formula #3
I need to edit this formula 2 ways =COUNT(J1:J5) first way I need it to count any cell with a value lower then 10 as 1 and any cell with a value of 10 or higher as .75 For example if cells j1 to J4 are all valued at 6 but cell J5 is value at 11 the total I get would be 4.75 Second formula I need is to count J1 to J5 only the cells with a value of 10 or higher as .25 For example if cells J1 to J4 are all valued at 6 but cell J5 is value at 11 the total I get would be .25 Hi Leave Alone! First problem: =COUNTIF(J2:J6,"<10")+COUNTIF(J2:J6,">=10")*0.75 Second pro...
Please Please Please help
Hi I have a Worksheet with option buttons and I need the users to be able to click on the options but not be able to drag or move them. I don't want the users to be able to click into or type anything in any of the cells - only these options buttons???? How is it done. I have tried unlocking all cells and then locking the individual ones, but the user can still drag the option button around and they could do this by mistake thus upsetting the design of my sheet! I have tried protecting the sheet for Objects - but then I can't click on the option at all ....Please someone help...
I need help with SQL please
I have a form with a group box on it. The code for it is: 20 Select Case grpPlan.Value Case 1 30 strMon = "WorkRec" 40 Case 2 50 strMon = "IntRec" 60 Case 3 70 strMon = "FinalRec" 80 End Select After I select the one I want then the SQL is build based on the selection and a report is generated. strWhere = "EmpSuper.WorkRec=""" & strMon & _ """ or EmpSuper.IntRec=""" & strMon & _ &quo...
Help with series data
I am trying to create a sheet.. But In A1 i need to to look like this: TOTE20000 TOTE20000 TOTE20000 TOTE20000 TOTE20001 TOTE20001 TOTE20001 TOTE20001 BUT i need to keep this series up to TOTE24999 Can anyone help me with a simple solution? It wont see the pattern with TOTE infront but will with just the numbers, But when I do a Replace it starts chunkign the numbers to decimals. I appreciate any help! I have to read between the lines a bit because I'm not really clear on what you want. Let's say you want to enter 20000 in the cell, but you want it to be displayed as TOTE20000...
conditional formatting help please 07-19-07
Hello, I am having trouble using the conditional formatting. I want the background of the "End Date" to turn red when the "Start Date" is entered and then for the red background to go away after an "End Date" is entered. I used the expression ("Start Time" Is Not Null) and that made my background red but I can't seem to figure out how to get the red background go away. I tried a couple of diffrent expression like setting another condition ("End Time" Is Not Null) but it didn't work. Can some please help me find the right express...
Help with vlookup results for summary
I gotta vlookup table and on tha other worksheets people enter the info from dropdown boxes. I need to show the books sold and the average of looks at it after being chosen to be listed as a summary. A B C red book $15 x Blue book $10 x red book $20 w So if a "red book" "$15", a "blue book" "$10" and a "red book" "$20" was sold, and I want to list red book or W books, how can I display this summary info? It should look something like this so i can use the figures for sums and division. Red Book | 2 | ...
formula help #34
cell J2 has starting balance of 500,000 cell J3 has running sum from column D column D has both positive and negative entries The running sum in cell J3 is 25% of total entries in column D I need to subtract cell J3 from cell J2 but when I enter too many negative numbers the initial amount goes past 500,000 in J2. How do I keep cell J2 from going past the initial 500,000? Excel 97 SR-1 Thanks, Steve T If you're saying you don't want it to SHOW less than 500,000, then you could use something like: =IF(MYFORMULA<500,000,500,000,MYFORMULA) If you want to be ALERTED when it's ...
modify macro
Hi everyone I'm VBA dumb so please bear with me. I have a macro that inserts a row at the selection and then I want it to copy the cell below the selection and paste into the new row's cell. Here's what's in the macro now Selection.EntireRow.Inser Range("D23").Selec Selection.AutoFill Destination:=Range("D22:D23"), Type:=xlFillCop Range("D22:D23").Selec When I run the macro, a row is inserted above the cursor's location (no matter where it's placed) but the AutoFill is always to D23. My question is how do I get the cod...
lost toolbar in win word and outlook
i could use some help. my toolbar has disappeared in word and when i use word as my email editor in outlook. i have tried a couple of online suggestions, but to no avail. i want to remove office then do a reinstall. it seems like my only choice right now. Hi - I can't help you (sorry) because I'm having the same problem as you are. I just posted my subject earlier tonight also. -".... Can't edit a forwarded message when using plain text ...When forwarding a message using plain text, I can not edit, underline, change,font, etc". I haven't rec'd any replies ...