Search results

I have this module to export a spreadsheet. The issue is with the SQL statement. I have tried both the stored query and using it in code. When I take out the reference to forms!frmMain!cboRptShift the export is successfull. I need this reference to correctly create the export as well as another...

Good afternoon, I have a report which sorts rank using an IF statement. Looks like this: SELECT LastName, FirstName, IIf(IsNull([MI]),"",[MI] & ". ") AS Expr1, Rank, Shift, StateEntryDate, Random, PromoDate, DaysOff, IIF([Rank]="COII", "0", IIF([Rank]="COI", "1", IIF([Rank]="COS", "2"...

I need to export the data from an access table to an existing excel workbook with multiple sheets. Sounds familiar I know but none of the solutions I've found here or elsewhere address the below issues. The easy part is that all of the data needs to be exported and the spreadsheet field...

Seriously I know there has to be a simple line of code for this. I want to set the AllowZeroLenthString property for one field on one table to true just long enough to run an update query to clear out the fields for preperation of new assigned numbers. I don't want to permenently set it to...

This one should be really simple. I need to filter out only the first instance of a field that returns multiple instances in a query. IE (query result I get now) Example A Example A Example A Example B Example B Example B I need to get back Example A Example B

I have a Form with two subforms. The user enters a value into a textbox named NUMBER. The OnEnter event populates sfrmInfo with the fields; NUMBER, LAST_NAME, FIRST_NAME, ADDRESS. I have some validation code and if the NUMBER is valid an Add Record command button appears and they can then add...

I have a report that pulls up an individuals information from a query. I have a folder where images of these individuals are stored. I need to link up their image with the rest of their information on the report. The report prompts the user for an ID #. This ID # is the also the file name...