Search results

An SQL statement needs a semicolon terminator Mysql = "SELECT Max(CDbl(Mid([YouFieldName]," & X & "))) AS NewNum" FROM tbl_YourTblName Where YourFieldName Like '" & sPrefix & "*'" & ";"

There was a known bug in earlier versions of Access where Name-Autocorrect would mess up report orientation.Try turning it off if you have it enabled.

Is this on one line or two lines as it shows here? It may be missing the line continuation character (space-underscore).

You have a comma before the FROM clause - that might be an issue.

The other suspect would be your field called AutoNumber.

Make sure that you have Option Explicit set at the top of EVERY module. Change some code (add a space and remove it again) and then compile and save your application. That should clear the phantom breakpoint. If it does not, you will need to research the de-compile option.

Do you mean 2 Primary Keys or 2 or more fields making up a Primary Key (AKA a Composite Key)? You cannot have 2 Primary Keys in a table (by definition a PK is a unique identifier for a record in a table). You can index another field to disallow duplicates if you wish. You can have 2 or more...

Put an unbound text box on your report. Set its controlsource to =1. Set its running sum to Over Group or Over All as appropriate.

I use a Global variable to track which form opened which other form and then use that in the close event to go back to the previous form, HTH.

I feel that you might be making a mountain out of a molehill here. You sound as if you want to use the sub-form as a navigation tool for the main form. Why not use a listbox or a combobox instead? Select the record you want and code takes you to that record. (3rd option in the combo box wizard)...

1 pregnancy has many women - I don't think so!!

Look in the page set-up - all the margins/orientation etc. stuff is in there.

My first suspicion would be that 'Cleartype' text display setting thingy. The fonts used have different coloured pixes on curves and suchlike to smooth out the viewing on LCD screens.

If you use MZ-Tools (a freebie which adds much functionality to the VB IDE) it has a feature which allows you to see the calling procedures for any procedure. This is very helpful.

Your Else block needs some attention. You end your If block before the intLogonAttermpts 1 to 3 bits. Why the reset of intLogonAttempts to zero each time? You should try an ElseIf structure (or a Select Case structure) for your intLogonAttempts 1 to 3 bit.

With a bit of VBA coding you can set up the Attendance subform to click one button and mark all as attended - then you go through and remove the absentees. No biggy there. Your instructors are only going to have to go into one form - they may access several Lesson records in that one form. See...

I am a bit confused by your table design. I don't understand the distinction between the Training and CourseDate tables. The CourseDate field is odd. Either it is redundant data or is the CourseDate in the Attendance table actually a LessonDate? The only way you will be able to create a...

SWAG here - could it be confused by [Name] ? Name is a reserved word in Access. (I do not have A2010 so cannot test)

I believe it used to be an issue in earlier versions of Access where modules were loaded 'on demand' and any potential call's module was loaded as well. I think that later versions of Access are more efficient in this respect so it is not so critical now.

Here is a start