Search results for query: *

I have a main form with two subforms, each of which is a continuous form that refers to a subset of records. I want the flexibility of continuous forms over datasheets in order to haandle fancier headings and formatting than datasheets would offer. I can easily synchronize the sub forms to a...

I'm installing an application for a client who has about 20 simultaneous users. With rare exception, the application works just fine with one user and fails with one or more of the above error codes. 2427 You entered an expression that has no value 2447 Invalid use of dot operator 2465 Run...

Somehow I've either written or copied code that causes the query for a continuous form to re-execute (i.e., requery) simply after holding down the alt(ernate) key. What's the best way to find out what's causing this ugly action? I would think I should just look for key-down or some similar...

This should be an easy question to answer. If I have "funny looking" code in VBA how can I find the control or controls which invoke the event? For example, I usually change the VBA-assigned event name to something meaningful by defining first the meaningful label or combo box name on a control...

Hi! I've got a form and subform that work just fine. But... and you knew this was coming... what causes the properties sheet to show up when the subform appears? Did I do something in code (VBA) that would have caused it to happen? It doesn't always happen, but usually at an inauspicious time...

When I set up an event to handle the not-in-list for a combo box, I first invoke a subform which lets me add the data to the lookup table. So far, so good. Since I wanted to pick up the value that the user entered and stuff it into the subform for the lookup table, I do something like this in...

Hi! This is one of the strangest anomalies I've seen: the client had a record (which I cannot delete through normal means) whose words are in what appear to be DBCS format. I haven't a clue how they got there, but on the one record where this occurred, every single field in the record except...

Hi! My searching may be over. So far I've been only modestly successful, so maybe you can help me. I want to create a table from a union query that consists of two SQL action queries. The new field is to be in datetime format and is derived from another date field in the same record. The date...

There's got to be a good place to go to find out how to "install" the OCX for the spinner, but I can't seem to find something succinct. Please advise where I can find out how to find appropriate controls (I have a spinner with a version of 2.0), register it if it's necessary, then use...

I have a date in text format that needs to be treated as if it were a data (i.e., #mm/dd/yy#). Maybe there's a better way to do it, but I have a number of dates in various months that need to be converted to the first day of the respective months so that I can consider all dates within a month...

Hi! I think I've got an easy one: I have a main form and a subform that work just fine. On the main form I have a command button that invokes the subform. In the subform is a query that refers back to the main form to pick up selection criteria. All's well. Now, I want to use the same form...

I've searched high and low and I know there's an easy answer, but it's eluding me. I have a wide continuous form with lots of fields and want to create an "editing window" that will reflect two things: the name of the field that the cursor's positioned at on whatever row is current...

My client wants a spreadsheet layout with columns frozen on the left (a la datasheet view), but datasheet view won't work for a bunch of reasons having to do with formatting and layout. (Well, _maybe_ it would work, but at the moment it seems there are too many things to consider in that...

Hi! Is there a simple way to open a continuous form laid out like a datasheet and position the cursor several columns to the right or, better yet (and assuming a wide form) so that column "x" which would normally be beyond the right-hand side of the screen could show up on the left...

Hi! My client hated the design I created using normalized tables and complementary forms to navigate and pop up various related information. I had a continuous form that kept everything on the main form that would fit without scrolling and then used a command button to get at additional data...

What's the best way to take a Clipper file and export it for some further processing using Access (or some other tool) to update a key field (called "name") and then reimport it into Clipper. I've read that there are problems with memo fields when exported and imported, but I'm not...

OK, I keep thinking I know something about Access and then whammo, I get a slap on the face. Today it's a case of having made a nearly successful conversion from Access 97 to 2000 for a client's application. Lo and behold, I get a blank page after the first sub-report. I've tried removing stuff...

I can format US currency as having two or three decimal places (the default being two, of course). However, I have the situation where thhe values for stamps are either whole cents or half-pennies. I'd like to display the numbers as, for example, $0.34 (or 34c, where c is the cents sign) and...

I have an interesting problem that I thought I'd solved, but I can’t quite get it to work. Maybe you can help. So, let me first describe the environment, then give my proposed solution and perhaps you can tell me where I've stumbled. The main query that the report uses is a straightforward...

Client wants me to use Active Directory to pick up names of employees in departments, etc. I've got to believe this is a fairly straightforward thing to do, but I don't know how to get started. I presume I need to know about Active Directory (nothing's in my books on Access) and I'd like a...