Search results for query: *

Tried the '!' instead of '.' separating the table name and field name. Didn't help. Tried posting an alpha character to the field and it works fine. I was wrong about what the cr should look like if it updates. It should be a box with a '?' in it. If I export the table to a flat file and...

If the field is updated, it will show a non-printable character in the field as a square. The same thing will show in that field when I hit <CTRL>+<ENTER>, if it works. If I try ?ASC(CR) in immediate mode, I still get nothing, since there is nothing for the function to return. It should...

I tried adding the primary key: Didn't work. Tried removing the field, closing the database, reopening the database and re-adding the CR field: Didn't help either.

Thanks genomon, but increasing the width of the field to 7 chars didn't help. Still won't accept input to that field. Pat

Please excuse a VFP developer trying to work in MS Access. I have a database which I created in Access 2007 and then retro'd to Access 2003. In this database is a table called Ajh82Work which has a one character text field called CR. I am trying to Update this field by inserting a carriage...

PH - Thanks. I went with strictly your code for that section, and with only a couple of little tweaks, it works! Had to change the reinitialization line to use mRange instead of mRange2. It was adding an unwanted row at the bottom which had text in a numeric field. Really fouled up the Sum()...

Thanks, PHV. At least you got me started in the right direction. Column AH comes over as a General field, but with text data in it. So, I first changed the NumberFormat to Currency. However, now I have the number data stored as text in a Currency field. If I run a macro to...

This question is about MS Automation in MS Access 2007. Hope I have the right forum. I've been developing in Foxpro & VFP for 20 years, but this is my first attempt at an app in Access. The following code works fine until the oExcel.ActiveCell.Value = mTotal entry on the next to last line...

From my other thread, I was able to figure out how to manipulate the Access Ribbon Bar to my liking. But, what I really want to do is attach a Ribbon Menu or a simple menu to a form so I can actually hide Access and only show my form on the screen with the custom menu. From my experimentation...

AceMan, I finally found it in writing on Microsofts MSDN page. The custom menus have been 'REPLACED' by the Ribbon Menu sytem. That word 'REPLACED' was used by Microsoft MSDN. This means that the ability to create them in A2007 is gone. The only way to do it, is to create your menus in...

After much searching(threads here, Microsoft.com, MSDN, and Google), I have not been able to get a straight answer to this question: Is it possible, in Access 2007, to create custom menus which are part of the open form? I am not asking about creating a ribbon, popup bar, etc. Just a plain...