|
Drop Changes or Copy to clipboard
I have a database that is Access FE and SQL Server BE.
Once the user has input all the relevant data into the Combo & TextBox's I
have a submit cmdButton which will then update the relevant recordset in the
table. My problem is that once this has been done and the User clicks Add New
record, after inputting a PatientID there is a pop up box stating
"Write Conflict"
"This recod has been cha...
|
1 |
11/19/2008 10:46:09 PM |
|
|
criteria expression for list box
I have a form with two option buttons and a list box. the list box data
depends on what option is selected. Each option used a different table to
draw in the data. However, I have combined the data into one table. The
table contains a list of Accounts.
01 01 01
01 01 02
01 50 01
What I need is when Option1 is selected it draws the accounts that do not
have 50 in the middle and ...
|
4 |
11/19/2008 10:24:52 PM |
|
|
Requery a subform based on Combo Box
Can someone help explain why this won't work.
I have a bound form tied to a query. On this form I have a combo box for the
user to select the criteria. I am using an After Update event in so that the
user selects the criteria from the drop-down and it simply requeries the
form. I am getting an error as it says the .Requery method or data member not
found
Here is my code
Private Su...
|
2 |
11/19/2008 10:20:01 PM |
|
|
suppress error message
I'm using Allen Browne's CarryOver Module to copy values from the prior
record. Works great! How do I suppress the message:
"Cannot carry values over. Form '" & strForm & "' has no records."
that occurs when entering the first record? Is there any reason I would not
want to supress this message?
Thanks...
|
2 |
11/19/2008 10:18:01 PM |
|
|
Combo box / Subform Question
I have a combo box that displays two columns from the main data table that it
queries
EmpID & EmpName (I have it showing both because not everyone knows the ID)
When the selection is made I have it update the Subform below with all the
Emp Details. My problem is that it will work when I only have the combo box
show the EmpID but when I have it show both it no longer works. It obviously...
|
8 |
11/19/2008 9:42:42 PM |
|
|
Variable defined in a function
Hi,
I have a below function in a form.
****
Private Function OfficeClosed(TheDate) As Integer
Dim Date_export As Date
OfficeClosed = False
' Test for Saturday or Sunday.
If Weekday(TheDate) = 2 Then
OfficeClosed = True
Date_export = Date - 1
Else
Date_export = Date
End If
End Function
...
|
7 |
11/19/2008 8:55:17 PM |
|
|
access 2007 form help
I am using access 2007. I have a combo box named cbo_supplier on a form named
frminvoice. I have created a maco named mcr_add_supplier that opens the
frmsuppler in add mode. I tied the macro to a dbl click event for the
cbo_supplier field in my frminvoice. In 2003 it was easy to go to the
ongotfocus event and get any new suppliers to instantly be available in the
combo box once I had ad...
|
5 |
11/19/2008 8:39:01 PM |
|
|
Please help to email reports in snp files
I am trying to send multiple emails with attached files at once.
The code should take each record and populate to the report then attached
that report to email and send it. The email address has in each record in the
table.
My table has around 1000 records, so i need to email around 1000 records
with attached file.
Please help. Thank you.
Dim db As DAO.Database
Dim rs As DAO.Recordse...
|
1 |
11/19/2008 7:33:10 PM |
|
|
Open a form - Search and Open another 2 forms?
Hi,
I have a Main Screen obtain the records from a temp table. User will click a
button to search for Lastname and Firstname in 2 separate table Customer and
table Service.
If found in those 2 tables then
- open 2 form for edit that record
Else
-Add new record in those tables
After that go back to Main Screen with the next Record.
Ques:
1- How do I search for those 2 text box?
2-...
|
1 |
11/19/2008 7:02:18 PM |
|
|
Text Property - read only?
I am trying to set the text property of a textbox in order to trigger a
Change() event on it (Access 2003). The textbox is enabled, not locked,
visible, and unbound. I set focus to it before trying to change the text
property. Why is this giving me an error 2135, "This property is read-only
and can't be set"? The docs say Text is a read/write property.
Me.txtCount.SetFocus
Me.txtCo...
|
8 |
11/19/2008 6:42:02 PM |
|
|
SP 3 MDI to SDI
We just get Access 2003 SP 3 update.
My application is changed from MDI to SDI.
Is it by default for SP 3?
Are there option to set to back to MDI?
Your help is greate appreciated,...
|
3 |
11/19/2008 6:06:39 PM |
|
|
Print files
This code will print only file;
CreateObject("Shell.Application").Namespace(0).ParseName("c:\Notes\Note1.snp").InvokeVerb ("&Print")
I am trying to print all snp files and i keep getting error message ("object
variable or With block variable not set"). What am i doing wrong?
Dim strPath As String
Dim strFilter As String
strPath = "c:\Notes\"
strFilter = ahtAddFilterItem(strFilter...
|
5 |
11/19/2008 6:02:37 PM |
|
|
Form with optional Cascading combo boxes
Hi all
I'll begin by saying I am still new to Access, with less than a year since I
was told to pick it up and learn as I went, and have only been digging into
the SQL for about a month. What I would like to know is if I am on the right
track for a project I am working on.
I am working with a huge data set (44 columns and over 700,000 rows) and what
I've been asked to do is create a way fo...
|
1 |
11/19/2008 5:31:57 PM |
|
|
SUN programs?
Hi All,
Do you know of a program from SUN that can run MDB/MDE?
Thanks,
Tracktraining
--
Learning ...
|
1 |
11/19/2008 5:21:01 PM |
|
|
Inserting Subform Programattically
Does anyone know how to insert a subform at runtime?
I need to do this because I have a form that has to dynamically populate
with a series of subforms depending on how many records it sees in a query.
Thus if there are 5 records in my query I need to create 5 subforms and
populate them accordingly....
|
6 |
11/19/2008 4:54:09 PM |
|
|
Drop Changes or Copy to clipboard
I have a database that is Access FE and SQL Server BE.
Once the user has input all the relevant data into the Combo & TextBox's I
have a submit cmdButton which will then update the relevant recordset in the
table. My problem is that once this has been done and the User clicks Add New
record, after inputting a PatientID there is a pop up box stating
"Write Conflict"
"This recod has been cha...
|
1 |
11/19/2008 3:52:22 PM |
|
|
entering data into table
Hi, I have the following data structure. One sr contains 20 different nums
in nums field. Instead writing sr (here 1) again and again 20 times, what I
should do to generate sr.no. twenty times automatically and after entering 20
nums it should increment by sr+1.
mytbl is
sr nums
1 25
1 46
1 35
1 42
1 59
...
|
1 |
11/19/2008 3:25:02 PM |
|
|
ACC2000: Run-time error 2450--Move from form to subform to subfor
Having a problem moving (tabbing) from a main form to a subform then to a 2nd
subform.
I have a main form with text boxes. The main form also has 2 subforms, also
with text boxes. I checked the Tab Order, and it shows correctly the names
of the text boxes on the main form, followed by the names of the 1st and 2nd
subforms.
In the 'On Open' of the 3 forms I have the following code t...
|
2 |
11/19/2008 3:17:01 PM |
|
|
auto distribute weight factor
I just wonder are there any function that can use for auto distribute
weight factor.
I have a request that for 7 weight factor which should be 100% total.
Is it possible to have user modify weight factor and distribute the
rest automatically?
For example, the 7 weight factors are 30, 20, 15, 15, 10, 5, 5.
If user changes 30 to 25 for the first weight factor then the rest 5
can distr...
|
1 |
11/19/2008 2:02:52 PM |
|
|
Closing a single form
Hi
Currently I have a single form with a close button with the following code
attached to it( It is the default code generated from wizard for the close
button.)
Private Sub Close_Click()
On Error GoTo Err_Close_Click
DoCmd.Close
Exit_Close_Click:
Exit Sub
Err_Close_Click:
Msgbox Err.Description
Resume Exit_Close_Click
End Sub
I have vbCr...
|
4 |
11/19/2008 1:27:20 PM |
|
|
Shut Down Access at Specific Time?
At work we have an access file on a shared drive that multiple users access.
This creates a locked file which prevents any saved changes to the file. Is
there a way I can create a code, so when checkbox Mcheck = True, to close
Access at a specified time that would close it for all users that have Access
open?
Thank you for your Help....
|
2 |
11/19/2008 11:06:13 AM |
|
|
Hyperlink problem
Appreciate help on this
I have a form with a textbox (file_name)
Private Sub FILE_NAME_Click()
Application.FollowHyperlink Me.FILE_NAME.Value
End Sub
This can open C:\CoyFile\dbswmal\Allen_DataNotAccurate.xls
...\dbswmal\Allen_DataNotAccurate.xls
This cannot open D:\ABC\Company\Accurate.xls (CD drive)
\\Company\accurate.xls or
..\Company\accurate.xls
Actually, it cannot ope...
|
3 |
11/19/2008 9:51:02 AM |
|
|
Open the selected file
I accidentally posted this as a reply to my own question on Nov. 5. I have
copied that "reply" and posted it as new:
I posted this question before (in this group on Nov. 5) with quite a bit of
detail that was intended in part to show I had tried everything I could
think of or find before I posted, but perhaps it was too much detail, as I
received no replies. I will try a more minimal a...
|
1 |
11/19/2008 9:00:35 PM |
|
|
Open selected file
I posted this question before (in this group on Nov. 5) with quite a bit of
detail that was intended in part to show I had tried everything I could
think of or find before I posted, but perhaps it was too much detail, as I
received no replies. I will try a more minimal approach, and fill in
details as needed.
I would like to open a file that corresponds to a field in the current
reco...
|
2 |
11/19/2008 9:01:50 PM |
|
|
Cloning (?) form window
Can I have a form (same form) in more that one window?
Rewriting the question, after opening a form, can I open it again in
another window?
I suppose I can copy the form (giving some other name) and open the
original and the copy, but it seems stupid.
Thanks
H. Martins...
|
2 |
11/19/2008 10:30:55 PM |