Search results for query: *

I am trying to write an expression in a default value for a field to make it equal the Previous Records field value. Can this be done and how, because I'm not getting it. Thanks for any help. A day in November is worth 5 in October

This works. Bingo: IIf([LicenseType]="7","Yes", IIf([LicenseType]="8","Yes","No")) This does NOT, returns #error for the field value. Days Rec to Issue or Reject: IIf([issue_date] Is Not Null,[Date Info Rec]-[issue_date], IIf([reject_date] Is Not Null,[Date Info Rec]-[reject_date],"No Dates...

Setup From Form1 user picks YRQTR from drop down and picks another YRQTR from drop down (for comparison) and picks Region from Drop Down and then user used to pick a salesdistrict Then would go to another form for the type of report to run. With 40 sales districts it took a long time to run...

I have a problem when I am mail merging an Access table to a word document. The problem is that one of the fields I am merging is an OLE object. (it contains a bitmap image) When merging the fields (customer name, address, etc) no problems but when merging the OLE field all that shows up is...

I am thinking maybe this can't be done. I have a single table query that when it is run, I want the data to be non-updatable. I have searched and can't find where you can do this. I saw where people had queries not be able to update when they wanted to be able to update. I have went through...

If the record gets changed I populate a field with the =now() function using the BeforeUpdate. User wants both date and time. The field only displays the date but the time is included. Works fine. Now they also want a nightly report that shows all records changed or created for the day. Here...

I have forgot something. I have a single table form. When record gets changed my AfterUpdate event works fine to the extent it places the values in the fields, but then I can't move off that record for nothing. I have to Edit Undo Current record. Here is my AfterUpdate Event. Private Sub...

Form is based on a table. After adding or editing a record in the form. If I press the New Record button, Access takes me to a New record BUT the curser is in whatever field I happened to be in on the previous record, when I clicked on the New Record button. I want it to go to the first field...

I have a pretty plain invoice tracking database. The user wants the ability to be able to attach a document (word, excel, pdf or even text files to a invoice record on a form. Database is on a shared drive, a folder for the documents can be on the same shared drive. I want user to be able to...

Fed Qtrs run 1 qtr later then State Qtrs. In a table. I have a field [Reporting Period] from data entry that contains the State Qtrs. In a query, I have a field for Fed Qtrs that I want filled automatically from the State Qtrs value. I have a rather large expression that works but is there a...

you use tab control and go to different pages. I have about 45" of form space I need, Multiple questions with mutliple radial button anwsers that are captured into text fields. Can't seem to find this info w/o actually doing it. Or what is the best way to get 45 inches of form space to get...

I inherited this database. So... Anyone had this problem or may have a solution for me it would be greatly appreciated. The Form and subform have a bunch of combos and radial buttons that are based on field names from an Inspections table. When I click the save button or go to the next record...

I can't seem to find a setting for this? Is there one? Can any one help me? please