Search results

I'm trying to figure out something for this thread. Basically, I have a form that has some combo boxes where you make some selections. You then click a button (on the same form) that launches a report that returns data based on the choices you made in your combo boxes. On the report I have it...

OK, I call a report, RSR, from form FISReports. On the form, you can choose the date range (not optional), a specific individual ("BA", optional), and the status (optoinal) of the projects you want to report on. The button that runs the report has the following code to filters the optional...

In Access 97, is there an easy way to reset an autocounter? Or, maybe, more generally speaking, is there a way to "reset" your database? Meaning, I've done all my testing and I want to clear the data, reset counters, etc... Is there a simple command for this? I've looked around some and not...

OK, I get this error in 2 different circumstances (so far) in some of my various forms. That said, I wouldn't be surprised if they are fixed the same way or have the same root cause. Circumstance 1 I have a form w/ a combo box and buttons. You select the person who's records you want from the...

OK, I have to forms that load the same subform. The subform, FSRComment, has a text field "SRNum". The text field is supposed to get its value from the the form that loads it. I put this line in the Default Value box of the text field: =[Forms]![FSREdit]![SRnum] Or...

In the form I'm working on, I have 2 combo boxes (they could be list boxes too, I don't believe this part matters). The first is a list of project descriptions, "projects". You select a "project" and it requeries the 2nd box to pick the appropriate project number, "projectSR", for the "project"...

I have 3 nearly identical queries running that, in turn, are ran by 3 nearly identical reports. Everything is the same in regards to what fields/data to pull for my report. The only difference in the reports is which query they call. The queries SELECT, FROM, and JOIN statements are...

This question picks up where this one left off. I have a form, FISReports, this form calls a report, RISIF. RISIF uses a query, QISIFReport, as its record source. On FISReports, there are 3 pieces of criteria: 1. To and From dates (to unbound boxes) 2. BA (unbound combo box, this is a list...

Is it possible to have a query call a form as output? NOT create a form, but SELECT a form that already exists and populate it with data predicated from the WHERE clause? Basically, I'm trying to work around some of the limitations of the command button wizard that only let me whittle down my...

OK, I have a form, ISForms, that I'm really using as a switchboard. The form has to pieces of selectable criteria: BA & SRType. You select from combo boxes the criteria for each, then click the form you want and, based on your criteria, a specific form (SRType) that w/ the records of the...

OK, instead of using a switchboard to for the user interface of my DB, I'd like to use a form w/ command buttons that then take the user to the areas they need to go to. I'm doing this because I don't like the default settings of the switchboard and find it difficult to make changes to it...

I have a form that is called by a switchboard. In this from, "callreport1", you enter criteria which in turn, a query uses to build a form. The criteria is: to date from date employee name As it works now if you enter your date range (to/from date) and an employee name it generates a report...

In this report, I have it subsort by "BA". In the "BA Footer" (not the page footer), I've put in a count: =Count([DtReceived]) "DtReceived" is a field in the Header. So, basically, for each "BA", I'm trying to count header records. What it is doing, though is counting the detail records...

We use access 97 and the text field is limited to 255 chars. I'm just curious what the limit is in 2000 and if anyone knows what it is in XP? We'll be jumping to XP later in the year.

OK, I have a switchboard. On the switchboard I added a combo box that allows you to pick an employee name. I'd like it to work so that when you select a name, say "Jones", then click a form, it filters so that you only see the data for employee "Jones". I hope that makes sense? I'd like to...

I'm making my first DB in Access 97 and have this stumbling block (among many!): I have to combo boxes. They read records from table 'project' and the form writes to table 'ISIF'. When the user selects one of the choices of the 1st combo box, I would like the 2nd combo box (I guess this could...