SQL Group by Query with aggregate function as well as detail information
Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, … I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the corresponding [...]
Answer Question
| October 8, 2012 11:13 AM
Access, GROUP BY statement, MAX, Query
Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, … I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the corresponding [...]
Answer Question
| October 8, 2012 11:13 AM
Access, GROUP BY statement, MAX, Query
access query criteria using LIKE operator and msgbox if no results
I am using Access 2010. My query criteria looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & “*”……so the user clicks the button and a box pops up with the above question. If the user types in a letter and there are no subjects that start with that letter it just opens [...]
Answer Question
| September 5, 2012 4:10 PM
Access, like operator, query criteria
I am using Access 2010. My query criteria looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & “*”……so the user clicks the button and a box pops up with the above question. If the user types in a letter and there are no subjects that start with that letter it just opens [...]
Answer Question
| September 5, 2012 4:10 PM
Access, like operator, query criteria
Report design Access 2010 / 2007
I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. [...]
Answer Question
| August 3, 2012 3:46 PM
Access, Access 2007, Report format
I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. [...]
Answer Question
| August 3, 2012 3:46 PM
Access, Access 2007, Report format
Problems exporting Access table to XML file
I am having a problem with exporting a table from Access as an XML file. I export the table and the XML file has the following at the beginning of the XML file: [!--l version="1.0" encoding="UTF-8"--]- [dataroot xmlns:od=""urn:schemas-microsoft-com:officedata"" generated=""2012-05-17T08:57:06"">[/dataroot]
Answer Question
| May 17, 2012 2:50 PM
Access, XML
I am having a problem with exporting a table from Access as an XML file. I export the table and the XML file has the following at the beginning of the XML file: [!--l version="1.0" encoding="UTF-8"--]- [dataroot xmlns:od=""urn:schemas-microsoft-com:officedata"" generated=""2012-05-17T08:57:06"">[/dataroot]
Answer Question
| May 17, 2012 2:50 PM
Access, XML
Access and sql server wide tables
Does anyone know how to access sql server wide tables using Access
Answer Question
| May 5, 2012 7:01 PM
Access, SQL Server
Does anyone know how to access sql server wide tables using Access
Answer Question
| May 5, 2012 7:01 PM
Access, SQL Server
Access 2003 Chart creation, scatter plot
I am looking to create a scatter plot in Microsoft Access with independent x and y values. For example: x y 0.3035 0.3300 0.3023 0.3249 0.3032 0.3283 I can’t seem to find a good way to do this within Access… Any help is greatly appreciated.
Answer Question
| February 28, 2012 5:34 PM
Access, Access Chart, Microsoft Access, Microsoft Access Chart, Scatter Plot
I am looking to create a scatter plot in Microsoft Access with independent x and y values. For example: x y 0.3035 0.3300 0.3023 0.3249 0.3032 0.3283 I can’t seem to find a good way to do this within Access… Any help is greatly appreciated.
Answer Question
| February 28, 2012 5:34 PM
Access, Access Chart, Microsoft Access, Microsoft Access Chart, Scatter Plot
Missing Record
why would a record not appear in a report when it has the correct criteria
Answer Question
| February 28, 2012 4:16 PM
Access, Microsoft Access, Microsoft Access record, record
why would a record not appear in a report when it has the correct criteria
Answer Question
| February 28, 2012 4:16 PM
Access, Microsoft Access, Microsoft Access record, record
Download AS400 Physical File to Excel Using VBA
I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain information [...]
Answer Question
| March 17, 2012 9:55 AM
Access, AS/400, excel, VBA
I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain information [...]
Answer Question
| March 17, 2012 9:55 AM
Access, AS/400, excel, VBA
Access History question
Does Access have the ability to show who made changes to a databse via userID?
Answer Question
| March 6, 2012 2:42 PM
Access, Microsoft Access
Does Access have the ability to show who made changes to a databse via userID?
Answer Question
| March 6, 2012 2:42 PM
Access, Microsoft Access
Return nth record
I have a db where I can not change any data type (they are all text). I want to retrieve every 237th record.
Answer Question
| November 10, 2011 4:59 PM
Access, Access 2007, Database, Microsoft Access, Microsoft Access 2007
I have a db where I can not change any data type (they are all text). I want to retrieve every 237th record.
Answer Question
| November 10, 2011 4:59 PM
Access, Access 2007, Database, Microsoft Access, Microsoft Access 2007
What is the best why to get started in DBA
I have some experiance in SQL and Access and all the other MS software too. I deal alot with spreadsheets, and database in my job. I work alot with the AS400 and do alot of queries throught MS Access. What is the fasted and tghe most inexpensive way to get to the piont of being self [...]
Answer Question
| March 31, 2012 11:00 AM
Access, DBA training, iSeries database, SQL
I have some experiance in SQL and Access and all the other MS software too. I deal alot with spreadsheets, and database in my job. I work alot with the AS400 and do alot of queries throught MS Access. What is the fasted and tghe most inexpensive way to get to the piont of being self [...]
Answer Question
| March 31, 2012 11:00 AM
Access, DBA training, iSeries database, SQL
OLE field in UNION query
I need to join 2 tables, each with a field with an OLE object data type, in a UNION query in MS Access, but I get the message that an OLE field cannot be used in the Select clause of a union query. Does anyone know a work-around?
Answer Question
| March 31, 2012 7:59 PM
Access, Access query, OLE object data type, UNION query
I need to join 2 tables, each with a field with an OLE object data type, in a UNION query in MS Access, but I get the message that an OLE field cannot be used in the Select clause of a union query. Does anyone know a work-around?
Answer Question
| March 31, 2012 7:59 PM
Access, Access query, OLE object data type, UNION query
Open / Convert MS-Access x64 file into MS-Access x32
Hi, Is it possible to Open or Convert MS-Access x64 file into MS-Access x32? Thank Regard’s Owais
Answer Question
| March 31, 2012 10:37 AM
32- versus 64-bit Windows OSes, 64-bit (x64), Access, Database software
Hi, Is it possible to Open or Convert MS-Access x64 file into MS-Access x32? Thank Regard’s Owais
Answer Question
| March 31, 2012 10:37 AM
32- versus 64-bit Windows OSes, 64-bit (x64), Access, Database software
Access 2007 Query Help
I need some type of statement that will check my query results for a number in a field and then remove any instance of this item from my query. Example: I have multiple books in a table and I have an identifier field (1 = English, 2 = History, 3 = Science, etc…) where it [...]
Answer Question
| July 5, 2011 8:57 PM
Access, Access 2007, Access query, SQL Query
I need some type of statement that will check my query results for a number in a field and then remove any instance of this item from my query. Example: I have multiple books in a table and I have an identifier field (1 = English, 2 = History, 3 = Science, etc…) where it [...]
Answer Question
| July 5, 2011 8:57 PM
Access, Access 2007, Access query, SQL Query
Unexpected error number in Visual Basic 6 and CR8.5
Iam using VB6.0 with CR8.5 and backend as MS Acess. During setup creation it gives me an “unexpected error number 28 has occurred.Out of Stack space”. plz help me out with proper solution Thanx in Advance…
Answer Question
| June 23, 2011 1:03 PM
Access, Visual Basic, Visual Basic 6.0, Visual Basic Error Messages
Iam using VB6.0 with CR8.5 and backend as MS Acess. During setup creation it gives me an “unexpected error number 28 has occurred.Out of Stack space”. plz help me out with proper solution Thanx in Advance…
Answer Question
| June 23, 2011 1:03 PM
Access, Visual Basic, Visual Basic 6.0, Visual Basic Error Messages
FAQ Database
how do you build a FAQ database using Microsoft Access?
Answer Question
| June 29, 2011 2:14 PM
Access, Access Database, FAQ
how do you build a FAQ database using Microsoft Access?
Answer Question
| June 29, 2011 2:14 PM
Access, Access Database, FAQ
MS Access Automating switch from Edit mode to Navigation mode.
MS Access, I’m looking for a way through code, property or expression, to emulate F2 key. In other words, as you tab through fields in an Access form to have the cursor enter those fields in edit mode (insertion point at beginning of field) instead of navigation mode where the whole field is highlighted. Even [...]
Answer Question
| April 8, 2011 4:16 PM
Access, Access Controls, Access Navigation Pane, Automation
MS Access, I’m looking for a way through code, property or expression, to emulate F2 key. In other words, as you tab through fields in an Access form to have the cursor enter those fields in edit mode (insertion point at beginning of field) instead of navigation mode where the whole field is highlighted. Even [...]
Answer Question
| April 8, 2011 4:16 PM
Access, Access Controls, Access Navigation Pane, Automation
Access 2003 report printing
We’ve been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we’ve used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the [...]
Answer Question
| April 12, 2011 6:15 PM
Access, Access 2003, Access 2007, Access 2007 printing, Access Database
We’ve been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we’ve used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the [...]
Answer Question
| April 12, 2011 6:15 PM
Access, Access 2003, Access 2007, Access 2007 printing, Access Database
Search a specific file in Visual Basic 6
Hello, I am using a vb6.0 and ms access in database, in my search button, i want to display a record a record that very specific, will u plz help me this….
Answer Question
| February 15, 2011 2:08 PM
Access, VB6.0, Visual Basic, Visual Basic 6.0
Hello, I am using a vb6.0 and ms access in database, in my search button, i want to display a record a record that very specific, will u plz help me this….
Answer Question
| February 15, 2011 2:08 PM
Access, VB6.0, Visual Basic, Visual Basic 6.0
Pass data from Access subform to another form
In Access – How do I select or pass data from a subform to another form? I can pass the data back to the main form, but I want to pass to the subform data to another form
Answer Question
| February 10, 2011 4:11 PM
Access, Access form controls, Access forms, Access Forms Database, Microsoft Access subforms
In Access – How do I select or pass data from a subform to another form? I can pass the data back to the main form, but I want to pass to the subform data to another form
Answer Question
| February 10, 2011 4:11 PM
Access, Access form controls, Access forms, Access Forms Database, Microsoft Access subforms
