|
Stop records navigation by mouse
Hi,
I develop "single form" and hide navigation buttons and create own buttons
to save and move records, but records can be move by mouse roling can we
stop that??
Thanks in advance...
|
2 |
11.09.2006 16:56:15 |
|
|
Date File Extension
Hello All,
Would one be so kind as to tell me how to assign the present date to the end
of a file name when exporting a query to a .xls file as run in a macro?
Thanks!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200609/1
...
|
3 |
11.09.2006 16:21:20 |
|
|
setting 'tag' properties to locked fo every record
Hi there
Can anyone help - i have a form with all properties = locked. When a button
(btn_edit) is clicked, a section of properties (tag = filter_two) are
unlocked and edits can be made. however, when i pass through records, i am
still able to edit records, having only pressed the edit button once on a
previous record. does anyone know how to set properties (filter_two) to
locked everytime...
|
3 |
11.09.2006 15:56:27 |
|
|
can't select from combo on continuous subform
I have a query called QryInventory. When I look at the query, I can add data.
I have a main form FrmInventoryNew, which solely serves the purpost of
selecting a Greenhouse.
The subform is a continuous form based on QryInventory.
I have a combo on that form to select the bench based on a greenhouseID.
I based the combo on a query where the criteria for GhseID
=[Forms]![FrmInventoryNew]!...
|
4 |
11.09.2006 14:01:02 |
|
|
Delete button dode
I have delete button on my form that is working well except that is seems to
be resorting the records. For example when I delete record#45 it should go
to record#44. It opens the correct record with model, part and NHL, but the
record is no longer record#44. Any ideas?
Dim strSQL As String
Dim strModel As String
Dim strPart As String
Dim strNHL As String
strMo...
|
5 |
11.09.2006 13:55:03 |
|
|
DLookUp
Can you use a pass-through query for the domain of a DLookUp function? I seem
to be hitting a snag on that.
Thanks
--
sam...
|
5 |
11.09.2006 13:37:30 |
|
|
dynamic add control in runtime
Hi everybody,
Can I in Acccess2k add a control to a form dynamically in runtime? How?
Thanks
Nhan
...
|
4 |
11.09.2006 13:30:01 |
|
|
Best way to link an MDE file
Hi
I am about to create an MDE file of my database. It will be available
on several computers and I was wondering what would be the best way of
linking each computer to it?
Would it be by specifying the path C:/blah/blahblah or another way?
If so could someone please tell me the way to do the other method?
Thanks
Colin
...
|
2 |
11.09.2006 13:26:02 |
|
|
Adobe 7 Automation
Friends, this is an odd request but can anyone open this bloody link
for me?
http://support.adobe.com/devsup/devsup.nsf/docs/53549.htm
I believe it holds the key to what I have been searching for the past
three hours...
What do I need?
I want to programmatically change the "View Adobe PDF Results" option
on the Adobe PDF Printer settings...
PLEEEEEASE HELP!
...
|
2 |
11.09.2006 13:17:55 |
|
|
NotInList
Hi,
access2002, xp
Looking for ideas on the best way to add an item to a combo box by double
clicking on it. I believe I can do this somehow using the NotInList
property.
I have a comboBox that pulls in all US Cities from tblCities using sql in
the rowsource property. I don't yet have all cities for all states in the
tblCities, so want to add them as the need arises. Can anyone po...
|
9 |
11.09.2006 13:01:02 |
|
|
Go to Item in Drop Down List
Hi all,
I need to set OnEnter of my Combo "Project1" to get the value from Text70
and then dropdown (so that i am automatically scrolled down the list to the
items which start with letters same as Text70)
I tried
Me.Project1 = Me.Text70
but it would call the value of the ProjectID column (which is invisible); so
the visible part of Combo "Project1" reflects absolutely different text...
|
7 |
11.09.2006 12:30:51 |
|
|
recordsetclone filters
hi there i have the following code to filter my query, and none of the
filters seem to be working. as the recorset initially gives one or two
records back and then after filtering it never changes.
Dim date_id1 As Integer
Dim date_id2 As Integer
Dim date_id3 As Integer
Dim childm As Integer
Dim child1 As Integer
Dim child2 As Integer
Dim child3 As Integer
...
|
6 |
11.09.2006 09:09:01 |
|
|
Staying at the top of the form
I have a database that produces 16 different printed forms. I have it set up
so that my masterrecord is on top and the 16 forms are linked as subforms. It
plugs in as much info as possible from the master and then they can enter
other info, comments, dates etc. on any of the 16 and print it from there. I
have it set up to open on the master record and the 16 subforms are tabs
across the ...
|
1 |
11.09.2006 06:21:01 |
|
|
Preventing a record update when a form closes ...
Hi,
I'm new to access and have been trying to understand the event model for
forms in access and am having trouble understanding some of the basics.
For example, I created a simple database just for testing purposes, it has
one table. This table has just two fields, an autonumber field used as the
primary key, and a text data field.
Then I created a form that was bound to the table...
|
2 |
11.09.2006 03:44:30 |
|
|
Access and VB
Ok I an new to this and need a little help....
I have customised the following code but I dont know how to implement in to
the access form, do I put the code behind a command button? Any help is much
appreciated.
Function OnHand(vProductID As Variant, Optional vAsOfDate As Variant) As
Long
'Purpose: Return the quantity-on-hand for a product.
'Arguments: vProductID = the pro...
|
27 |
11.09.2006 02:49:43 |
|
|
Option Group visiable based on text box value
I have a text box on a form called Type which will hold the following
values
P
S
T
I also have a option group with the following Yes, No, None
If text box called type = P option group visable
If text box called type = S option group Not Visable
If text box called type = T option group Not Visable
I only want the option group to be visiable if type text box value = P
Any Id...
|
2 |
10.09.2006 21:01:04 |
|
|
Too Many Dates
I have a calendar form that essentially works.
I have 42 textoxes that fill with values 1 -31 depending on the month
but the problem is that after it gets to the End of the Month I get an
additional 6 days. I need to fill the textboxes "D" up to the last day
of the month. How can I correct this?
Thanks DS
Me.FirstDate = DateAdd("m", -1, FirstDate) 'decrease by 1 month
Dim curday As...
|
2 |
10.09.2006 19:10:33 |
|
|
saving a record which is dependant on other conditions
For an Order Application I have an Order Header with linked Order Items.
There is a form to create a new order with a Single subform for the Header
and a continuous form for the items. The problem is that the Order Header is
automatically saved by Access when completed. A user may then backout of the
transaction prior to creating any Order Items thus leaving a spurious Order
Header in th...
|
1 |
10.09.2006 15:55:01 |
|
|
Creating a sum of different units
Hello,
I am working on a project where I need to create a sum of different units. I
have created a sub form containing data that is calc. in different units.
i.e.
bottle #1 1 Kg
bottle #2 500 mg
bottle #3 1 g
Sum of all bottles = 1001.001 grams
Sometimes the measures are in mass (grams) or in Volume (liters).
Does anyone have any suggestions? Thank you so much for rea...
|
4 |
10.09.2006 14:51:27 |
|
|
Runtime Error '2488' You can't use the ApplyFilter ...
I created a form which allows the user to select data from 4 different fields
and then the form creates a filter for the form based on this input. I
received the following error:
Runtime Error '2488' You can't use the ApplyFilter on this window.
Any ideas ?...
|
1 |
10.09.2006 14:49:02 |
|
|
Clearing combo box
I am using the following code to open Form FrmJobs2 and go to a specific
record.
Private Sub txtInvNo_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = "[Jobid]=" & Me.txtJobID
stDocName = "FrmJobs2"
DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog
DoCmd.Close acForm, "FrmCollections", acSaveYes
Me.Requery
...
|
3 |
10.09.2006 13:14:01 |
|
|
copy returned rows, changing foreign key..
I have a form which returns budget items for a certain period. I'd like to be
able to call up a previous period's budget, then copy these rows changing the
period to give a template for a new budget period.
(keys are client_id and period)
any ideas appreciated!
thanks...
|
3 |
10.09.2006 05:03:39 |
|
|
Complicated Combo Box Filter
I have a frm called frmcharges
It has a combo box called PersonID with the following
SELECT tblPeople.PersonID, [tblPeople].[LastName] & ", " &
[tblPeople].[FirstName] & " " & [tblPeople].[MiddleName] AS Expr1
FROM tblPeople;
On the same form I have a combo box called Bill to which looks up
information from a table called tblPeopleInsurance Which as the
following
SELECT tblPeop...
|
2 |
09.09.2006 20:33:01 |
|
|
Conformation yes No question
For when i click the order button on my database is there a way that i
can have a messagebox to come up to ask if i am sure i want to place an
order with a yes and no click boxes
Thanks
Simon
...
|
2 |
09.09.2006 18:37:01 |
|
|
On exit form opens report on specific record
I need when closing a form to open a report on a specific record.
So, I have this code:
Private Sub Form_close()
DoCmd.OpenReport "Invoice", acViewPreview, , "[DocId] = """ & Me.[DocID]
& """", acNormal
End Sub
The problem is that it opens the report always on the first record, no
matter which DocId I have.
If I run the code without closing the form it works fine.
I guess th...
|
2 |
09.09.2006 17:11:02 |