Search results for query: *

Hi, This is in Excel. I have got some rows of transactions. There is an ID number for the accounts in column A and a code for the transaction type in column C. I am trying to do something in vba or with formulae, but its proving difficult. The idea is to check column C, if the transaction...

Hi, I have got a table with a field for percentages It is set to: Data type: Number Field size: Double Format: Percent Decimal places: 2 On my form the text box is: format: percent Decimal places: 2 What i want to do is instead of having 21.9 come out as 2190% when you type it in the text...

Hi, i have got a form made from a table called TblMain. Each record has a date field for date entered. I have made a field in TblMain to hold the week commenced date. Just need to figure out how to have a working calculated field in the form so that the calculation saves in tblmain. The...

Hi, I am trying to do the below: Have a macro that will create a new workbook, with new sheets, amounts and names of which are dependant on a list in column A. So A1 = Menu A2 = User A3 = Data which will create a new workbook with 3 worksheets in it called 'menu' 'user' and 'data'. I have...

Hi, Spot of bother with this, can anyone help? its in Excel. I have a userform called FrmMaintenance. It has 4 option buttons: OptTitle OptPassed OptAbility OptReason A textbox: TxtAdd A Listbox: Listbox1 3 buttons: CmdAdd CmdDelete CmdOk The idea of it is, the option buttons update the...

Hi, This is in Excel.. I am having a bit of trouble figuring a way to do the below, wondering if its easier to do in vba. Table1 User Name Team Name User1 Team1 User2 Team1 User3 Team2 This table is set out in this way, giving the user's name and the...

Hi, I have got a problem and im not sure what is causing it, I have a table that should have 3036 records in it, and a backup from last night does have it, todays has 750 or so records, loads missing?? The other tables linked to this table still have all the records im guessing its corrupt...

Hi, this is example data in a separate sheet: Owner Reference OpenDate ClosedDate 39007 12345543442 14/04/2004 15/05/2004 39007 36363453544 30/09/2004 ? 39007 86565545453 02/04/2004 07/05/2004 39004 56780957463 07/06/2004 23/06/2004 39004 87486765489 25/05/2004 ? 39005 23456789053 22/04/2004...

Hi, I am having a little trouble trying to figure a way of doing this, i tried to do it the =INDEX( ,MATCH(),MATCH()) way, but its not setup to do it very easily. I have got sheets 'Summary' and 'Users' 'Users' is a table with 2 columns as below USER ID TEAM BOBB Team 1...

Hi, could someone point me in the right direction to the best simplest way to password protect an excel workbook so that a password has to be entered before going to the first worksheet, whether someone enables macros or not. I have used excel security to protect the workbook from creating new...

Hi, I am trying to do a formula to work out the result of the example below, its proving a little difficult.. A B C D User location Group Minutes 1 Bill 7 3 10 2 Alison THP...

Hi, i am trying to work out how to delete from a listbox this is what i have so far. OptTitle is 1 of 4 option buttons, each uses a different range, the 4 ranges are displayed in listbox1, depending on which option button is clicked, for this one the sheet is "Titles" as shown below and the...

----------------------------------------------------------- Text to add: |_________________________________| 0 Option 1(Titles) To List 0 Option 2 |Add| -------------- |Cancel| 0 Option 3 |Delete| | Mr | |Ok| 0 Option 4...

Hi, I have got a combobox (CboTitle) with match required = true I was wondering how to stop run time error 380 from occuring when the information in the combo box is blank. Ive tried a few things in CboTitle_BeforeUpdate but nothing has worked as yet. I was trying to get it to check if...

Hi i was trying to find what i am after through the faqs, posts and google but nothing i have found explains what i am after. I have 2 text boxes on a user form, i want to show in 1 todays date always in the format dd/mm/yyyy or dd/mmm/yyyy or whatever is best when you have computers with...

Hi i was trying to find what i am after through the faqs, posts and google but nothing i have found explains what i am after. I have 2 text boxes on a user form, i want to show in 1 todays date always in the format dd/mm/yyyy or dd/mmm/yyyy or whatever is best when you have computers with...

Hi, Does anyone know how you could get a button with a macro attached, where the macro brings up the built in Find menu in Edit-> find or Ctrl + F, and maybe even have only the find tab presented and not the replace tab?? I tried recording a macro but it didnt give a way to open up the find...

Hi, I made an input database in Access to keep a log. I am getting fed up of people not knowing how to use Access and i dont want to have to keep telling people how to use it correctly or teach someone how to change details. I soon wont be dealing with this dbase, so i wanted to change it to...

Hi, Got a vlookup problem in excel I have checked out previous threads for this, i have seen Zathras' vlookupnext vba code as well, i havent had time to check it out fully. I was trying something else and wondering if its possible. ive sorted my numbers and used =countif($A$2:$A2,A2) in...

Hi guyz, Strange thing here. I have 2 access dbases both are split to backends of their own both are used among 15-20 people. Ive checked the startup menu on both dbases and they are identical apart from the name and the startup form, yet only one of them lets people close the .exe directly...