Search results

  1. theDBguy

    Form design

    Can you post a screenshot?
  2. theDBguy

    Solution: Kind of 'UnCrosstab' code

    Hi. Pardon me for jumping in. I hope I am not out of line, but have you tried or consider using Excel's Power Query?
  3. theDBguy

    Emulating Split Form Example

    Oh boy! That's actually a very old topic with lots of discussions going back and forth on the subject of "bang vs dot. " If you do a search on those terms, you might find some of those old discussions.
  4. theDBguy

    Listbox help needed, please

    We all forget something or another sometimes. Good luck with your project.
  5. theDBguy

    Solved Concatenation producing weird result

    Hi. Congratulations! Would you mind sharing your solution in case others could also benefit from it? Thanks.
  6. theDBguy

    Advice on migrating Mysql/Access DB to Azure AD

    Hi. Welcome to AWF! Just FYI, this is somewhat of an old thread. How are you affiliated with "Ispirer?"
  7. theDBguy

    Print conditional formatting

    I could be wrong, but I think you can only export the data, not it's formatting. If you want to format the exported data, you will probably have to do it one row at a time.
  8. theDBguy

    Listbox help needed, please

    1. To bind the listbox to jobno, jobno has to be included in the record source of your form.
  9. theDBguy

    DLookup Issue

    Hi. Welcome to AWF!
  10. theDBguy

    Solved Loop through continuous form and assign value to textbox

    Hi. The short answer is to use a temp table instead.
  11. theDBguy

    Creating an Inventory System with Bills of Materials

    Hi. Welcome to AWF! Duplicate posts are highly discouraged to avoid any confusion during the discussion. Are you just new to Access but well versed with database development? Otherwise, you may have picked a tough a business process to model for your first database project. There may be...
  12. theDBguy

    New User, Long Time Reader

    Hi. Welcome to AWF!
  13. theDBguy

    What secret ways to generate an Error 70 permission problem?

    Hi. In my limited experience and knowledge of copying and deleting files using Access and FSO, I seem to run into Error 70 when the process steps over itself. I mean, disk access is the slowest computing process, so sometimes code process is too fast for it.
  14. theDBguy

    Solved Concatenation producing weird result

    Please see this article for future reference. http://www.theaccessweb.com/lookupfields.htm
  15. theDBguy

    Solved OpenArgs prompting "Enter Parameter Value"?

    Also, check your form properties, such as Order By and Filter.
  16. theDBguy

    Solved Text box from Combo box

    Excellent! Good luck with the rest of your project.
  17. theDBguy

    Solved Function returning String not working

    Hi. Glad to hear you got it sorted out. Good luck with your project.
  18. theDBguy

    Solved Text box from Combo box

    Yes, that helped a lot. See if this is what you meant.
  19. theDBguy

    Solved Function returning String not working

    Have you tried stepping through it? Try going to the Immediate Window and type this? What happens? ?SelectFromQryTransaction()
  20. theDBguy

    Solved Text box from Combo box

    Again, without being familiar with your database setup, that information doesn't really make sense to me. You said you want to see the "frequency" information. How can you get that data from that row source? Besides, you said you have 4 comboboxes, but you only gave us one row source. What if...
Top Bottom