Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 242
Search took 0.31 seconds.
Search: Posts Made By: Tim K.
Forum: Modules & VBA 06-01-2004, 10:18 AM
Replies: 2
Views: 845
Posted By Tim K.
You can use an Update query to help this out. ...

You can use an Update query to help this out.

UPDATE list SET omit12 = sendto;

But why do you want to duplicate this? It's not recommended to store repeated info in both fields.

:)
Forum: Modules & VBA 05-31-2004, 06:31 PM
Replies: 3
Views: 828
Posted By Tim K.
What error message did you get? You might...

What error message did you get?

You might use ' instead of " in the SQL statement. Something like this.

SELECT DatePart('ww',Date()) AS WeekNum;

:)
Forum: Modules & VBA 05-25-2004, 02:35 AM
Replies: 4
Views: 1,057
Posted By Tim K.
Just follow the example step by step and you'll...

Just follow the example step by step and you'll understand soon. There are lots of code involved. Just copy and paste in Access. Feel free to discuss more.

:)
Forum: Modules & VBA 05-24-2004, 05:31 AM
Replies: 4
Views: 1,057
Posted By Tim K.
To me, GetSetting/SaveSetting are limited. I...

To me, GetSetting/SaveSetting are limited. I perfor to do this by using API functions. Check this http://support.microsoft.com/default.aspx?scid=kb;en-us;Q145679 out.

Hope not to confuse you even...
Forum: Modules & VBA 05-01-2004, 08:26 PM
Replies: 4
Views: 1,094
Posted By Tim K.
You have to put this line too. ...

You have to put this line too.

forms("main_form")("sub_form").form.filteron = FALSE
Forum: Modules & VBA 04-28-2004, 07:48 PM
Replies: 4
Views: 3,050
Posted By Tim K.
Try this out. ... Dim tdf As Object ...

Try this out.


...
Dim tdf As Object

folder = Application.CurrentProject.Path

Set db = OpenDatabase(folder& "\RI Account.mdb")
Forum: Modules & VBA 04-28-2004, 06:21 AM
Replies: 5
Views: 1,350
Posted By Tim K.
I always use late binding style coding to avoid...

I always use late binding style coding to avoid the References problem.

Dim dbs As Object, rst As Object
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset(...)

:)
Forum: Modules & VBA 04-28-2004, 06:12 AM
Replies: 4
Views: 3,050
Posted By Tim K.
Change this line from DoCmd.DeleteObject...

Change this line from

DoCmd.DeleteObject acTable, db.TableDefs(i).Name

to

db.TableDefs.Delete db.TableDefs(i).Name

and make sure to delete all relationships before doing this.
Forum: Modules & VBA 04-28-2004, 05:37 AM
Replies: 4
Views: 2,466
Posted By Tim K.
A Microsoft Access project (.adp) is an Access...

A Microsoft Access project (.adp) is an Access data file that provides efficient, native-mode access to a Microsoft SQL Server database through the OLE DB component architecture. Using an Access...
Forum: Modules & VBA 04-27-2004, 04:03 PM
Replies: 3
Views: 1,059
Posted By Tim K.
I think you have to add a Number field to the...

I think you have to add a Number field to the tblExcelimport. Then loop thru its records and assign the newly added field with the DMax("[ID]", "tblData").
Then you can append it to the tblData. How...
Forum: Modules & VBA 04-27-2004, 03:53 PM
Replies: 2
Views: 1,596
Posted By Tim K.
You can import or link the text file into Access...

You can import or link the text file into Access manually and see if all records show up or not.

:)
Forum: Modules & VBA 04-27-2004, 03:48 PM
Replies: 4
Views: 2,466
Posted By Tim K.
Did you see the sp_ActiveAccounts in Access...

Did you see the sp_ActiveAccounts in Access Queries tab? Is this ADP?

If you see the sp_ActiveAccounts in Access, try adding dbo. prefix to its name.

dbo.sp_ActiveAccounts

:)
Forum: Modules & VBA 04-18-2004, 05:15 AM
Replies: 2
Views: 700
Posted By Tim K.
It seems to me that you also have set ADO in the...

It seems to me that you also have set ADO in the References. If this this the case, you have to add DAO as a prefix to all DAO objects. Something like this.

Dim dbs As DAO.Database
Dim rst As...
Forum: Modules & VBA 04-18-2004, 12:22 AM
Replies: 4
Views: 1,032
Posted By Tim K.
FileSearch already has a SortOrder property....

FileSearch already has a SortOrder property. Check your similar post in the other forum for more details.

EMP, LoadFromText is one of several undocumented procedures hiddenly provided by Access....
Forum: Modules & VBA 04-07-2004, 05:51 AM
Replies: 1
Views: 631
Posted By Tim K.
You can use VBScript in Access with no problem. ...

You can use VBScript in Access with no problem.

What are you trying to do with CreateObject?
Forum: Modules & VBA 03-12-2004, 11:58 PM
Replies: 2
Views: 1,166
Posted By Tim K.
Try this out. DoCmd.TransferDatabase...

Try this out.

DoCmd.TransferDatabase acExport, "Microsoft Access", _
"H:\Projects\SSSS.mdb", acTable, _
"tblInventorySource", "tblInventoryDest", False, False

H:\ is your...
Forum: Modules & VBA 02-16-2004, 06:26 AM
Replies: 1
Views: 966
Posted By Tim K.
Force it to save to a new file name. ...

Force it to save to a new file name.

.ActiveDocument.SaveAs FileName:="c:\newfilename.doc", FileFormat:=0 'wdFormatDocument

:)
Forum: Modules & VBA 12-30-2003, 06:34 AM
Replies: 8
Views: 1,293
Posted By Tim K.
We can't use Index property and Seek method with...

We can't use Index property and Seek method with linked table.
Check this How to perform Seek on Linked Tables (http://www.mvps.org/access/tables/tbl0006.htm) for a workaround.

:)
Forum: Modules & VBA 06-22-2003, 03:46 AM
Replies: 1
Views: 1,561
Posted By Tim K.
Hello Nilses, It's me again. Sorry for...

Hello Nilses,

It's me again. Sorry for leaving you high and dry.

Check the revised code below.


Function BetweenHoursInSecond(DateStart As Date, DateEnd As Date) As Long
Dim lngSeconds...
Forum: Modules & VBA 06-15-2003, 12:46 AM
Replies: 3
Views: 596
Posted By Tim K.
Try this. DoCmd.OpenForm "frmDenBookingDay",...

Try this.

DoCmd.OpenForm "frmDenBookingDay", , , "DenId=" & Forms!Main!DenId & " And Date Between " & Now() & " And " & DKount
Forum: Modules & VBA 06-12-2003, 06:10 PM
Replies: 2
Views: 1,213
Posted By Tim K.
You can use Chr(34) (") to help, like this. ...

You can use Chr(34) (") to help, like this.

Call Shell(SysCmd(acSysCmdAccessDir) & "msaccess.exe " & Chr(34) & "F:\Pooka\I like Rabbits.mdb" & Chr(34)

Application.FollowHyperlink Chr(34) &...
Forum: General 06-03-2003, 06:16 PM
Replies: 13
Views: 32,200
Posted By Tim K.
Here are some more. 1. Add OLE Objects into...

Here are some more.

1. Add OLE Objects into a db. If you embed pictures or documents to a db, the size will be increased in no time.

2. Open 97 db in 2000 or higher without converting it. This...
Forum: General 06-02-2003, 06:09 PM
Replies: 5
Views: 772
Posted By Tim K.
Or try this: =DateAdd("YYYY",1,Date) +...

Or try this:

=DateAdd("YYYY",1,Date) + CDate("02:00:00 AM")
Forum: General 06-02-2003, 08:04 AM
Replies: 5
Views: 772
Posted By Tim K.
You can use DateAdd() like this. ...

You can use DateAdd() like this.

DateAdd("YYYY",1,Now())
Forum: Modules & VBA 06-02-2003, 06:55 AM
Replies: 2
Views: 3,919
Posted By Tim K.
You can try name = CurrentProject.Path &...

You can try

name = CurrentProject.Path & "\export"

CurrentProject.Path is available for Access 2K or higher.

If you use Access 97, try this instead.

name = fRelativePath & "export"
Showing results 1 to 25 of 242

 
Forum Jump



All times are GMT -8. The time now is 09:17 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World