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...

Thanks gol4. I think this is a viable solution. The only problem is that the ImageList control squeezes the icons into the size of one, so when I create a new image that is twice as wide as the standard icon, the image is distorted/elongated. Anyway you know of that I can make the image wider...

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...

smedvid, thanks for your post. What VBA functions are useful in reading in the continuous record after record format of EDI/QIF? I'm not sure where to start. Thanks

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...

Jim, Thanks for your help... actually it seems that in order to get the formula value to update, I have to open the EXCEL sheet, save it, and then reopen the table. Closing and reopening the table doesn't seem to do the trick. Not sure if I'm missing something. Thanks. Sean

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...

Thanks Robert. What I really need to do is this -- I have several fields that have a preset payment amount (named, for example, [Payment1], [Payment2], [Payment3]. I have another field that does a calculation to determine which period I am in and returns a 1,2, or 3. I want a final field to...

It appears that the "fields" function does not work in a query. Can anyone offer any further help? Thanks

Shannon, I need to stick it in a query. Thanks for any help you might offer.

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.

Yes, the payments (cash flows) increase by 1/2% each period. I need to be able to return (not necessarily save) the interest and principal payments for each period of the annuity. I have done a two tiered annuity where the payment amount changed in the middle of the annuity. In that instance...