new run-time errors in existing db
Wed, 23 Jan 2008 15:07:00 -0800
I created an Access db 4 years ago, and it's been running perfectly until
today. The opening criteria form has 7 text boxes that can be filled in or
left blank. The first is for location, the next 2 are starting & ending
dates, the last 4 are other criteria like document number or item
description. When t ...
|
Changing Field Type
Tue, 22 Jan 2008 17:03:01 -0800
Hi.
I have a db that holds a large number of tables. Each table has its own
unique Record_ID.
I want to be able to determine (in code) wether the Record_ID is set to the
Primary key and if not, change it to the Primary key.
I have been playing around with the TableDefs object but cant work it out.
C ...
|
Visual Basic 6.0 --- Is here a forum for general questions about VB 6?
Tue, 22 Jan 2008 11:24:45 +0100
I have been looking for a forum for Visual Basic 6.0 but not found any.
I try to ask my question here any way.
I like to make a program where the userinterface is transparent.
Is that posible? If so, then how?
I know how to make things on the interface transparent. So that is not my
question.
...
|
Forever
Sun, 20 Jan 2008 12:43:07 -0800
...
|
Listbox with no Horizontal Scroll
Thu, 17 Jan 2008 01:51:00 -0800
I have a Listbox with 3 Columns. I need the information in all three
columns. So I get the data in column 2 and 3 from listbox.Column(1) and
listbox.Column(2) respectively. However, I don't want the end user to see
column 2 and 3. I only want column 1 i.e column(0) to display.
Unfortunately, because I ha ...
|
FTP Directory problems
Tue, 8 Jan 2008 08:00:02 -0800
Hi
I am trying to directory a folder on our ftp server. The folder is not the
root of the server. I appear to be able to open and connect to the internet
fine but then the code breaks and actually dumps me completely out of access.
Attached below is the first bit of my code.
Dim pData As WIN32_FIND_D ...
|
Access 2007 File Disappears
Mon, 7 Jan 2008 06:30:01 -0800
What would make a Access 2007 file disappear after it compresses? I have the
option selected to compress on close, but after it compresses and closes the
file just disappears. The file is located on a MS 2003 Server with shares to
appropriate users that interface it with Access 2007 Runtime.
Is this que ...
|
|
|
DAO 3.6 and Record level locking
Mon, 7 Jan 2008 03:30:00 -0800
My VB6 app used DAO 3.5 in page locking mode. WHen a locking error accured
you could trap error 3260 which told you the workstation name that was
locking the page.
I have upgraded my app to use DAO 3.6 and us the ADO method to open the
database in record locking mode before openning it with DAO.
Global ...
|
ISNULL statement in SQL to VBA string
Thu, 3 Jan 2008 07:39:44 -0800 (PST)
Hello,
i'm trying to understand the functions of the ISNULL statement from
SQL to work in VBA but I can't seem to do it. The string i'm trying is
written below:
strngSQL = "SELECT g_prodvend.prodid, ISNULL(g_prodvend.salesprice,
1) / ISNULL(g_prodvend.costprice,1) FROM prodvend"
basicly what I like is ...
|
M'I`5'Persecut ion my respo nse to th e harassmen t
Tue, 1 Jan 2008 15:53:00 +0000 (UTC)
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-= my. response to the harassment -=
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
My first reaction in. 1990/91 was to assume that if I broke contact then
they would not be able to follow and would lose. interest. So I did the
things that. have been suggested by other people; I sold ...
|
