|
|
Checking if a file exists by
ari
Hey all,
How in VBA would you check to see if a file exists to determine whether to proceed or not?
Thanks,
ari
|
|
2 |
430 |
|
|
New to DCount, Help Please by
GitarJake
Hi all,
I've set up a database for a nonprofit food distribution center. The
manager wants to limit the number of times a client can use the center to
once...
|
|
4 |
548 |
|
|
Update not working by
Brian
With regard to the following code it doesn't update the
table:
strSQL = "Update AVAILABILITY " & _
"Set AVAILABILITY. = varNewID " & _
"WHERE...
|
|
1 |
350 |
|
|
|
|
2 |
408 |
|
|
prefilling controls on a form by
Nathan Sanders
Hi
I have two forms FrmA and Frmb.
A command button on FrmA is used to open FrmB.
What code do I need to use to prefill controls on FrmB with values...
|
|
2 |
416 |
|
|
Why no update? Help! by
Brian
My update isn't updating the table. Why?
Code is:
strSQL = "Update AVAILABILITY " & _
"Set AVAILABILITY. = " & varNewID & _
" WHERE AVAILABILITY.BookingDate=...
|
|
1 |
1,034 |
|
|
How do I backup, copy or transfer data by
Qal
How can I backup data in Access 97 so I can retrieve it if
disaster strikes? also, how can I copy Access data to use
in another computer? can I copy or backup...
|
May 6th, 2004 12:58 PM
by Qal
|
3 |
656 |
|
|
RunSQL asking for a parameter by
Brian
I have a form with a button that executes some code which
amongst other things includes:
MsgBox varNewID
strSQL = "Update AVAILABILITY " & _
"Set...
|
|
2 |
272 |
|
|
|
|
1 |
595 |
|
|
Rpts: Force Group Header Even If No Data by
S Jackson
I have a report that is grouped by a field named . The report is
launched from a dialog form which contains a Region List Box. The report
prints data for...
|
|
1 |
576 |
|
|
OPEN OE AND CONNECT TO THE INTERNET by
pm-bk
I AM TRYING TO FIND OUT IF THERE IS A WAY TO TO OPEN UP OE AND GET THE
INTERNET TO CONNECT AT THE SAME TIME OR SOMETHING SIMILAR TO THIS
FUNCTION...IS IT...
|
|
3 |
376 |
|
|
Addin for sorting? by
Laurel
I'm not able to get the "Advanced Filter/Sort" option under "Records/Filter"
in the table maintenance window to work. I choose it, and it puts me in the
query...
|
May 6th, 2004 07:59 PM
by Laurel
|
5 |
359 |
|
|
Why doesn't this update work? by
Brian
My update isn't updating the table. Why?
Code is:
strSQL = "Update AVAILABILITY " & _
"Set AVAILABILITY. = " & varNewID & _
" WHERE AVAILABILITY.BookingDate=...
|
|
2 |
572 |
|
|
|
May 6th, 2004 09:50 PM
by Sunny
|
1 |
352 |
|
|
Where would I start looking for help? by
ari
Hey all,
I have a module I'm creating and one of the things it does is execute an Import TextFile into a table in my database. After that I would like to...
|
May 6th, 2004 10:11 PM
by ari
|
2 |
329 |
|
|
new record blank row by
Becky
Is it possible to make the new record blank row be at the top of a data table rather than at the bottom?
|
|
1 |
322 |
|
|
simple question? by
mark
On a form I want the choice input to one field (category) to automatically give an output in another field (location). That is, if someone inputs "cooking" in...
|
May 7th, 2004 09:16 AM
by mark
|
1 |
691 |
|
|
Calendar Control crashes Access 97 by
George Avery
Can anybody tell me how to resolve this please?
We have one PC on which Access 97 crashes whenever a form
with a Calendar Control 8 on it is opened. As a test...
|
|
0 |
1,136 |
|
|
|
|
1 |
385 |
|
|
Form and sub-form question (newbie) by
Ynot
When you use a form and sub-form e.g. a purchase order with a vendor table,
a purchase order table, and a purchase order detail table, I know the vendor
to...
|
|
1 |
344 |