Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.25 seconds.
Search: Posts Made By: DJkarl
Forum: Modules & VBA 11-01-2013, 09:51 AM
Replies: 2
Views: 862
Posted By DJkarl
Re: automatically login in to orcale ODBC Connect

Put a routine into your database on startup that relinks the Oracle Table. Use a tabledef and look for the Connect property then RefreshLink. This will prevent the popup box from showing.
Forum: Modules & VBA 10-23-2013, 06:23 AM
Replies: 8
Views: 4,683
Posted By DJkarl
Re: Windows 7, 64-bit Access 2003 Problems

Have you stepped through the code on the MDB yet? What line is the error on?
Forum: Modules & VBA 05-17-2013, 11:24 AM
Replies: 2
Views: 1,025
Posted By DJkarl
Re: Can I use VBA for this? Display records based on multiple criteria

I think in this case you would be better served by writing a query to filter your conditions rather than looping through a recordset to check each record.

SELECT * FROM Clients WHERE Priority =...
Forum: Modules & VBA 05-17-2013, 11:20 AM
Replies: 2
Views: 493
Posted By DJkarl
Re: Noob having trouble getting value from query

What line in particular is throwing the 3265 error?
Forum: Modules & VBA 05-16-2013, 07:34 AM
Replies: 2
Views: 394
Posted By DJkarl
Re: Isolate from string

Function ParsePart(strVal As String) As String

ParsePart = Mid(strVal, InStr(1, strVal, "\") + 1, InStrRev(strVal, "\") - (InStr(1, strVal, "\")))

End Function
Forum: Modules & VBA 05-16-2013, 07:17 AM
Replies: 3
Views: 1,265
Posted By DJkarl
Re: A2007 VBA Intellisense getting confused of which class is which

I've confirmed on my office 2003 machine this behavior exists as well. It seems odd but does not seem to actually impact the code running. I did notice that it only changes once you compile the...
Forum: Modules & VBA 05-15-2013, 04:11 AM
Replies: 3
Views: 524
Posted By DJkarl
Re: Two queries and one csv file

You will likely need to use the Open command with the Append option.

This is just a very quick sample.

Open "C:\Temp\Yourfile.csv" for Append as #1
Print #1, CommaDelimitedStringHere...
Forum: General 05-14-2013, 09:24 AM
Replies: 3
Views: 439
Posted By DJkarl
Re: Select non-coniguous records

Non-contiguous records...do you mean a random selection of X records?

This might help, haven't tried it though.
http://fontstuff.com/vba/vbatut02.htm
Forum: Modules & VBA 05-14-2013, 09:16 AM
Replies: 3
Views: 524
Posted By DJkarl
Re: Two queries and one csv file

First you should really get both queries to have the same number of columns, otherwise how can you relate the data together?

If they have the same number of columns, in the same order, you can...
Forum: General 05-09-2013, 08:48 AM
Replies: 3
Views: 472
Posted By DJkarl
Re: Compact and Repair Problem

Strange behavior indeed. I know indexes add size to the database, but I can't imagine it would add enough size in this case to cause a problem. SQL server is an option, but 1 million records isn't...
Forum: General 05-08-2013, 09:53 AM
Replies: 3
Views: 472
Posted By DJkarl
Re: Compact and Repair Problem

Once indexes are deleted you need to recreate them, it likely deleted them because you changed the datatype. Presumably Access can't index a Decimal the same way it index a Long. In the future I...
Forum: Modules & VBA 05-08-2013, 06:56 AM
Replies: 1
Views: 1,132
Posted By DJkarl
Re: MS Access Forms using VBA to auto login in https URLs

Are you getting any errors? You might want to change your error handler to display the error messages, it might help diagnose the problem with the login.
Forum: Modules & VBA 05-07-2013, 07:39 AM
Replies: 2
Views: 773
Posted By DJkarl
Re: File moving system - best method?

Q: Is there a better way than timers to trigger your file sweeps?
A: In this case I don't think so. Since the job is recurring you are reliant on something happening again and again, a timer is...
Forum: General 05-03-2013, 10:07 AM
Replies: 3
Views: 4,887
Posted By DJkarl
Re: Creating stand alone software from access database?

You can distribute your database as an MDE / ACCDE with the Access Runtime, or you can write your program in Visual Studio using Access as a back-end only, compile your program then distribute the...
Forum: General 05-03-2013, 05:44 AM
Replies: 1
Views: 384
Posted By DJkarl
Re: Summarize the data with Access (for the beginner)

You would use a query to get what you need. Any beginner reference on SQL would be helpful, here's one directed at using MS Access....
Forum: Modules & VBA 05-01-2013, 11:21 AM
Replies: 11
Views: 11,842
Posted By DJkarl
Re: VBA- Random Number Generator

I don't generally do other peoples code for them, but this sounded like fun. Here's what I came up with, think it does what you want, but since it's not a pay gig I don't really feel too bad if it...
Forum: Modules & VBA 04-25-2013, 06:19 AM
Replies: 2
Views: 630
Posted By DJkarl
Re: Help with code

If you have the degrees you can use the formula (degrees * (PI/180)) = radians

PI is defined in the .NET Math class, Math.PI.
Forum: Queries 04-24-2013, 10:18 AM
Replies: 1
Views: 377
Posted By DJkarl
Re: Null value in function

Use the following.

NZ([popi_r2a],'')
Forum: VB.NET 04-24-2013, 09:17 AM
Replies: 2
Views: 3,248
Posted By DJkarl
Re: How steep is the learning curve?

Depending on what your program does it could be easy or difficult to migrate to VB.NET. The syntax is similar to VBA in how you declare variable, and functions. However you lose what Access does for...
Forum: General 04-22-2013, 10:42 AM
Replies: 1
Views: 503
Posted By DJkarl
Re: Memory limitations in 2010?

This is from Microsoft.
http://technet.microsoft.com/en-us/library/ee624351%28v=office.14%29.aspx
2007 and 2010 require more memory just to run, so it would stand to reason if they have not...
Forum: Modules & VBA 04-22-2013, 10:38 AM
Replies: 10
Views: 1,035
Posted By DJkarl
Re: Protecting VBA from user changes to code

I have never found a very reliable way to keep people out of the queries. You can keep them out of forms and reports by making the database an MDE or ACCDE, this would also keep them out of the code...
Forum: Modules & VBA 04-17-2013, 07:25 AM
Replies: 10
Views: 1,035
Posted By DJkarl
Re: Protecting VBA from user changes to code

Open a VBA module, on the tools menu you should see several options, there should be one like YourDatabasename Properties...
Click this, go to the second tab called protection. Click the Lock...
Forum: Tables 04-16-2013, 07:14 AM
Replies: 2
Views: 556
Posted By DJkarl
Re: Cannot Copy Table (See Pic)

The table you're showing has no data, the row you have highlighted is a new row, what would there be to copy?
Forum: General 04-16-2013, 04:35 AM
Replies: 2
Views: 959
Posted By DJkarl
Re: Thin Client solution helppp!!!!????

So basically your client wants to use, manipulate, and access a database created in MSACCESS, but not use any available tools that would allow them to do so. Your client wants the same capabilities...
Forum: Modules & VBA 04-15-2013, 05:39 AM
Replies: 7
Views: 3,229
Posted By DJkarl
Re: Connecting To Oracle - Instant Client 11.2.0.3

The only time I've seen this issue happen, is when we converted to Windows 7, Oracle didn't like the Program Files (x86) folder path, if the office path was changed, or Access was launched with a...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:25 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