| Thread | Last Post | Replies |
|
| Cancel as integer | 20 Feb 2007 06:27 GMT | 5 |
The system I am working on has loads of procedures triggered by a double-click. I have been asked to change it to a single click. Simple solution. I created the 'Event Procedure', and then used Call procedure_dblClick(cancel).
|
| access 2007 closes when I click the "office button" | 20 Feb 2007 05:32 GMT | 1 |
When I click the "office button" in the left upper corner of access 2007 it causes the program to immediately close. I did not think this is a "kill button". When I rollover that icon it says "click here to open, save and print and to see other things that you can do ...
|
| on load event | 20 Feb 2007 04:38 GMT | 1 |
Hello, I have the following code in the load event of a form named new player: Private Sub Form_Load() DoCmd.GoToRecord acForm, Me.Name, acNewRecord
|
| Combining Primary Keys | 20 Feb 2007 02:59 GMT | 1 |
I have to track product that comes in under one purchase order, has three seperate sizes, and can be processed on either 1st Shift or 2nd Shift on any day during the week. I would like to be able to sort and analyze my data based on purchase order,
|
| Changing Data Type when importing Excel spreadsheet | 20 Feb 2007 02:30 GMT | 2 |
When I import a file using the Import Spreadsheet Wizard and I get to the Field Options screen where it allows me to choose the fields and the Indexed option, my Data Type option is grayed out. Shouldn't I be able to change data types at that stage for each field as opposed to ...
|
| Button last called | 20 Feb 2007 02:15 GMT | 3 |
Have a form I would like to add a last talked to button, this button would be used to show the operator the last time (time not date)they called a technician. The information doesn’t need to be saved, if that helps.
|
| Importing Excel Spreadsheet into Access 2000 | 20 Feb 2007 01:52 GMT | 4 |
I have created a macro to import data from an Excel spreadsheet to an Access table. All of the column headings and data types match i.e. text =text, etc. One of the columns, Operator ID, in the Excel spreadsheet has both numbers and alpha, or alpha-numeric characters. Example:
|
| Date between two Dates | 20 Feb 2007 00:58 GMT | 2 |
I have a table with StartDate, EndDate and Rate and there is a record for every year. For example, the most current or last record is StartDate 7/1/06 and EndDate 6/30/07 and Rate .063. The previous record is StartDate 7/1/05 and EndDate 6/30/06 and Rate .060. I have another ...
|
| Ongoing Performance Issue | 20 Feb 2007 00:57 GMT | 8 |
I have a number of reports that use a crosstab query for the record source. I modify the reports each week to include the new data. Whenever I open one of these reports, whose record source is a crosstab, in design mode and attempt to add and move fields everything everything ...
|
| Frustrated by access and outlook calendar | 20 Feb 2007 00:42 GMT | 6 |
I am a very frustrated user after searching all day for a solution to my problem. I currently have a form in my db that creates an apointment, saves it to outlook and saves it in a table in my db. This works excellently.
|
| Database Security | 20 Feb 2007 00:39 GMT | 11 |
I have sent up security on my database, however, others can get into the database under their own workgroup file. What am I doing wrong in protecting my database? I have read articles and tips, however, they are vague and I cannot figure out how to keep others out unless they ...
|
| Timestamp wth MY sql | 20 Feb 2007 00:39 GMT | 2 |
I have my database on a Mysql server The timestamp field does not work when data from my website is writen to the database I have a form on my website that lets people fill out brochure request
|
| Rounding | 19 Feb 2007 23:52 GMT | 1 |
I'm trying to round a Rate to 2 decimals with the round up as Excel but it doesn't working in the Biuld up. How can i fixed the problem?
|
| subqueries | 19 Feb 2007 23:28 GMT | 2 |
Does Access allow subqueries? Anyway I have a simple problem. I have a bills table and a supplier table and I only want the info to show up in column of the query if the supplier has certain criteria. For the rest of the
|
| Access 2007 & SharePoint | 19 Feb 2007 22:54 GMT | 12 |
Can someone who knows about the SharePoint/Access 2007 integration answer a question? I'm wondering what happens when an Access 2007 user connected to a SharePoint server loses the network connection. We have a control room that has been using an actions log that is
|