Microsoft Access 2007: Using an IF statement
I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do that? Something like if [...]
Answer Question
| December 11, 2008 1:00 AM
Access 2007, Database programming, IF statement, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do that? Something like if [...]
Answer Question
| December 11, 2008 1:00 AM
Access 2007, Database programming, IF statement, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
Migrating data from Microsoft Access to SQL Server 2000
I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.
Answer Question
| December 9, 2008 8:00 AM
Database migration, Microsoft Access, Microsoft Access import/export, SQL Server 2000, SQL Server 2000 import/export, SQL Server import/export, Windows Services
I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.
Answer Question
| December 9, 2008 8:00 AM
Database migration, Microsoft Access, Microsoft Access import/export, SQL Server 2000, SQL Server 2000 import/export, SQL Server import/export, Windows Services
Excel to Access conversion
When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?
Answer Question
| December 10, 2008 4:11 PM
Access 97, Excel 2003, Excel to Access Conversion, Microsoft Access, Microsoft Excel
When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?
Answer Question
| December 10, 2008 4:11 PM
Access 97, Excel 2003, Excel to Access Conversion, Microsoft Access, Microsoft Excel
Combo box question when developing a SQL database in Visual Basic 6
I am developing a SQL database using Visual Basic 6 with ADO and Microsoft Access, but in it, I have a combo box with two options – yes and no. I want the combo box, after yes or no is selected, to open another form where a user can enter other details. How would I [...]
Answer Question
| December 5, 2008 6:20 PM
ADO, Microsoft Access, SQL Server database, Visual Basic, Visual Basic 6
I am developing a SQL database using Visual Basic 6 with ADO and Microsoft Access, but in it, I have a combo box with two options – yes and no. I want the combo box, after yes or no is selected, to open another form where a user can enter other details. How would I [...]
Answer Question
| December 5, 2008 6:20 PM
ADO, Microsoft Access, SQL Server database, Visual Basic, Visual Basic 6
Access/Word Mail Merge Currency lost digits
I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 …Even worse $700.60 appears as 700.6 How do I get the decimals to show?
Answer Question
| January 27, 2009 8:42 PM
Access 2007, Database issues, Mail merge, Microsoft Access, Microsoft Word
I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 …Even worse $700.60 appears as 700.6 How do I get the decimals to show?
Answer Question
| January 27, 2009 8:42 PM
Access 2007, Database issues, Mail merge, Microsoft Access, Microsoft Word
Navigation Pane
In Access 2003, my database window showed me all my database objects. Now I have a navigation pane that I have to scroll through to locate things. Is there any way to display all the objects in my database at once?
Answer Question
| December 5, 2008 8:02 PM
Access 2003, Access 2003 Navigation Pane, Access Database, Access Navigation Pane, Microsoft Access
In Access 2003, my database window showed me all my database objects. Now I have a navigation pane that I have to scroll through to locate things. Is there any way to display all the objects in my database at once?
Answer Question
| December 5, 2008 8:02 PM
Access 2003, Access 2003 Navigation Pane, Access Database, Access Navigation Pane, Microsoft Access
Complex Database Issue
I’ll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is “roughly” the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table [...]
Answer Question
| December 4, 2008 8:37 PM
Access 2003, Access Database, Database, FTP, Microsoft Access, Microsoft Excel, Sorting
I’ll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is “roughly” the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table [...]
Answer Question
| December 4, 2008 8:37 PM
Access 2003, Access Database, Database, FTP, Microsoft Access, Microsoft Excel, Sorting
SQL Server 2005 or 2008?
I am a database user going back many years and have used several different platforms from the high-end (NCR’s Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical modelling and analysis. We also [...]
Answer Question
| December 8, 2008 6:05 PM
Microsoft Access, SAS, SQL, SQL Server 2005, SQL Server 2005 vs SQL Server 2008, SQL Server 2008, SQL Server Version Comparison
I am a database user going back many years and have used several different platforms from the high-end (NCR’s Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical modelling and analysis. We also [...]
Answer Question
| December 8, 2008 6:05 PM
Microsoft Access, SAS, SQL, SQL Server 2005, SQL Server 2005 vs SQL Server 2008, SQL Server 2008, SQL Server Version Comparison
User security based on table in database
I am using Access 2003. I have a small (2 table) database. One table contains unit rework information. The second table contains User information(ID, FirstName, LastName, Security level). I built a form with a place for 3 users to ‘sign off’ – one for operators, one for supervisors & one for QA. Each of these [...]
Answer Question
| December 4, 2008 4:14 PM
Access 2003, Access 2003 forms, Access forms, Microsoft Access
I am using Access 2003. I have a small (2 table) database. One table contains unit rework information. The second table contains User information(ID, FirstName, LastName, Security level). I built a form with a place for 3 users to ‘sign off’ – one for operators, one for supervisors & one for QA. Each of these [...]
Answer Question
| December 4, 2008 4:14 PM
Access 2003, Access 2003 forms, Access forms, Microsoft Access
How to import Microsoft Access to SQL Server 2005
hi, while i am importing database MS-Access to sql server 2005 its could not importing its Showing like this: The operation could not be completed. Additional information: -> Not a valid password.(Microsoft JET Database Engine) What to do? can you give the solution. Thanks, Deepa
Answer Question
| December 2, 2008 4:41 PM
ASP.NET, C#, Microsoft Access, Microsoft Access import/export, SQL Server 2005, SQL Server 2005 import/export, SQL Server 2005 migration, SQL Server migration, Web development
hi, while i am importing database MS-Access to sql server 2005 its could not importing its Showing like this: The operation could not be completed. Additional information: -> Not a valid password.(Microsoft JET Database Engine) What to do? can you give the solution. Thanks, Deepa
Answer Question
| December 2, 2008 4:41 PM
ASP.NET, C#, Microsoft Access, Microsoft Access import/export, SQL Server 2005, SQL Server 2005 import/export, SQL Server 2005 migration, SQL Server migration, Web development
Microsoft Access menus
How do you setup menus using MS Access?
Answer Question
| December 4, 2008 7:29 PM
Interface design, Microsoft Access, Microsoft Access menus, VBA, Visual Basic for Applications
How do you setup menus using MS Access?
Answer Question
| December 4, 2008 7:29 PM
Interface design, Microsoft Access, Microsoft Access menus, VBA, Visual Basic for Applications
Amending a Product Price without altering existing orders in Microsoft Access
Platform; Windows XP Microsoft Office – Access 2000 Adapting the example database that was supplied with Access – Northwind Sample Database. I adapted the above sample database back in 2003 to my own database but have now hit a snag and i am unable to rememberor or find the solution. Currently, If a product price [...]
Answer Question
| December 1, 2008 6:27 PM
Access 2000, Database programming, Microsoft Access, Microsoft Access 2000, Northwind sample database, VAT, Windows XP
Platform; Windows XP Microsoft Office – Access 2000 Adapting the example database that was supplied with Access – Northwind Sample Database. I adapted the above sample database back in 2003 to my own database but have now hit a snag and i am unable to rememberor or find the solution. Currently, If a product price [...]
Answer Question
| December 1, 2008 6:27 PM
Access 2000, Database programming, Microsoft Access, Microsoft Access 2000, Northwind sample database, VAT, Windows XP
Export report into seperate Word docs
Hi, I have created a Crystal report that runs from an Access Database. The report shows details of different projects. There are around 300 projects in total, and when I am exporting these at the moment, all the details are being produced in one report. However, I want to be able to export the projects [...]
Answer Question
| November 25, 2008 3:00 PM
Access Database, Crystal Reports, Crystal Reports 10, Microsoft Access, Microsoft Word
Hi, I have created a Crystal report that runs from an Access Database. The report shows details of different projects. There are around 300 projects in total, and when I am exporting these at the moment, all the details are being produced in one report. However, I want to be able to export the projects [...]
Answer Question
| November 25, 2008 3:00 PM
Access Database, Crystal Reports, Crystal Reports 10, Microsoft Access, Microsoft Word
Hotel database (Rooms availability) using Access 2007
Hi there… I’m working on hotel database (Access 2007) I have a table named Rooms There are 3 fields in it Room ID, Room type, availavility how can I make Access shows the vacant rooms which are not related to any guest?
Answer Question
| November 24, 2008 1:55 PM
Access 2007, Database programming, Microsoft Access, Microsoft Access 2007
Hi there… I’m working on hotel database (Access 2007) I have a table named Rooms There are 3 fields in it Room ID, Room type, availavility how can I make Access shows the vacant rooms which are not related to any guest?
Answer Question
| November 24, 2008 1:55 PM
Access 2007, Database programming, Microsoft Access, Microsoft Access 2007
E-mail Notification
Can Access 2007 notifiy me by e-mail when someone has added or made a change to my data file?
Answer Question
| November 26, 2008 5:02 AM
Access 2007, Access 2007 alerts, Database alerts, Email alerts, Microsoft Access, Microsoft Access 2007
Can Access 2007 notifiy me by e-mail when someone has added or made a change to my data file?
Answer Question
| November 26, 2008 5:02 AM
Access 2007, Access 2007 alerts, Database alerts, Email alerts, Microsoft Access, Microsoft Access 2007
Beginner – How to move a table
I have one database, called Mask List. It contains two lists, Mask List and VIP Visits, which are unrelated and unlinked. I’d like to move VIP Visits out as a separate table I can call up and use without having to go into the Mask List database. I have created a link directly to VIP [...]
Answer Question
| November 25, 2008 7:32 AM
Microsoft Access, Microsoft Access tables
I have one database, called Mask List. It contains two lists, Mask List and VIP Visits, which are unrelated and unlinked. I’d like to move VIP Visits out as a separate table I can call up and use without having to go into the Mask List database. I have created a link directly to VIP [...]
Answer Question
| November 25, 2008 7:32 AM
Microsoft Access, Microsoft Access tables
Converting SQL data to Microsoft Access through coding in VB.NET
I have tables in SQL and i want to port them to MS access through coding in VB.NET
Answer Question
| November 26, 2008 7:01 AM
Data migration, Database, Microsoft Access, SQL, Visual Basic .NET
I have tables in SQL and i want to port them to MS access through coding in VB.NET
Answer Question
| November 26, 2008 7:01 AM
Data migration, Database, Microsoft Access, SQL, Visual Basic .NET
Microsoft Access QueryDef problem with numeric column anme
I have a form that creates a query on the fly. It works great, but has a problem with columns that have numeric names. The table is not mine so I can not change the columns. When I run the query the column name appears in the column. I tried to find anything wrong in [...]
Answer Question
| November 20, 2008 12:15 PM
Database programming, Microsoft Access, Microsoft Access forms, Microsoft Access queries, Microsoft Access QueryDef, Query Definition, QueryDef
I have a form that creates a query on the fly. It works great, but has a problem with columns that have numeric names. The table is not mine so I can not change the columns. When I run the query the column name appears in the column. I tried to find anything wrong in [...]
Answer Question
| November 20, 2008 12:15 PM
Database programming, Microsoft Access, Microsoft Access forms, Microsoft Access queries, Microsoft Access QueryDef, Query Definition, QueryDef
Sort Access Query From Variable
I wanted to see if there was a way to sort an Access query based off a variable. I have a textbox on a form and I want to be able to type in a field name and then open one query and it’s sorted by the field name I type in the text box. [...]
Answer Question
| November 19, 2008 9:12 PM
Access query, Microsoft Access
I wanted to see if there was a way to sort an Access query based off a variable. I have a textbox on a form and I want to be able to type in a field name and then open one query and it’s sorted by the field name I type in the text box. [...]
Answer Question
| November 19, 2008 9:12 PM
Access query, Microsoft Access
Export Attachmets
How do you export all attachments for all records from Access 2007 database?
Answer Question
| November 19, 2008 6:44 PM
Access 2007, Access Database, Access Database Attachments, Export, Microsoft Access
How do you export all attachments for all records from Access 2007 database?
Answer Question
| November 19, 2008 6:44 PM
Access 2007, Access Database, Access Database Attachments, Export, Microsoft Access
