Search results

So, I have a FE/BE 2007 database with a variety of different front-ends customized the the various users. They do share a lot of common queries, reports and forms, but not entirely. I have explored some of the various auto-updaters, and they seem to be all aimed at distributing an entire...

I have a database we use to track the workload of my office. I have created custom front ends for a variety of users. Many of the forms and reports between the different front ends are identical. The primary difference between them is that they either default to a different custom report, start...

I have a Front-End/Back-End database. I would like to give access to certain members of senior managment to run reports off this database, but IT says they can't have write access to the directory - only read access. When I open up the front end off my desktop (that is, the front end is...

I have a mini-form with two combo boxes and a launch button that I use to customize a query that then feeds a report. It's a pretty straightfoward operation and works fine. The hang-up is that on the report I have a field in the header that counts the number of records in the query and reports...

Here's the offending code: IIf(IsNull([SuspendDate]),(Date()-[DateReceived]),IIf(Isnull([ResumeDate]), ([SuspendDate]-[DateRecieved]),(([Date()-[DateReceived])-([ResumeDate]-[SuspendDate]))) AS Queue As near as I can tell I have Then and Else conditions for each IIf statement, all my...

Helpful friends, I have a calculated field in a form that checks to see if the completion date is filled in. If not, it returns the CURRENT date minus the start date. If it is, it returns the COMPLETION date minus the start date. Here is my (working) code for that...

I've looked around and seen a number of questions on this topic, but none of them quite get me where I want to go. I have a master form called "frmDataEntry" and the primary key is a string field called "numStudy" and does include both letters and numbers. I have several forms which point...

I have several reports that span more than the window can handle. My boss has asked me (since he only looks at the reports on the screen) if it is possible to freeze the report/page header at the top of the report view (to keep it from scrolling off the top of the screen) similar to the freeze...

Is it possible to toggle the .visible status of an object in a Report based on the value of one of the fields in the record? I have a report called rptDrillDown which gives the details of a record after being called by an On Click event from the summary report. So far, so good. It's calling up...

All right, I've been wrestling with this for most of the day... I want to create a summary report with minimal data, and a link on each entry that will open a detailed report for just that line. (This is for Admins who will not have write priviledges to the db so they can't open forms - at...

Almost feel like I'm cheating coming here to ask rather than doing all the research and homework myself... Anyway, I have a button that calculates a value, and I want to then populate a field on my form with that value. I've successfully calculated the value (and have a msgbox to confirm it)...

Hi, all I'm working on my db for tracking studies. Some studies need a Work Order number and some don't. I'm working on a VBA button that will populate the W/O field with a number one higher than the highest W/O Number on record. Working through it, I've set up a messagebox to make sure...

This is a pre-emptive question. In our organization, most folders are read-only for everyone outside of your group. We have managers outside our group that would like to have access to reports from our study tracking database. I'm going to set up a simple front end with a form with buttons...

Now I've gone and done it. (Let me preface this by saying that I'm working on a copy of my front end, not the original). I have my db start with a particular form that most of the people will be using and it has links to the other forms they need. I went and changed the name of this form while...

I have a form where certain items are made visible and invisible as needed by check boxes and buttons. I had everything working just fine. Then I moved everything into a Tab Control so I could have multiple tabs on the page. Now nothing turns on and off as I click the controls. Did moving the...

Filter on Checkbox - Resolved I have a Yes/No field (Archive) in my table for archived studies that is tied to a checkbox (chkArchive) on a form. I would like to hit a button (btnActive) and filter out all the records for which that box is checked. Currently I'm calling an On Click event...

Conditional Calculated Value - Resolved I have an unbound Text Box in a form that is for showing active days in a project. If the [CompletionDate] txt box is empty, I want it to show Date()-[DateRecieved] but if [CompletionDate] is occupied, I want it to show [CompletionDate]-[DateRecieved]...