|
Problems with Snapshot Viewer ActiveX Control
Yesterday, I started running into problems with a form that had the Snapshot
viewer control on it. The code which set some of the controls properties
started crapping out, even though it had worked on other PC's. I just bought
a new laptop (with Windows XP) and was thinking that that was the source of
the problem.
At any rate, I deleted the control, unregistered it and then reregistered...
|
2 |
10/20/2008 3:20:01 PM |
|
|
extract items from list in single field, revisited
Hi,
Would this also apply to my situation:
I need to parse a long text field (imported from a very old database format)
which will contain 0 or more 13-character blocks of text. These blocks
represent status update entries; each begins with "!!" but does not have any
delimiters at the end of the block.
I have no experience with the Split() function in Access VBA, and the last
tim...
|
5 |
10/20/2008 3:09:01 PM |
|
|
Decimnal Places Rounded in Code, but not in the Form
We have an age calculation that must be rounded and stored.
1) The Form and Table settings are the same I've tried Fixed and General
formats.
2) But everything submitted and processed through the LET statement
is automatically rounded.
We want : 45.4 to be 45.4 and 45.6 to be 45.6
But, the VBA changes it to 45.00 and 46.00.
The form field values do not show this.
--&g...
|
5 |
10/20/2008 3:02:04 PM |
|
|
classes scope
Hello,
I hope I'm able to make this clear...
If I declare a class object into a form a module, will it "live" ONLY until
the form is loaded? Even if it is declared public?
Even if before closing the form I open another one and declare another
instance of the same object and make it point to the object previously
created?
thanks,
rocco...
|
3 |
10/20/2008 2:17:03 PM |
|
|
Control to use for sorting by column in continuous form
Does anybody have a suggestion for how, on a continuous form, to emulate the
type of column-based sorting such as exists, for example, in Outlook? I have
column labels in the form header and columnized data in the detail below the
headers. I want to allow the user to click on the header and get some sort of
indication of how the form is sorted.
I have no problem with the VBA to rewrite ...
|
3 |
10/20/2008 2:11:03 PM |
|
|
Cycle records - Mouse Wheel
I have a form which has a Go To New Record action on open event.
The form is based on a table so as the form is opened it goes to a new
record as expected. The form is set to cycle on current record only but if
you use the mouse wheel it is still possible to cycle to earlier records in
the table.
Is there a way to prevent this and stay on the new record?
Also - if someone starts to ...
|
4 |
10/20/2008 10:50:01 AM |
|
|
FileSystemObject
How cani I get the list of folders using FileSystemObject?
I can get the folders list until one level down, for example:
I have the following folders:
C:\BLK2DB
AllocSyst
Files
XML
Excel
DB_PASM
Files
Chemicals
I use the following code to get the list folders
Sub ShowFolderList()
Dim strPath As String
...
|
2 |
10/19/2008 11:34:37 PM |
|
|
Export All Tables to Another Access Database
I would like to write a procedure to export all tables from my current
Access database to another database. Can someone help? Thanks.
Mike
...
|
5 |
10/19/2008 8:01:37 PM |
|
|
Export All Tables to Another Access Database
I would like to write a procedure to export all tables from my current
Access database to another database. Can someone help? Thanks.
Mike
...
|
1 |
10/19/2008 5:35:06 PM |
|
|
Update Field in table
I have a table query called custinvcountqry based on the number of invoices
each customer has, the qry has 2 fields, countofinv and customerid. what I
am trying to do is update each customer record with the number of invoices
they have in the system, the field name in the customer table is invcount,
what is the most efficient way of doing this, the count will only be updated
when the us...
|
2 |
10/19/2008 4:50:52 PM |
|
|
copy from recordset ( ms word)
is there any method to copy data from access03 to word03 like (copy from
recordset which i use to copy to excel )
if any demo links / DB / materials will help me greatly....
|
2 |
10/19/2008 11:35:00 AM |
|
|
Can't find file DAO350.dll
I am not sure if I am in the right newsgroup but here goes.
I am using Vista Home Premium and VB 6. I have not used VB 6 for a while but
it always ran without problems. I started it today and immediately got an
error message "Can't find file DAO350.DLL".
This file is present on my computer in C:\Program Files\Common
Files\Microsoft Shared\DAO - file size is 570,128 dated 27 April 1998...
|
3 |
10/19/2008 9:37:47 AM |
|
|
Access Developer doesn't appear
Helo everyone,
I Installed the AccessDeveloper software and Runtime Components for Access
2007. I did this because I want to create an installer for a database.
However, I get no errors during the install but the Access Developer options
are not available in the Access menu's. I tried activating it as an add in
but that didn't work.
When I start access it displays a message stating ...
|
3 |
10/19/2008 8:47:03 AM |
|
|
Two Conflicting Events
On an Access form, I have a textbox containing an AfterUpdate event which can
take up to 2 seconds to execute. (I won't get into why the event takes that
long). Also on the form is a close Button which, when clicked, closes the
current form. If the user has focus in the textbox and immediately click the
close Button, I get the following error:
"Error No: 2501, Error Description: The Run...
|
3 |
10/19/2008 5:35:01 AM |
|
|
Wrong Format
I have several files downloaded for me that are supposed to be in .xls
format. I believe they are really .csv files with a .xls extension. I am able
to save them as Excel Workbooks by opening each one and doing a Save As.
There will be several of these files in a folder on my desktop and I will
need to convert many of these files each day.
Is there a way I can convert them into an Excel...
|
3 |
10/19/2008 4:40:01 AM |
|
|
Returning Null with Dlookup
Hi I was if some one might explain this further I have an event using dlookup
but I'm returning a null. Here is the code.
REMS_Number = DLookup("[Rems Number]", "tblProperties", "[PropertiesID]=" &
[propertiesid])
Any assitance would be helpful.
thanks you very much.
Keri...
|
8 |
10/18/2008 5:11:01 PM |
|
|
Using Access to fill out PDF forms?
Is there a plugin or other methodology that would allow information from
Access databases to fill-in PDF forms?
Thanks for any ideas!...
|
4 |
10/17/2008 9:32:28 PM |
|
|
Insert Access Dbase Field into a specific cell
Good day,
I have a field called HeaderOne on an Access Dbase and I would like to open
an excel workbook and insert the information into a sepecific cell say for
example A1. How would I code this? Any help is appreciated.
Thank you, for your time. Kyle.
...
|
4 |
10/17/2008 7:58:23 PM |
|
|
Application.Run
Access help says you can use the Run method of the Application object to run
a procedure in another project from your current project by use of the syntax
above. However, when I try it, Access tells me that the procedure can not be
found....
|
2 |
10/17/2008 7:37:02 PM |
|
|
Problem with variant
i'm stating this:
Public Function GetConclusion2(MaxOfQ0, MaxOfQ1) As Variant
MaxOfQ0 and MaxOfQ1 are fields
when i put it through debugger, place stop and step through the values for
MaxOfQ0 and MaxOfQ1 are the same. The greater value get given to both fields.
Any ideas why this is happening?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/ac...
|
7 |
10/17/2008 7:25:08 PM |
|
|
Application.Run "projectname .procedurename"
Access help says you can use the Run method of the Application object to run
a procedure in another project from your current project by use of the syntax
above. However, when I try it, Access tells me that the procedure can not be
found....
|
2 |
10/17/2008 4:39:32 PM |
|
|
Application.Run
Access help says you can use the Run method of the Application object to run
a procedure in another project from your current project using the following
syntax:
Application.Run "projectname .procedurename ", "Arg1"
However, when I try it, Access tells me that the procedure can not be found....
|
1 |
10/17/2008 4:36:04 PM |
|
|
Application.Run "projectname .procedurename "
Access 2003 Run Method
Access help says that you can run a procedure in another project using the
Run method of the Application object with the above systax. When I try this,
however, access says that it can not find the procedure....
|
1 |
10/17/2008 4:17:01 PM |
|
|
get hader name and page number
how to get header name and page number of each page in word...
|
2 |
10/17/2008 3:28:09 PM |
|
|
Using SendKeys for Enter
I have tried to find the answer to this question in these posts but was
unable to. I have been reading that SendKeys is not the way to go. Makes
sense since I switched to Access 2007 and now my SendKeys statements DON'T
work. My question: I am running a Delete Table Query and it always asks the
question "This table will be deleted" and it wants a Yes or No answer. I
want this to be ...
|
3 |
10/17/2008 8:00:56 PM |