Search results

  1. G

    Will Joe Biden be the next president?

    Thr democrats are already destroying America, what do you think a radical black woman running mate abd shadow gov with Obama would do. By the way, there is no way they are going to let biden and trump debate, it would be horrible to watch!!
  2. G

    The Virus that came from China.

    Made By and Came from. Made By Creation was made by God, All things where created through Jesus Christ. Came from. We Came From rocks (LOL -adult fairy-tale) viruses are not where not created by man but manipulated Ok, The sarscov2 Came From originated from a Lab in China, by scientists...
  3. G

    White Lives Don't Matter - apparently

    Eternal Lives Matter! When I look at someone, I look upon the heart. I am a Christian American Indian and I have forgiven all of those who have done my relatives wrong in the past.
  4. G

    VBA SQL Statement using IF Then ElseIF Ignore Zeros Populate List Box on a Form

    😀! I changed some lines and it works! was getting an error but only because you are missing the line: ErrorHandler thank you!
  5. G

    VBA SQL Statement using IF Then ElseIF Ignore Zeros Populate List Box on a Form

    I dont understand how the debug works you have to go to the live form and go to the next record to make debug work in vba editor?
  6. G

    VBA SQL Statement using IF Then ElseIF Ignore Zeros Populate List Box on a Form

    NICE!!!!! I am going to paste this into visual basic editor and see if i can get it to work.
  7. G

    VBA SQL Statement using IF Then ElseIF Ignore Zeros Populate List Box on a Form

    Oh Sweet! thank you, I like your website. I have been there quite a few times but nothing like what I am requesting.. would it be something like this? How would this be written in VBA to work in Access using VBA to populate the List Box Me.listRECORDS when the form Loads? Dim mySQL As...
  8. G

    VBA SQL Statement using IF Then ElseIF Ignore Zeros Populate List Box on a Form

    Hello All! I am trying to write VBA for a form using a SQL statement and need help, lots of help! what I would like to do is match values on a form (1 text box and 2 combo boxes) with another table that match ID's I would like to then populate an unbound List Box on the form with these values...
  9. G

    DLoolup Show Results Values in Texbox on its own line multiple columns

    Got It To Work With Access 2010!!! Here is the modified Code Private Sub cboCategory_AfterUpdate() Dim dbs As DAO.Database, rst As DAO.Recordset, StrKeywords As String Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT colKeyword " _ & "FROM tblQldKeywords " _ & "WHERE...
  10. G

    DLoolup Show Results Values in Texbox on its own line multiple columns

    JHB YOU ROCK! I really appreciate it. you went out of your way to help Here is the solution Developers who want to use the Data Access Object (DAO) library instead of, or in addition to, the new Microsoft ActiveX Data Object (ADO) model, must manually set the reference in each new database...
  11. G

    DLoolup Show Results Values in Texbox on its own line multiple columns

    awesome JHB, Thank you for your time.. Trying it now, getting a compile error at
  12. G

    DLoolup Show Results Values in Texbox on its own line multiple columns

    Hello JHB, I apologize for not being more clear. I have a great deal of trouble putting all of this into the correct syntax. I am so excited! THIS is working but it only shows one result txtKeywords = DLookup("colKeyword", "tblKeywords", "colCategory = '" & Me.cboCategory & "'") I would...
  13. G

    DLoolup Show Results Values in Texbox on its own line multiple columns

    Access 2010 - Question Hello Group what i am trying to occomplish something i cannot find no matter how hard i search! maybe i am not wording it right. I would like to use DLookup to show results values from a table and display in a unbound textbox on a form. the results from each column in...
  14. G

    Remove Spaces Between Words And Add Hyphen Copy Other Field Access

    Hello All GOAL - I would like to have one text box where I enter a sentence txtKeywords: Access Is For Smart People Smarter Than I I would like to create a button when clicked moves txtKeywords into another textbox [txtKeywordscombined] field and removes the spaces between the...
  15. G

    How Do You Populate A Bound Textfield With Text From A Unbound Textfield?

    Hello, Yea 'doesn't work' didnt help me much either! I figured it out after 2 days,.. I fixed it than stared at the screen for a minute and uttered 'Seriously?' I had to go to FILE than enable content, it was a security setting protecting me against myself i guess... No warnings, No hints...
  16. G

    How Do You Populate A Bound Textfield With Text From A Unbound Textfield?

    Im sorry but that does not work either I am trying to populate a bound textbox on form with a unbound textbox that combines other unbound textboxes thank you
  17. G

    How Do You Populate A Bound Textfield With Text From A Unbound Textfield?

    Hello *.* Can someone please help, after hours and hours I am turning for help.. I have 4 fields that are unbound on a form. img1 img2 img3 img4 When these are entered they are all combined and autofill another unbound textbox = imagename SIMPLE? what i would like to do is from this...
  18. G

    box showing choices, select multiple choices for each record

    Thank you for your help. Thank you Adam! it is working now. the code in the red was just backup code as i was learning. thank you! you are awesome
  19. G

    box showing choices, select multiple choices for each record

    Thank you Adam, Yea, with subforms its tricky. I WILL Make sure to hang on to that one! I am now applying your listbox solution to other areas of my database and I am stuck again! Question: I figured out how to get more then just one column into listbox, then... How do I INSERT more then...
  20. G

    box showing choices, select multiple choices for each record

    Its Working ADAM! I got it working! One interesting thing.. every time i renamed machineID in .AddNew section !machineFK = Forms!frmMACHINE!MachineID it kept changing the small case m in machineID to large case M so i did some renaming. and then BAM! I learned a couple of valuable things...
Top Bottom