|
Locking individual records
I'm attempting to use SharePoint 2007 lists as tables for an Access
application (long story). My understanding is that Sharepoint doesn't do a
very good job of handling record locking, so I thought I might try to
implement my own.
My concept was that I would lock each record, as it is displayed on the form
(OnCurrent event), so that no other user can edit, the record, while the user ...
|
1 |
10/27/2008 5:36:12 PM |
|
|
Use of List box and 'Index or primary key cannot contain null"
Hi,
I have put a list box on a form that is set up to allow for multiple
choices. It gets its info from a table with the command SELECT HSALast FROM
HSA;
All seems to work fine in terms of it allowing you to select none, one, or
more of the items in the drop down list. I do have a problem though. If there
was something selected for this field (one or more items, makes no
difference) i...
|
3 |
10/27/2008 5:24:03 PM |
|
|
Update form with newly added data
I have a form (frmCustomers) with a combo box. I have code in the combo
box's Not In List event that opens a form (frmAddCustomer) so users can add
new data. What I'd like to have happen is for the data in frmCustomers to
update to the newly added data as soon as frmAddCustomer closes.
Any help is appreciated!...
|
2 |
10/27/2008 3:59:34 PM |
|
|
Records question
I have the following code in a new database to list records on form current.
How do I use this code when there are no records as this is a new database.
Me.Dynaset.MoveLast
Me.txtRecordTotal = Me.Dynaset.RecordCount...
|
2 |
10/27/2008 3:29:15 PM |
|
|
Null coding
I have a form that will create a new form if one has not been created or go
to the existing form if one has been created, this code used to work now it
does not.
I am not sure what is wrong with this code
If IsNull(Me.txtRWNId) Then Call Create_RWForm Else Goto_RWForm
In all cases now a new form is created even with a value in the txt box?...
|
3 |
10/27/2008 3:03:01 PM |
|
|
Need to convert "tab" to 5 spaces
Hi everyone,
I have an unbound form with a particular (unbound) control that gets saved
in a "memo" type field in the database. As the user is typing into that
control, I would like to convert their use of the "tab" key to five
consecutive blank spaces.
Using OnKeyDown event, I can convert it to a single blank space (vbKeySpace)
.... but I cannot do mroe than this (separately, I've ...
|
5 |
10/27/2008 11:36:32 AM |
|
|
Set focus in mult-nested controls
I have the following:
Main form with 1 Tab Control with 8 pages.
On Tab_Page1, I have 4 combo boxes and a subform.
The subform contains a Tab Control with 4 pages; each TabPage corresponds to
each of the 4 combo boxes .
What I am trying to accomplish:
When I select one of the combo boxes, I would like the corresponding TabPage
in the subform to be "displayed" and the focus returned ...
|
2 |
10/27/2008 1:12:14 AM |
|
|
Prevent modifying fields by other users
Hello.
I have a form that when someone adds a record their Login ID is inserted
into a field automatically using the 'Username' Module code and the callout
of =fOSUserName()
This database is shared by many folks. I want to lock these fields so that
only the person that created the record can modify these fields. What I mean
by this is that I have a field called "Transfered To" where yo...
|
4 |
10/26/2008 11:02:38 PM |
|
|
Close report that has no data
I have
Private Sub Report_NoData(Cancel As Integer)
msgbox ""
docmd.close acform,name
but the close command generates an error. How do I close the report after
displaying message?
Thanks,
J.
...
|
11 |
10/26/2008 11:02:10 PM |
|
|
Allow Additions Ignored
Access 2003.
I have a form based on a table and in the Properties (Data Tab), I have set
Allow Additions to No. However, when I open the form, I can navigate to a new
record and the navigation buttons do not have the New Record button greyed
out.
Any help appreciated....
|
4 |
10/26/2008 6:31:04 PM |
|
|
Variable Scope
I have an event procedure for a form control that steps through selected rows
of a list box and does some actions. One of the columns is multi-valued (1 or
more values separated by semicolons). I use the split() function to put the
column into an array and rifle through its values.
My issue is the array's scope. I declare it inside an if statement deeply
within a larger loop that steps...
|
3 |
10/26/2008 4:08:02 PM |
|
|
Event Procedures on Forms
Hoping that someone can help with the following few queries...
1) I have the following procedure, which is used to unhide a field if a
tickbox is ticked. This works fine on the existing 'record'. However when I
navigate to other records it still remembers the tick box option of the
previous record? Any ideas?
Private Sub ContractNoExpiration_AfterUpdate()
If ContractNoExpirati...
|
5 |
10/26/2008 3:13:03 PM |
|
|
GoTo Next Greyed Out
I have two tables where records are related by a many-to-many relationship so
I am using a link table to achieve this relationship and store any related
records. Fine.
I have two forms, one for each of the tables, with any related records from
the other table displayed in a subform in datasheet view in each.
When I open one of the forms it opens at the first record in the table as
e...
|
2 |
10/26/2008 9:57:00 AM |
|
|
Formatting margins betwwen columns on form in access 2007
When I create tabular form in access 2007 in layout format, it gives margins
between columns. By default the margins is 0,053cm to top and left.
Is it possible removing the margins? Or is it possible to change these
margins programmatically?
If I remove the layout, I can increase or decrease the space between the
columns. I would like to keep layout format and increase or decrease ...
|
1 |
10/26/2008 9:55:54 AM |
|
|
Filter a subform
I have Form with a subform and combobox..
i have this rowsource for my combo58
RowSource:SELECT DISTINCT location FROM [Data Entry2] UNION SELECT ' All
Locations' FROM [Data Entry2] ORDER BY location;
i set Link childs and Link Master fields to blank.. so that all my records
will be displayed in my subform.
can anyone help me how can i write my codes for my Combo58 that when i
select...
|
5 |
10/26/2008 8:16:01 AM |
|
|
combo box for addresses that ignores door No's on Auto Expand
This could be a bit too ambititious, but...
Is it possible to have a combo box ignore the door number of addresses and
instead match/autoexpand against the first alpha characters it finds? for
example:
If I type 'Spoo' against the list below, the combo will autoexpand on
'Spooner Street' (ignoring the No.20 prefix)
Alpha Street
Beta Street
Ceta Street
Decima Street
10 Sobey Str...
|
12 |
10/26/2008 12:39:22 AM |
|
|
Unable to LockBoundControls based on bound combobox value
Hi!
I want to lock the fields on a form and subform based on the status field in
my main table. The status may be open or closed. Using a combo box (named
status and with controlsource = status), I want to select either "Open" or
"Closed" and use the AfterUpdate event to run the code for LockBoundControls
(from http://allenbrowne.com/ser-56.html).
By the way, the code works beautif...
|
2 |
10/25/2008 11:34:03 PM |
|
|
Append multiplie fieds from one table to main table
Hi'
I need to populate fields using small table to a main table, so instead
typing the same information over and over I want to use some sort of combo
box to populate the same fields.
tks
jg...
|
2 |
10/25/2008 5:03:25 PM |
|
|
Filter affecting DoCmd.FindRecord
Hi all,
I have a database being used as a process manual. On my main form
Frm_MainForm is a free text field LinkedInfoPage1. When I click on what is
entered in this field (It is the Title of another page) the Frm_MainForm
remains but the data (or record) changes.
This is just what I want it do do! (Finally figured this one out!!!)
However it only works when all records are being viewe...
|
1 |
10/25/2008 4:53:00 PM |
|
|
If part doesnt already appear Append otherwise Update
Hello All
i have a form where i have a "shopping cart" that the user has 2 buttons
that cause a quantity of parts to be added to an order. each time they hit
the + button it needs to add a qty of 1 to the table. if there is already 1
of that part in the table it needs to update the table so that there is now 1
more to the current qty, and if the part isnt in the table then it needs to
...
|
2 |
10/25/2008 1:04:39 PM |
|
|
Create a calculated date in a field on input form
I need to create an input form in which there is a field for the user to
input a year. After the user enters a year I would like a date to appear in
another field. The date would always be the same month and day (June 1) and
the year would be six years before the date entered in the Year field.
So for example if the user enters "2010" in the Year field, the calculated
Date Field would...
|
5 |
10/25/2008 4:23:00 AM |
|
|
Refresh unbound textboxes on form
Hello All
I have a form with 6 unbound text boxes that show various calculated values
(using DLookups etc.). The only problem is that the values are not
displaying when the form is first opened: the only way I can get them to
display is either to click on them, or to tab through them.
I have tried using the following commands in the form's OnOpen event:
[text1].SetFocus
DoCmd.GoToCont...
|
20 |
10/25/2008 3:23:54 AM |
|
|
Shell error #5 under Vista 64-bit
I am getting Error Number 5: Invalid Procedure Call or Argument upon
executing the shell command.
Strangely, this happens only on a Vista Ultimte 64-bit computer. The exact
same command in the same procedure/program works without error when run
under either Windows XP or Vista 32-bit.
Also, the very same command line which fails on the 64-bit Vista machine
works fine when run from a...
|
2 |
10/24/2008 11:23:35 PM |
|
|
Multi-Selection Code review
My objective was to use a form to execute a db query object filtered by a
multi-select listbox control. While I've been an application developer for a
long time, I haven't done much VBA (or VB). The the code below (from the
button on click event) gets it done, but did I make it harder than I had too
(with the understanding that I wanted to leave the SQL in a query object)?
I'd give cr...
|
3 |
10/24/2008 9:23:01 PM |
|
|
Adding an Attachment via VBA
I'm trying to figure out a way to attach a file to a attachment feild in
Access 2007.
Basically, the file would be located in My Documents and always be called
AccuData.txt
I assume this would require some sort dao commands, which are a little out
of my league.
Any help would be great
Thank You...
|
6 |
10/24/2008 9:06:13 PM |