Search results for query: *

I think I've been trying to reinvent the wheel for about two days now. Using a query (as opposed to a macro I'd have to run to update my table) I need to count how many entries in my db live in a particular state - and break these entries down into groups of, let's say 15, placing a...

How would I pull information (into my form) from the next or previous record? I've tried this: Me!NextPartTitle.Value = DLookup("[PageTitle]", "Articles", "[ID] = " & [ID] + 1) which gets me into trouble when the id doesn't exist. Do I have to loop till it finds a higher-numbered ID? Or...

Okay -this answer's gotta be simple, but I can't find anything in access help. How do I tie an event to someone hitting the "enter" key after putting info into a particular text box?

How do I get my query (which creates the row source for a list box) to sort correctly when the column I'm sorting on is a UDF? Apparently it's sorting before doing the calculations - not after. Rerunning the query in the list box's after change event simply reruns the query - which of course...

Well, I've shot the last six hours or so trying to figure out where, how many and what type of quotes to use. I know this has got to be pretty simple - but I can't seem to see the rhyme and reason to how/when to use them. I'm loading up the row source for a list box with a query. Picking up...

I'm getting the infamous "Data type mismatch in criteria expression" in my totals query. The field causing the trouble is created in a separate query by simply adding the values of other fields like so: Score: Str([Count1]+[Count2]+[Count3]+[Count4]+[Count5]+[Count6]) From what I can glean...

Why does my record not "synch" when I open the form from the switchboard? It opens fine when I simply double-click on the form icon - but nothing I've tried will get it to synch if opened directly from the switchboard. I have this in the sub-form's code module: Dim rs As Object Set...

This has gotta be really simply - but somehow I can't find this needle in a haystack: How do you associate a form with its subform so that you only see related records in the subform instead of everything?

Is there a way to count how many characters are contained in a particular field? In other words, keep a running count of how many characters somebody has typed into a control? Would I use the instr function - or is there a more automated way?

I've got products that I'd like to associate with a topic (that is, "Widget A" is related to "Using Widgets" and "History of Widgets.") I'd like to make this association via a simple yes/no check box - and at least when creating the association, I'd like to see a large checkerboard pattern...

I've got a subform being displayed in datasheet mode. Problem is: it shows just the first one and a half lines - and cuts off the rest. I've got "can grow" set to yes for the "details" section of the subform. I have noticed that when I first open the form, the subform will automatically...

I have received a database loaded with addresses - with the zipcodes formatted as numbers (which, I believe is incorrect). Naturally, when I try to print them out zips from the east coast (the ones using a leading zero) appear with four digits. How do I put back the leading zeros in access...

When I'd like to load an image onto a form, how do I deal with the error that results when the image doesn't exist? I can exit the sub based on "on error" - but that won't work when there are several images on the page (because each has its own error message). As you can see, I've...

I would like to check a checkbox when I make a change to a corresponding text box. If the text box is empty, I'd like no check, and a I'd like to see a check if anything is in the text box. (Both text box and check box are bound.) I've tried the following code - and it will tick the box - but...

In excel we can speed up code execution and get ride of screen blips by turning off screen updating - is there such a thing for access?

Is there a way to force all the controls on my form to update to current values simultaneously whenever I change a value somewhere on my form (via any and all controls)? I'm ending up with a bazillion strings of identical code, each attached to the event of several controls - when there's gotta...

I'm trying to use a dropdown/combo box control to move all fields (on my current form "WhereWhen") to a particular record. "Events" is the table "EventID" is the field "WhereWhen" is the form "WhereWhenEventCombo" is the name of the combo My best attempt so far: DoCmd.GoToRecord , acGoTo...

I've created a form; it pulls its info not from a single table but from a query (which pulls from two tables). When I switch over to VB I see pages (housing code) named after every form except this one. So... I don't know where to (or if I can) insert code created for this form. Am I supposed...

I would like to add a combo box to my form. I have four fields (in each record, naturally) that I would like to offer in that drop down box. That is, I've entered a single city into each of 3 or 4 fields and want a drop down that offers those three/four cities for selection (as opposed to a...

I've got "dlookup" working just fine: I enter a zip code, it looks up the correct city and state name abbreviation. But... I when I enter that zip, I also want to retrieve the full state name (in "proper" format) from another table based on the state abbreviation retrieved. It ain't working...