Search results

It truly is not a calculation but rather an assigned value (done yearly at beginning of season) which is then used as input to various Report generation, criteria for some Select Queries and input to a Lookup table. Believe it makes little sense to re-create/repeat the same...

This is a MAKE table query and the field stored will be used as a selection criteria in several reports and select querries and/or input to lookup tables down the road. This function is only done once a year. Believe I am using the correct approach but feel free to correct me if you think I...

CORRECTION Correct VBA storage area is named: Work1 - Weekx (Code) (NO leading Work1 _), sorry

Some progress (hope ?) BUT now when runnung the Make table query it gives me the error: undefined function '[Create_Week_Num]' in expression The Actual function is stored in _Work1 - Weekx (Code) as Private Function Create_Week_Num(WeekNum As Integer) What am I doing wrong ...

Need a little more help: How do I code the Make table query to call that function so that WeeK_Num gets placed into correct field in given table. Thanks...jnh

I am pretty new at this and have LOTS to learn.... Have a Make table query and don't seem to have correct coding that calls a function and places funtion result into specified table field VBA coding (simplified): private function Create_Week_Num () Week_Num as String do something end...

Hi, Building a report showing a score sheets (ball games). I am Not using any header/footer. Each score sheet is only a 1/2 page allowing me to print 2 score sheets on each 8.5x11 page BUT the 'fixed' data (Team Id,dates,courts.......) does not align the same with top and bottom report (1/4"...

Hi, Frustration............. Can anybody tell me why sub listed below will not work - it jumps to next control regardless how many characters are keyed in LastName (won't even give Msgbox if < 10). Is there a better way to validate keyed Form data ? Thank you...jnh Private Sub...

Hi, When a Control encounters 'LostFocus' it triggers a macro event. The macro performs a small test and displays a Error message, if so needed. I want to go to next control if data is ok (which works) or I want to return to control where incorrect data was entered (LastName in example)...

Hi pbaldy; Thanks for the "Welcome" from the Northern part of NV. But I still confused: first part of field will always be one numeric followed by a comma followed by a name (first and last name not exceeding 30 characters). Trying to separate the numeric into a new field (A...) and put the...

Hi, Have a table column which has data like 1, First and Last name. Trying to split that data into 2 columns: Team_Num (which is the above 1) and Name (which is above First and Last name).Thanks for any help.jnh

Just starting with Access and will probably need a lot of help. Thanks