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...
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...
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...
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...
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...
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"...
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...
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...
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...
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"...
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...
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...
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...
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...
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...
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...
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]
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.