|
Hide menu options
When i run my database it shows the menu options how to i hide the
menu?
thank you.
...
|
2 |
12.09.2006 18:43:02 |
|
|
highlite a row
I have a table in form view with numerous records, how can i highlite the
whole row when selecting?
Diane...
|
11 |
12.09.2006 18:10:04 |
|
|
How can I do this?
Hello everybody, I have this report. When I double click on any of the
fields in this report I need the form Warehouse to open and to show the
record I've clicked on.... is it possible?
Thanks
...
|
5 |
12.09.2006 17:52:46 |
|
|
Add button in Inventory
Hi Guys, i have a problem adding my inventory.
I have a table call the "product"
Inside the product table i had a field call "UnitsInStock"
I wanted a textbox in the form to allow the user to key in the number of
quanity that is going to be added. once the number is key in, the user will
click on a add button to have the values added to the "UnitsInStock"
THanks for the help. :)
--
Mes...
|
4 |
12.09.2006 17:28:02 |
|
|
Using a combobox to filter a form with several subforms
I have form that we use to complete registrations for an educational program.
The tables I use are: tblprog2006 (key idsprogid), tblfamily (key
idsfamilyid), tblchild (key idschildid), tblcontact (key idscontactid). In
the registration form I have the main form as frmprog2006 with subform
counselor and subform volunteer as well as subform family. Within subform
family I have subforms c...
|
1 |
12.09.2006 16:45:03 |
|
|
Pop-up form based on original form criteria
I have numerous selections that can be either good or bad. If bad, I am
wanting a pop-up form to appear and the user to be able to type pertinent
information regarding whatever was selected in the original form. The trick,
however, is I am wanting the pop up to be dynamic so I don't have to creat
150 separate forms for every selection type.
ex.
1. User selects room temperature as...
|
1 |
12.09.2006 16:31:03 |
|
|
Finding record in form based on value in second form
What should be simple has me stumped. I have a main database form,
'frmJobs' open, the key field being 'ISSPropNo'. I then open a second
form, 'frmFind' based on a query which filters for different values in
the Jobs table, 'tblJobs'. The 'frmFind' form displays the key field
value of the selected record in a textbox control, 'chrISSPropNo'.
Several other values are also displayed to allow th...
|
1 |
12.09.2006 16:30:05 |
|
|
Error message when running a report from prompt form
I have a report that runs from a prompt form that has two controls for date
parameters. The report runs fine on my machine but when another user tries
to run the report they get this error message
"You entered an expression that has an invalid reference to the property
visible
The property may not exist or may not apply to the object you specified"
Can anyone tell me where to start lo...
|
3 |
12.09.2006 16:20:39 |
|
|
Using query in form?
I have a table with a lot of columns. I have two columns i want to prepair to
be used in a tablesheet form. One with sizenumber and another with
productnumber. I have a datasheet form where I want to use the data from
sizenumber and productnumber writen as one ex. "3-345767" (first number is
size and the second is productnumber). Well I succesfully done this in a
query table but I can't ...
|
3 |
12.09.2006 15:59:01 |
|
|
After Update - If specific result?
Here's my current AfterUpdate on a ComboBox:
Private Sub cboProductFamily_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
'Stop
rs.FindFirst "[Product_ID] = " & Str(Nz(Me![cboProductFamily], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
...currently working like a charm with two minor problems....
|
2 |
12.09.2006 15:46:02 |
|
|
Requery Form adds new record - why?
I've got a form that I need to Requery after a certain control is changed.
The control (which is an Option Group) simply has this code behind it:-
Private Sub frmJobType_AfterUpdate()
Requery
End Sub
This works fine if I open the form in normal mode (to edit an existing
record) however if I open the form in Add mode (using DoCmd.OpenForm
FRM_Jobs, , , , acFormAdd) the Requery seems ...
|
7 |
12.09.2006 15:38:46 |
|
|
Lost Focus??
Hi,
I have several date fields on a form that I want to tab thru. After
entering the date in the first and tabbing to the second, it seems as though
the whole form looses focus. The blue bar at the top dims until I press
enter and then I can enter the date in the second field. I checked tab
order and it's okay and tab stop is yes on property sheet.
Can someone please tell me what I'm d...
|
8 |
12.09.2006 15:12:22 |
|
|
Step through code?
In VFP I could include the line..
SET STEP ON
...in my code, and when it fired, the execution of teh code would transfer to
a window where I could step through the code a line at a time OR evaluate the
values of any variables that might be referenced there.
I have this code in the AfterUpdate of a ComboBox:
Private Sub cboProductFamily_AfterUpdate()
' Find the record that matc...
|
6 |
12.09.2006 14:26:02 |
|
|
Select entire field
Hi all,
How can I select entire a field after it has been updated ?
Here are some code in my form:
'---------------
Private Sub AccID_GotFocus()
Me.TempID = Me.AccID
End Sub
'------------------
Private Sub AccID_AfterUpdate()
If DLookup("[AccID]", "AccTbl", "[AccID] = '" & Me.AccID & "'") > 0 Then
If Me.AccID <> Me.TempID Then
MsgBox "AccID Exist !"
Me....
|
1 |
12.09.2006 13:53:02 |
|
|
Combo Box In Table Not Showing On Form Field
I have a combo box that I created to link to a table that indicates a list of
reason for cancellation. The combo box is linked to a field in the table that
I have. The same field in the form is not showing a drop-down arrow to choose
from the list in the combo box. How or what do I need to do to get the field
in the form to have the same drop-down list that the same field in the table
ha...
|
14 |
12.09.2006 13:35:02 |
|
|
Tool or Text tips do not work
Access 2003:
Mouse hover over control will not pop up the standard yellow window
with tips entered in the control's ControTip text property.
I tried to bring the control to the front but that doesn't work either.
At one time I disabled all bars and menus to have control over which
ones appear for this application. However, I removed the registry
entries for all preferences for th...
|
1 |
12.09.2006 13:05:01 |
|
|
Syntax error in filter?
Please help with the syntax error below:
Syntax error (missing operator) in query expression '([RCName] Like '*'
AND [DeptName]Like'*'[DateEntered]Between #1/1/2004# And #9/12/2006#)'
[code] Private Sub Apply_Filter1_Click()
Dim strRCName As String
Dim strDeptName As String
Dim strDate As String
Dim strWhere As String
Dim strNumber As String
' Check that the rep...
|
2 |
12.09.2006 12:58:02 |
|
|
Cannot add new menu to the ShortCut Menu Bar
Access 2003:
Ultimately, a new or customized Context menu that appears when the user
right clicks in a form is required.
I have not done this for a while but as I recall the standard technique
is to display the ShortCut Menu Bar from the tool bar customization
window and drag a new menu from the Command list to the 'Custom' button
listing at the right end.
In this case, it does...
|
1 |
12.09.2006 12:58:02 |
|
|
Dirty Form
My user (Access '97) in a multiuser front-end back-end linked-tables database
gets a message that a form has been modified and saved since he loaded (and
presumably must have changed) the form. It's a simple form. The only thing I
can see is that each user clicks on the A->Z sort button on entering the form
because until they do that, they have no data in the form (why?).
Can I lock...
|
5 |
12.09.2006 11:55:01 |
|
|
how do l link a combo box so it displays another field
Can anyone explain how l link a combo box so when l select an entry in the
combo list it will lookup and display
another field, what l want to do is when l select a customers name in my
form it will link to their address field
and display it automatically. I've tried looking through the help files to
no avail!...
|
2 |
12.09.2006 11:30:49 |
|
|
current record not available after add
I have a form ("Sales") with several subforms. One of the subforms,
"Purchaser", is tied to the Sale record by a Purchaser ID in the Sale
record.
When I enter the Purchaser subform, I have some code to add a new
purchaser record if the Purchaser ID in the Sale record is NULL or 0.
The problem comes when I've just added a Sale from the Sales form using
the Add (rightmost) button of t...
|
2 |
12.09.2006 10:04:28 |
|
|
Calendar to show bookings
Hello, I have an application to keep track of apartments's bookings. I have
it fully functional but I would like to add a feature and I would like to
have some guidelines for the implementation. Basically I have a reservation
table and an apartment table and I would like to have a calendar that shows
with different colors when the dates are booked and maybe also departure
days with ano...
|
1 |
12.09.2006 09:55:53 |
|
|
DSUM with BETWEEN statement
Hello,
I am struggling with this DSUM function in the following case:
I am trying to get the total amount for the [intImporto] in the reservation
table and display it in a text box using some parameters. In my form I have
a cboBox to select the apartment on which I want to base my query and two
text boxes to select the timespan I want to diaplay the sales for. All
works as expected as ...
|
13 |
12.09.2006 09:41:08 |
|
|
debuging actions
Help....
I have a multi-level forms. There is a main form, a sub form, and then the
subform has many sub-subforms. When I am entering data into the basic
fields of the first level subform, the program seems to "freeze" for 1-2
seconds after I change a field. The field is simple data entry (like
entering a date). It appears that it is also refreshing the sub-subforms
after I enter ...
|
1 |
12.09.2006 09:02:40 |
|
|
column chart from textboxes data
Hi i would like to have a column chart in ms access 97 from based on 5
texboxes on that form. I know that you can only create charts from a
table or query. Each textboxes have a query that returns a numeric
value. Also how can i make the chart updated everytime you open that
form. Thank you
...
|
3 |
12.09.2006 07:58:55 |