Search results for query: *

I've searched high and low for some reference to what this thing is but have found nothing. I have three queries in my database. I'll be working in a form that is based on a query and more or less everything is fine. After using the forms, if I then go to the query window there's this...

Is there an alternative to DLookup? I seem to remember reading somewhere that DLookup was antiquated and that newer versions of Access have a new way of doing the same thing. Also, can DLookup's use variables? I have the following but it doesn't work because there is more than one field on...

I have a database of tenants for various buildings. When a user needs to add a new tenant to a building they have to select the exact building from a combobox then that building (using its ID number as a global variable, intProjectID) opens the "Add new tenants" form filtered for just...

I think I'm really missing something fundamental here. I have a few tables that are just about as normalized as they can be. They are tblTenants, tblApartments, tblVoucherStatus, tblNotices, and tblDates. Each tenant has an apartment (they may move from one apartment to the other in this same...

I have a field YearFiled in a table. The data type is Date/Time and I want the format to simply be yyyy. I put that in the field's format property but every time I enter a date, say 1973, it tells me what I've entered isn't valid for the field. Can anyone tell me what I might be doing wrong here?

I posted the question a few threads down, Thread705-421739. To reiterate the question.... I have a combobox on a form that is used to search for the record that matches the selection in the combobox. I originally set it up using the combobox wizard which inserts the following code behind the...

I keep running into Type Mismatch error 13 (is this really a bug in the program?) when I try to use the standard combobox code to find a record based on the selection in the combobox but add in a line to turn off any pre-existing filters. The code is: Dim rs As Object Me.FilterOn = False...

I have three related questions: 1. When you open a form that contains a subform, does Access consider the subform "open" as well, I mean in the sense that it goes through the load and open procedures? 2. If you open a form that contains a subform, how do you refer to that subform...

I know it's possible to center, bold, italicize, change the font or color of the text in my own custom message boxes (VBA). I read it somewhere a while ago but, now that I want to do it, I can't recall where. So many books, so many websites. Can anyone help me out with this? For instance, if...

The last few subforms I've created aren't showing up in the VBA Project Explorer window. When I try to refer to them in VBA code I get an error message saying that Access couldn't find the subform referred to (fyi: I'm not trying to do anything complicated at the moment, just set the focus to a...

I have a simple combobox that is used to find and bookmark a matching record on a form. I just used to the wizard to create it since it's easy and it works. The code is: Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[EntityID] = " & Str(Nz(Me![cmbSearchbyEntity], 5))...

I have a search form that has a bunch of unbound comboboxes from which the user selects values and then clicks a search button that builds an SQL string based on the values entered. The results are then assigned to the ControlSource of a subform. The user can execute as many different...

I have a subform on a main form that shows the results of a query. The records are read-only. If the user perchance tries to edit any of the records in the subform, I would like to have a MsgBox popup telling them they can't edit there (similar to the msg you get in a query window when you try...

I am trying to set the ControlSource of a textbox in code but keep getting the "#Name?" result. The idea is to have the textbox show a concatenated string that includes a variable. Me.tbxResults.ControlSource = "Search results for your query by " & varCity But this...

I am trying to develop a search form that allows the user to search for records based on various criteria of their own choice. Right now, I'm testing a Select Case block with some If..Then. statements. Yesterday the Select Case block was working for the most part. Then, to take care of a...

I have a form where the user selects values from a few comboboxes and then hits a Search button that populates a listbox with the records that match those values. That works but, instead of a listbox, I would prefer to use a subform (because subforms can show the record count, etc.) but can't...

I have read somewhere I can't remember where exactly (too many books, so many inadequate indexes) that you can format text in a message box. Things like change the font, center the message, set the font color, etc. Actually, wherever it was I read this, I noted at the time that the author...

The following If...Then block is supposed to perform different commands on form based on whether the user clicks vbYes, vbNo, or vbCancel. It all works except for the vbCancel. If the user clicks vbCancel, I want the form to close. What happens instead is that the MsgBox closes and the focus...

I posted this question once before but, alas, I dropped the ball on the thread, so I'm posting again. I have a form, frmProperty, that can be opened via command buttons from two places: from the Switchboard and from frmOwner. When frmProperty is opened from the switchboard, the user is most...

I have two forms that both can be loaded from a main switchboard. There is a button on Form B that can also load Form A (but user cannot go from Form A to Form B). When loaded from the switchboard, the OnLoad event takes the user to a new record and maximizes the window. When the user is in...