Viewing 15 posts - 106 through 120 (of 274 total)
I think you need to use the Forms!FormName.ControlName syntax or the Me.Parent.ControlName syntax to get the desired behavior. Tab key behavior when you are using subforms and want to...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 12, 2015 at 7:19 am
I think the issue you are having is related to the OnCurrent event - it gets triggered the first time the form becomes active (after the load and got focus...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 9, 2015 at 3:57 pm
A couple of questions to help narrow the scope of the problem: What version of Access are you using, and what format is the database - .mdb or .adp...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 9, 2015 at 2:20 pm
The usual method for getting the value of the identity column is to do a query that gives you the maximum value of the identity right after you add the...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 9, 2015 at 7:45 am
How are you triggering the cloning of a record? If it is a button on the main form (presumably bound to the table InvoiceHeader), then you would probably find...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 8, 2015 at 3:31 pm
It appears that query should work, and what it would do would be to populate the [Lead] column in the Application table with the value of the matching record in...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
January 22, 2015 at 8:10 am
The combo box should be a useful way of setting the priority for each record - you can make the priority a numeric column, and hide the actual field while...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 19, 2014 at 8:46 am
To do as you describe really requires the use of VBA - macros are too limited. I presume this is a continuous form that displays multiple records, and you...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 18, 2014 at 7:26 am
The order of records being displayed on a form is determined by the record source for the form - so if your form has a SQL statement as its record...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 17, 2014 at 4:16 pm
One of the things about Access, that you will discover if you haven't already, is that the recommended practice is to load the front-end Access file on the workstation, rather...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 12, 2014 at 11:17 am
So are you using the same front-end accdb database and changing the connection string on start? If so, you would need to enumerate all of the form objects to...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
December 10, 2014 at 5:18 pm
We're going to need a few more details (pardon the terrible pun) in order to assist you on this. First of all, if you have a one-to-many relationship between...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
November 28, 2014 at 7:26 am
You don't indicate what version of SQL Server you are using, but it appears it is a recent one - 2008R2, 2102 and 2014 have an option that you have...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
November 24, 2014 at 8:58 am
I think there may well be a more general solution that doesn't involve tracking who has what open. I presume you are using ODBC linked tables in your Access...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
November 19, 2014 at 3:09 pm
Regarding the size growth, the first question is whether you have done a compact and repair? It's much more important in .accdb and .mdb files than it is with...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
November 12, 2014 at 11:21 am
Viewing 15 posts - 106 through 120 (of 274 total)