Search results for query: *

I am trying to reformat the data in a notes table by using a union SQL statement. I am getting an error anytime I try to union more than once (see below) SELECT CATEGORIES AS AUDIT, HOURS_1 AS HOURS, NAME, Period_1 as PD FROM Admin_Time_Reporting_Table WHERE HOURS_1 IS NOT NULL UNION SELECT...

I have a single record form and have added a listbox populated with a unique field from the recordset (I'm using a dataenvironment). I want to enable the listbox to navigate through the recordset, similar to what access does when you add a listbox and choose to have it "find a record on the...

I have a frames page: a banner and a body. When I click a link in the banner frame, I want to feed one page into the body as well as changing the page in the banner. Can't figure out how to do this. I am running FPage 2000. It seems that for a hyperlink you can only specify one page and one...

I am trying to do a TotalType = dscSum on a field element in a DAP. When I select dscSum it tells me that Totals are not allowed on the field. The field is numeric. Documentation is sketchy on TotalType so I couldn't find what the rules are that govern its use. Any help would be appreciated.

I have a form with multiple treeview controls. The nodes are fed via code from hierarchical tables native to the Access database. I have several "new record" forms that launch off of the main form which essentially create new records in the native tables. I would like to have a way, when the...

Is there any way that I can assign two images, side by side, to a treeview node instead of just one? I am designing a task and documentation database and I want an image for the type of document it is and then an image for the status (working, complete, reviewed, etc.) I wasn't sure how to get...

I am working on a database that essentially manages tasks. I want one of the fields on my form to be a drop down list of icons representing various task stages (in progress, complete, reviewed, etc.) I don't need text, just the list of icons that I designate. Can't seem to figure out how to...

I have created a form in Outlook 2000, saved as an oft file. The body has rich text and a hyperlink. When I create an email from the form, nothing shows up in the body (only the subject). The body does show up when I am editing the message but not in the outbox after I send it (the sent...

I would like to create a small application in Access that will track credit card and banking transactions. I want to enable users to import qif files from various institutions. Does anyone know of a VBA routine or ODBC definition that will allow import of the QIF "record after...

I have a table and a query that lists bill numbers and adjustments. I want to create a field/formula similar to an auto number where the first instance of a bill number will be assigned 000 and then increment up 001, 002, 003 until the next bill number is reached at which point it will restart...

I have an Excel table that is linked to Access. One of the fields is calculated (in Excel). I am able to update the data from the entry fields but must open, save, and close the Excel file in order for the calculated amount to appear as updated in my linked table. Is their any way to call a...

Here is my scenario: I have two list boxes. One is populated from a "total population" table. One is populated from a "selected population" table. I have VBA code that adds the record from ListBox1 (Total Population) to the recordsource for ListBox2 (Selected...

I am concatenating several pieces of data together which will tell me which field (among several) from which to pull data. The question is, how do I refer in a formula to a field by using concatenated text. Can't figure it out, would appreciate any help.

I need to calculate the present value and current interest payment for a specific period in an annuity. This would easily be done with PV and IPMT except the cash flows are not constant. They increase by .5% every period. I am thinking that this is going to require an array-oriented module...

Here is what I want to do --- Query1 has the same identical returned fields as Query2. The results are slightly different. I want to have, in Query2, an additional calculated field that returns an asterisk if the same record exists in Query1. If the record does not exist in Query1, then I...

I am using the following syntax to filter on a checkbox field: DoCmd.ApplyFilter , "[Report] = 'Yes'" I get the following error when the code executes: Runtime error 2501 You used a VB method but then clicked cancel in a dialog box. (which I haven't done) Any suggestions?

I have 24 subreports (no parent/child relationship, no field to group on) in a main report. I want to insert a pagebreak after each subreport, but only if the subreport has no data (I have a HasNoData event on each of the underlying reports so if there is no data, nothing passes to the main...

Programming in Access sometimes makes my hair stand on end. I am aware of the subreport page header problem... don't know how to solve it - I have dynamic crosstab reports (about 20 of them) feeding into a main report. Each subreport has a different number of columns, etc..., making an attempt...

I am going to use Tabledefs().Fields().Delete in VBA code to delete all columns in certain tables that contain all null values (I must do this at runtime as tables are created). What I need is to get a list from Access (query, command, property????) of the fields that sum to null so that I can...

I am displaying a DSUM of a crosstab column in a report. It worked fine before I did the NZ in the SQL statement. The query still works fine, and everything that used to be null is now zero in the query results, but my DSUM in the report is giving me #ERROR. Any help would be appreciated.