Search results

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.

Have you stepped through the code on the MDB yet? What line is the error on?

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 = True and TimeToCall < Time() If you only want 100 or less records add the following SELECT TOP 100...

What line in particular is throwing the 3265 error?

Function ParsePart(strVal As String) As String ParsePart = Mid(strVal, InStr(1, strVal, "\") + 1, InStrRev(strVal, "\") - (InStr(1, strVal, "\"))) End Function

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 project, otherwise it happily leaves them as you typed them.

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 Close#1

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

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 join them together with a UNION statement. create a new query SELECT * FROM query1 UNION ALL...

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 an unreasonable amount, unless the record size is huge (lots of columns). What I would do next...

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 would create a blank table from your existing table basically a Make Table query with 1 row...

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.

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 pretty much what you need. Q: Is there a more efficient way to handle file copies that allows the...

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 EXE and the database.

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. http://office.microsoft.com/en-us/access-help/microsoft-access-for-beginners-part-iii-writing-the-queries-HA010247313.aspx

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 doesn't ;) Option Compare Database Option Explicit Public Type LaneAssignments laneNumber As...

If you have the degrees you can use the formula (degrees * (PI/180)) = radians PI is defined in the .NET Math class, Math.PI.

Use the following. NZ([popi_r2a],'')

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 you automatically (it does surprisingly a lot of stuff). If you are still using Access as a...

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 upgraded their systems that they would not be able to do exactly the same amount of work. Component...