Search results

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 alter, do the following: 1) Add anew field with desired properties and name it with a temporary...

See if this thread helps.

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 an appropriately configured firewall & TCP/IP protocol. Furthermore, be aware that hosting your...

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 longer a requirement. To start debugging, you would press the Play button instead of "Execute button...

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? Well, sometime, I've forgotten to observe this rule and try to mush both thing in a single go. As you...

Actually, I'd suggest the whole reason why objects reset is due to the fact that when you are debugging, you may have inadvertently reset the project which causes everything to reset. If you ever have pressed the "Stop" button and/or clicked Ok to "This will reset your project", the objects will...

Having worked with both 32-bit Access on 64-bit and 64-bit Access on 64-bit OS, I can assure that user32 lib is still available and should work. On a 32-bit Access (irrespective of whether OS is 32/64 bit) you can use the older VB6 declaration format and 2010 will still recongize it. However...

Do you have a function named ReplaceWhereClause in your code? It's a user-defined function and if it's not defined, that may be why you're getting the error.

Just to confirm, Doc_Man, when you found that you had two databases opened in the DBEngine.Databases, did you try to close one of either? What happens then? Closing recordsets may not be enough.

Sorry for not having made it explicit that we of course couldn't close our current database - the code I gave was from automating the Access from outside which is a different horse. I guess it would work if it was Count = 1 though there's the off chance that you have two Database opened and...

In theory, yes, that's correct. However, as mentioned, I had a case where I was automated Access and I couldn't get it to close because it had a Database open which then messes up the automation because I can't move/copy the file. When I added code like this: Do Until Acc.Databases.Count = 0...

Have you checked CurrentDb.Recordsets? What about DBEngine.Databases collection? I've had a case where I can't close an automated Access instance until I close all recordsets/databases via the collections. Is there a object reference to the Access.Application object by somewhere else? (example...

Have you googled for ODBC driver for SQLIte? I am sure there were ODBC driver and with some patience, you can actually link to SQLite from Access and therefore use Access queries to load up the data.

Well, it's possible but this is not a approach I'd want to undertake. Instead, consider getting a Telnet Client Library. If you can get an ActiveX library, then it's immediately compatible with VBA and will be much easier to use & develop. While you can use APIs to send & read commands, the...

Regarding the "(Access 2007)" you see on the titlebar - that's expected whenever you have an ACCDB file format and you didn't give an custom application title. As you may have noticed, there is actually no such thing as 2010 file format. You still use 2007 file format in 2010 but here's a rub -...

Oh, wait, you're talking about something different. In MySQL that's "prepared statements" -- PREPARE myStmt AS INSERT INTO aTable (aNumber) VALUES ?; EXECUTE myStmt 1; I don't know if SQL Server has an analogous concept (I do think they do - it just occurred to me that I've never bothered...

Disclaimer: I've not worked on DB/2 before but "host variables" sounds very similar to what is used in MySQL client. You're talking about something like this: DECLARE @myVariable INT; SET @myVariable = 1; INSERT INTO aTable (aNumber) VALUES (@myVariables); The above is not possible via ADO...

mdlueck - I'm happy you got it worked out. Sorry about the infinite loop - that's because it's missing a MoveNext in the loop which is why you got same id again and again. However, I have to point out that you don't need Parameter at all for your code. You're getting it from your cmd's...

mdlueck- the article is talking about using ADO.NET against different backend, of which Jet may be one of the backends. The disclaimer is correct insofar talking about getting output _from_ the Jet database, as opposed from _from_ SQL Server. In your case, you are using ADO to obtain output from...

Yes, precisely.