NONE
There is no Code on the form at all
cwby1966
Last Activity: Mar 5 '10, 07:34 PM
Joined: Feb 27 '07
Location: Minneapolis MN
-
Run Time Error 2427
I have a form that everytime you open it or move from record to another you get this error message 2427 You have entered an expression that has no value.
Any help? -
Sorry this took so long, I pretty much forgot about the conversation. It looks like MS pulled the "Office" out of it in the name tagline, so in line 7 of the code you'd change "Microsoft Office Outlook" to "Microsoft Outlook" - also, the same for Outlook 2000. See if that works for you. -
Exporting reports to excel
Questin
Does any one know why they have removed the feature to export a report into Excel? -
Hey Sorry I did not respond to your post about PDf till today. I have been out of the office -
What is the data source for the report? Are you only using the hotel name as criteria?Leave a comment:
-
Thanks for your help
Very much appreciated -
You cant use macro. You need this add on
I am not sure why you where not able to download as i was able to download again . You have to go through all of the validation steps etc.
Possibly try again
SorryLeave a comment:
-
I haven't tried it in Office '07 yet, as we're still on '03 at work. I do have '07 installed on my home PC, though, so I'll see what I can do with it and let you know. -
I believe your code is correct but you need to make sure you have the PDF add on installed
Link
Download details: 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPSLeave a comment:
-
I found that creating a combo box with the following code in the afterupdate event seems to work very well. You can type in your search value. I do this in most of my forms where the user needs to search for a record.
"code"
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Cl one
rs.FindFirst "[Project ID] = '" & Me![projidselect] &...Leave a comment:
-
I have the same situation in a DB. There is an add on you can down load from MS.
Link below, I then output to report to that format. But you need the add on
Download details: 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS
hope that helpsLeave a comment:
-
Subform Requery Problem
Hi
I have posted several time have and have gottten lots of great help Thank you!
I have a form with 2 subforms
the 1st subform (Details) is detail of sales transactions. part #, qty, price,
The second sub form (dailysummary) is a summary of sales data.
I am tring to have the sunform dailysummary requery after teh qty is updated.
I have search on this forum and have tried several of the ideas presented... -
All of the controls in the if statement are form controls they are unbound cont fields...Leave a comment:
-
Text Box with data source of iif statement
I have a text box on a form with the following data source iif statement.
This text box is to display...Code:=IIf([leasecnt]=0,"No Leases Entered ",IIf([tbl_leasefllwup].[Form]![fllcnt]=0,"No Items Entered",IIf([tbl_leasefllwup].[Form]![pstd]>"0","Past due Follow-up Items",IIf([tbl_leasefllwup].[Form]![Due]>"0","Follow Up Items to Review","No Review Items"))))
-
Message using IIF statement
Hi
I have a form that has a sub form. Want to add a text box that would didplay a message depending on different cirteria. The sub form list items to be followed up on, so if there was an item that was past due and not complete I want to diplay a message that there are past due items, same if there was an item that was due in the next 30 days.
I have tried creating a text feild with a control coure using dcount but had not luck. Can... -
Thanks
Works Perfect....Leave a comment:
-
Filtering a Subform
Hi
I have a main form with a subform. The mainform has 2 textboxs Starting date and ending date. These are for the user to select a date range, and then clicka button to filter the subform to view only records that are in the date range. This DB is in Access 2007. I have tried appling filter with a saved query I have also tried the folloing code. Any ideas
Thanks
...Code:Private Sub Command111_Click() Me!tbl_leasefllwup.Filter
-
Thanks for the reply I have tried that and it works exceept the criteria for the filter comes from a combo box....Leave a comment:
-
Applying and Clearing Filters
I have a filter that is applied on the click of a command button. If you click the button to remove the filter and show all records and then choose to do another filter with a different location you get the same data as the first time is there something I need to do duifferently
I have included the code for both the apply filter and the show all records
Apply
[code=vb]
DoCmd.ApplyFilt er "fltr_drawingsi te", ""...
No activity results to display
Leave a comment: