Recent content by raweber

I guess I didn't look to closely past his first sentence. Is there much written about putting together a log-in form? Now I'm thinking and this makes me curious.

How about this - is there a way to manually copy the altered forms, queries and reports from one Front End to another so I don't have to make the specific changes to each and every front end individually? Thanks, Rob

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

Thanks, vbaInet - it worked! Rob

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

Cool thanks.

The answer is yes, the query is based on the values of the two combo boxes. How would I make the form close when the report is closed if the closer just uses the red "x" to close the report. Is there an On Close event? (I suppose I could just go a look at Excel, huh?) Thanks, Rob

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

Re: Syntax Error (Missing Opertor) In Query Oh, that's brilliant! Thanks so much. One other thing - DOH! Thanks again, Rob

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

All right - great! I've got that working. I want to use this value in reports, as well, but I'll go onto the reports forum to ask that.

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

BOOM! Thank you!

Okay, I'm trying to implement Baldy's code as such: Private Sub btnEdit_Click() Dim rs As Object Dim strBookmark As String 'set a variable to the current record strBookmark = Me.numStudy DoCmd.OpenForm "frmDataEntry" 'take it to the selected record Set rs =...