Search results

  1. M

    Combine dynamic listbox column values

    You are welcome. Glad it helped.
  2. M

    Combine dynamic listbox column values

    The attached database file downloads for me. Not sure what the problem can be. Check you private messages.
  3. M

    Combine dynamic listbox column values

    Attached is a database that I put together that should do what you are wanting to do. You can check the VBA code behind the form and various controls that make this work. From what I could tell from your post, you wanted to create a string of the names selected from non-displayed columns in a...
  4. M

    Off site host server

    How much your host will do depends on the host. The host can setup and create the empty database. That host may or may not have the ability to help you with importing any existing table structure and/or data. This would depend on the host. When I first started trying to use an SQL Server...
  5. M

    Off site host server

    First, assuming you do not have and manage your own server, you will first need to contact a host. There are plenty of host available but you should check their pricing for hosting your database. If you have a third party already hosting a website for you it would make sense to check with that...
  6. M

    Declare variables of input box

    Actually all of the variables in the declaration statement are being defined as variant type variables not as string variables. Take a look here: https://msdn.microsoft.com/en-us/library/office/gg264241.aspx for a starting point to learn more about properly declaring variables.
  7. M

    Off site host server

    The process that is making the connection can be being called from an AutoExec macro or it can be in VBA code that is being executed from an event of some form that has been defined as the startup form. Hope this helps.
  8. M

    Cloud - Ms Access and SQL Server application

    AnthonyGerrard, you are quite Ok to PM me. I will be happy to provide any info I can. GBalcom, I initially created an ODBC connection to connect to my hosted SQL database. When making defining the ODBC connection it is best to use the latest version of the "SQL server Native Client". As...
  9. M

    Using VBA to link Unbound Object Frame to Workbook

    Well, thanks to both of you.
  10. M

    Using VBA to link Unbound Object Frame to Workbook

    Thanks for trying to help. I really do appreciate it. Byron
  11. M

    Using VBA to link Unbound Object Frame to Workbook

    If you recall, when using VBA code to open and manage Excel workbooks, if you do not reference every object by setting an object variable for each, (ie. App, Workbook, Worksheet, Range, etc) you can and will have one or more instances of Excel left open in the Task Manager when your code has...
  12. M

    Using VBA to link Unbound Object Frame to Workbook

    Yes, I am talking about an Excel process in the Task Manger.
  13. M

    Using VBA to link Unbound Object Frame to Workbook

    The only problem here is that I was not expecting that just creating a link to a chart in a workbook would cause an instance of Excel to be initiated and that instance would remain open until the link is broken or the Access form is closed. I really think that I am going to be able to work...
  14. M

    Using VBA to link Unbound Object Frame to Workbook

    Shortly after submitting this thread, I discovered that a instance of Excel is opened when the action to perform the link is taken. Then once the link to the unbound object is activated the instance of Excel remains open until the link is removed or the form is closed. If anyone has more info...
  15. M

    Throwing errors every other run...

    You definitely need to declare object variables for the various objects you are needing to refer to in Excel. You have declared an object variable for the Excel Application (appExcel). However, you are not declaring an object variable for the Workbook or the worksheet. Try using the method...
  16. M

    Displaying x combo boxes & positioning them

    One approach for accomplishing your goal would be to create a form with a record source of your table and then create a tab control that would have a tab for each possible chip configuration. One each tab you can create the size and requirements for the location of pins for each chip design...
  17. M

    How do you do "not in" in access sql?

    It it perfectly acceptable to use Not In("Value1", "Value2", Value3) in Access Sql. Date values must be formated: #1/1/2013#
  18. M

    I need a little help with some code

    Your welcome.
  19. M

    Windows XP and Access 2010 Runtime

    I have a new build Windows XP machine that I built to test the installation and deployment of an Access 2010 application that was created on another XP machine. This application uses an SQL database as its storage database. I have manually installed the MS Access 2010 runtime. I have also...
  20. M

    I need a little help with some code

    Try: If instr(1, me.step, ",") > 0 then Your code here end if
Top Bottom