In Access 2007 how do I use VBA code in my print button to print to a “specific printer” for my report.
Answer Question | December 12, 2008 1:05 AM
Access 2007, Code, 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
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
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
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 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
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
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 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 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
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
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
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
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 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
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
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 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 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 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