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!

  • Congratulations wOOdy-Soft 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: *

  • Users: smiley0q0
  • Content: Threads
  • Order by date
  1. smiley0q0

    rotate txtbox 90 degrees

    is there any way to make a txt box show the text vertically? not like this D A T A but actually rotated 90 degrees... thanks, Jared
  2. smiley0q0

    project database

    has anyone made or seen an access project database to keep track of projects, their status, estimated completion time... etc. i've seen microsoft project .. just wondering if there was anything out there that i would be able to more easily manipulate to my own needs... thought about making...
  3. smiley0q0

    copy design mode of table

    is there any way i can copy and paste the design mode of a table? I need to see the Field name, the data type and the description? thanks, Smiley
  4. smiley0q0

    close database when idle for period of time

    Is there a way to have a database close when it has been idle for longer than 30 minutes? would like a warning box to come up saying something like This database has been idle for 30 minutes, if you would like to keep it open, click whatever.... have that box have a timer thing on it that...
  5. smiley0q0

    maximizing on open

    Don't know if this is the right place to put this question but here goes. Why is it if i have an access database open and i open another, that one doesn't open in maximized mode? Is there any way I can change this so no matter what it opens maximized? I've tried the on open event, but for some...
  6. smiley0q0

    list box changed to datasheet form

    I used to have a list box that listed several locations and other quick summary items from a table, if the users double clicked on one of the items a form would come up with the detail for that location. the users thought it would be nice to be able to sort by the columns in the list box, the...
  7. smiley0q0

    simple middle name pull formula

    hi, i'm sure this is pretty simple, but i'm a little rusty on my excel formula's i have column that has first, middle and last name seperatede by comma's i have managed to pull the first and last name out and put them into their own cell, but i am having a brain cramp of how to pull the middle...
  8. smiley0q0

    tabbed form information

    I have a tabbed form with 3 tabs. the question i have is there a way to have some text just to the right of my 3 tabs that says a breif description of that specific tab? ie. my three tab names are ANI Carrier Order When i seleect the ANI tab, i would like "ANI BRANCH INFORMATION&quot...
  9. smiley0q0

    group by month in query and average date

    is there a way to group my dates by the month? i have a table that has 2 years worth of dates. it has DptName, EmpName, EmpTermDate, NumHrsWrkd I have been asked to provide a report that shows by month a list of how many people quit in each department, the total hrs worked and an average date...
  10. smiley0q0

    form with list of check boxes

    ok, i am fairly new to access, so i'm looking for some help on this form i am trying to develop. i have a table that has a list of serial numbers and some other data like location etc... but what i am trying to do is create a form that shows the serial number and a list of all the available...
  11. smiley0q0

    seperating city and address in 1 cell

    i have been given a spreadsheet that has the whole address (address, city, state, zip) in one cell, i am trying to seperate them out into their own cells. the zip and state were simple, i am having trouble with the city and the address because of the different lenths of city names and not...
  12. smiley0q0

    new data to list in cmbo box

    I have a form that has a drop down combo box that is limited to the list. (the list is TblCompName) When the user enters new data in, there is a button that allows them to add a new company to the list, the button opens a form where they just type in the new company and click a "done&quot...
  13. smiley0q0

    format list box

    is there any way to format a list box? i have a list box that pulls data from my TblMain, everything works great except for the "OfficePhone" column... it pulls the number in just fine, but i have this input mask \(###") "###" - "#### in my table, the list box is...
  14. smiley0q0

    no not include table

    i am a novice with access... so this might be a dumb question... i have 2 tables, one with 500 usernames (TblMain) and another with 20 of those user names (TblFilter). i would like to make a query that lists all of the user names in the main table except for the ones that are in the filtered...
  15. smiley0q0

    code for conditional tab color

    i am a rookie at using code in excel, but i think this is the only way to make happen what i want to happen. I have a main page where i enter different amounts in column G... about ten of them... then i have 10 seperate sheets, each sheet looks at a single amount... in the individual sheets...
  16. smiley0q0

    easy excel formula

    i think i've done this it before, but i can't find it. lets say in A1 i have a phone number with the dashes ie 817-358-4874 in another cell i want a formula that looks at A1, but doesn't show the dashes. so it looks like: 8103584874 make sense? if all else fails, i'll just do a...
  17. smiley0q0

    excel cell formatting with concatination

    I have 3 sheets in an excel document. the first one i input a dollar amount in cell E1. the second sheet, i put in the same amount in cell G2, but this cell is custom formated to have 16 digits. (ie. 0000000000152.36) then in the 3rd sheet it concatinates A2 through K2 what i want to be...
  18. smiley0q0

    Control+D disable

    Is there any possible way to disable the control+D function in an excel spreadsheet? heres what's going on... got an employee that has a list of about [bold]20,000[\bold] invoice numbers, she gets a nice big stack put on her desk every month and what she does is a control+f to find the invoice...
  19. smiley0q0

    multiple word document shortcut

    Quick question... does anyone know if there is a shortcut key(s) in word to flip to the other open word documents, like the ctrl+tab in excel? Thanks, Smiley [worm]
  20. smiley0q0

    unkown password sheet, need to unprotect

    my boss has given me some old excel spreadsheets that the sheets were password protected by some unknown john doe can't get into them to make the necessary changes [flame] could start from scratch and do some copy paste, but i thought i'd try here first... a while back I saw either a FAQ or a...

Part and Inventory Search

Back
Top