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 / November 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
mde21 Nov 2006 16:42 GMT2
Is there any way to view the code behind a Form and Report on an mde file..
I did the stupid thing - all my people are using my mde then I worked on the
mdb thinking I had a back up.... Guess what....
Converting fields in VBA21 Nov 2006 16:22 GMT6
I have a few fields that are imported from aonther program.   They are "time"
fields, although in the Dabase they are txt fields.  (due to the way the
other program exports the data)
is there a way to convert those fields to actual time values to do time
text field being padded with blank...21 Nov 2006 16:19 GMT2
I have two fields defined in a table, each as a text field with a length of
5. They are defined identically. I create a new record in a recordset using
.AddNew and assign values to these fields., then use .Update to write the new
record. I assign values to each field using a ...
Apply formatting to selected text in text box21 Nov 2006 15:08 GMT1
Is it possible to apply bold formatting to selected words in a text box i.e.
not all of the text?
Thanks
Can I change the "Enter Parameter Value" text?21 Nov 2006 14:42 GMT2
Since I will not be the only one using the database, I would like to make the
popup box read "Enter the Contact ID" or something other than
"Table!Contacts!ContactID" so that people using the database will know what
the popup is asking for.  Is this possible to do?  Thanks!
VB programming guides or books21 Nov 2006 12:48 GMT5
I am trying to find a good book/manual on VB programming. I have the Access
Bible but the section on VB does not go into a lot of detail. I would like to
learn more about writing code.
For example I was working on a data base and wanted to update one subform
select Query for report with two option groups21 Nov 2006 10:55 GMT1
Hi
Is it possible to select the query for a report based on the results of two
option groups on a form?
eg the report requires the same set of information, but the query it uses
Reference request21 Nov 2006 06:26 GMT1
I would like some help writing a procedure that would identify what
references are missing in the active database. Sometimes when I get help from
all of you, I get the dreaded invalid....msg. I use Office 2003, XP and 2000
depending on what class I am teaching. Thank you.
Recordset or Query object?21 Nov 2006 01:02 GMT3
I have a form in which the user selects search criteria and enters values for
that criteria. I can use that to build a select sql string easily enough but
after this I seem to be having a mental blank. Should I use the sql string to
generate a recordset, or should I store it as a ...
Is there a way to run link tables thru code?20 Nov 2006 22:55 GMT1
Is it possible to link tables at startup in code and test for links in the
same code?  I have the menu item "Link Tables" on the menu right now, but
the user may link the tables over and over again.  I would like to be able
to automatically test for a link at startup and if it ...
dlookup vs. elookup20 Nov 2006 22:53 GMT4
we use reports in Access 2003 that use DLOOKUP in text box/control source.  
ELOOKUP does not appear to work in this situation, is that correct???
thanks in advance!
CreateControl20 Nov 2006 21:22 GMT5
I use the CreateControl to create a new control within a form.  However,
later I need to reference the newly created control.  How can I name the
control after creating it or is there an input for this that I missed for
this exact purpose?
find X sequential values in a table20 Nov 2006 18:51 GMT2
I have very minimal VBA skills...  Given a table of about 50,00 records, I am
trying to identify whenever at least x (in this case, at least 5) sequential
values in the field (check_number) occur in the existing table and whenever
these values are identified, write these values ...
On close or auto close in Access DB20 Nov 2006 18:20 GMT1
In MS-Excel you can create a function called Auto_Close that will fire when
the file is closing.
Is there an equivalent function in MS-Access? If not, is there a
work-around? Could an example please be posted?
FindFirst Method syntax20 Nov 2006 18:07 GMT3
Please help me to understand the syntax for the Recordset.Findfirst when
searching for a CustomerID field using a combo box.  First I declare an
Object variable with Dim, then assign a recordsetclone to the variable.  Then
I use the FindFirst method to synchronize the combo box ...
 
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.