|
Recording old value after a change
Ok I can do this at any point but want to minimize the number of stored
records in the notes field.
I have a user driven db that uses logins to track a lot of what goes on. I
am trying to track if a user changes a record from one person's ownership to
anothers. Currently I have this code.
Private Sub Salesperson_AfterUpdate()
origionalvalue = Forms!Active_Leads!Salesperson.OldVa...
|
2 |
12/9/2008 9:34:58 PM |
|
|
MsgBox replacement - procedure flow
Hi,
I have an Access 2003 app where I want to replace the standard Msgbox
function with the ability to show a message in a popup form which can be
customised. My question is: how do I suspend execution of the procedure at
the point that the MsgBox form is opened, and then return to that point once
the msgbox form is closed (either by the user clicking a command button
option or via th...
|
4 |
12/9/2008 8:50:55 PM |
|
|
Button to backup
I need to backup the database, Candidates, five days a week. I would like to
have a button to press which will backup Candidates to "J:\bak\Backup (Tue)",
"J:\bak\Backup (Wed)", etc., so it needs to determine the current day and
execute the backup.
Thanks MUCH!...
|
4 |
12/9/2008 8:48:23 PM |
|
|
Very strange subquery field disappeared with a filter
Hi all,
So I have this search filter that functions with a text field and button on
a form. The code, which works, is as follows:
The issue, however, is that when the filter is on, the data in the two
fields that are actually subqueries in the recordsource query
[expClientMainName] and [expClientFirstName] disappear. This is especially
odd given that the search variant is actually sear...
|
1 |
12/9/2008 7:32:16 PM |
|
|
VB Error
The error must be the loop because Access just crashes when the loop is on, i
use the loop in other Subs, also productQuantity is 45.
Any suggestions?
Sub chkDelete_Click()
Dim Mydb As DAO.database
Dim QryDat As DAO.Recordset
Set Mydb = CurrentDb()
productID.SetFocus
productID = productID.Text
txtQuantity.SetFocus
DoCmd.RunSQL ("INSERT INTO tblPr...
|
4 |
12/9/2008 6:16:08 PM |
|
|
How to align a text in an email
Hi,
First of all thank you so much in advance.
I am doing a mass mailing using access 2003.
I have this code which works great. When the email is sent the .HTMLBody
appears in one line. I want the email body to appear like the following:
Center the first line "The Next......"
Leave a blank line
Center the second line "Market Downturn......"
Center the third line. "Will Combine to...
|
6 |
12/9/2008 5:56:54 PM |
|
|
Determining Whether a Specific String Exists in a Field
I want to determine whether a specific string of letters exists in a field
on the current field.
How is that done?
...
|
2 |
12/9/2008 5:08:53 PM |
|
|
vba yes no code
I have an excel export button that works fine, i would like to add a
prompt that when I click the export to excel a yes/no prompt comes up,
yes to export no to exit prompt, this way i can eliminate accidental
clicks. Thanks in advance.
Ryan...
|
5 |
12/9/2008 4:52:55 PM |
|
|
Data table on a web server
Is there a way to have a data table saved on a web server and have it
constantly updated by individuals submitting data via the web as an
XLS file? I'm guessing there would be some scripting involved with
this. Does anyone know if this can be done, and if so, is there a
resource somewhere to help with it?...
|
3 |
12/9/2008 3:53:46 PM |
|
|
Option Group Option Buttons
I have created on a Form in my Database an Option Group with 3 Option
Buttons, so that for each Record I can select 1 of these Options to have its
value stored in a particular Field of the Databbase Table. However, I do not
know, and have been unable to find a solution through MS Access Help, how to
program the Properties of the Option Group or the 3 Option Buttons so that it
will show ...
|
4 |
12/9/2008 2:55:47 PM |
|
|
OnClick, If..then add to other table
Hi all,
I have been working on various code combinations for this, but not getting
anywhere. So was hoping someone could help.
I have a form with 1 bound text box "SID" (PK and FKthroughout DB) and 4
unbound check boxes, and a button called "Confirm"
What i want is when the user clicks "Confirm", if "CheckBox1" is ticked, add
a record to a table "tbl2" with "SID" from for form going to...
|
3 |
12/9/2008 2:40:29 PM |
|
|
Iif function not functioning in another computer
I have a few unbound text boxes in my form wich show totals from the form'
subforms. The formula (in general names) is:
=IIf([Subform].[Form].[RecordsetClone].[RecordCount]>0,[Subform].[Form]![Total],0)
When I copy the DB to the user' computer, I get #Name?. The formula is
working, though, if I leave only [Subform].[Form]![Total], without using the
Iif function.
I've made sure tha...
|
5 |
12/9/2008 2:00:13 PM |
|
|
Change caption on continuous subform
I wasn't able to find an answer that works for this one. I have a subform
that is a continuous form and displays two records ONLY. The main form shows
a patrol car, beat assignment, etc and the subform shows the officers
assigned to that car for that shift, etc. Each officer has different
statistical data that will be entered into the subform.
On our paper form we have a section for "Of...
|
4 |
12/9/2008 12:20:12 AM |
|
|
Report Grouping and Calculating Subtotals then Total
I am having an issue calculating subtotals in an Access Report. I have no
problem getting the total when I place the fields in the Report Footer, When
I try and place the same fields in the DivisionalTotalFooter, it is totaling
each entry not grouping the data together by Division. There are 6 division
categories and I would like to show on the report each entry for that current
day so...
|
2 |
12/8/2008 11:16:00 PM |
|
|
Button Coding for Forms
Ok, I posted a similar question, but I am not sure I explained myself enough
in order to get the correct answer. I have also lost the thread I was
working off of, and I aplologize to those who were helping me.
I have three forms I am working with. I have a main form with two subforms
in it. I have a combo box on the main form that will search through
employees and it pulls up all the...
|
6 |
12/8/2008 11:13:00 PM |
|
|
how to use list box contents as query criterion
Good day all,
I have a list box of invoice IDs that I'd like to use as criterion in a
query that returns records matching the invoice ID(s) selected by the user.
Here's what I have so far which generates an error (run time 3265 Item not
found in this collection) pointing to the DELETE command;
Dim iDb As Database
Dim qdef As QueryDef
Dim i As Integer
Dim strSQL As String
Dim strWh...
|
3 |
12/8/2008 10:56:38 PM |
|
|
Refresh All
I have a subform that shows up on a lot of different forms. If I change
something on the subform I want it to refresh everything. I know how to
refresh it on one form, but I want it to show up on all forms and refresh
everything on the form that it is on.
I have an idea and that is refresh the form by creating a dim.
Dim MasterForm as variant
MasterForm = subform's Master Form
Fo...
|
3 |
12/8/2008 9:30:02 PM |
|
|
get easter date in the year
I have a function to calculate holiday in the year. I can get all the
holidays except the Easter.
I am looking for any example to get Easter day from a function.
Your information is great appreciated,...
|
3 |
12/8/2008 7:01:48 PM |
|
|
Error 3601-Please help
I have a query below run OK but when I insert into a form then i got an
Runtime-error 3601 Expect 2.
SELECT * FROM dbo_A
WHERE Soundex(lname)=soundex([forms]![FrmMain]![lName]) And
Soundex(Fname)=soundex([forms]![FrmMain]![FName]);
- Soundex function is from Allen Browne website.
Thanks you in advance....
|
8 |
12/8/2008 5:37:55 PM |
|
|
baskets
How would i make a area of the form the list of basket content?
(tblBasketsContent where basketID=currentBasket)
I thought about using subforms but dont know how to do additional code when
the field quantity changes, and when the record gets deleted, also would need
it to have a scroll (like subforms, if subforms aint possible)
Any suggestions?...
|
3 |
12/8/2008 5:20:59 PM |
|
|
IF statement help.
I have a form that I need help with. I have a field that is unique
(primary key) and there is code that looks for this field and if it is
a duplicate there is an error message that pops up. I would like to
revise the code to where a message box pops up asking 'Is this for
Multiple Disposal Site ticket?'. Then if user clicks 'yes' then it
will allow the duplicate; if no then go back to origina...
|
2 |
12/8/2008 5:17:01 PM |
|
|
Making a form invisible
When I set Me.visible = false does the form become invisible immediately or
is there some delay? What actually triggers the form to be invisible? I am
setting visible = false and yet the form is still visible after it is
unloaded....
|
2 |
12/8/2008 5:15:01 PM |
|
|
Implementing popup form
I have a form which I need to popup, collect data from a textbox, then
disappear returning the data to my calling form. I have it all working but
the popup form does not disappear when it is unloaded even when I have
Me.visible = false in the unload event and in the button event which closes
the form. The form is defined as popup=yes, modal=yes. I open the form in
dialog mode to retrieve...
|
4 |
12/8/2008 5:14:01 PM |
|
|
Maximizing Forms
Is there a way to have ALL forms (I have dozens) maximize. I've heard about
using the docmd.maximize code for an individual form, but looking instead for
module language (or similar global fix) that would have all forms maximized
when opened.....THANKS!
...
|
4 |
12/8/2008 4:54:01 PM |
|
|
Command button to open EXCEL path
How do I code a command button to open a specific EXCEL sheet or file located
in a specific location each time I click the command button? Is this
possible? I understand that I can output to EXCEL, but in this case, I only
wish to open then print an EXCEL file. This file acts as a data collection
form. It was too cumbersome to create in Access. I'm hoping to be able to
print the from fr...
|
2 |
12/9/2008 3:34:57 AM |