Thanks for the heads up.
I support an old accounting system.
This accounting system was originally written in MS Access 97
Then, later versions were released written in MS Access 2000, 2002, 2003
Each release had additional features and the purchaser was given the source code.
Many purchasers...
I was just asked by a client if MS Access 2003 and MS Access 2007 will run on a new Windows 8 PC
I do not have Windows 8 yet, so I was wondering if anyone had tried running the older versions of MS Office and MS Access on a Windows 8 operating system
1) Does it work?
2) If it works, are there...
I have a large MS Access XP Accounting program written in MS Access XP
The program has a menu system and about 75 smaller MS Access Mde files
The program was designed and intended to be run in a folder loacted in Program Files folder
When the sub folder is created in the Program Files folder...
I have a large MS Access XP Accounting program written in MS Access XP.
The program has a menu system and about 75 smaller MS Access Mde files
The program was designed and intended to be run in a folder located in Program Files folder.
To run this application in any other folder would require...
I would be happy to Post the code.
I am still working out the kinks.
In a nutshell, I am creating a Word file which is a contract.
The client wants the word contract to be produced from the information in the database
There can be minimal changes to the final document after it is created...
Thought I tried that, but in my frustration I must have missed the obvious
Thanks,
Hap...
Access Developer [pc] http://www.fcs-software.com/fcsaccessdev.html
Access based Accounting Solutions - with free source code
Access Consultants forum http://www.tek-tips.com/threadminder.cfm?pid=1121
Hi Strongm
That did the trick.
It seems that if it were an Excel Sheet, I could have created the Excel Sheet by setting the OLE.Class = "Excel.Sheet"
and then using this code:
With ctl
' Enable control.
.Enabled = True
' Set Locked property to False.
.Locked = False...
Thanks for your reply,
I also can not seem to find an example, but it must be possible.
Does Anyone else have any experience doing this?
Thanks,
Hap...
Access Developer [pc] http://www.fcs-software.com/fcsaccessdev.html
Access based Accounting Solutions - with free source code
Access...
Hi,
I am trying to automate a process in VBA where I create a Word Document and then store the Word Document into an OLEBoundItem control on an Open form, tied to a datafield in the recordset
I Can create the Word Doc with no problem, but so far, I can only get the word document into the OLE...
I am in the process of converting an MS Access project from Access 97 to a later version of MS Access
I know that MS Access 2000, 2002, 2003 all support the MDW security file.
My question, what was the last version of MS Access that supported the system.MDW file?
Seems MS Access 2007 does...
Hi,
I have a rather large MS Access application that is written in Access XP /2003 version
Access seems to install in the Program Files Folder
The original author whom wrote the Access application installed the Application in \Program Files\AppDirectory
Now, on a Windows 7 system
Everything...
Hi,
I have a rather large MS Access application that is written in Access XP /2003 version
Access seems to install in the Program Files Folder
The original author whom wrote the Access application installed the Application in \Program Files\AppDirectory
Now, on a Windows 7 system
Everything...
Hi,
Thanks for getting back
1) I believe it is group policy
2) XP
3) Yes, all users
If they leave the PC on overnight, they get the error when accessing the drive in the morning
If they log off and back on, then the drive is connected ok.
When I connect remotely, using LogMeIn, it is just...
I have a User who is getting an error message and I need some help
I know a little about system security and servers to be dangerous.
Windows 2008 server, users all connect up, no problems.
If they leave their workstations on over night, then when the users first access the network mapped...
Just in case, check the form sorting property and form special formating property, check your VBA code and check any sub forms if used by the copied form.
When you find the problem, write yourself a comment in the VBA code, where the problem was, so if you need to copy the form again, it will...
Thanks Phil.
I just could not seem to find that Archives page.
FYI, it is looking like there may not have been a 64 bit back then.
I downloaded a zip file that might have what I need, but most back then were 32
Thanks Again,
Hap...
Access Developer [pc]...
Hi,
I have a client who has been running Windows XP and using MySQL ODBC driver 3.51.27 (32 bit)
They want to go to Windows 7 so it appears that I now need the 64 bit version.
Here is the problem the currently available 64 bit version is version 3.51.29 and that driver appears different than...
FYI:
You may want to try this:
Resetting the Seed
You may be able to solve the problem with a compact/repair:
•In Access 2010: Compact and Repair Database on the Database Tools ribbon.
•In Access 2007: Office Button | Manage.
•In earlier versions: Tools | Database Utilities...
Couple of questions for you.
1) Did you upgrade the FrontEnd and BackEnd to Access 2010?
2) After the upgrade, did you refresh the table links?
3) Using the frontend, Can you just open one of the tables that is giving you trouble and try adding a record to the table. What exactly is the value...
Just a wild guess:
Try:
Function AutoFillNewRecord(F As Form) as Integer
or
Function FnAutoFillNewRecord(F As Form) as Integer
Might also try:
=AutoFillNewRecord(Forms.Customers)
Hap...
Access Developer [pc] http://www.fcs-software.com/fcsaccessdev.html
Access based Accounting...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.