???q?V?^?f?U?_?h?Z ?^ ?]?U?`?U?]?q?W?U?_?h?Z
Tue, 06 Jan 2009 06:09:39 -0800
ÈGÈHÈEÈP ÈcÈU ÈBÈCÇõÈPÇý ÇöÈCÇ÷ Çü ÈEÈCÇúÇ÷ÇøÈFÈGÇõÈC 2008-09!
...
|
How do I use "Or" for 3 instances in VBA on a form
Tue, 06 Jan 2009 05:38:22 GMT
Hi All,
I am using the below code in a database which we use to do repairs to devices.
This snipet of code is checking if the device requires a battery replacement
but we are increasing our products and I need to include an Or kind of
statement on the first Line so that it will check for "Device 1" Or "Device ...
|
Auto set Menu Options
Mon, 5 Jan 2009 18:21:01 -0800
Hello again,
Can someone direct me to some sample code, if its possible and/or available,
to set Menu Options via code?
I want to be able to set the security option to low and uncheck the action
query option on the start up of my DBs so that I, and my coworkers, will not
have to set this each time we use ...
|
VBA to move into Excel cells
Mon, 5 Jan 2009 13:35:01 -0800
Access03/WinXP
Running code to dump data from a recordset into an Excel file. I am trying
to populate the first row with the recordset field names. The problem is in
trying to move from one column to the next - the error is "438 - Object
doesn't support this property or method."
Any help is appreciated ...
|
Remove reference using VBA code
Mon, 5 Jan 2009 13:22:02 -0800
I have a reference to an external Access database that I would like to remove
using code so that I can compact the "closed" external database using code.
There was code for removing references in "help" but I need help on how to
determine name of the reference. Will removing the reference "close" the
exte ...
|
Macro Excel in Access module
Mon, 5 Jan 2009 11:35:00 -0800
Hi,
I'd like to run an Excel macro in an Access module. I did like that:
Set objXL = CreateObject("Excel.Application")
Set objWkb = objXL.Workbooks.Open(MyWorkBook)
Set objSht = objWkb.Worksheets(MySheet)
Rows("1:5" ).Select
'After that it is not working from Access
'But it's working if it's directly ...
|
auto deleting records that are missing data
Mon, 5 Jan 2009 08:28:01 -0800
Access 03 / I have a MAIN FORM and a "subform" that is accessed when you
select the checkbox on the main form. Code is used to automately fill in the
CASE NO on the subform when it opens.
Heres the problem; when an operator accidently checks the box and opens the
subform, a new record is now created in the su ...
|
|
|
Compare two fields each record of table, update record or not in new table
Mon, 05 Jan 2009 15:56:29 GMT
Let me see if I can describe the situation I have..
One table. No Primary Keys. (inherited code, gotta love it)
I want to compare records,
if the first field in record one matches the first field in record 2, then
make double sure the last field does NOT match (report error if so) then
'merge these records ...
|
slowing down a loop
Sun, 4 Jan 2009 15:48:04 -0800
I have a access form with a button to show a ticker tape.
What I would like to do is slow down the loop, something like sleep 500,
below is my code.
Private Sub TickerButton_Click()
Dim x, y, z, done As Integer
Dim varMyStr, varMyMsg As String
Dim varCounter As Integer
x = 0
y = 0
z = 0
varMyStr ...
|
Upload/SaveAs/FileCopy to HTTPS
Sun, 4 Jan 2009 13:16:02 -0800
In Excel, I can use;
ActiveWorkbook.SaveAs
"https://cards.collaborationtools.consumer.citigroup.net/sites/Jax-OST/PassCounts/JAX Pass Counts.xls"
to save an Excel file to an HTTPS location.
How can I do the same thing with Access?
There is no FTP involved to my knowledge.
I want to be able to save a fil ...
|
