Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / October 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Access 2007 New attachment field11 Oct 2007 09:24 GMT6
I am thrilled with the new attachment field type in Access 2007.
Not sure how musch space it takes.
Is there any way of referencing an e-mail if one sends the e-mail from
Access?
Strange files/modules in VB window11 Oct 2007 05:37 GMT1
I am using Acc03 SP3 and have recently noticed some strange/new
modules/projects will appear in the Project pane of the VB window.  I did not
create them and I can not delete them one is Utility and the others start
with AZ***.  I was able to find that at least one is a wizard. ...
Requery to same record?11 Oct 2007 00:41 GMT5
I have a form with a drop down list with values for Salesman. Whenever I
select a different Salesman from the drop down list, I retrieve the remaining
fields from the corresponding record in a table for that particular salesman
and populate the remainder of the form.
Combo box Question10 Oct 2007 23:05 GMT4
hi-
I have a form that has 2 Combo boxes. Drop1 and drop2
row source for Drop1 is a list of values in a table.
row source for Drop2 is based on what users selects in drop1.
"Dim qdftemp as QueryDef" gives me rrror Message...10 Oct 2007 22:28 GMT1
I wrote a function in and in it, the statement "Dim qdftemp as QueryDef"
gives me a compiler error of "Compiler error: user-defined type not defined".
What gives? I have used this statement before in other databases and it has
worked.
Is there a way to determine if a column exists in a table?10 Oct 2007 22:25 GMT4
My code is building SQL based on user input. Is there a way I can test to see
if a specified column really exists in a table before executing SQL that
references it?
Thanks
Selecting columns10 Oct 2007 20:59 GMT1
I need to unhide some columns.  The number is variable but is a known factor.
To select the columns Excel requires a letter designation, i.e., Columns
("A:D").Select.  However, I want to use numbers instead since I know the
number of columns.  If this is not possible, is there a ...
Cascade list/combo box10 Oct 2007 19:41 GMT2
I'm not sure how to phrase my question so I'll give you some of the detail.  
I have an Equipment Table and a Manufacturer Table with a many-to-many
relationship.  I want to design a form that will list all the Equipment
Types.  When a Equipment Type selection is made I want ...
SQL for List Box Row Source10 Oct 2007 18:33 GMT7
I am creating SGL statements for a list box programmatically in VBA.  
Unfortuneately, they can get long, and sometimes exceed the length that the
rowsource property can hold.  Is there a way to get around that, such as
saving the SQL as a query def, and simply calling the query?
Follow Hyperlink10 Oct 2007 16:10 GMT3
Good day.
I have a table called tblMain that has the following three fields.
OrderNum "file Number Field
FileLoc " file location Feild
Type Mismatch Error10 Oct 2007 16:01 GMT3
While trying to open the database we are receiving the following error, "Type
Mismatch".  The person who created this database is no longer around and I
have very little access programming knowledge.
Any ideas on how to fix this?
Calculate Percentile by grouping fields in Database10 Oct 2007 14:19 GMT4
Hi, i am having DATA like this in access table , i would like to calculate
Percentile 50% of sales by grouping data at Month Level, that means for each
month i ll get differnt percentile value , eg.  2007/01 - Percentile Value,
2007/02 another percentile value.... and so on, is ...
refreshing linked tables10 Oct 2007 13:46 GMT4
I am building a dbase that has 5 linked tables from other Access dbases that
we use in the department.
I would like for the procedure I'm programmin to update the data in the
linked tables every time the script runs.
Help with code10 Oct 2007 09:26 GMT6
Apologies for the repost.
I have a set of fields that require information before "Qry_status" can be
changed from "outstanding" to "complete". The added complication is that if
the query type is an "invoice" then I need an extra two fields.
Object required error10 Oct 2007 09:21 GMT2
Hello i'm trying to create a WinHttp Request object but i get the error
"Object required". What libraries must i use to do this?
The code i'm using is the following:
dim HttpReq
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.