Search results for query: *

I am using this calculation within a query. I don't know where it was getting that number. I was able to make a change and use DatePart and get the results needed. DatePart("d",[DepreciationDate])-DatePart("d",[DateAcquired]) The numbers are coming out correct now. Here is the rest of the...

Hello, I am try to get the number of days only from two dates in an Access query. I need the days to calculate depreciation for an asset. It works fine in Excel but I am getting the wrong number in Access. DATEDIF(C9,$B$4,"md" = 5 Days Date1 = 7/26/2008 Date2 = 3/31/2011...

Sorry this is hard to explain. I have a report that gives information about meeting rooms. Things like Room number, Presenter Name, Meeting Title, and Meeting Type. Meeting Type is usually populated with something like, Breakout Meeting, General Session, and State Meeting. However when Meeting...

For example: The room combo field usuall has a record like "205 206" or something like that. If the room can't be combined then the field is empty but it's still displayed on the report.

Is it possible to dim a record in a report if it is null?

I am using seven forms to enter information about a venue.The active form contains the primary key record that is also carried to the related second. example: (frm-room.roomId (primary) to related frm-presenter.roomId.) I have been using this code to open forms, set values, and close forms...

I figured it out. Don't perform the calculation directly in the field but use After Update in the field being calculated and have it post.

I have a table named tblroom with a field named theater. I want to update the table field from a calculated field called theater in the form called frm-room. The record in the form creats a sum from a calculation. I need to have it populate the record theater in the table. I have done this...

I had to add one more line of code on the first line. I was getting an error message concerning relationships in the database. Refresh.Me corrected the problem. Thanks again for all your help. Private Sub Open_Presenter_Form_Click() Me.Refresh DoCmd.OpenForm "frm-presenter", acNormal, ...

That works perfect!!! Thanks

I received a compile error on this line. Any idea what wrong? Forms!frm-presenter!roomId.DefaultValue = Me!roomId

Here is my goal: I have two forms with an command button on the primary that opens the secondary form with the current record ( "roomId" ) on the primary and secondary. The primary form name is: "frm-room" with roomID as the primary key. I want it to set a value to the secondary form...