Search results

I have a listbox filled form a query. It has 4 columns. I want the value from the last column and use it to open a report. I can open a report ok, the issue is that Me.lstThings.Column(3) is always null. Read a stack of posts out here and appear to be doing it right. What am I missing?

I have a db that stores a list of monetary entries. Each time and entry is made, a tax form is printed that shows a number for a credit based on the monetary value (45% of the monetary field value base on a year that runs from July to July). This form is a report based on a query. I...

This is great, thanks. Now if I can modify so that is selects the closest match and makes it the current record (like the lower nav search does) I will be on the money.

What would be the best way to mimic the search box in the navigation bar at the bottom of each form? My user doesnt like the small box at the bottom and would like a larger box at the top of the form. They do not want a standard search of "enter name parts" and click search, they want the same...

I think I see my issue. I have a form that launches a popup form (modal) for data entry of a single record, with a print button as they want to print a report of that record at data entry time. The form either opens as a tab without focus or if I set it to popup, opens in the front but I can...

Typically when you print something, you get a print preview (with focus) and then print dialog to print to a printer of choice. How can you accomplish this ni Access 2007? I can go straight to print, and I can preview (unfocused tab) or preview as popup, then magnify/demagnify with mouse and...

worked like a charm.

Thanks a bunch! As for the odd named field in teh query, access did that as I used the query wizard to create it. Will keep you posted on the results.

here you go. Launch the Individual form and then try to add a new donation..then click the report button (square, no text) after adding data (dont need to click save and close) and see what happens.

Ok, cleaned up the ID fields to be TableNameID (as they should have been in the first place and I know better (slaps hand)) Anyway, still get prompted for the parameter...when launching report from DoCmd. If I open the query or report, it runs fine (showing all records). I pass a where clause...

It is a number field and the query behind the report is a join and has numerous tables with ID (the default autonumber field) in it, all refereneced by TableName.ID. If I manually fill in the prompt with the id I saw in the MsgBox, it works. Not sure why I am getting prompted.

Have a report based on a query. This is how I am opeing the report from a buttonclick: DoCmd.OpenReport "IndividualDonation", acViewNormal, , "[IndividualDonation].[ID]= " & Me.ID I have a msgbox prior to this to check Me.ID and it is correct. The report prompts for IndividualDonation.ID...

I have a 2007 db, been working no it in 2007 and occasionally in 2010, careful not to use any 2010 items. Well I goofed and added a Navigation Form (2010 only) and then deleted it. Now My 2007 db opens in 2007 fine, everything works, but the glowering Warning message and lovely yellow yield...

beautiful! Thx.

I have a form (of a single record) with a list box showing related records based no a relationship. The first records list box is great, shows what I want. When you navigate to the next record is still shows the data from the first record. My query for the list box ends with WHERE...

Google showed no love...lots of "for sale" and MS Dynamics. Couple of articles on using the access 2007 crm template, but that template does not exists in the office template downloads (it may have as some point). Anyone have a simple CRM in access they would like to share?

If I go with tabs, can you navigate between them without losing what you enter then click save when ready? Sub form sounds promising as well.

I have taken over the project and it is a single table. 7 forms are used to manage x number of fields each, but their are 20 fields that show on each form. May need to add an "IsDirty" check between tab navigation with forms that are opened? The users open x number of forms, then edit...

I have a db with 7 forms. On each form there are 20 - 40 fields on each. The first 20 are the same on each form. I have a few questions... 1) best way to have data entered on first form carry over...autosave? 2) is there a more OOP way of creating a single form that is reused on each form so...

You da man! Ran some test, ended up using Form_Activate and Form_Deactivate to get and set the current record id. Activate gets fired during the open process as well as the tab select. Deactivate gets fired on close or lost active tab status.