2007 error
Mon, 6 Oct 2008 18:48:38 -0700
I converted a 2003 database to 2007 and when I ran it one of the subforms
showed all the proper information but when I clicked on a label I got this
in an error message.
[select
Charges].[TransactionNumber,Charges].[siteID,Charges].[Transactioncode,Charges].[qty,charges].[Charge,Charges].[TransactionDate,N ...
|
Password protect Snapshot files?
Mon, 6 Oct 2008 16:34:00 -0700
Is there any way to have a snapshot file password protected like pdf files
can be? I'm using the following code to save reports as snapshots.
DoCmd.OutputTo acOutputReport, strDocName, acFormatSNP, sPath & _
strTitle & ".SNP", False
This works good for saving reports in snapshot format but I was ...
|
Help with AllowEdits
Mon, 6 Oct 2008 14:03:17 -0700
I have a form with tabbed pages (3 tabs). Is there a way to allow users based
on their security level that is assigned to them to edit or not edit per
tabbed page. ex:
User1 has seclvl = 1
he can edit the entire forms so AllowEdits = True for user1
user2 has seclvl = 2
I want him to only be able to edit ...
|
Using the Access button wizard to link forms
Mon, 6 Oct 2008 12:55:18 -0700
I am having a problem getting the button wizard to open the correct forms. I
have my main form (form 1) that is defined by a Unique Primary (ex. CaseID)
key and it is related in a one-to-many relationship to another form (form 2)
that has a primary key (StructureID) and a foreign key (CaseID). I want to be
a ...
|
Sanda Daigle Listbox Error
Mon, 6 Oct 2008 13:50:15 -0600
Hi Groupies:
I am using the SelectRecords listbox example from Sandra Daigle in an Access
2007 database.
Everything is working fine except when I go to remove a selected item from
the right hand box to the left hand box.
I get the error "Run time error 3061" "Too few parameters. Expected 1".
I have tri ...
|
Highlight focus and required fields
Mon, 6 Oct 2008 12:39:01 -0700
Greetings all,
I recently installed Allen Browne's "Highlight the required fields, or the
control that has focus" module. It works great and has improved the
functionality of my forms.
The only question I have, is how to use it with a subform. I did set the
OnLoad property of the subform to "=SetUpForm([ ...
|
on_exit code fires twice
Mon, 6 Oct 2008 12:09:18 -0700
I have the following code on_exit of a form control to make sure there is a
part # entered before clicking on any other control on the form. If I click
the close button while my cursor is in the Part control, the msg fires twice.
Is there a way that I can get it to only fire once when the close button is
c ...
|
|
|
sending emails from access through outlook
Mon, 6 Oct 2008 12:04:11 -0700
i have 2 problems with sending emails from access through outlook:
1. outlook reports that the email has not been sent even it in sent items
folder.
2. how can i format the email (font, color, align)?
thanks ...
|
Why is this an error?
Mon, 6 Oct 2008 10:12:35 -0700 (PDT)
What's wrong with this, I get an error here.
Private Sub Form_Open(Cancel As Integer)
Me!cboxVendor.RowSource = "Select en_vend_key, en_vend_name" & " From
tblAdageVolumeSpend Order By "" & " "tblAdageVolumeSpend.en_vend_key;"
End Sub ...
|
Finding Field Type and Length in a SQL Database
Mon, 6 Oct 2008 05:55:01 -0700
I have a SQL Server 2005 back-dnd with an Access 2007 front-end. Tables in
SQL are linked into Access. I want to be able to, with a VBA function, be
able to find the field data type and if a string, length assuming the
function is given the table name and field name.
Reason - All of my forms are unbound t ...
|
