Formatting a subform for printing in access 2000
I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the [...]
Answer Question
| March 9, 2009 8:54 PM
Access 2000, Access Database, Access forms, Microsoft Access, Printing Subforms
I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the [...]
Answer Question
| March 9, 2009 8:54 PM
Access 2000, Access Database, Access forms, Microsoft Access, Printing Subforms
New Access user!
I am a new Access user with no training. What I know, I have figured out on my own. The issue I am having now is why does Access always save a copy whenever anyone exits the database? It will save a copy and number it every time. Most days there’s about 12 -15 copies. [...]
Answer Question
| March 4, 2009 2:04 PM
Access Database, Microsoft Access
I am a new Access user with no training. What I know, I have figured out on my own. The issue I am having now is why does Access always save a copy whenever anyone exits the database? It will save a copy and number it every time. Most days there’s about 12 -15 copies. [...]
Answer Question
| March 4, 2009 2:04 PM
Access Database, Microsoft Access
Access 2003 using IIf statement on a form
I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for ‘current grade’ and a field for ‘target grade’. I also have a field ‘progress’ in which I am using an ‘IIf statement’ to compare the two fields (to [...]
Answer Question
| March 5, 2009 9:32 PM
Access 2003, Access 2003 forms, Access forms, IIF function, Microsoft Access
I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for ‘current grade’ and a field for ‘target grade’. I also have a field ‘progress’ in which I am using an ‘IIf statement’ to compare the two fields (to [...]
Answer Question
| March 5, 2009 9:32 PM
Access 2003, Access 2003 forms, Access forms, IIF function, Microsoft Access
MS Access 2007 Author credit
I’m designing a database for my town office as part of my class project. I want to put my name on the project somewhere as author so I get some credit for my work. Where/how can I do this?
Answer Question
| March 3, 2009 8:12 PM
Access 2007, Access Database, Microsoft Access
I’m designing a database for my town office as part of my class project. I want to put my name on the project somewhere as author so I get some credit for my work. Where/how can I do this?
Answer Question
| March 3, 2009 8:12 PM
Access 2007, Access Database, Microsoft Access
access 03 sending emails
I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can’t get it to [...]
Answer Question
| March 2, 2009 4:31 PM
Access 2003, Access Database, Microsoft Access
I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can’t get it to [...]
Answer Question
| March 2, 2009 4:31 PM
Access 2003, Access Database, Microsoft Access
Viewing the guts of a Microsoft Access form, query and report, programmatically
I have over 1000 MDB’s which need to be checked to make sure they don’t reference any external sources. So, I’m searching for ‘A:’, ‘B:’… ‘Z:’, ‘’, etc. I need to search the guts of each form, query definitions, and reports to find any references to something external. The data is done. Is there any [...]
Answer Question
| February 27, 2009 10:05 PM
Microsoft Access, Microsoft Access forms, Microsoft Access queries
I have over 1000 MDB’s which need to be checked to make sure they don’t reference any external sources. So, I’m searching for ‘A:’, ‘B:’… ‘Z:’, ‘’, etc. I need to search the guts of each form, query definitions, and reports to find any references to something external. The data is done. Is there any [...]
Answer Question
| February 27, 2009 10:05 PM
Microsoft Access, Microsoft Access forms, Microsoft Access queries
Microsoft Access Drop Down List
Hi, I have combo boxes in Microsoft Access where if the user starts typing the drop down list expands. Now if they use the keyboard to select the item, Access moves to the next control and the list is brought back up, but if they use the mouse then the list stays down. I was [...]
Answer Question
| March 2, 2009 9:30 PM
ComboBox, Microsoft Access
Hi, I have combo boxes in Microsoft Access where if the user starts typing the drop down list expands. Now if they use the keyboard to select the item, Access moves to the next control and the list is brought back up, but if they use the mouse then the list stays down. I was [...]
Answer Question
| March 2, 2009 9:30 PM
ComboBox, Microsoft Access
Set Down Arrow Action In Microsoft Access
Hi, I was wondering if there was a way to set when the down arrow is pressed on a Continuous Form in access that it goes to the next record and not the next field. Any suggestions would be great. Thanks, Dustin
Answer Question
| February 11, 2011 7:26 PM
Access forms, Microsoft Access, Microsoft Access forms
Hi, I was wondering if there was a way to set when the down arrow is pressed on a Continuous Form in access that it goes to the next record and not the next field. Any suggestions would be great. Thanks, Dustin
Answer Question
| February 11, 2011 7:26 PM
Access forms, Microsoft Access, Microsoft Access forms
Word and Excel
In MS Access you can create a form so when its all filled out the data is automatically put into an Excel spreadsheet under the correct headlines. Is this possible to do this with a form made in word?
Answer Question
| February 28, 2009 3:43 PM
Microsoft Access, Microsoft Excel, Microsoft Word
In MS Access you can create a form so when its all filled out the data is automatically put into an Excel spreadsheet under the correct headlines. Is this possible to do this with a form made in word?
Answer Question
| February 28, 2009 3:43 PM
Microsoft Access, Microsoft Excel, Microsoft Word
Microsoft Access linking
Hi, I have a database in access which has a main table and a products table. They are linked by a customer I.D. field (Primary Key). I have 2 forms one is the customer form and one a products form there is a button to open the products form from the customer form. I would [...]
Answer Question
| February 26, 2009 10:40 PM
Database programming, Microsoft Access, Microsoft Access forms, Primary keys
Hi, I have a database in access which has a main table and a products table. They are linked by a customer I.D. field (Primary Key). I have 2 forms one is the customer form and one a products form there is a button to open the products form from the customer form. I would [...]
Answer Question
| February 26, 2009 10:40 PM
Database programming, Microsoft Access, Microsoft Access forms, Primary keys
Can I link items between Outlook, Word, Excel, and Access, through the Calender view?
Can links be set in Outlook Calender ’07 to docs in Word, Excel, Access? I want to be able to go to a set date and access from that view all items pertinent without having to go looking for each item separately. Is possible?
Answer Question
| February 25, 2009 5:33 PM
Microsoft Access, Microsoft Excel, Microsoft Word, Outlook 2007, Outlook calendar
Can links be set in Outlook Calender ’07 to docs in Word, Excel, Access? I want to be able to go to a set date and access from that view all items pertinent without having to go looking for each item separately. Is possible?
Answer Question
| February 25, 2009 5:33 PM
Microsoft Access, Microsoft Excel, Microsoft Word, Outlook 2007, Outlook calendar
How can I print all picture attachmens attached to a record on an access report
I have a number of records that each have multiple attachments (pictures)> I have created a report and only the 1st attachment of each record prints on the report. Is the a way to have all the attachments print on the report for each record?
Answer Question
| February 25, 2009 4:40 PM
Access Database Attachments, Access reports, Microsoft Access
I have a number of records that each have multiple attachments (pictures)> I have created a report and only the 1st attachment of each record prints on the report. Is the a way to have all the attachments print on the report for each record?
Answer Question
| February 25, 2009 4:40 PM
Access Database Attachments, Access reports, Microsoft Access
Microsoft Access AutoNumber
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to [...]
Answer Question
| February 25, 2009 12:01 PM
AutoNumber, Database programming, Microsoft Access, Microsoft Access auto increment, VBA
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to [...]
Answer Question
| February 25, 2009 12:01 PM
AutoNumber, Database programming, Microsoft Access, Microsoft Access auto increment, VBA
Adding Serial Number to an already existing access document
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh
Answer Question
| March 22, 2010 2:46 PM
Access 2003, Access Database, Microsoft Access
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh
Answer Question
| March 22, 2010 2:46 PM
Access 2003, Access Database, Microsoft Access
Resizing Microsoft Access 2003 properties form
I recently installed MS Access 2003 SP3 on a new machine under Windows XP SP3. I find that I cannot resize the properties window when doing form design. The problem also applies to popup forms that I create. If I take the .mdb file to another machine, it works just fien. I have tried uninstalling [...]
Answer Question
| February 23, 2009 7:32 AM
Access 2003, Access 2003 forms, Microsoft Access, Microsoft Access 2003, Microsoft Access 2003 forms, Windows XP
I recently installed MS Access 2003 SP3 on a new machine under Windows XP SP3. I find that I cannot resize the properties window when doing form design. The problem also applies to popup forms that I create. If I take the .mdb file to another machine, it works just fien. I have tried uninstalling [...]
Answer Question
| February 23, 2009 7:32 AM
Access 2003, Access 2003 forms, Microsoft Access, Microsoft Access 2003, Microsoft Access 2003 forms, Windows XP
How can I select unique records from Access based on two criteria
I need to do the following: SQL = "select amount, count(amount) from table1 group by amount having count(*) =1" This returns all unique records, but I need to add another criteria to that statement ie: I need to select all unique records only if a second value is met as well! This is what I [...]
Answer Question
| February 20, 2009 1:08 AM
Microsoft Access, SQL, SQL queries
I need to do the following: SQL = "select amount, count(amount) from table1 group by amount having count(*) =1" This returns all unique records, but I need to add another criteria to that statement ie: I need to select all unique records only if a second value is met as well! This is what I [...]
Answer Question
| February 20, 2009 1:08 AM
Microsoft Access, SQL, SQL queries
Sending more then 1 Access Report to Outlook
Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie
Answer Question
| February 20, 2009 1:00 PM
Access 2007, Access reports, Microsoft Access, Outlook
Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie
Answer Question
| February 20, 2009 1:00 PM
Access 2007, Access reports, Microsoft Access, Outlook
Combo search box – “Invalid Outside Proceedure”
..and before you ask, no I don’t use anything linked into Access 2007 to program my database. So, I’ve been creating a form coming from the same table with the same information to be used as a separate edit form. And now suddenly my “search box” gets this error in my normal form. HELP!
Answer Question
| February 17, 2009 4:05 PM
Access 2007, Access errors, combo box, Invalid Outside Procedure, Microsoft Access
..and before you ask, no I don’t use anything linked into Access 2007 to program my database. So, I’ve been creating a form coming from the same table with the same information to be used as a separate edit form. And now suddenly my “search box” gets this error in my normal form. HELP!
Answer Question
| February 17, 2009 4:05 PM
Access 2007, Access errors, combo box, Invalid Outside Procedure, Microsoft Access
Temporary recordset in MS Access VBA
Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don’t need [...]
Answer Question
| February 19, 2009 6:40 PM
Access 2003, ADO, DAO, Microsoft Access, MS Access 2003, MS Access VBA
Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don’t need [...]
Answer Question
| February 19, 2009 6:40 PM
Access 2003, ADO, DAO, Microsoft Access, MS Access 2003, MS Access VBA
Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?
hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver… i believe every thing should be fine. I have check the access permission for that user. that is not the [...]
Answer Question
| February 16, 2009 7:09 PM
Database connectivity, DSN connection, Microsoft Access, Microsoft Excel, SQL Server connectivity, SQL Server import/export
hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver… i believe every thing should be fine. I have check the access permission for that user. that is not the [...]
Answer Question
| February 16, 2009 7:09 PM
Database connectivity, DSN connection, Microsoft Access, Microsoft Excel, SQL Server connectivity, SQL Server import/export
