|
Data Type Conversion Error 3421
Hi,
I have a funtion that has suddenly developed this error. It has worked fine
and nothing has been changed. stID is where the error happens. So it appears
to be adding the first 2 strings but no the 3rd. I'm at a loss, thank you for
any help.
Function AddFile1(rstTemp As DAO.Recordset, _
long1 As String, photo As String, stID As String)
With rstTemp
...
|
3 |
11/12/2008 8:18:14 PM |
|
|
renaming query field headings
I have renamed query field headings with my own headings this way when
users export to excel the orginal database headings, which are
confusing, will not be displayed. but when i rename them and click the
export to excel button a input box appears, why would this be?
Here's query SQL that renames fields
SELECT tblAdagePaidDebits.gl_cmp_key AS Company,
tblAdagePaidDebits.so_brnch_key AS B...
|
8 |
11/12/2008 8:08:41 PM |
|
|
Concatenate 1 table, 1field
Hello all, I am new to using modules but that seems to be what I need. I have
a simple task to perform, but just can't figure it out. I have 1 table with 1
field with 11 redords in it that I want to make 1 record. How do I do that?
Thanks
...
|
3 |
11/12/2008 6:15:08 PM |
|
|
help with insert into statement
Can someone help me with what's wrong with this insert into statement?
SoftwareID = "SELECT Software.[ID] FROM Software where Software.[Name] = '"
+ cmbSoftware.Value + " AND ServerID = '" + ServerID = "';"
(this comes from a combo box)
nodeID = ID
Dim sql As String
sql = "INSERT INTO Node_Software ( [NodeID] [SoftwareID])
Values (""" & nodeID & SoftwareID & """)"
MsgBox sq...
|
3 |
11/12/2008 5:47:02 PM |
|
|
filter combo box
i have a form with 4 combos and a listbox. how can i limit(filter) the values
of a combo based on the values selected on another combo and the list box?...
|
4 |
11/12/2008 5:12:17 PM |
|
|
Calculation into Dollar Amount
I have an Order Form that automatically calculates a percentage
Private Sub FreightCharge_AfterUpdate()
[adminfeetbl] = [OrderSubtotal] * 0.02
[SubtotalBAF] = [OrderSubtotal] + [FreightCharge]
[InvoiceTotal] = [OrderSubtotal] + [FreightCharge] - [adminfeetbl]
End Sub
But I am starting to see some serious rounding issues, is there a way to
specify that the amount should be in curren...
|
3 |
11/12/2008 4:49:20 PM |
|
|
Opening One Form From Another and Minimizing the First
When I have a command button on one form, to open aother
form, I'd like to have the first form minimize, and restore
(automatically) when the second form closes.
I think I can handle everything up to the point of wanting
to restore the first form.
Anybody care to offer a clue or two?
--
Thanks,
croy...
|
7 |
11/12/2008 4:32:50 PM |
|
|
Ole Object
I have a table with 12 word documents in an 12 OLe fields
I have a table with patients.
I need to place at various times, one of the word documents (template) into
a form which will then be printed out as a report for a particular patient.
I'm not sure if this is the best way, but the user needs to be able to make
changes to the word template depending on patient. So if John Doe has ABC
...
|
1 |
11/12/2008 4:25:03 PM |
|
|
??????
zugeerspam@yahoo.com
...
|
1 |
11/12/2008 4:15:51 PM |
|
|
email current record from a form
Hi all
I need help with the following. From a button on the form, the user would
click on it and be able to email the record he's looking at as an attachment.
I just need Outlook to display and the user can fill out the recipient's
email address himself. How do I do that?
thank you very much anyone for any help you can provide....
|
3 |
11/12/2008 4:09:01 PM |
|
|
Opening an Explorer folder from a form
Hi Again,
How do I make a button to open an explorer folder?
I have a button that runs some make table queries that prepare for a
mail-out. I have some documents set up to use these tables. I would like
the user to see a button that opens the explorer folder that has these
documents(which have similar names to the country of destination of the
letters) so that the printout of these do...
|
5 |
11/12/2008 2:40:37 PM |
|
|
checkbox
i have a checkbox field in my subform
i have already set YES default value in the properties
but it does not work, even in my table i have set Default value to YES.
can anyone help me how to accoplish this? or do i need to write my VBA?
i just want that this field only be set to YES.
thanks for any help, i appreciate...
|
6 |
11/12/2008 11:24:48 AM |
|
|
Copying a record and changing some fields in both record
Hi Everyone,
If I have items in a catalog.
Each record has a catalog number.
I would like to copy an item from catalog 29 to catalog 30.
I need write code to
a) copy a the record and
b) add some notes to the copied record and
c) delete certain expenses related to the record from the original
record.(a few fields in the record.
I have had almost no experience working with recordsets,...
|
1 |
11/12/2008 10:45:42 AM |
|
|
split database
Hi All,
Can I split the database if one of the table is a linked table (via ODBC)?
if so, how can this be done? I keep getting the following error: Subscript
out of range , Invaid procedure call or argument.
Thanks,
TrackTraining
--
Learning ...
|
2 |
11/12/2008 8:53:12 AM |
|
|
Search Several Tables
Hi, I'm trying to understand best way to approach a search. I would like to
use the Alpha search on lebans site-is it the best choice?
I want to create a work order with three tables, customer, contacts, and
buildings. I would like user to click on an alpha character to bring up all
customers starting with that alpha character(into a combo box, I think) then
be able to click on desi...
|
1 |
11/12/2008 4:48:02 AM |
|
|
Data entry form
Hello,
I have created data entry form in MS access 2007. I have a vendor table in
which all vendor details are present. In a different form i have provided a
combo box for the vendor ID. I want the vendor name, vendor address, city,
postal code to be automatically generated when the user selects a particular
vendor id....
|
3 |
11/12/2008 4:19:11 AM |
|
|
Error 2109- find record in subform
I have an unbound dialog form (frmAddFirstPractitioner) that collects
information from the user. When the user clicks the "okay" button on
frmAddFirstPractitioner, a sub saves the new record and launches another form
with a subform on it. I want the form/subform to open with the new record
open. The form that is launched is frmSitePractionerData and the subform is
frmSitePractitioner...
|
4 |
11/12/2008 3:29:48 AM |
|
|
Dlookup prob
Hi All
Am using a form/subform and wish to look up a price from an unrelated
entity.
Hence subform has:
[ProductName] which is a text primary key. It needs to look up
[ProductPrice] from tblProduct and return it into [ProductPrice] on
the subform.
If I hard code it as:
______________________-
Me!ProductPrice = DLookup("[ProductPrice]", "tblProduct",
"[ProductName] = 'Kayak' ")
_...
|
4 |
11/12/2008 1:43:37 AM |
|
|
OutputTo pdf error
I have a listview control on an Access 2007 form where users can select any
or all of a list of names who will be sent an email with a pdf certificate
attached. The pdf is an Access report. I'm using the following code and the
OutputTo line is generating an error number 2501 (The OutputTo action was
canceled). I can't figure out what I'm doing wrong. Here's the syntax of
offending li...
|
2 |
11/12/2008 12:57:01 AM |
|
|
Compare last record to new ("unsaved") record
What I'm trying to do is set up a Job Ticket auto number. I know I could use
Autonumber but I want a better chance of keeping the gaps in numbering to a
minimum. Here is what I have:
NetworkJobTicketTBL with the fields:
TicketNumber
TicketYear - Default value Year(Now())
TicketMonth - " " Month(Now())
TicketIncrement - No default value
When the user saves the record,...
|
6 |
11/11/2008 10:51:00 PM |
|
|
send a form by email
...
|
1 |
11/11/2008 9:37:01 PM |
|
|
Pls help, my VBA does not work
Heloo,
In one form my ID dereives from chruchID and member sequence number does
work, while the same VBA to combince the addressID with church number does
not work. I do not know what's woring, I do the same in my address form using
Address table. Pls help, below iis the 1stone that workds, while the 2nd one
does not:
Option Compare Database
Option Explicit
Private Sub Form_BeforeI...
|
4 |
11/11/2008 9:27:01 PM |
|
|
Hello
Hello,
I have a data entry form. I want to see if someone enters unit and amount in
the data entry form. the calculation should be done automatically in the
total amount field in the data entry form. Please let me know how it is
possible....
|
3 |
11/11/2008 9:23:11 PM |
|
|
Weird combo box update issue
I have an issue I'm hoping someone can help me with. Basically, in some
circumstances, when a new record is entered into a form, part of the data is
not saved and an ID number is saved in it's place.
First, I have a form with a combo box (cboCustomer) that displays Customer
names. The Row Source for the combo is:
SELECT [tblCustomers].[CustID], ([CustLast]+" " & [CustFirst]+" ...
|
3 |
11/11/2008 9:02:08 PM |
|
|
date in string
Hi,
What is the correct syntax to write something like:
Next visit: 11/11/08
Where "Next visit:" is a string
11/11/08 comes from a date-field on a form...
I thought it was someting with # but I can't remember
Thanks
JP...
|
2 |
11/11/2008 8:05:11 PM |