Sedrick
Last Activity: Jan 14 '14, 07:09 PM
Joined: Aug 27 '11
Location:
-
Thanks! Will need to take a closer look. Funny, when I searched for this on the web it came up with nothing about Access 2007. Thanks again. -
Rich Text Formatting of Data by the User
In the past I have seen an Active-X addition that allows the user to do Rich Text formatting in MS Access Text or Memo Fields, similar to an MS Word Document with highlighting, bolding, underlining, etc. This was created by Mr. Laban I believe.
My question is two-fold.
1. Do the newer versions of MS Access allow the user to do rich text formatting of the data they enter in Text or Memo fields?
2. Has... -
Layered Sub-Report Headings for Every Page
I am pushing the limits in Access 2003 with 7 layers of subreports defined.
For each item of the report there can be a group of sub-items, each of these sub-items can have a group of sub-items, and so on down 7 layers.
I am attempting to create a report that shows each item with it's sub-items in a layered format. I have the item listed in the detail section with a sub-report pasted just below it. The sub-report contains... -
Sorry for the misunderstandin g. I was not running code and then changing things manually in the middle of the execution. I guess I did not make that clear enough.
I was executing what I had set up manually. Stopped the execution. Made a change to the query and re-executed. The recordset was released at the end of the module when the code closed it and set it to nothing.
I found another possible solution since my...Leave a comment:
-
Although I have not yet been able identify the cause of this I found a way to work around it.
I simply take out all the parameters from both the Query definition and the code that passes in the parameters. Run it to verify working. Then add back one parameter at a time to both the code and the query's underlying SQL.Last edited by NeoPa; Nov 2 '12, 01:49 AM. Reason: Edited to lose unnecessary comment about earlier post attempt.Leave a comment:
-
It is saved manually when I exit design mode.
I just tried something else. I deleted and created it programatically using the QueryDefs collection and the CreateQueryDef method. Still the same error.
...Code:Currentdb.Querydefs.Delete "qry_def_Log" CurrentDb.CreateQueryDef("qry_def_Log", _ "PARAMETERS lngTeamID Long, lngShiftID Long, strOther Text ( 255 ); SELECT DISTINCTROW Log.ID,Leave a comment:
-
Sorry for not being more clear on this.
The change I am making is manual, not programatic.
I am going into the query under the Access Queries menu and doing "Design" for the existing permanent query listed there.
I right click in the tables area at the top and choose "SQL". Then I go in and take out strOther as a parameter there and also remove it from the WHERE clause. So the code...Leave a comment:
-
Error While Creating a Recordset from a QueryDef with Parameters
I have successfully used this type of code to create permanent queries that are much faster to access from vba code. (It seems to be much faster than using normal DAO RecordSet code with queries or tables).
It also lets you use parameters.
I first define a query in the normal query design mode and save it. Then I add PARAMETERS to the top of the SQL.
I can then access it as a QueryDef object from the... -
How to Disallow Change of TimeStamp Field
I am putting a timestamp field in a table, using Now() for the default value.
I'm using Access 97
Seems like I figured this out once before, but does anyone know of a way on the table level (not in the form) to disallow a user changing the timestamp? Is there a way to use a validation rule or another method to stop changes from being made to a field?
I know I can handle this in a form using the table,... -
Looks like I've found the problem!
I was checking for just about all varTypes except for two - Nulls and empty strings.
The problem seemed to be occurring when it encountered null values to assign to the collection. I simply changed null values to "" and it took care of it!
Thanks for your interest.Leave a comment:
-
VBA Collections Getting Corrupted
Has anyone experienced this before? My code is set up and has been working fine, assigning strings, integers and longs, along with other sub-collections to a main Collection. The collection is defined globally and I use it to hold values the application references.
I'm getting the same errors on both Access 2003 and Access 97.
The problem seems to be coming when I assign a member to a collection. If I am in an open... -
Interesting. I wonder if MS Access works the same way.
Here is the section from that site that I was referring to:
In order to use collections to manage class objects, you must do the following:...- Create an instance of the class
- Set the properties and methods of the class
- Add the class to a public collection
- Unload the instance of the class
You might expect that unloading the instance of the class resultsLeave a comment:
-
Destroying A Collection Contained in Another Collection
This link mentions a concept that is new to me - Destroying objects by letting a collection hold the reference to it, destroying the original instance and then when done, removing that member of the collection to destroy the object
http://support.microsoft.com/kb/198465
I'm wondering if the same thing is true for collections of collections.
I created a public collection to hold values for forms to set... -
Thanks for looking.
I think I found the problem.
I had an error going on with some assignments to a Collection. For some reason it seemed to assign all the properties of a form to it instead of the string. When I cleared that up, the other problem with the public variables holding their values cleared up!
I also recalled that a Public variable will lose its value under some error conditions.
...Leave a comment:
-
Public Variables Persistence
Hi,
I created some Public variables using Access 97 to hold often used database options.
One example is a variable to test for debugging mode, so the code can make special considerations for printing debugging code, etc.
The variables are set in the top of a module, before any Procedures with this kind of syntax:
Code:Public bDBUGGING as Boolean
In Access 97 it works... -
Thanks Rabbit,
You know, I was just thinking of something. If a 2007 or 2010 database is encrypted and split then you have the following. An encrypted .accdb file and an encypted front-end (I see from the Microsoft site that both the front-end and the back-end databases should be encrypted) http://office.microsoft.com/en-us/ac...010096299.aspx
When you have...Leave a comment:
-
Access Security - Secure Logins
From what I have been reading, user level security is not available on Access 2007 and newer unless you have converted the database from an earlier version that does have it.
How good is the security if this step is taken (to convert from an older versoin)? In that case, would the username and password be automatically encrypted across the network if a 2007 or 2010 database was set up on a server with local user clients on individual... -
Access Security
I am interested in the best approach to securing both the login and the data of an Access database. I have a few different questions, but for this thread I'll begin with the question of data encryption.
I understand that starting with Access 2007 the data can be encrypted for a database. In setting up a server with a database of encrypted data and a front-end on the local user's machine how secure is it when going across the network?... -
SoundGuy,
Glad to hear ADezii's suggestion helped in your application!
Thanks NeoPa and ADezii for all the input to my questions. Sorry haven't gotten back to this sooner.
Was looking at the GetObject function but have not had time to test it out yet. Seems like it might read standard objects but not classes created with VBA. I'm thinking about trying it with the CurrentDb.Prope rties members to see...Leave a comment:
-
Sorry for the delay. Yes if you could break that into another thread, I'd be interested in discussing it. Thank you for pointing out the solution to the current problem - /cmd option from the command line. That should work perfect!
This other discussion on application automation seems quite valuable to me for future applications.
Thanks!Leave a comment:
No activity results to display
Leave a comment: