i have a subform which lists of data.
is it possible to create an event from that list?
like if user double click a "name" from a subform?
each row contains different info so... how would i approach this>?
i want my subform to requery after updating data in another form.
right now, i have a subform which requeries when i click the command button but i was wondering if there is a way to do it in a time frame or such.
so that user don't have to close and open everytime to see if there was an...
i needed to find a way to refresh/update report after an update but i guess that's not possible in access.
so someone recommended continuous form.
what exactly is continuous form? and how can i approach
to create a form which works as a report?
is it possible to list them by itself after an update?
i know in sql they have stored procedure which updates immediately after a new data is entered. Does access have this kind of feature?
Able to update a opened report when a new data is entered?
i have a database that's on a shared folder. i would like to have the one on the main computer to...
isnt it possible to have your report opened and have it refresh on it's own every 10min or so?
or do i have to close and reopen everytime to check for an update??
i've linked 2 cbo boxes from different forms.
so from form 1 if user selects OK, it opens form 2
and that record shows up on form 2 as well.
problem is i need to show different column on the form 2.
i.e. if first combo box contains 2 colums,
"Name", and "Number". (but only shows "name" from...
i've linked 2 cbo boxes from different forms.
so from form 1 if user selects OK, it opens form 2
and that record shows up on form 2 as well.
problem is i need to show different column on the form 2.
i.e. if first combo box contains 2 colums,
"Name", and "Number". (but only shows "name" from...
how would i create a list with "option" then record to the table.
like lists of description /w empty check boxes. so when user clicks one of the check box, that description is then recorded to the table.
?
Private Sub password_AfterUpdate()
=DLookUp("[password]","tblpasswordMonitor","[password]=forms!frm_pwMonitor![password]")
End Sub
trying to set up a quick pw filter and open if it's true..
what am i missing?
Im not sure if this is possible in Access but...
From FormA, if user clicks command button,
a pop up will show up and ask for password.
if true, then open FormB, if false, retry or close.
is that possible?
does anyone know where i can maybe download a sample of a budget database? im new to access and vba and im trying to learn different types of databases. i've downloaded most of the samples available from microsoft but didnt see any that's related to budget or financial database. any suggestions?
i have a dynamic forms. how do i make it so that
when user select from a list box, type amount, and click cmdbutton.
and then select another from another listbox on new form.
and click cmd button,
it'll subtract amount from first row selected from the list box and then add an amount to the row...
i just updgraded to access 2003 and now my file won't open. it says it's missing MSACCESS.EXE
i searched it manually and now it says
the dynamic link library mso9.dll could not be located
what is going on? i hope i didnt lose my database...
i have a form which filters
stDocName = "frmFsource"
stLinkCriteria = "[StaffID] = '" & Me![cboStaffID] & "' And [AbID] = '" & Me![cboBud] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
and im trying to add another field. this one's little bit different since im not linking them...
if i have a listbox. is there a way user can select from that listbox and click a command button which will update other field from another form?
ie. lstTransFrom (if user highlights from the list)
from frmTF
cmdUpdate (then user clicks this command button)
Balance (from...
from the startup.. option, i disabled all the menus and such. which is fine... but i just realized that i can't even right click now... how can i change these settings back to normal?
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.