Search results

How about: If KeyAscii = 13 Then or just "13".

Just an additional thought. What about setting your connection to exclusive in the process? I don't know how this will work with everyone using the same login... Or simply have two accounts, give them one, and the other you can use exclusively for this purpose.

A quick and dirty response since I haven't used access in months... If your value isn't in the query your building your form off of, then your new form should be a modal form (just one way to do it) on top of your other form with the combobox you are referencing. In other words, if the value...

To take things further... What level of protection do you think developers should be able to take to protect their Intellectual Rights? This is a very important question. There has been many discussions, debates, articles on just how far developers should go in taking an active stance or...

Another viewpoint... Most likely this program will have some kind of security level with different levels of protocol. Do you think that Microsoft is the only one that has individual machine locking protocols? Most all of the software protection programs that are for sale to developers have...

I just ran across this and found it interesting enough to post here for those who are interested. R' ------------------------------------------------------------------------ For years the company has been toying with the idea of taking the data store from SQL Server and porting it to...

Dont know... maybe... Using XP Pro SP2 here...

Or... This may sound silly, but create another textbox-combobox setup on the form with the same functionalilty - everything identical - and see if you get an identical error... I have had Access lose its internal reference to objects textboxes etc. on the form before and a simple restructure or...

Pat, It does it on mine... And double checked... it does it in both 2000 and 2003 format. You can see it change even in design mode when you expand it. With no image.

Here is my 2 cents... I think that 'Doc' has given great advice... Access I believe is great for creating fast apps that if you stay within the bounds of the jet engine and everybody is running the same setup, you can create complicated programs, and run relatively error free, provide you do...

Here is another free look at various programming topics and components a lot of people simply forget about... just set aside an hour+ or so to view them... Microsoft On-Demand Webcasts http://www.microsoft.com/seminar/events/webcasts/ondemand.mspx There used to be a free tool that was...

First of all I am not an expert... I agree and learning also. In ADO.Net you have no more server side cursors, the DataSet is completely a disconnected state, you have to make changes, save changes, and then update the database. Movement within the DataSet is from the DataTable and DataView...

It has been a over a year since I have seen this and I haven't used Access in a while so bear with me... What I can remember what can cause this problem is that there is a single column in a query that is repeated more than once, and I would assume that it is used in an expression and this...

Great response... and very well put. Thank you. I will honestly bet you, that you don't loose too many arguments do you? Can I have more of what you are eating? :)

>Why does everyone confuse Access with Jet? Because it is synonomous... and a lot of us assimilate it as a whole. >Firebird SQL is a replacement for Jet, not Access unless I am reading the add incorrectly. Oracle, DB2, SQL Server, MySQL, etc. are >ALL replacements for Jet. Previously I...

I should let Roy respond to this, but VB.Net is a BIG jump from VB6 or VBA. A lot of methods or I should say some methods are no longer supported in VB.Net when upgrading from VB6 or VBA, so depending on how much programming you have done in your application, extensive or otherwise, will depend...

Here is my 2 cents... Personally I believe that Access has or plays a major role in personal database development. I guess what I mean is that it is a great introductory database program that can be used to create complicated databases as an individual or their certain needs grow. I hope that...

Here is a link for more info on DAO and what can be expected in the future. http://www.access-programmers.co.uk/forums/showthread.php?t=74485&highlight=drops+jet

Sue, I copied the same moves you did and my AutoExec worked fine. Made a test database, created a module, saved a function that opened a form "Form1", created a new macro using the RunCode command, selected the function name in my current database in the Action Arguments, named the macro...

Or if you simply want to scroll through a grid etc. with the form set to a certain size use "GoToPage" on your command buttons and assign your x and y coordinates on your form.