Search results

Enclosed is a screenshot showing the vba code, Table, & watch List with values... record count shows all 16 records but .MoveLast values are not the last values in table. Even with a explicit OrderBy DoCmd. please take a look at the attached jpg...any ideas to resolve? thanks

the TRUE is showing as a -1 not a 1. I understand why 1 would be TRUE. 1 is ON, 0 if OFF. But why is Access showing -1 for a TRUE if this is normal for Access then I will deal with it, but VBA shows a true condition as a positive number, not a negative

With a Table I want to do I lookup based on the value of another field, exactly like a Vlookup in Excel. I am trying the DLookup but dont know if this is what i need. Here is a visual (attachment) to help understand what i need. This is the DLookup() DLookUp([tblAnswers]![AnswerNumber]...

here is a screenshot. i created a calculated field which compares 2 column values. if its TRUE then the calculation returns -1 (which is odd) if FALSE it returns 0 is there a way to make True 1 and leave False as 0 . Or whats the reasoning..Thanks

"No open table = no (implied) recordset. No recordset = no cursor. No cursor = no .GoToRecord" makes complete sense. I am new to Access VBA so was experimenting and could not understand the logic and your line sums it up. And the 'red herring' was the 'Set rs =' (not on purpose) But assume i...

i can retrieve, add, edit data to a table when it is closed but i get an error, "The command or action 'GoToRecord' isnt available now." if i try to move to a record when the table is not physically opened. seems odd to me. If i open the table this sub works fine. any insight.. thanks. im...

i am using VBA and recordset method to fill a textbox in my form. it was 'bound' to a table which i removed and got a different message... "cant assign a value to this object" anyone share the rules for using VBA to change values of controls on a form. thanks

i have attached a pic. I created a Option Group (no wizard) and dragged 4 option buttons into the frame. If I select any of the 4, they ALL get selected... i want the standard behavior, only 1 option is selectable at a time, so i can use VBA to get the 1 selected (i have the code already)...

I have 2 different forms I am working on and they come from the same table. I was able to drag 1 field onto the form, the 2nd field gives me a message, the table "my table name" is already opened exclusively by another user, or it is already open through user interface and cannot be...

thanks for the feedback, you gave me some food for thought, at least i can start eliminating some options. thanks

Ranman: i was going to leave the Option Control with A, B, C, D and just place textbox over the control to show the various answers to choose from. the issue i am having is storing the answer selected into another table... Gizmo: thanks, the presentations seem thorough. i look into it in...

i am way late on this but i am stuck and this spoke to me... i removed the table Record Source in order to ue multiple tables (1 to fill the textboxes with data, the other to store a persons input) but once i add a 2nd table to the query and add a field, & save, when i return to the form it is...

I am trying to create an exam application. The questions, choices, correct answers, and explanation are in 1 table. I created a 2nd table to record the responses to each answer and deliver a score at the end of the exam. When i try to use Option Group the only option to store the result is in...

after extensive testing and searching, i came across those who had the same issues... the issue stems from importing from Excel... as per Microsoft, they scan the first 20 rows if a majority is short text they label "Short text" and import the first 255 char only. Though you can make the...

questions on what the proper procedure regarding adding "Source Control"... If i use the "build" dialogue and select the table, then the record source it returns "=[Question]" your saying this is incorrect? is there ever a time you would use the "build button" ? also... do I need to...

i did not format as general date, Access for some reason has the weidiest default options, even when you choose data type as Text... they are off and still maxs out at 255 char. my source is just a cell in a column of a table, no queries.. no combox box, just a textbox here is another...

thanks for the reply. Minty, your link refers to using a Memo Type to open the box up to > 255 Chars. I am using 2016 and the "Long Text" is now considered the memo type. i have made changes to both "Rich Text" on the table and on the TxtBox in the form. it still is cutting it off at 255...

i have a text box in a form that is connected to a table, the text box seems to cutoff the text once it reaches a certain length. In my table the text column is it formatted as "long text". I did a Len() and the max length is 277 characters. I have Grow = YES and Shrink YES I dont know...