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
how i can select random values from a coloumn from a given table
Answer Question | November 25, 2008 5:12 AM
Database programming, tables
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
There is a requirement to have a subset of data available in DB2 tables in production to a test environment. There is no relationship defined in DB2 (so info available in catalog relationship tables). Now we need to find the relationship between the tables using some automation process. So we might not able to manually [...]
Answer Question | November 24, 2008 10:34 AM
DB2, DB2 Table Relationships, Mapping table relationships, Table Relationships
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
How can i connect DBF By VB.NET
Answer Question | November 21, 2008 5:02 AM
Database connectivity, dBASE, FoxPro, VB, VB.NET, Visual Basic, Visual Basic .NET
I’ve got a flat text file that I want to convert from AS400 IFS to a Database file. First I want to convert to a flat file just to prove I can. The File is being Sent via FTP from Unix to AS400/IFS. Files have been sent in both unix txt format and MDOS format. [...]
Answer Question | December 1, 2008 12:22 AM
AS/400 FTP, Copy From Import File, CPYFRMIMPF, Database conversion, Flat files, IFS, Integrated File System, Unix
How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed “sheet 1″ and second for the sheet tabbed “sheet 2″? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read [...]
Answer Question | February 9, 2010 5:36 PM
CSV, Delimited function, Microsoft Excel, SAS
We are a large non-profit organisation (20,000+) with many individuals producing minutes and summaries from internal and external meetings, parliamentary debates, conferences, etc. We are considering to implement a Knowledge Management system, which should allow local users to enter summaries directly in a database and thereby make the summaries available to all members of the [...]
Answer Question | November 21, 2008 12:56 PM
Database, Knowledge management, Knowledge management applications, Knowledge Management Software
I have one program that uses an SQL database and I want to install a different program that also uses an SQL database on the same machine. Will this cause a problem? Why or why not?
Answer Question | November 21, 2008 11:07 PM
Database, SQL, SQL Database
I need to set up admin access on a MS SQL server but limit the access to a particular db.
Answer Question | November 21, 2008 10:09 PM
SQL 2005 admin, SQL Security
Is it possible to test mirror database logic with a single machine?
Answer Question | November 26, 2008 1:37 PM
Database, Mirror, Server
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 am writing a sql to bring someone’s highest test score into a table. The sql is bringing in the highest test score possible, rather than the person’s test score. I assume MAX is making that happen. If I take MAX out, it returns the single row subquery returns more than one row error. What [...]
Answer Question | November 21, 2008 11:42 PM
Distinct Records, MAX, SQL, SQL Query, SQL tables
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
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
I have a Database for tracking conference attendance. Because of this I want to be able to both retrieve attendees and also adding new attendees. I have a form that allows me to retrieve attendees already input into a table via a combo box, but I can’t add new attendees via that same combo box. [...]
Answer Question | November 19, 2008 5:41 PM
Access 2003, Access Database, Database issues, Microsoft Access
i am doing mca. i am not having networking as subject . but i want to choose networking as career. what are the different ways to learn networking..
Answer Question | November 17, 2008 12:02 PM
IT careers, IT education, Masters in Computer Application, MCA, Networking careers
I’ve installed Appeon for Powerbuilder on win2000 server, and I’m trying to access it from linux with Ies4linux, but it doesn’t work, my page is blank ( I’ve install wine,cabextraxt & Ies4linux ), why it happen, have I lost my steps ?
Answer Question | November 17, 2008 7:33 AM
Appeon for PowerBuilder, CABextract, IEs4Linux, Linux, Linux interoperability, PowerBuilder, Sybase, Web enabling, Windows 2000 Server, Windows interoperability, Windows on Linux, Windows on Unix, Wine