Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BSando

    Open recordset

    Hi, I want to call data from a table so I can manipulate the data. I am sure I need to use the openrecordset command. I can manipulate data how I want it, but can't work out how to call the field in the table. For example I have a table called "assetreport" and a field in the tabe is called...
  2. BSando

    Splitting text

    JbinQLD Thank yu for your help this s just what I needed. Some people make things happen, some watch while things happen, and some wonder 'What happened?'
  3. BSando

    Splitting text

    thanks. Looking at the Data again, the project name is always closed in brackets.Does that make it easier separating the data? Some people make things happen, some watch while things happen, and some wonder 'What happened?'
  4. BSando

    Splitting text

    Hi, I want to split text from a table feild into 3 query fields for manipulation later. The text looks something like: 1234 southside project X 1324 South bank Project Y And \i want it to look something like this: Site ID site name project ---------------------------------- 1234...
  5. BSando

    Importing Excel

    Hi All, I want users to import an excel file to a table. I want the user to be able to select the file they import because every file will not have the same name. Everyfile will have the same format. I have tried the Transferspreadsheet cmd but i get an error because I don't have the file name...
  6. BSando

    Update after selection

    Skip I found a work around. I just validated a cell instead of using the combobox and used Vlookup for the other cells that needs updating Thanks anyway Some people make things happen, some watch while things happen, and some wonder 'What happened?'
  7. BSando

    Update after selection

    Hi I'm sure this is simple but I just can't get me head around it. I have a combobox on a spreadsheet which is linked to a cell (B9) and when the user selects the item from the list I want to update cells on the same sheet based on a table. I can update the cells with the below code...
  8. BSando

    Next Available line in table

    Skip, Thanks for your help Some people make things happen, some watch while things happen, and some wonder 'What happened?'
  9. BSando

    Next Available line in table

    Hi all I have a spreadsheet set up as a form where the user selects a site location and the other fields (i.e Address) auto populate based on a table I have on a back sheet. This works fine. But if the user needs to add a new site and details I want to have a user form where the data is entered...
  10. BSando

    Date field

    I just wanted it to give the date the user fills in the form without updating it everytime it is opened Some people make things happen, some watch while things happen, and some wonder 'What happened?'
  11. BSando

    Date field

    Hi All. Thank you for your help. For now I have gone with macropod's suggestion and just make it the current date. I did try to update the formfield by clicking on a label but that didn't work. Thanks again Some people make things happen, some watch while things happen, and some wonder 'What...
  12. BSando

    Date field

    Hi All, I have a label in my word doco that I want the users to click on and this fills in a textfield with the date. It odes works with in reason, when I lock the form I get a message telling me it is a protected area of the document. what do I need to change so it works while the form is...
  13. BSando

    Checkbox range

    Fumei, my form as about 50 checkboxes on it. but I have broken those checkboxes up in to sections i.e. section 1 = area 1 of store, section 2 = area 2 of store etc. but I want to have a text field in each section on the form that tallies all of the checkboxes in that section. Some people...
  14. BSando

    Checkbox range

    Thanks. I tried to find the post, but I couldn't find it. I even looked under myThreads Some people make things happen, some watch while things happen, and some wonder 'What happened?'
  15. BSando

    Checkbox range

    Hi all, I have a word doco with checkboxes and thanks to help I have received I have been able count if the checkboxes are checked. But because I have about 50 check boxes on my form and my form is broken up into sections I want to be able to count the checkboxes by a range, so from checkbox1 -...
  16. BSando

    Working with MS Project

    Hi All, It has been a few years since I worked with MS Access, so please be gentle. I want to create a DB for Telco projects, but I would like to be able to export the data to MS Project. Does anyone know if this is possible Some people make things happen, some watch while things happen, and...
  17. BSando

    Access with Project

    Is it possible to export data from access to MS Project? Have a Merry Christmas Guy's Some people make things happen, some watch while things happen, and some wonder 'What happened?'
  18. BSando

    Unrecognised database format

    I lost my database due to a virus and I wnated to load a backup copy I have. The backup is a MDB file, but when I try to open it I get told 'Unrecognised database format D:\Implementation backup.mdb' I have tried to import the table etc to a new db but no joy. Any suggestions? Thank you in...
  19. BSando

    Transpose Table into excel

    Hi All, I have a table I want to export to excel but i want to transpose the data and remove the field names from this: field1 field2 field3 john tim bob ----------------------- to this: ----------------------- John Tim bob any help would much be appreciated Thanks Some people...
  20. BSando

    Word Table

    I have a excel workbook that I want to open from Access and copy and paste cell data to a new word document, but I want to paste the data in to a table. Any ideas? Thank you an advance Some people make things happen, some watch while things happen, and some wonder 'What happened?'

Part and Inventory Search

Back
Top