Search results

Hi, I need an assistance here in MSAccess. I have a fields in a table with type as Memo that should hold more than 255 characters. I'm trying to update the fields for 1001 characters through VBA. What's happening: 1. The records is getting saved but only 255 characters are...

There would be hundreds of tables to import from excel to access. Hence, updating the first row with 1 is not feasible in all the tabs. Below code worked to import all the tabs, but I'm looking for a code which would let me set the "Default Value" as 1 at the same time. OR Please give me...

Hi, Don't know if I'm asking a simple question. I'm stuck on a step where I want to import an excel worksheet into the msaccess like we do normally. I do not have any data inside, it's just the header I will be importing. The data will be feeded by other forms based on some selections. My...

Please look into: http://www.access-programmers.co.uk/forums/showthread.php?p=1282863#post1282863

Please look at my issue... http://www.access-programmers.co.uk/forums/showthread.php?p=1281562#post1281562

Any luck folks?

Can we have the code without holidays table? I do not have one. In addition, can I have this one also solved pleaseeeeeeeeeeeeeeeee http://www.access-programmers.co.uk/forums/showthread.php?p=1281562#post1281562 :banghead:

Hi Mihali, The library is up-to-date when checked in msaccess application. He is able to launch the file in msaccess application versin. He's getting the error when tries to launch via RunTime access version. Other users are able to use the database. I tried asking others to shut the...

Hello Folks, The situation: I have designed an msaccess database for a particular team to feed their data. The team does not have msaccess rights, so routed them to install RunTime version msaccess which allows the user to use the database in a secured mode. All the team members are able to...

Michael, excellent job. It's working fine. Thank you

No, there's no holiday table required in the calculation. please help without considering Holidays. In XP, I had the below code working: Function GetNetWorkDays(startDate As Date, endDate As Date) As Integer Dim objFunction As MSOWCFLib.OCATP Set objFunction = New MSOWCFLib.OCATP...

There's no MISSING reference in the library. I unchecked & rechecked all the references. On XP, it's working. Issue is with Win 7. Old OS: Win XP New: Win 7 Old msaccess: 2003 New: 2010 Old office: 2003 New: 2010

Hello Folks, I'm using the below code in msaccess which used to work perfectly on the Win XP platform. I upgraded my OS to Win 7. It's now giving an error as "Runtime Error 429 - ActiveX Component Can't Create Object". I unchecked & rechecked all the library references. Function...

Hello, I'm using the same code in msaccess which used to work perfectly on the Win XP platform. I upgraded my OS to Win 7. It's now giving an error as "Runtime Error 429 - ActiveX Component Can't Create Object". I unchecked & rechecked all the library references. Old OS: Win XP New: Win 7...

Now, I have a table with Subdatasheet in it which can be seen with a click on + sign. I have a query as below: SELECT [SETUP - NameAll].* INTO [SETUP - Name] FROM [SETUP - NameAll]; where, SETUP - NameAll is my main table & SETUP - Name is the table which I want the records updated in. The...

Additional info... I believe the changes are needed in 20th line of the code. i.e. cd "program files\Microsoft Office xp\Office10" I tried editing this code with cd "program files\Microsoft Office\Office11" for access 2003 & it worked. But this practice is not a solution all the time on each...

Hello, I have a problem while opening an access database through a batch file. We work on a network and all of us having different version of ms access installed on the system. We have a batch file which allows us to open the database & work. The code in the batch file is as below: @echo off...

Hi jleach, even I had an issue. I have date in the format e.g "Jan-23-2012 03:45:59 PM" in the column. please suggest a syntax to fill in the Built option in design mode of the query. I want output as 01/23/2012 in one column & another column should have 03:45:59 as time given above...