Search results

I've made my own record navigation buttons on a form. they work fine, except when i get to the first record. if i click 'previous' then the 2105 error pops up "you can't go to specified record". the buttons were created through the wizard, and have error trapping in them. for some reason, it...

it only took me 4 months to get this to work.... found the solution on this site, but can't remember which thread now... instead of placing the iif statement in the criteria line, put it in the 'field' line of a new colum in the query, then set the 'show' line to false, and the criteria to...

anyone have a work-around idea? the error handler doesn't seem to catch it either. oops, just saw that the error number is 2455, not 2455a. it looks to me like these chart objects aren't very well linked with access. everything seems a little.....questionable...

I've got a report that includes a pie chart created through the chart wizard. the source data for the chart depends on options set in a form. to change the source data, (in the OnOpen event), i create an SQL string and then i have the following line: me.objGraph.rowsource = SQL once the code...

guess it just confused things more...

Here are the non-updateable queries: this calculates the outstanding value by taking the original vallue, adding the value of all revisions, and subtracting the value of all the invoices for a job: SELECT Input.Enquiry_Index...

I know, but i'm trying to simplify it. it's a big ugly query that i don't want to make people try to decipher. i'll try to narrow it down a bit..... give me 5 minutes.

I have a listbox, and it's underlying query includes a group by / sum function pairing. because of this, it's recordset is non-updateable. I need to select an updateable recordset for which that calculated field is in a certain range (say between 0 and 1). what i'm hoping for is to use the...

Database: Invoices.... need a billing address, and a delivery address. I have a table of addresses (of both kinds, of course), a table of invoices, and a linking table for the many-to-many, because each invoice has a delivery address, but may have a separate billing address. in my linking...

Nice to see fellow bass players on here. I play a mexican Jazz with EMG-J pickups @ 18v. fairly cheap bass, but it feels so nice, and plays so well. my band is www.thiscrookedmile.ca you'll see reference to me moving to the UK if you check it out. I also played in various jazz bands at...

this sounds like a long way around a combobox......

yeah, they're linked on clientID. also, the listbox is bound to contactID, so i would think it would select the contact, but it only selects the client. table info: Contact_Info: contactID (PK) ClientFK (foreign key to ClientID) ContactName, etc. Client Info: ClientID (PK) ClientName, etc...

i've attached a small database (not all parts work, but the relevant ones do) showing a client/contact selection system. the listbox shows results of the search from the fields at the top. if you click on the second or third contact for a client, it brings up the client properly, but for some...

Well, after stepping through the code many times, i discovered that for some reason when the new form was opened, the query wasn't run. the recordset's field count was correct, but record count was 0. a requery after opening solved the problem, but i shouldn't need that. what's going on here?

I've used that on the form itself, but i want to include the result of the dsum on my search page. the only way i know how to set up a search is by using a query, with dynamic criteria based on text-entry or option controls on a form. to be able to search for certain total values, i need to...

i want one checkbox to determine wether or not the records with a 0 value are displayed, and the other to determine wether or not the records with a non-zero value are displayed, so i can show one or the other, or both, or (not likely to be used, really) none. i do need both checks because i'm...

little more info: this is the whole criteria string that works: >0 or IIf([Forms]![frmJbBk]![chkcmpltJB],0) meaning if that checkbox is checked, i get the 0 values and the non-zero values (there are no negative values), and if it's not, i only get the non-zero values. if i enter this...

here's what i have: IIf([Forms]![frmJbBk]![chkIncmpltJB],>0) it doesn't work. if i replace it with just >0 it works, but then i lose the option of hiding those records (obviously) how do i format the >0 to get the iif output to work in the criterion?

I need to create a button on one form to open another form to the same record. i've tried using the wizard, and everything looks like it should work, but it doesn't. the form still opens with a blank recordset. the field i'm using to link the two is the autonumber index of my main table (which...

In my main table, each job has a value. over time, it can change, but i need to retain the original value, so i have another table that tracks the adjustments to the value. this of course, leads to a calculated field on my forms. I have a search page on my form that includes searching for the...