|
AllowEdits
A form is disabled for editing on load by using "Me.AllowEdits = false".
Editing is enabled when a user clicks on a label called "Edit". Below is
what I intend to do:
Private Sub lblEdit_Click()
If Me.lblEdit.Caption = "Edit" Then
Me.AllowEdits = True
Me.lblEdit.Caption = "Disable Edit"
Else
If Me.lblEdit.Caption = "Disable Edit" Then
Me....
|
6 |
11/19/2008 4:53:52 AM |
|
|
Send email SNP files?
I have 200 records in my table ‘tblLetters’ (ContactName, ShippedDate and
ContactEmail columns) and I have one report ‘rptLetter’. The ContactName and
ShippedDate columns populates in the report.
Sense I have 200 records. I need to create 200 SNP files and OutputTo to c:\
drive.
Here is the code;
THIS CODE WILL SEND ONE AT THE TIME. HOW CAN I CREATE ALL FILES BY CLICKING
ONCE...
|
1 |
11/18/2008 10:59:02 PM |
|
|
Run code after a form print preview
Running Access 2003.
I have a form that I want to print preview. When I when I fire my code from
the cmd button, it works fine It calls a sub that positions the controls and
sets the color for printing. But upon closing the print preview, I need to
run another Sub to reset the colors and reposition the controls. The problem
is, there is no Event for returning from print preview in w...
|
4 |
11/18/2008 10:44:00 PM |
|
|
filter by selection
I am able to have a double click on a field in a continuous form that will
filter by the selected record in the field. What I am not able to do is to
show in a textbox in the footer of the form the selected item. So when the
person double clicks on the field what was filtered on shows in the textbox.
It is a way for the user to know that the form is filtered as the list
is/could be lo...
|
2 |
11/18/2008 10:15:01 PM |
|
|
Multi-criteria drop down link to subform
Hi all,
I have bound subform "frm_Summary" that links to my master data table
"tbl_Contractor." At the top of this form I have two combo boxes "cmb1",
"cmb2"
- Cmb1: queries tbl_Contractor and brings back the Invoice number, I am
using the afterupdate to then populate Cmb2 and bring back the project name
based on the invoice number selected.
I then have my subform update to the ...
|
1 |
11/18/2008 8:44:01 PM |
|
|
Problem retrieving data from a subform
Hello there,
I’m working on an application that will be used to register people. The app
is somewhat complicated so first I’ll explain what the app does (or is
supposed to do) and then I’ll explain what the problem is.
The registration process is performed in two steps, each step being done at
a different physical location (in the first location a new record is created
but it ...
|
1 |
11/18/2008 7:50:32 PM |
|
|
Form not recognizing record added via SQL statement
I have a table that has data entered in 2 ways. One way is when it is
entered on a subform of another form. The other is a stand-alone form. The
underlying table structure is as follows:
ReasonCodes - ReasonCodeID(PK)
RPPCauseInfo - RPPCauseInfoID(PK) - ReasonCodeID(FK)
I have a one-to-many relationship between ReasonCodes(One) and RPPCauseInfo
(Many).
When data is entered via th...
|
3 |
11/18/2008 6:58:23 PM |
|
|
Form does not close on DoCmd.Close acForm, Me.Name
Hi All
I have a Cancel command button on my form with this _Click event code:
Private Sub btnCancel_Click()
If Me.Dirty Then
Me.Undo
End If
DoCmd.Close acForm, Me.Name
End Sub
The trouble is when the record is dirty I have to click this button
*twice* to actually close the form. Why?!
Any ideas? Thanks in advance,
Chrisso...
|
2 |
11/18/2008 6:23:01 PM |
|
|
need help with DSUM
I getting invalid syntax with DSUM.
I trying to pull an amount from a atable where criteria is the year in
txtDate AND the account number is in txtAccount.
Both txtDate and txtAccount are on the same form.
Here is my DSUM...
=DSum("Amount","Deposits","[AccountColumn]="[Me!txtAccount] AND
"[DateColumn]="(Year[Me!txtDate])...
|
4 |
11/18/2008 5:29:01 PM |
|
|
DoCmd.TransferSpreadsheet - Access can't find my query
I have the following line in my code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"sp_export_persons_to_excel", "W:\DOCS\DRAFTS\eortazontes.xls", True, "A1:
G12"
sp_export_persons_to_excel is a stored procedure.
However Access tells me that it "can't find the object
'sp_export_persons_to_excel' ".
I tried replacing the string "sp_export_persons_to_excel" with the names ...
|
5 |
11/18/2008 11:36:51 AM |
|
|
Access 2007, form delays
I am just in the process of moving a 2000 Access database to 2007. Access has
been upgraded to 2007 but the file format for both the front and back end are
still in 2000 file format. The database appears to run fine in 2007 but has a
couple of odd quirks.
When typing ahead in a combo box it sometimes stops at the second letter typed
Hyperlinks do not always work
Information is not always...
|
5 |
11/18/2008 1:52:34 AM |
|
|
Referencing a subform in docmd.open Where clause
I am going to try to simplify my problem.
I have a form with custID, prodID and tankID.
I have a subform with TransactionDate and Amount.
I have made a search form where I can pick the customer and product and date.
I want to be able to open to the page with that particular date/Year.
The form and subform or linked by pageID.
I am able to open my form to the customer or Product or Tank but I...
|
6 |
11/17/2008 9:33:47 PM |
|
|
Best way to split one table into 2 tables thru a form
This is like the reverse of a form/subform set up, where i am importing data
from a mainframe that is actually a text file. I import it and manipulate it
into one table thru my import process. The user would work thru a form to
determine which lines actually go together to make one load. Then a new
record would be created in the "One" table (as in one to many) and the
existing table w...
|
3 |
11/17/2008 7:21:01 PM |
|
|
Refresh main form control when subform exited ?
I have a main form containing a subform.
The subform lists checks received and when a new check is entered a 'balance
due' control on the main form needs to be adjusted. I'm having a hard time
getting this to happen. There only seems to be an 'enter' or 'exit' event for
the subform and neither seems to be of much use.
Does anyone know how to do this? Thanks....
|
4 |
11/17/2008 6:39:02 PM |
|
|
copy data from one table to another based on condition
Hi, I am new to access. I have problem in adding data from table from
another based on certain condtions :-
Mydata table is something like :-
numvalue numcount
16 4
23 4
39 4
8 3
15 3
37 3
41 ...
|
3 |
11/17/2008 5:47:02 PM |
|
|
yes/no box checked yes based on certian user
I want to have a hidden yes/no box marked yes on a form when a certian user
creates a record on a form. I am trying to track leads a cold caller makes
and gives to sales people. then i can run a query to display all the
contacts where the box is yes. I
--
Message posted via http://www.accessmonster.com
...
|
9 |
11/17/2008 4:16:20 PM |
|
|
Modify ALLCAPS memo field
I have a database with a memo field that has many entries entered as allcaps.
Is there a function similar to Pcase or vb language that would permit
modifying the allcaps data in the memo field to a modified 'Proper'
capitalization with only the first letter of a sentence or bullet
capitalized? The memo field can contain several sentences or several
numbered bullets....
|
8 |
11/17/2008 7:59:02 AM |
|
|
treeview crashes access after n recordset-changes
Hello all,
I developed a small database for storing information about quotations (i.e.
when typed in, who is the responsible field-staff-member, for which
distributor for which reseller and who is the final customer).
The database ist necessary to compensate missing capabilities in our main
tools.
Now, i tried to build up a kind of a verson-history fpr quotations; this ist
possible bec...
|
4 |
11/17/2008 7:54:54 AM |
|
|
Another Form-Subform problem
Hi,
Can anybody please help on this ?
I have a Form and a "Continuous Subform". Among others, there are two date
fields (not the master-child) on both the main and the sub forms.
While I navigate through the records on the main form, I want the date field
(control) on the sub form whose value matches with that on the main form
change its back color (highlighting).
Here, the date ...
|
2 |
11/18/2008 4:26:27 AM |
|
|
Using variables to make code faster and more efficient?
I have a dialog form that asks users for query criteria. It works but it
takes a long time to run. How can I use variables to make the code below
more efficient? (I think Dim has to be used, but I am not sure how to relate
it to my code below.) "Country" and "Program" are text boxes.
Private Sub Form_Load()
Country.Visible = False
Program.Visible = False
End Sub
Private Sub Search_...
|
9 |
11/18/2008 6:49:45 AM |
|
|
Limit To List - table showing incorrect data
I have a combobox to where if a value isn't listed you can add it. On
my form this works correctly and when the record is pulled or when
looking in the underlying table the data isn't correct. Would anyone
know why this might be? The values are pulling from a query and the
query looks good. This combobox also autofills the next text box on
the form.
Example:
If I look for location "Dall...
|
6 |
11/18/2008 8:05:15 PM |
|
|
Re-displaying a blank data entry form
I have created a form that uses list boxes and text boxes to allow the user
to enter in data and then click a command button to add the record. I have
also created some VBA code to check and make sure that all the values are
valid before inserting the record into the table in the database. Once the
record is inserted, I would like to have the form re-display the same as if
it was op...
|
9 |
11/18/2008 8:31:39 PM |
|
|
Textbox access by security level
I have a database that I have set up (with lots of help from this site). I
am almost completed the database with the exception of setting data entry
control to some of the form textboxes based on security clearance. Here is a
basic description:
I have a table that contains UserID, FirstName, LastName and SecurityLevel.
I have a form that needs to have 3 sections filled in to be complet...
|
3 |
11/18/2008 9:26:47 PM |
|
|
Short time display problem on form
I am using the "Short Time" format to display time in a 24 hour format but
when I type in a time that starts with a zero (ie. 00:30) it does not display
the first zero. Instead it displays 0:30 and not 00:30 as I would like. Any
help?...
|
6 |
11/19/2008 12:19:06 AM |
|
|
Calendar control month selection
How can I cause an event when a different month is selected on the calendar
control. I use the click event and it works' fine when I click on a day, but
I can't seem to execute anything when just the month dropdownList control on
the calendar is clicked and a different month is selected. Any Ideas?...
|
2 |
11/17/2008 1:42:45 AM |