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 / February 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
If list box null19 Feb 2005 05:20 GMT1
Don't over think this, because I'm  MORON.  
>On a form I have a listbox and when that listbox returns no results I would like something eles to happen.
Wheel Mouse and code window19 Feb 2005 00:27 GMT5
Why doesn't the wheel, on my mouse, work in the Visual Basic window?  To
scroll, I have to use the slider.  It is a pain.  Have I missed a setting
somewhere?
msoFileDialogSaveAs18 Feb 2005 22:45 GMT5
I have AccessXP with ServicePack3 installed.  I have referenced  the
Microsoft Office 10.0 Object Library.  I can access the FileDialogOpen and
FileDialogFilePicker but it refuses to let me access FileDialogSaveAs.  Any
help would be appreciated.
Date string and Charater string syntax18 Feb 2005 22:09 GMT4
I need some help on setup up a syntax string for finding UserID and Log date
and blank Time field.
Here is my code
Dim rs As DAO.Recordset
Alarms18 Feb 2005 20:51 GMT3
I would like to create something in access so when certain dates expire that
I have in a table or query I get some kind of notice. Is this possible?
Thanks,
Kelli
Using Code to modify Code in MS Word18 Feb 2005 20:19 GMT1
Is it possible through ole automation to use code in Access to
programatically modify lines in WORD code modules, similar to the Modules
collection in Access?
Thanks in advance!
John Nurick [Microsoft Access MVP]-Static/Global usage18 Feb 2005 20:15 GMT1
1) I go out and read the data base name which will always include the
facility number IE-060002 Kansas, 060003 New York, etc.
2) I concatenate that name and use only facility number to make my new
table and append data to it IE-060002, 060003, etc.
Add New SubRecord if one doesn't exist.18 Feb 2005 19:34 GMT4
Another basic question ... and my brain is fried... Please help.
Two tables are linked by RecID (one to many with referential integrity
added). The 1st table has RecID entered by AutoNumber upon the addition of
new records. The 2nd table doesn't have the RecID (number field) ...
Open Folder on Network via Command Button18 Feb 2005 19:13 GMT2
I have a form which displays a single record with a single field [SKU] at a
time.  On this form, I have a command button, which on a click, I would like
for it to open a folder on our company's network.  For example, if [SKU] =
C100 on the current record, I would like to build ...
looping through all items in a combobox18 Feb 2005 19:05 GMT3
Access 97
I have a combobox on a form.
The row source for the combobox comes from a SQL statement that queries a
table.
read a Access table and processing record by record18 Feb 2005 18:37 GMT4
Can someone please provide a sample of how to read a Access table.
I need to set one field based of the value of other fields.
I would like to do this thru VBasic. Because I am going to have multiple
test conditions.
Need macro to stop if table is empty18 Feb 2005 18:11 GMT4
Hello,
 I have a query that makes a table of tickets not assigned to our
technicians.  If the table has tickets in it, I want the macro to launch a
program, which I think I can do.  The problem I have is if the table is empty
truncation error18 Feb 2005 17:58 GMT7
I am writing a function in VBA to implement an algorithm that my company
uses.  This algorithm takes the input, multiplies the number by a certain
factor (1.025 in this case), and then truncates the number to the tenth
place.  This process is repeated TableUp number of times.  ...
VBA Code - Records from linked tables and appending to unlinked table18 Feb 2005 17:51 GMT1
I am using the code below to search for records on all linked tables (Seven
linked tables). The records are appended along with a ~tmp1&*? table
created some how created by my code. Can someone tell me how to change the
code to eliminate the extra table and streamline the code?
Error: 'saveRecord' isn't available now18 Feb 2005 17:46 GMT8
Im getting an error on the save statement below.  It actually saves the first
2 statments in the table using the 'QueryAddStatusNextDate'.  But it does not
add the 'QueryAddStatusReminderDate'.  I don't know if it is because the
QueryAddStatusReminderDate is a update query and ...
 
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.