Search results

I've tried searching for more info. on the 'On no data' with no luck. The post I've found were folks looking to cancel a report if it was blank. I did find something on the MS site at...

Hi, I have a report with four subreports. If the subreports have no data I have a formula to put the word 'none' in the first field as follows: =IIf(IsNull([Question]),"None",[Question]) I do a print preview and the word 'None' shows up and subreport looks good when I view just the...

I used the wizard to create a find duplicates query. I know for a fact that 15 records are duplicates. I'm getting over 300 records. When I dumped the data into Excel and did a pivot table to count the number of records by account number only 15 had a total count of 2. All others only had 1...

Hi, I have the following code Gap: IIf([Q1]=2,"GAP",IIf([Q2]=2,"GAP",IIf([Q3]=2,"GAP",IIf([Q4]=2,"GAP",IIf([Q5]=2,"GAP",IIf([Q6]=2,"GAP",IIf([Q7]=2,"GAP",IIf([Q8]=2,"GAP",IIf([Q9]=2,"GAP",IIf([Q10]=2,"GAP",IIf([Q11]=2,"GAP",IIf([Q12]=2,"GAP",IIf([Q13]=2,"GAP",IIf([Q14]=2,"GAP",""))))))))))))))...

Hi, I have a user that uploads a spreadsheet weekly. I want to assign a unique id to each record that is the current date plus the start and end date for the data they are loading which would be the week prior plus a counter. For example: Data from the week of 5/4-5/10 is loaded on 5/12...

I'm getting closer to getting it but now it's got the extra semicolons if the field is blank. How do I eliminate them if memo field is blank? zzGap: [Gap1] & IIf(IsNull([Gap2]),"","; " & [Gap2]) & IIf(IsNull([Gap3]),"","; " & [Gap3] & IIf(IsNull([Gap4]),"","; " & [Gap4]) &...

I want to combine six different memo fields into one. I found this code and it works to combine two fields so I edited to add a third and it does not do anything. Comments: [QAComments1] & IIf(IsNull([QAComments2]),"","; " & [QAComments2]) This is my edited code to add a third field...

I have a form that closes when I click to change the view or if I use the record selector to move to the next record. The form closes and when I re-open it the next record is showing. Any ideas what's going on and how to begin troubleshooting? TIA

Thanks, that worked nicely. How would I do it for a start and end date. Currently, I have Between [Forms]![Main Menu]![StartDate] And [Forms]![Main Menu]![EndDate] but want them to be able to press enter and not fill out a date in the form to see all.

I've used this parameter back in Access 2.0 where I ask for I put [What location?] as the parameter and users can put 'North' or hit enter to get all locations. I can't figure out what the 'code' is behind this. Any ideas? Thanks.

I'd like to implement this on my front end. I work on the front end on my desktop and change the link to my desk top back end copy in order to speed things up as it's really slow when I am linked to the shared drive. I forget to relink it to the back end on the shared drive and users are...

I have this on the open event: Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize End Sub and this on the unload event as someone else recommend. Private Sub Form_Unload(Cancel As Integer) DoCmd.Restore End Sub The form is now opening in full screen but when I close the dbase there...

Thanks Paul but how do I show all notes in one memo field?

We have a memo field that folks may add to on different days. Additionally, different users may add notes if the person who started to work on the transaction is out of the office. My manager would like to add a way to include the date and initials of the person that added a new memo...

Part 2 of my above question: The same user that was just able to open the form correctly, got the error 'The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events. She got this last night but no issues this...

I have a front end that I have distributed to four users. The front end sits on a shared drive and when I make design changes I just replace it and have the users copy it over to their desktops. I set up a main menu for them to access the various forms, reports, etc. When I first open the...

I have a date in my form that folks fill in when they have completed that record. The date will be blank if they have started the record or have not started at all. If they have started completing the form by selecting pass or fail from the dropdown for each of the 9 questions in the form and...

I have the following code that updates the end date to be the same as the start date after the user tabs out of the start date. Instead of making it the same date, I want it to be six days later. How do I add that? For example, user enters 11/10/13 in the start date. I want the end date to...

I have set up a macro to import an Excel spreadsheet. I added a message box that pops up when the import is done. I'd like for it to give a record count to confirm the correct number were loaded and I'd like for it to stop loading if there is an issue. For instance, the user added a field to...

I'm not having issues with the memos cutting off. The issue is some memos are blank and I want to list the memos one under the other versus side by side in columns. If the first or second memo are blank it leaves a large gap. How do I hide the blanks?