Search results

We have a search form which has combo boxes from which criteria can be chosen to search i.e. Project, category etc (most based on a primary key of "ID"). We want to add check boxes for 2 items - safety Yes/No and environment Yes/no - so that the form can be searched on these criteria also...

We're using the following code to try and create a report from a mulit-variable search form. We believe its "supposed to" work - but (guess what!) it doesn't. Any advice would be appreciated. THE SEARCH BUTTON Private Sub btnSearch_Click() Me.FrmSubPCGSearch.Form.RecordSource =...

I have a bunch of reports with the code below (highlighting every 2nd line). When there's no records to report, the code collapses ('cause you can't divide zero by 2). I've tried saying using 'recordset.recordcount <1 docmd.close" (or something like that), but it doesn't like the recordset...

I have a form with a command button. When the button is clicked I want it to close the form; and then run the code below. The code below works fine; does just what I want it to. But I can't work out how/where to put the docmd.close code. Every where I've tried has either not run the rest of...

So, really, the easiest way is to copy my form and call it "Risk2" or something? 'Cause the datasheet view can't have command buttons.

I have a form, let's call it "Risks". On the form view there is a command button. It opens the same form but in datasheet view and filtered against certain criteria. I would like to create an "on close" command for the form that says "if this form is in datasheet view and is closed, then...

I have a report comprising of about dozen or so sub-reports. These sub-reports are also available to users as stand alone reports. Some of the reports will occassionally have no data. ie there may be no safety issues this month. This is causing the reports to fall over. I notice there...

Thank you :-)

I'm formatting a report to highlight certain lines (eg if this & this apply, then turn the line red etc). I have a date field "milestone due", and I need to highlight milestones due this month. Previously, for other things, I've used "Now - 31" to give anything falling within the last month...

I have a message box (pops up on the after update code of a field) with a long-ish message. I'd really like to force the message into two lines. Is this possible? I know how to code forced line breaks in Word macros, but Access VBA is still doing my head in.

We got around this issue by: - designing a continuous form with the basic details, which were showing on the sub-form. To the side of each record is a command button that opens a 2nd form - the 2nd form shows all the extra information, which was the main details of the original form. So (in...

Bump. Still need input.

I have a form, that has on it the details of a specific incident. Below the details I have a sub-form that lists all the incidents. So (sort of) ... ------------- Issue: 1 Details: Ladder fell over Personnel: Joe Blogs --------------- Issue..Details .............Personnel 1 ......Ladder fell...

Decided the easiest way around the whole thing was to add a field to my main table (actually rename an unused field), and put a box on the first form asking for the user to type in what they want to appear on the title page. Its a wee bit of double handling for the user, but ultimately a whole...

I have a TOC, manually created, which is currently a sub-report to my main report. I've read the MS Knowledge Base instructions for creating an automatic TOC, and I'm thinking of trying them. The instructions indicate that when you print or preview the report, the TOC is generated, and...

I had a look, and I've never used that format before. Not that that's especially relevant, most of what I've done in the past 4 weeks I've never done before <sigh>. I'll have a play with it and let you know if I work it out :-)

I have a very large database. One table is a version control table. The user registers each version of a monthly report. So the table contains - say 3 versions against April's report; 4 against May's report etc. When the report is opened, it filters against a chosen month. The field the...

Lovely. I knew it would be easy. Its just knowing what VB calls things.

I have a form that opens filtered against various criteria. I have code sitting in the "on load" to update information on the form. If there's no data against the filtered criteria I get a de-bug message. This will obviously (unnecessarily) freak out the client :-) I assume there would be...

I have a command button with a password. I lifted the code straight from a message I found on the forum here. I assume it is possible to allow the user to update the password somehow, without introducing them to the finer art of VB programming. How would I do that? Code I'm using is...