|
By Code, Is A record being Edited by another user
I have a multi user system "Shared" "Edited Record" are set and I do get the
message that says another user is updateing the record already. However, the
user does not like that. What they want is not to be able to enter any text
into a field if someone else is currently editing that record. Is there some
type of code that I can run in an IF statement to see if the record is Locked?
...
|
5 |
12/13/2008 6:46:59 PM |
|
|
Move to last record after form opened
I want a form coded to move to the last record immediately after the form has
been opened.
I don't want the recordset to be sorted, and I can't use Open event as the
first record has not yet been displayed....
|
7 |
12/13/2008 2:57:54 PM |
|
|
Show Companies with no MainContacts
CoName Table has a CompanyName field.
Contacts Table has the name of a Contact, and a MainContact field (yes/
no).
So the SQL statement would include CompanyName, Contact and
MainContact.
I want to display (list) those CompanyNames which do not have a
MainContact.
How do I make this calculation?...
|
6 |
12/13/2008 2:54:14 PM |
|
|
fields on form 'shift' when record is saved?
Would anyone know why when data is entered into a form and then the
record is saved that a couple of fields shift to the left? The align
is set to center and all but two of the fields stay centered. If
someone could help on this, I'd appreciate it. Thank you....
|
1 |
12/13/2008 12:51:57 AM |
|
|
Check value of multiple text boxes
Hi all
I have a sub form that contains 12 text boxes, named funnily enough
Jan, Feb, Mar....ect.
Each of these text boxes is controled by value from a query.
Now when a user updates the relevant part of the main form the subform
refreshes showing the revised data.
I use conditional formating to set the colours of the textbox
depending on the value, which works great, but, what I would...
|
8 |
12/12/2008 10:09:39 PM |
|
|
Max Function in Row Source Coding
I am having a minor problem with some coding I have for the Row Source in a
database. The current code is based on filtering the dropdown list an the
last month's data:
SELECT tblA.REVCENTER, tblA.FACILITY, Sum(tblA.TOTAL_AMT) AS SumOfTOTAL_AMT
FROM tblA
WHERE (((tblA.MONTH)=DateSerial(Year(Date()),Month(Date())-1,1))) GROUP BY
tblA.REVCENTER, tblA.FACILITY HAVING (((tblA.REVCENTER) I...
|
3 |
12/12/2008 10:02:07 PM |
|
|
acPasteAppend Adds Record Instead of Update Record
Is there a way to use the acPasteAppend to update a record instead of adding
a new one? On my form I have a "Copy" button and a "Paste" button. This is
the code:
On the copy button (Command2) this code in the Click Event:
Private Sub Command2_Click()
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
End Sub
On the paste button (Command3) this code in the...
|
3 |
12/12/2008 9:36:34 PM |
|
|
Check textbox value before change
I have a form called Edit Application which is used to pull a record
from the tblCreditApplicationInput table and display the record for
Editing. One field is called Date Rcvd, which was created when the
application is created. Another field is called status which uses a
combo box to pull 4 values-Draft, IN Process, Approved, Declined. My
client wants me to have the Date Rcvd value change t...
|
2 |
12/12/2008 7:52:03 PM |
|
|
Running an Update query before closing a form
Hello everyone,
I have form ( record sourece table1)that has a control (ctr1) whose value I
need to update to a field in a different table ( table2). I have a command
button that I have to click everytime before closing the form to run an
update query so that the current value of ctr1 is copied to the field in
table2.
- It works fine when new records were posted. But when previous reco...
|
3 |
12/12/2008 7:09:01 PM |
|
|
getting data from a main form to records in a subform
TIA:
I have an form with two tabs. One tab is a main form and the other tab is a
related subform. Data is entered into the main form. Some of this data
needs to be copied to one or two records in the related subform.
I would like to have a command button on the main form that would switch to
the subform, start a new record and copy data to the record and if
([field]=not null) start ...
|
10 |
12/12/2008 6:27:01 PM |
|
|
Mouse button Pop Up
In Access 2000 and Windows XP, I have a label with no caption. I use it so
that an admin can right click on the form and some command buttons become
visible. If the admin right clicks again the command buttons become
invisible.
The problem is that when you right click on the form you get a pop-up menu
which contains some enabled values (Form Design, Data Sheet View) and some
not ena...
|
2 |
12/12/2008 6:24:35 PM |
|
|
requery
I have subforms that add records. My problem is when I close the subform the
new record does not show until I move to another client and come back to the
original client. I know I have to do a requery of some kind, but I am at a
loss as to where to start. Thanks for any help....
|
4 |
12/12/2008 6:14:12 PM |
|
|
Current page selected
Is there a way to determine which page on a tab is current (selected) or in
use. Thanks is advance....
|
7 |
12/12/2008 6:01:02 PM |
|
|
Search for records in a form and display
Good Morning, First i'd like to thank everyone out there helping all those
people like myself who are just working hard on trying to learn. We couldn't
do it with out you, I know i couldn't!!
I am trying to create a form that has a search function. I tried some other
suggestions i've had but they only used the search function within Access
itself not the form. I need it to search for th...
|
5 |
12/12/2008 5:46:00 PM |
|
|
Storing Images and Files in SQL2000 with a project DB as front end.
I have a Project database (Access 2003) that I am using to store Files and
Images into SQL2000. I am using the OLE_CREATE_EMBED Action to store the
image or document into SQL (Image type field) It works great! however The
databse is just growing like crazy. We have other applications that do the
same on sql2000 (not using access as a front end) and they are not growing
as much. When I cr...
|
4 |
12/12/2008 4:52:01 PM |
|
|
recordsetclone not working
Hello,
I am hiving trouble with recordsetclone.
I have a form that I open and want to display the number of records. The
code that I am using is:
Set rst = Me.RecordsetClone
Me.txtRecordNumber = Me.CurrentRecord
Me.txtRecords = rst.RecordCount & " record" & IIf(rst.RecordCount = 1, "",
"s")
The txtRecords box will only show 1 record when there is more then one. The
wierd part of thi...
|
5 |
12/12/2008 2:23:51 PM |
|
|
Add new record if nothing found with filter
Hi all,
Is there any way I can have a subform open up to a new record if nothing is
found by the search criteria that is filtering the main form?
Here is the search code
Also, I realize that I have the BeforeInsert event cancelled, but that is
because the address component of the search form is a concatenated read-only
expression, so it doesn't make sense to just let the user input a ne...
|
3 |
12/12/2008 2:07:00 PM |
|
|
Error 2046 when using "OutputTo"
I am using 'OutputTo' to generate a report in snapshot format.
It works perfectly when I bypass the StartUp form with the shift key, so
that it goes into edit mode. But when I start the database as a user would
do, and get to the snapshot generation code, I get the error message "2046:
The command or action 'OutputTo isn't available".
Would appreciate some expert advice....
|
3 |
12/12/2008 1:12:01 PM |
|
|
Multi-Select listbox selection order
Hi,
I'm using a multiSelect listbox, but need to know the order that the items
were selected. Is there a way to do this without *lots* of coding after each
item has been selected (I know I'll need some coding to de-select the whole
list if the primary selection is de-selected) ie. can the ItemsSelected
property be ordered in such a way?
...
|
3 |
12/12/2008 12:18:01 PM |
|
|
Window Focus
I've got an issue here that is driving me nuts. I have several databases
using a common library which has which defines many functions including
WaitSeconds, and ShowMessage. WaitSeconds was the first function written
which displays a modal form for the specified amount of seconds with a
message in a label control. Later I decided to create the latter function
which does the very same th...
|
1 |
12/12/2008 5:27:00 AM |
|
|
Trap paste event in text box
I need to strip selected html tags from text copied from MS Word into a text
box with rich text format. I have written a VBA procedure which works when I
call it by clicking on a button after paste but I would like it to run
automatically at the time of the paste event. I have looked at all the
available events on the event tab but can't find one to do this?
--
Chris...
|
6 |
12/12/2008 3:59:00 AM |
|
|
Subform unable to present Query Output ?
Hi Karen,
Saw your posts, I face some situation.
1. I Had A form with More Than 10 subforms, I put this into 2 tab (Avg 1 tab
holds 5~8 Subform).
2. Which subforms to displays depends on Main Form ComboBox> Generate Form2>
Subform Display Base on Choice.
3. This is preset in the form>
* * * * * * * * * *
TabControl1.Visible = True
Page1.Visible = True
Subform/ Sub...
|
1 |
12/12/2008 3:34:26 AM |
|
|
Ac 2007 Timer hangup in ACCDE
Why would a timer event work fine in an ACCDB but not in the ACCDE compiled
version? This very same programming worked fine in Access 2000 to 2003 MDE
versions. The specific problem is that the timer event is not being run at
the 'Timer Interval" setting. The initial setting freezes on the screen. Is
this a 07 bug? Is there a workaround?...
|
3 |
12/12/2008 11:12:01 PM |
|
|
Searching/Modifying/Deleting Records on a Subform
I want to be to change or delete records on a subform based on whether or
not they contain certain text strings.
How do "search" for the relative records (i.e., the records that contain
certain strings)?
How do I obtain the ItemID from that record?
How do I change the value of one or more fields in that record?
How do I delete the record if that is appropriate?
Thanks!
...
|
5 |
12/13/2008 6:38:37 AM |
|
|
Save record on lost focus
Hi,
In a countinuous form, I have 2 controls ctrA and ctrB that make up a set of
records. I have control ctrC on the form footer counting the records if ctrA
has a value regardless of the ctrB's value.
ctrC counts the records only after the user moved to the next line or to
another set of record. So in a situation where the user deletes ctrA's value,
and straight away close the form, c...
|
4 |
12/13/2008 6:40:15 AM |