Search results

I have a table with 25 columns, tried the "highlight/select table" then click report. I get a report that is about 10 columns shorts. Any idea why this happens. Need the report because I am going from report to excel via macro and the column sum in the footer translates nicely to excel that...

I have been going through the forums and found a nice solution to take a report to excel. My issue is that the report is gray headers and black text/details. Looks great. When exporting to excel it is the reverse.. black headers and very faint gray text for the data. Any idea how I can solve...

I have a form with 3 fields and a button. On button click I need to run a macro that calls 3 queries in order. The 2nd and 3rd need 3 parameters, thus the form. How can I pass them in? Fill out form, click button, run delete query, run 2 append queries that need parameters then finally open...

Here is the query....the Diff column is the difference between a field and a calculated field. Why do I get a popup asking to fill out the Diff value. If I leave it blank and click ok it runs and is correct. SELECT DonationRecipients.RecipientName, DonationRecipients.ApprovedTaxCreditAmount...

I have a simpel query: select field1, sum(VBACalc(field2,field3)) as thing, field 4 from table groupby field1,thing, field4 seems to run fine, but always mutilplies the result by 4. I have edited my database table to have only 1 record. Stil multiplies by 4. I set a stop itneh VBACalc (which...

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

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

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

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

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?

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

I have a db with 4 forms. My users want to be able to open a form, go to record x then open another form and have it open to the same record x. Also, the standard tabs that you get when opeing multiple forms, when you are on form y and change to another form via the tabs, do the same...