Search results

Hi, Trying to SUM all records where first 3 characters of Company = DMV. Have tried all kinds of () but always get the Enter Parameter... prompt. What am I missing on query? DMV: Sum((IIf([left$(Company,3)]="DMV",[AMOUNT],Null))) Your help is greatly appreciated. A Healthy and Happy 2016...

Hi, Have a Make table query that needs to create (add) several new fields where each field must be numeric design. Have tried: Score1: Not Null - does not seem to work (results in a Binary field) Score1: 0 - which does give me the numeric field designation but every field in table contains a...

Hi, Have 2 tables: ...TableA: 1 indexed field "Name" and many data fields in ~ 1000 records ...TableB: 1 indexed field "Name" and 2 data fields (DataB1 and DataB2) in about ~ 50 records Tables currently have NO relationship set. Want to add TableB data fields to TableA if Name are...

Action: User keys data into a Form Control which triggers a VBA event procedure call. The VBA event uses value of user input to perform several calculations. Result of each calculation in then placed into proper control (me.NumA = result1 me.NumB = result2....) during the VBA call. Problem...

Have a table (several hundred entries) which must be updated weekly using VBA code. I know how to write the actual VBA code (for each record) but I do not know how/where/what is necessary to open the table, read each record seq and update based on VBA code (function call return value) and to...

Pretty new at this game and still have many ??? but for right now can anybody help me with: ...Have disabled a couple of fields in a form. Would like to change the Background color to something else instead of that 'Grey" given ...When Validating a field (via a sub routine) I would like to...

Hi, Have a table with 18 fields and based on content of a given field I might have to create a new output record. This means that it could be possible that the need for 18 new records for every input record may exist. All new records must go into the same new table. Any suggestions, 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, 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