|
Error 13 type mismatch
I have the following code and I keep getting a type mismatch error. I've
tried every possiblity that I can think of to no avail. I haven't been able
to find anything that seems to relate to my situation.
Dim strOldPosition As String
Dim strNewPosition As String
Dim intOldPosition As Integer
Dim intNewPosition As Integer
Dim intOldTire As Integer
Dim intNewTire A...
|
3 |
12/24/2008 3:02:57 PM |
|
|
Modifying Delete Button code
In my form I have Delete Button coded by the wizard with some modification as
follows:
Private Sub btnDeleteAsset_Click()
On Error GoTo Err_btnDeleteAsset_Click
If MsgBox("Are You sure You want to delete this asset?", _
vbYesNo + vbExclamation, "Attention!") = vbNo Then
Me.Undo
Cancel = True
Else
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd...
|
2 |
12/24/2008 11:50:59 AM |
|
|
my scrolling wolcoming greetings does not work any more
Hello.
Chruchdatabase that I am developing is made in many languages, so for the
welcoming greetings also should be made in languages.
It works when I derictly have the string in the VBA, but now it is not
scrolling although it shows in the intended language, what did I miss here,
here is my revised VBA:
Private Sub Form_Timer()
Static strMsg As String
Static intLet As Integer
Stat...
|
4 |
12/24/2008 10:42:01 AM |
|
|
Associated labels and groups
Is there any way you can access/detect programatically (vba) an associated
label from a textbox?
I have a similar question for groups. You can group controls in a form and
manipulate them together.
But how can such groups be accessed in vba? I am missing the collections that
exist e.g. in powerpoint.
Thank you for suggestions!
...
|
5 |
12/24/2008 8:23:37 AM |
|
|
Anyone have problems after new service update?"
My last post seemed to have disappeared, though I received a message someone
responded to it. I can't find it, even searching with my user name.
hmmm....
I have a field in a database that we have been using since 1999. All
fields, except this one, are working. The computers at the office have been
upgraded with the current security patch. So, up until then, it appears the
db has...
|
2 |
12/24/2008 5:49:01 AM |
|
|
gotorecord and current record
I recently upgraded my application from Access 2003 to Access 2007. In a
form's vba code module I used a DoCmd.GoToRecord , , acNewRec to set the
focus to a new record on my continuous records form ... I can see the cursor
on the new record but the focus is still on the 1st record (I see the black
triangle and when I tab to the next field the cursor jumps back to the 1st
record). In ac...
|
1 |
12/24/2008 2:17:02 AM |
|
|
Form_Activate not being triggered
I have a Main form with a subform containing related records I have a
double click event in the subform to open another form to view the
records in their own form. The problem is the Form_Activate procedure
on the form that open is not running. I am opening the new form via a
DoCmd.Open form.
Could someone explain to me how to get the Form_Activate to trigger?
The end result I am after is ...
|
9 |
12/24/2008 1:56:22 AM |
|
|
Conditional Formatting using Unbound column of Combo Box
Can you tell me how to use the unbound column of a combo box in conditional
formatting?
I am working on a combo box called "cboname" which has two columns: 1) name;
and 2) ConfidenceHave. There is a combobox that is called "cboconfidence
needed".
I need for each row on the "cboname" combo which has a lower value in
"ConfidenceHave" than the value in "cboconfidenceneeded" for that re...
|
2 |
12/24/2008 1:20:03 AM |
|
|
Main Form Mandatory fields
I have a form with 3 tabs. The first tab is the main form. I do not want
fields field on the 2nd tab filled in unless all the mandatory fields are
filled in on the main form. What is the best way to accomplish this? Then,
the third tab should not be filled in until the necessary fields are filled
in on the 2nd tabbed form.
Thanks for the help....
|
2 |
12/24/2008 12:43:18 AM |
|
|
from that runs a query
I created a from where I would like to run a query on criteria that
provide. the criteria are a selection of comboboxes where a user can
select whatever. the first problem is that when I open the form out of
design view it automatically wants to connect to the database server
prompting our password right away, which I do not want to happen. How
should I do to make it where I can select all th...
|
2 |
12/24/2008 12:36:47 AM |
|
|
Anyone have problems after new service update?
There has been this db that the company has been using since 1999. It has
been working great all these years, now, after the new security update
(possibly some stuff for office), a field is not working. It works fine on
my home computer (without the upgrade), but on both the employee's (office)
computer and my desktop when I dial in, the field is not showing the info.
Anyone else havi...
|
2 |
12/23/2008 10:55:16 PM |
|
|
AfterUpdate event and Form Filtering
I've got this code in my AfterUpdate event of my combo box
Private Sub cboGlob_Disp_Name_AfterUpdate()
Dim strSQL As String
If IsNull(Me.cboGlob_Disp_Name) Then
' If the combo is Null, use the whole table as the RecordSource.
Me.RecordSource = "qselEQU_SEC_B"
Else
strSQL = "SELECT * FROM qselEQU_SEC_B " & _
"INNER JOIN qselEQU_SEC_A ON qselEQU_SEC_B.GLOBAL_COMPANY_DISPL...
|
4 |
12/23/2008 9:37:12 PM |
|
|
Slow Combobox Results
I have been updating a database that I did not design but have been tasked
with updating. We need to add a new year of prices to the database. I have
all of the new info in already and it works fine. However the way that I
changed the form has slowed it down significantly.
The form has several cascading combos and the last one is slowing the form
down.
cboFilterState
cboFilterYear...
|
15 |
12/23/2008 8:51:37 PM |
|
|
Message box asking for password
Hello,
I have a switchboard that I modified from the built in Ms Access sample
database. My question how can I have a message box requesting for pasword,
then I go to open a form in which we have the Option to open again many forms.
Thanks for any idea provided.
--
H. Frank Situmorang...
|
3 |
12/23/2008 5:31:32 PM |
|
|
istext ???
I have this code that I'm trying to fix. The data type on a field
(Field_Ticket_Number) was changed from integer on the back end to
nvarchar. I'm a beginner and am trying to figure out how to make this
code work now with a string instead of number:
Private Sub dbo_Field_Ticket_Header_Field_Ticket_Number_BeforeUpdate
(Cancel As Integer)
Dim lngField_Ticket_Number As Long, strCriteria As S...
|
6 |
12/23/2008 4:02:00 PM |
|
|
Access Form Question
I have a form that has a search capability. The user puts in the account
number and it sends a pass through query to a SQL Server to retrieve the
data. The data then populates the form by changing the forms source to the
query. If the query doesn't retrieve any data the form goes blank. The text
boxes and buttons all disappear and all you see if the completely blank form.
I need a way t...
|
4 |
12/23/2008 12:19:01 PM |
|
|
Subform fields changing
I have form with a single search field and Search button. I then
underneath have a subform that has no Master and Child link (I don't
need one).
The subform's RecordSource is set to a query and when you open it the
first time the datasheet view is exactly how I want it. The problem
begins when I have to update the underlying queries. I have to run a
Make Table query on the data in the sear...
|
2 |
12/23/2008 9:57:38 AM |
|
|
=[QTY]*[Price Per Unit] Need Help Please
The below formula works great but, what if I want the total from this formula
to report into my table? For example:
=[QTY]*[Price Per Unit]
Price: 5.00
Qty: 2
Total: 10.00
The Price and Qty will report to my table but no sum. I know what is wrong
I have a formula in the control field. But how do I get both the heading of
the table and the formula to work in the control field a...
|
5 |
12/23/2008 8:09:02 AM |
|
|
append multi entries
I need a way to enter data to a table, but I want a short cut. If I have
more than one of a product I can enter it into the table using a text box for
some sort of a multilpier. Like if I enter the number '4' in it, after I
click 'Enter Data' it will enter the data from the form fields into the table
total number of 4 times. Is this possible? I hope I'm clear on it.
Troy...
|
5 |
12/23/2008 8:05:01 AM |
|
|
Inserting an Access 2000 report into a Word document
I want to insert an Access 2000 report into a Word document. The report is
ready to go but I need the code to do the insertion (and, if possible, limit
it via code to selected records).
I know how to open the Word document. I just need the VBA code to insert
the Access Report.
...
|
2 |
12/23/2008 3:37:18 AM |
|
|
Unbound forms and dao recordset question
I have an unbound form I would like to use for entering new records (only).
I have deliberately chosen to separate entering new records and
viewing/updating previously entered records due to some factors of my
database that would make is difficult to accomplish both tasks with the same
form. On my data entry form I have three controls (among several others)
that all pertain to a single...
|
2 |
12/23/2008 2:58:02 AM |
|
|
How To Use a Form To Specify Input And Output
I have a task to read in a pipe delimited text file and output the same file
to a tab delimited file. I am to include a form to specify the input and
output and add a button on the form to run the conversion.. I cannot use any
macros to perform the conversion. (i.e. TransferText).
I am new to Access programming. Is there a way to accomplish this?
Thank you
- Thomas...
|
6 |
12/23/2008 2:13:44 AM |
|
|
How can I know recordset count changed
Hi guys,
I have some details information of a record which is placed in the form
footer in a continiouse form. I should hide the footer if there's no record
in the form. since it's a multi-user form, the record cout might changed by
other user and I may get the latest records by refreshing manually.
The thing is, if I refresh it and no more records appears, I don't know the
change. F...
|
2 |
12/22/2008 8:49:01 PM |
|
|
Please help with multiple choise
If Ct1=1 then st=1
if Ct2=1 then st=2
if ct3=1 then st=3
if ct4=1 then st=4
if ct5=1 then st=6
If more than one of above marked then st=5.
How can I do that in VB ?
Thank you all in advance!...
|
3 |
12/22/2008 6:30:00 PM |
|
|
need help writing a DLookup statement
on a form <FixtureCataloges>,
i have 2 fields that uniquely identify the record: [Manufacturer] and
[CatalogNumber];
also on the form is a subform with 1 field: [Options], whose data source is
a table, FixtureCatalogsLuminiareTypes,
the table has 3 fields [Manufacturer] [CatalogNum] and [Option]
(-spelled differently... too many people woking on the same...);
and is ...
|
8 |
12/22/2008 6:20:29 PM |