Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.20 seconds.
Search: Posts Made By: Banana
Forum: Modules & VBA 06-25-2012, 01:01 AM
Replies: 1
Views: 3,245
Posted By Banana
Re: ADO + MySQL + Ms Access 2007. Unbound Form filters

Hi -

No, that is a limitation of the method of binding the ADO recordset to a form. There are also few other limitations. Here's a partial list...
Forum: Modules & VBA 06-19-2012, 01:38 AM
Replies: 10
Views: 2,244
Posted By Banana
Re: What SQL interpreter can and can't recognize

@Galaxiom, yes, it was introduced in 2010.

@OP,

In all versions of Access, though, you can always right-click a cell in QBE and select "Build..." to open the expression builder. Within it, you...
Forum: General 06-18-2012, 05:19 AM
Replies: 11
Views: 3,568
Posted By Banana
Re: AppActivate

This is basically why I shun SendKeys/AppActivate; you're at mercy at everything else and have to contend with timing your requests and ensure that there's no interrupts that may disrupt your...
Forum: General 06-18-2012, 01:18 AM
Replies: 11
Views: 3,568
Posted By Banana
Re: AppActivate

I've always thought that trying automate via SendKeys & setting focus using AppActivate were kind of dicey because you're relying on certain UI behavior and that there's no unexpected errors (e.g. a...
Forum: General 06-17-2012, 12:52 PM
Replies: 14
Views: 1,770
Posted By Banana
Re: overflow

Rain,

IME, "Print" has not worked for me before. I always had to say "Debug.Print" inside procedures. I assume you copied "?256& * 256&" and pasted it into a procedure instead of into Immediate...
Forum: General 06-17-2012, 06:14 AM
Replies: 14
Views: 1,770
Posted By Banana
Re: overflow

In case of literals, VBA will assume the smallest data type appropriate for the literal. Thus a literal '256' would be an integer. An integer 256 multiplied by integer 256 will overflow.
...
Forum: General 06-14-2012, 12:15 PM
Replies: 3
Views: 754
Posted By Banana
Re: odbc and database security

Just to clarify, because the title was "odbc and database security" and this appears to be for an Access backend, it's not really ODBC that's responsible for security. All it does is pass forward the...
Forum: Tables 06-01-2012, 07:17 AM
Replies: 94
Views: 32,748
Posted By Banana
Re: Composite primary keys

That's what happen when I try to answer from top of my head. :)

Here's the post (http://www.utteraccess.com/forum/CurrentDb-set-vari-t1720104.html&p=1721338#entry1721338) that I was thinking about...
Forum: Tables 06-01-2012, 07:07 AM
Replies: 94
Views: 32,748
Posted By Banana
Re: Composite primary keys

FWIW, it's not 'every other objects' --- for instance, Recordsets suffer from the same malady that TableDefs does with respects to holding onto its parent reference.

Brent had posted sometime in...
Forum: Tables 06-01-2012, 06:46 AM
Replies: 94
Views: 32,748
Posted By Banana
Re: Composite primary keys

"On Error GoTo ...", "Exit <procedure>" and "Resume ..." statements automatically clears the error so Err.Clear in this case would be redundant since I do a Error GoTo 0 to narrow the scope of On...
Forum: Tables 06-01-2012, 05:57 AM
Replies: 94
Views: 32,748
Posted By Banana
Re: Composite primary keys

Some code to play with and ponder upon.

Option Compare Database
Option Explicit

Public Sub TestIt()
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Dim qdf As DAO.QueryDef
Forum: Forms 03-11-2012, 07:32 AM
Replies: 4
Views: 2,536
Posted By Banana
Re: Access 2010 64 bit form issue

Isn't Mousehook a workaround for older Access versions where there were no Mouse scroll events? This also involves APIs and if you didn't update the API declarations properly, it may not work...
Forum: The Watercooler 01-19-2012, 04:12 AM
Replies: 21
Views: 2,088
Posted By Banana
Re: Brianwarnock

My condolences to you, Brian. Remember also to count your blessings.
Forum: Modules & VBA 11-04-2011, 04:03 AM
Replies: 8
Views: 4,700
Posted By Banana
Re: "Enable automatic reconnect" possible with VBA?

Maybe it's actually OK but there's other issues going on. I already linked the similar issue where a hosted MySQL has too short a timeout set that breaks the connection and the workaround. Maybe if...
Forum: General 11-03-2011, 12:06 AM
Replies: 4
Views: 3,808
Posted By Banana
Re: char datatype? (not varchar)

Just to be clear here; there's two different factors here:

1) can we store a fixed length string?

2) can we output a fixed length string?

Both questions are actually different because as...
Forum: Modules & VBA 10-28-2011, 09:13 AM
Replies: 8
Views: 4,700
Posted By Banana
Re: "Enable automatic reconnect" possible with VBA?

You need to pass in the Opt argument in the connection string. It's listed here (http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-connection-parameters.html). Notice at the bottom...
Forum: Modules & VBA 10-28-2011, 05:57 AM
Replies: 1
Views: 876
Posted By Banana
Re: How do I control domain users only to access my MS Access Database

You'd use filesystem permission for this. Put your Access database file (both BE/FE) in a certain folder and grant full permission only to that domain group. Your users can then enter the folder,copy...
Forum: Queries 10-21-2011, 02:32 PM
Replies: 1
Views: 2,675
Posted By Banana
Re: Upsert?

Unfortunately, there isn't any special upsert syntaxes for Jet SQL.

You'd have to do it the ANSI way - update with an inner join then insert using a frustrated join in two separate queries.
Forum: Modules & VBA 10-17-2011, 03:10 AM
Replies: 9
Views: 722
Posted By Banana
Re: Populate Combo with Fontnames

If you're using Access 2010 (maybe 2007, too?) then you can just give your users rich text with ability to select fonts, colors and few other options.

An article on rich text capability...
Forum: Modules & VBA 10-12-2011, 03:18 AM
Replies: 2
Views: 958
Posted By Banana
Re: Variables within String variables possible?

Well, yes. One way to do this is to make use of Replace() function to scan the text within string variable for something like {FirstName} and replace it with appropriate value. You'd probably give...
Forum: Tables 10-12-2011, 03:15 AM
Replies: 1
Views: 571
Posted By Banana
Re: Altering Web Table Fields

You can alter some of properties but changing a filed from text to lookup is not one of them. You'd need to add a new field, delete the old field.

If you want to keep the original data when you...
Forum: General 10-12-2011, 03:07 AM
Replies: 2
Views: 2,789
Posted By Banana
Re: Keeping MySQL connection via ODBC alive??

See if this thread helps. (http://www.utteraccess.com/forum/index.php?s=&showtopic=1939485&view=findpost&p=1944525)
Forum: General 10-06-2011, 06:31 PM
Replies: 5
Views: 2,015
Posted By Banana
Re: Local SQL Server vs. Online mySQL Server

Just to be clear -

There is NO need to involve an Apache and/or IIS web server at all to have a server available online. Any RDBMS (e.g. either SQL Server or MySQL) can be shared with others with...
Forum: SQL Server 10-04-2011, 02:57 PM
Replies: 3
Views: 1,435
Posted By Banana
Re: Debugging TSQL

I believe for 2005 you could only debug with a Visual Studio installment. You could set breakpoints but it has to be started by Visual Studio to actually debug.

With 2008 (2008 R2?) that is no...
Forum: General 10-03-2011, 05:58 PM
Replies: 18
Views: 3,084
Posted By Banana
Re: Closing a database and Access at the same time

FWIW -

I do have kind of similar problem where I try to do too much in the BeforeUpdate/AfterUpdate sequence. The mantra ought to be "validate in BeforeUpdate, modify in AfterUpdate", right?...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 11:58 AM.


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