Search results

  1. R

    shiver me timbers.. old john McCain?

    Old johnny boy is not as confident as one might think in the up coming presidential race but a 'in office' government official, more over the potentially the next president concerned about the environment? and he's a YANK...
  2. R

    MS Outlook - Attachments Question

    Hi, Im currently doing a Data Storage project for my company and one of our biggest problems is Duplication via email attachments. Dealing with this is fine because it will baiscially come down to comms telling people how to use the file link feature & setting up a file transfer folder if folder...
  3. R

    ListView Checkbox problems...

    Rite, So i got a ListView box that is controlled by a combobox, so when the user selects a name the ListView populates with the check-boxes being the first column. I have set them so they are all checked (true) because this is what the user requires more often then not. However for those odd...
  4. R

    counting and checking n levels in a recordset

    Hi, I need to work out how many components we have in stock that make up a Part - identified by being the PrimaryPart. Each part has a component, which in turn has another component, but different part have a different number fo sub-components, a simple display of the table I am using is shown...
  5. R

    Man Cut His own Penis off!

    http://news.bbc.co.uk/1/hi/england/london/6586879.stm its a weird feeling laughing and cringing at the same time!
  6. R

    Joining the Gym...

    I've been considering it since my sporting days have been non-exsistent the last couple years but do you consider it to be worth it or just a waste of money?
  7. R

    The Chinese Army - Hacking Division

    Working for a large defense contractor (I wont disclose which one) but its the one which pretty much makes all the 'planes trains & automobiles' for the UK & US army & we do alota work for the other countries such as the Saudies. However as all companies do we had a team day the other day...
  8. R

    Data hand-down

    Reet, I have a problem i have been pondering over for the last hour or so and im not sure the best way to do this! Its slightly tricky to explain so bare with me! So I've made a Software Licensing Database which tracks licenses etc.. Its based information provided by another company which...
  9. R

    How badass is Call Of Duty 4..

    I've since lost the zest for online gaming a couple years ago, it died with Counter Strike when their was a cheating epidemic and you never knew who was/wasnt cheating! but now i'm addicted again with COD4! Anyone else played it? One of the few games with a great Single and Multiplayer!
  10. R

    Do Until loop possibly?

    Afternoon all, well my problem is I have a list of license's (software) & my bosses have decided that rather than having information saying we have 50 installs & 45 licenses they want licences specifically assigned to people. The assigning is not the problem its the creating this list...
  11. R

    String Concatenation of same field.

    Hello all, rite baisically i've imported an excel spreadsheet and it contains a list of purchase orders, however where their is multiple items for a purchase it splits the order up into multiple items on the spreadsheet. For Example: Order Number Product 1...
  12. R

    delete records higlighted within a subform?

    Helo all, fairly simple problem but im the solution could be a problem! Anyways I ahve a form that displays a Computers Information such as: user, pc build etc.. On this for i also have a subform thats shows what software and licenses are attached to this system. Relationships are made through...
  13. R

    Write Conflict when user Updates Customers Information on Form.

    Hi, Well I know why this happens b/c the table that the information is being pulled is the subsequently being updated however when moving to a diff customer or closing the form etc.. The user is then displayed the MsgBox of Write Conflict and supplying the user with 3 options of Disregarding...
  14. R

    Sum Total giving interesting result?

    Ok baisically im doing a quick db for my company that is organising every file stored within the server and monitoring their last access'd, modified etc... I have a query which collates all the files which can be deleted on a server and file count is something alond the lines of 300K+ however i...
  15. R

    VBA Module Update Query, Null Values etc..

    Howdy I've got this module which is suppose to look all the tables listed within a table & find the customers within these tables and get the averages for each question of the customer surveys. However for some reason the sql statement is trying to find every customer in every table and if it...
  16. R

    Average from Multiple Columns

    Hi, I've got all the columns i require in my query and and i've averaged these, however i need to create a final column which contains the Average of all the other Column Averages.. if you get what i mean! Put it this way i have columns A, B, C. All the numbers containd within each column...
  17. R

    Access Import destroying Excel Table/Cell format..

    Hi All, this could be very simple or hard im not really sure anyways, I've got a very swish looking spreadsheet that imports data from an access database and it all works beautifully. However my only problem is that when it imports into Excel it squashes everything up so its rather difficult...
  18. R

    Import all excel files within a given directory?

    Hi all, as the title says i want to create a script that will import all excel files in a give directory and put them all into 1 temp table within access. All the excel spreadsheets are in exactly the same format. I can import a single spreadsheet into access no problems but as far as i can...
  19. R

    Query Design.DB Design question

    Hey, I've got this problem and im 95% sure its going to need a query in order to achieve this answer im looking for. I'm creating a Software Licensing Management db and its all working lovely. However my only problem remains is the graphical representation (text box within one of the forms)...
  20. R

    Autofill Query Field based upon other fields within the same query?

    Hi, Baisically I got this query which controls the selection of Software within a system. i.e. It contains the fields Vender_ID, Application_ID, ApplicationEdition_ID and ApplicationVersion_ID. These auto-filter based upon the users selection (e.g. Vender=Adobe so...
Top Bottom