|
Saving a form without overwriting record
I have a form that is bound to a "Company" table as recordsource. This has a
listbox that displays all companies and a textbox for entering new company.
The table only has one field which is called "Company" and it is also the
primary key. Supposed i enter a new record called "Alpha" in the form, an
existing record that also starts with "a" will be overwritten.
I tried to create a butt...
|
4 |
11/26/2008 6:32:00 AM |
|
|
drop down field
Hi All,
I was wondering if there is a way to code in VB if the drop down field is
selected to be "Terminated", then that field cannot be changed anymore. So,
once the user select "Terminated" from the drop down menu field, then a
message will appear asking if this is what they want, if yes, then
"Terminated" is selected and user is unable to change that field anymore.
Is this possi...
|
4 |
11/26/2008 1:38:29 AM |
|
|
Remove filter
Hi Groupies
I use the following code on a command button to open a form
to a newly created record based on data input into a form.
stDocName = "frmWorkOrder"
stLinkCriteria = "[lngWOId]=" & Me![lngWOId]
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenForm stDocName, , , stLinkCriteria
My question is how do I open the form frmWorkOrder to the new record
but remove the for...
|
5 |
11/25/2008 8:44:26 PM |
|
|
steve lebans conditional formatting
Hello. I have a continuous subform on a main form that needs to have the
active row highlighted. I am using the conditional formatting routine from
Steve Lebans' site. But it is not working by not highlighting the active row
of the subform. Not getting any errors either. There is a line in the class
mod that might need to be modified as it indicates but I am not sure how it
would be...
|
2 |
11/25/2008 6:52:01 PM |
|
|
Folder Button
Hi,
I was wondering if some one could help me tweak the following code i
have?
the following codes allows me to create a folder on our server based
on two fields with that record, and its stored at"P:\ QUOTATIONS\"
Instead of the the "P:\QUOTATIONS\" been hard coded into the VB I've
created a table for the location to be stored
Table is called "tblFolderLocation" and field is called...
|
3 |
11/25/2008 5:34:15 PM |
|
|
Run time error -2147352567 (80020009)
I get this "The value is entered isn't valid for this field"; error.
This is from a button that pulls data from a subform. This button used to
work, and works on other records. So I am not sure as to why this is now
occurring.
I am using Access XP
This is my code
Private Sub cmdUpdateCost_Click() 'Syteline btn click event
' On Error GoTo Err_cmdUpdateCost_Click
...
|
1 |
11/25/2008 4:46:11 PM |
|
|
adding tab in form
Hi,
I havm a form with some data...
Now I want to add a second "tab-form"
How is the procedure? I can add a tab-form with2 tabs but how do I get
the current fiels to the first or to the second page?
Now, the "tab-form" is positioned overthe current form but I can no
longer see the fields.. I can selectthem but cant see them...
The new "tab-form" lies like a carpet OVER the fields of my c...
|
5 |
11/25/2008 2:27:26 PM |
|
|
Multiple totals and tables
I have multiple tables with total fields, I need to add to a Main total field
in a form therefore calculating all the total fields into one field. I have
tried a query but that didnt work.
Any Ideas?
--
Elaine...
|
2 |
11/25/2008 1:39:41 PM |
|
|
Invalid SQL on INSERT
I continue to get an "invalid SQL error" with the following SQL. When I copy
the sql from the immediate window into a query, it runs fine.
Here is the code generating the sql statment.
'Create Link in tblLLCRegLink
If Not IsNothing(strGroupID) Then
Me.LLCRegGroupID.Requery
Me.LLCRegGroupID.Value = strGroupID
strSQLa = "INSERT tblLLCR...
|
5 |
11/25/2008 1:07:01 PM |
|
|
Opening attachment from table
I have to open image stored in attachment table field directly using command
button, without opening attachment dialog box.
How can I do that?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1
...
|
1 |
11/25/2008 12:56:05 PM |
|
|
complex code
i have an unbound text box in my form. the user can enter anything there and
on enter runs a query that returns records that contain part or the entire
value entered.
this is the criteria i have entered in the deisred field of my query:
Like "*" & [Forms]![Form2-WAREHOUSE]![CODE SEEK] & "*".
problem statement: each record in my table field contains a combination of
letters, numbers and...
|
10 |
11/25/2008 8:37:01 AM |
|
|
Asterisk in Inputbox
I am using this code to password protect (such as it is) the opening of a
form
[code]
Private Sub cndAdminArea_Click()
Dim password As String
Dim Answer As String
password = "admin"
Answer = InputBox("Enter Admin Password: ", "Admin Confirmation",
"Enter Password")
If Answer = password Then
DoCmd.OpenForm "frmUpdate"
Else
MsgBox "You have not en...
|
3 |
11/25/2008 2:37:10 AM |
|
|
How to link a table to a form
I'm brand new with Access. I've made a simple table with Name, Phone, email,
company. What is the next step I do to create a form that links to the table
so that when I enter info into the form, it'll show up on the table?
I see it in all the templates Microsoft supplies but I don't need it that
technical. In those templates provided there also is that option to click on
the ID number and it ...
|
5 |
11/25/2008 2:02:52 AM |
|
|
"No current record" error on ApplyFilter command
I have just started to get this error on certain selections from a dropdown.
All selections do a different applyfilter. However, one particular selection
gives this error. This drop-down used to work and no code has changed (to my
knowledge) in this area. Any ideas?...
|
1 |
11/25/2008 12:21:01 AM |
|
|
LinkChildFields, etc. (Access 2000)
I want to programmatically change the child/master fields; the trick is that
sometimes I want to link on a single field and sometimes on TWO fields. How
is that done?
...
|
2 |
11/24/2008 10:25:58 PM |
|
|
Subform linked to Main form via user login
Hi Guys,
I have a form that has the userID login displayed via a textbox on the main
form. On that form I have a subform that is bound via a query that uses the
login id via the textbox on the main form to filter all the relavent userID
records. The filter is in the form of "[Forms]![Main Risk Register
Form]![Text7]".
Unfortunately for me the form when opened does not show any reco...
|
3 |
11/24/2008 9:58:12 PM |
|
|
Format text box based on table field format
Is there a way to have the format of a text box be based on the format of the
field it is referencing in the table?
I have a form with unbound text boxes that get bound during the form load.
Right now, the text boxes have no formatting assigned, so when binding one to
a text or date field there is no problem. When it is bound to a number, it
is not retaining the format options saved...
|
6 |
11/24/2008 9:48:08 PM |
|
|
Making bound field value equal other field value
Hello All,
I have a form and a subform. When the subform is updated I get a total of a
specific field and can transfer that total to my main form and make an
unbound field equal that total. I really need one of the fields (bound) in
my main form to equal that total. How can I make a bound field equal that
total from the subform?
Thanks,
Rob...
|
8 |
11/24/2008 8:38:03 PM |
|
|
Automatic Table Entry
I'll try to make this question simple.
If I have a table with fields 1, 2, and 3, can I make field 3 default
to the value of "1" if fields 1 and 2 are value "0"?
Thanks!...
|
6 |
11/24/2008 6:21:29 PM |
|
|
Updating Field Value In Another Form
Hello,
In my database there is a unbound main form and a subform (Datasheet
view) which is bound to a table, for data entry purpose. On double
click event of “txtID” (Auto number) field in subform will open
another form called FRM_Memo to put more detailed description. What I
wish to do is to update the txtID field value in FRM_Memo txtRef field
automatically while opening FRM_Memo. Please h...
|
3 |
11/24/2008 10:04:11 PM |
|
|
Change FieldName
Hello,
After a practice of doing traansfer database, I need to change the
FieldName. Ah, I can change the fieldName, if the transfertext, but what if
the transferdatabase of DBASE type. Can we change the FieldNames as
transfertext type?
If yes , please let me some information of how to do.
Thanks ,
...
|
5 |
11/25/2008 5:33:00 AM |
|
|
Convert Columns to Rows and insert into another table based on values in columns
Hi Folks,
I have created a non normalized table from a linked Excel sheet I
created in the following format and need to update a normalized table
based on values in this linked Excel Sheet.
Most code I have found online for converting columns to rows updates
the values directly but in my case I just need to find the
logicalnames with values of 1 and then update the ServersAppTable with
...
|
8 |
11/25/2008 10:03:31 PM |
|
|
Waiting to save Main form data until Subform is complete
Hello - I have a main form that creates a manufacturing batch, then a subform
that establishes the first transaction in the batch. I do not want a batch
established unless a transaction is attached. Additional transactions would
then be added to the batch through a different Batch Transaction Add form.
Currently, when I tab through the fields and enter the appropriate data the
batch i...
|
2 |
11/25/2008 10:31:15 PM |
|
|
Stephen Lebans alpha search w/listbox
I'd like to use Stephen Lebans alpha search to load a list box. I have his
search working perfectly and it returns the alpha character in strTemp that
user picks. In Stephen's example he is loading a textbox. I would like to
load a listbox starting with alpha character that user has pressed. Here's
my code:
Private Sub LblAlpha_MouseUp(Button As Integer, Shift As Integer, X As
Sin...
|
3 |
11/26/2008 12:47:01 AM |
|
|
Why my dev box shows flat field borders; TS shows chiseled?
With Access 2003, I've noticed that on my dev box fields all look like
flat/thin borders have been applied, but the property actually is
chisled. On any win 2003 TS box I deploy to, suddenly all those chiseled
fields show up. Does anyone know why?...
|
4 |
11/26/2008 3:46:19 AM |