| Thread | Last Post | Replies |
|
| Code to calculate a leap year | 30 Mar 2005 18:44 GMT | 4 |
Does anybody know of any code to calculate whether a certain year is a leap year, in Access VBA?
|
| Calling an MDE File using COBOL | 30 Mar 2005 17:54 GMT | 1 |
How do I call an Access MDE file using Cobol without getting a DOS window? Your attention concerning this matter is greatly appreciated. -Stefanie Mnayarji
|
| How can I know if a particular Access db is already open | 30 Mar 2005 17:09 GMT | 4 |
I have a frontend/backend system at a non-profit. Users entering intake interview info are not always computer savvy. I frequently find that they have opened the frontend more than once....even 4 times once. I'd like to be able to prevent this. I've found some logic that will ...
|
| Maximising Word Window from Access | 30 Mar 2005 17:01 GMT | 1 |
In Access 97 I want to open some Word documents at the same time without creating more than one instance of Word. The following code works but I have been unable to maximise the Word window (not the document window) using code in access. Any suggestions?
|
| Changing Shortcut Menu options | 30 Mar 2005 16:56 GMT | 3 |
Is it possible to change the Shortcut Menu options for a list box, depending on what is being displayed in the list box? e.g. Shortcut Menu looks a bit like this:
|
| Arrays ... multi | 30 Mar 2005 14:48 GMT | 3 |
I am a mid level access user and have been asked to provide reports for a database designed by someone else in my office.I am not a programmer but have a keen interest in access and use it regulary I am trying to create a report based on a query, showing respondents
|
| Stored Procedures | 30 Mar 2005 13:53 GMT | 1 |
I am running a stored procedure to update tables and return the record id of the record that was just entered. I am having issues on the Stored Procedure seems to work differently when I run it straight out and when I step thru the code.
|
| accessing a table's field when they are an unknown name | 30 Mar 2005 11:47 GMT | 2 |
I use different tables of data all the time with my project, and so I have to either change the field name or else change my code everytime. For example, one table might have a field called "Home Phone" and in the next table it might be called "Phone". Is there some code that ...
|
| Excel Charts in Access | 30 Mar 2005 10:06 GMT | 1 |
Is there a way to import excell charts so they work in Access. Excell has many more chart options than access and I need to use one of those charts where each bar has multiple parts that represent the parts as a percent of the whole. so for one company with 500 sales to 5 ...
|
| Displaying data versus actual data | 30 Mar 2005 09:58 GMT | 1 |
I am having some problems with appending from 1 table to another. My main problems are always with the date/time. Some of my problems are with the actual data in the field versus what is displayed. Here are a few examples: 1. Date: How do I just get the long date out of this? ...
|
| Code to use unknown fields in a table | 30 Mar 2005 09:25 GMT | 1 |
Hi, here is part of some code I have to access table fields. The trouble is, I am constantly using different table of data, each with their own field names. This is what my code currently does (one example): Checks the "Home Phone" field to see if there is anything data there, ...
|
| Conditional Open form on startup | 30 Mar 2005 07:56 GMT | 1 |
I have an Access database that is emptied and re-used for each new 'campaign' I have a main form that I go to at start-up but I want to start at a "set-up" form until the user is ready to start at the main form. Seems simple but I don't know how.
|
| Returning query result in code | 30 Mar 2005 07:07 GMT | 1 |
How do I return the query result in a function to a module code caller?
|
| why is my database so slow? | 30 Mar 2005 05:25 GMT | 1 |
I have a database with about 30,000 records in it. I have created forms to search for and display the results of the search. I have included an advanced search where you can select any field and search inside that form similar to filter by form. Some of my users dont have ...
|
| Late binding | 30 Mar 2005 01:31 GMT | 1 |
Access 97. I have created a database that creates 78 sub self contained databases that are sent to managers around the world. The problem is this I get an error on the following line of code in the new databases. Dim cbrCommandBar As CommandBar
|