Search results

Friends, I'm having trouble grasping why I can't get my totals query to work correctly. I have a table called tblEvents. There is a field in this table called [Outcome]. The [Outcome] field will have one of three values: 1. "ESTIMATE FULLY SUCCESSFUL" 2. "ESTIMATE PARTIALLY...

Friends, I need any and all help with this report/subreport problem. I have a report that pulls info from the departments (Operations, Analysis, and Specops). Users from each section input data into their own data entry forms. Records from each section all have a SITREPNUM field...

Friends, I'm having an odd problem with my Contacts Addressbook form. I have a addressbook-style form that lists several buttons along the bottom (i.e A-z, "ALL") that are used to filter names matching the selected letter criteria. The same set up is used in the Northwind Sample DB. The...

Friends, Haven't seen a similar post yet, so here goes. I have a typical QBF search form which returns criteria matches in a continuous subform (fsubSearchResults) at the bottom of my main form. Oftentimes I want to isolate (or remove) certain records returned in the results subform. I...

Friends, I have a contacts form which contains a subform (continuous forms) for telephone numbers. The subform is necessary since each contact will have several (3 or more) numbers each. The telephone numbers are not formatted the same way, however, since some of the numbers are international...

Can anyone tell me why I keep getting errors when I try to use a standard string function in my control source expression for my report field? This is the expression: ="POC: " & [TitleRank] & " " & [FirstName] & " " & [LastName] & " at x-" & Right([WorkPhone],4) I keep getting the following...

Friends, I'm having difficulty accomplishing a few things that I'm sure can be done with some built in string functions. I have a memo form which I need to perform a "quasi-tab." I already know a way to simulate a tab in a memo field by trapping keycodes and all, but it still does...

Does anyone know if it is possible to lock the scroll bar in a memo field? I have a form with a memo field in which the user types a (at times) lengthy transcript. When the focus leaves the memo field and the user then returns to that memo field, the cursor is placed at the beginning of the...

Friends, I am having a wonderful time trying to get my continuous form to filter correctly. I have a QBF search form which returns record results in a subform located at the bottom of the search form. The QBF works utilizing MS's dynamic QBF approach (using QueryDef to build an SQL...

Friends, I am having a problem getting my date range to work in my search form. I have the following code to pull dates from my QBF form fields [FromDate] and [ToDate]. When I run the query, however, I keep getting Type 13 mismatch error as if I did not format the date where clause correctly...

Friends, I have a main form [frmEvents] with several cmd buttons that open linked forms. If there is criteria that matches the linked field in the linked form the corresponding records are displayed. If not the form opens with a blank detail area. There is no On NoData event for forms, so how...

Openform with search criteria Friends, Having trouble making my search form work correctly. I have a search form which returns records in a query (Dynamic_Query). Instead of the query, I want the the retrieved records to be displayed in the form that I use for data entry. I am not sure how to...

Two questions. What's the best way in VBA to determine if the current record is the last record in the recordset? What's the best way in VBA to determine if the current record is a new record (unsaved)?

I have come across a boat load of posts in different forums where people tout the advantages of using unbound forms for data entry. There seem to be a lot of advantages to using unbound data entry form, particulary for multi-user systems. Among the advantages is having complete control over the...

Friends, I have a problem with a report of mine (rptDailyReport). The report pulls data from three separate tables and therefore has three sections. The main section of the report pulls info from the Operations table (tblOps). The two subreports pull info from Special Operations...

This should be easy for a lot of people out there. I need to write a data validation expression that specifies that entries in a [ReportNumber] field cannot end in a letter. I have a feeling that I need to utilize the Right() function, but I'm not exactly sure how. Is this enough information...

My Kingdom!! My Kingdom for a solution to this image link problem!! Friends, Is there no way to display linked images using an unbound OLE field INSTEAD of an IMAGE field?? I have a main form with linked images shown as thumbnails on a subform. I need to use an OLE field as a picture display...

Pat Hartman, Anyone, I saw a previous post response from Pat Hartman which explained this a bit, but I'm still not tracking for some reason. I want to model a report log system that is currently in use in my office. Presently, transcript reports are simply listed in a logbook (rptnumber, date...

I have a switchboard with a subform that is "re-sourced" for each of several data entry forms. The switchboard form opens up maximized at startup and remains the only form open for the user. When any reports are opened (with form cmd buttons) in print preview mode, however, the switchboard form...

Hello all, I have a memo field which has the backstyle set as transparent. I have some objects behind the memo field which I need the user to be able to see as they type into the memo field. When the memo field gets focus, however, the backstyle returns to Normal (opaque) and the...