Search results

Hi Gurus I use Scripting.FileSytemObject (FS) to check if a shared folder "Data" in a "MainPC" in a LAN Workgroup exist .. as in ... FS.FolderExists("\\MainPC\Data\") Is this a good way or is there another better way to do it.

i found the missing file, it was really file MISSING at a location i specified but human error of failing to put it there. pbaldy Esq, your comment out "On Error .." is great help, so easy but need my friend to prompt THANK YOU.

Thank you friends. I will go back to tinkering following all your advices.

Hi guys .. back after a long while to bug you I have a perfectly run .mdb file for years that do some housekeeping script from a module before it end up in a form. In this particular win10 tablet it flag error 53 ..file not found. I try to debug it but can't find the line causing it. Guy...

Folks I finally is seriously moving to SQL server .. need a helping hand I think of doing this with command as part of my codes in a FE. I thus start with mdb as template to import from, into a to be created database in SQL server What are the text commands that can achieve my goals.

I don't need to use migrate assistant for access, just use SSMS create the intended database name & then import tables from access mdb into it.

i downloaded the migration assistant for access but it is for Access 8.23. I only wish to use sql server 2008 however the downloaded assistant does not point to SqlServer 2008 R2. Friends i will like to try to work on 3 alternative 1 where can i get a download Migration Assistant that feed to...

@A.Blaster .. Container is what I want, where do I start to import to get there. I think I choose the wrong way to import that ends up me not seeing the Container. Your response DO help to clarify my question

Hi folks I use mdb as the backend. I will like to import this database to SQL server. If i just import using SQL import function I end up with all tables. I like to keep together in one database as in mdb .. how to get there

Thank you very much comrades .. lots to chew. Appreciate Peace2u

Hi friends I am a small guy stretching the dollar to help the small guys thus i still use msAccess 03 which is fast and simple, essentially i can do almost everything (low traffic) inspite of the caveat about vulnerabilty. Having said this I get to what i am thinking about to day. My approach...

Bro that is what I do if I use Item ID .. thanks for your time ... appreciate

Now I have a mental jam. Let's say I have the database with a string field holding all the barcodes. If I want to find If a particular code exist I presume I have to open an input form to hold the to be scanned string code. Once the code is in then I have to scan all existing record to see if...

Thank you friends for your input

Hi gurus When i scan a barcode in what form is the information being captured? How should the captured info be kept in a database.

Brother after looking at your codes my mistakes is in the line .. Application.CommandBars("1Views").Controls![1V-Sub].enabled = False because 1V-Sub is at next level. Thus i need to use your idea of 2 x CommandBarControl so i can set the lower level control by referring to the top level...

Good follow up, good job. I want to convert to mdb to check it out.

Thanks bro for trying. From what i know what you found is the same. Thus following also equivalent Application.CommandBars("1Views").Controls![1V-Sub].Visible = False I just found: only the top level control include "Menu Headings" will not give an error. If the control is below the top...

Hi guys Wow new image .. good show My issue today is i have an toolbar eg "1Views" with an sub menu eg "1V-Sub" which itself contain few controls "SeeIt1", "SeeIt2". My simple wish is to be able to toggle "1V-Sub".Visible between True/False when a certain state occur, thus stopping all its...

Gizmo I tried with acnormal in Open form then what you suggest outside the Open Event work If I use acPivotTable or set DefaultView to Pivot table, then same outcome .. blank