Limit number of rows in a table
Dear all, I’d just like to ask if anyone can help me find a solution to the following problem: I want to limit the number of records in a table. So when all the available rows are used, the customer can purchase additional ones. Say for example that the customer is allowed to enter 100 [...]
Answer Question
| February 6, 2009 7:26 AM
Auto increment, Database programming, SQL
Dear all, I’d just like to ask if anyone can help me find a solution to the following problem: I want to limit the number of records in a table. So when all the available rows are used, the customer can purchase additional ones. Say for example that the customer is allowed to enter 100 [...]
Answer Question
| February 6, 2009 7:26 AM
Auto increment, Database programming, SQL
How do you convert Executive Asst.1 to EXECUTIVE ASST.1
how do you convert Executive Asst.1 to EXECUTIVE ASST.1
Answer Question
| February 2, 2009 3:38 AM
Case convert, Database programming, Lowercase, Uppercase
how do you convert Executive Asst.1 to EXECUTIVE ASST.1
Answer Question
| February 2, 2009 3:38 AM
Case convert, Database programming, Lowercase, Uppercase
Notes rich text field to BLOB/Memo field in SQL Server using ADOdb
I have an agent that uses ADODB to connect and insert a row into a SQL Server database. I want to store the contents of the Body field in the memo (rich text) into a Memo field in the SQL Server database (or Blob field). I’m finding examples of reading this kind of data back [...]
Answer Question
| February 2, 2009 7:40 PM
ADO, ADOdb, Binary Large Object, BLOB, Database programming, Memo fields, MySQL, SQL Server development
I have an agent that uses ADODB to connect and insert a row into a SQL Server database. I want to store the contents of the Body field in the memo (rich text) into a Memo field in the SQL Server database (or Blob field). I’m finding examples of reading this kind of data back [...]
Answer Question
| February 2, 2009 7:40 PM
ADO, ADOdb, Binary Large Object, BLOB, Database programming, Memo fields, MySQL, SQL Server development
Access 2007 – How to include option group on report
Hello, I’m new to Access so please consider this when forming your response. This has been driving me crazy and I’ve looked high and low on the ‘net for a solution. I look forward to your response. I have a form with an option group. I’ve wish to have this display on my report. Take [...]
Answer Question
| February 2, 2009 5:55 PM
Access 2007, Database programming, Microsoft Access 2007, Microsoft Access 2007 Reports
Hello, I’m new to Access so please consider this when forming your response. This has been driving me crazy and I’ve looked high and low on the ‘net for a solution. I look forward to your response. I have a form with an option group. I’ve wish to have this display on my report. Take [...]
Answer Question
| February 2, 2009 5:55 PM
Access 2007, Database programming, Microsoft Access 2007, Microsoft Access 2007 Reports
Problems saving data in tables in Visual Basic 2008
I cant Save any data in tables when i pressed the save button icon in vb 2008
Answer Question
| January 30, 2009 9:12 AM
Database programming, Visual Basic, Visual Basic 2008
I cant Save any data in tables when i pressed the save button icon in vb 2008
Answer Question
| January 30, 2009 9:12 AM
Database programming, Visual Basic, Visual Basic 2008
Monthly Average in Access 2007
Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible – my VB sucks Thanks Riaan
Answer Question
| January 30, 2009 11:53 AM
Access 2007, Access 2007 functions, Database programming, Microsoft Access, Microsoft Access 2007, Monthly Average
Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible – my VB sucks Thanks Riaan
Answer Question
| January 30, 2009 11:53 AM
Access 2007, Access 2007 functions, Database programming, Microsoft Access, Microsoft Access 2007, Monthly Average
How to replace a record in Microsoft Access 97 with VB 6.0
I create a program with vb 6.0 and i connected with ms access 97. Now i don’t know how to replace an existing record. For example i have the field “A” and the record is “20″ now i want to replace “20″ with “15″
Answer Question
| January 19, 2009 3:40 AM
Access 97, Database programming, Microsoft Access 97, VB 6, Visual Basic 6
I create a program with vb 6.0 and i connected with ms access 97. Now i don’t know how to replace an existing record. For example i have the field “A” and the record is “20″ now i want to replace “20″ with “15″
Answer Question
| January 19, 2009 3:40 AM
Access 97, Database programming, Microsoft Access 97, VB 6, Visual Basic 6
Sum of Donations for current year
I have a query that sums donations and groups them by year. When I print receipts, it gives me two receipts — one for year-to-date donations for 2009, and another that includes 2008 and 2009 donations. How do I get just the one receipt to print?
Answer Question
| January 21, 2009 5:42 PM
Access 2007, access 2007 preview and printing, Database programming, Microsoft Access 2007
I have a query that sums donations and groups them by year. When I print receipts, it gives me two receipts — one for year-to-date donations for 2009, and another that includes 2008 and 2009 donations. How do I get just the one receipt to print?
Answer Question
| January 21, 2009 5:42 PM
Access 2007, access 2007 preview and printing, Database programming, Microsoft Access 2007
Query won’t access open form field for parameter
I want to open a group of receipt forms using the “client ID” from the open form “Client” as the parameter. I created a button which runs the “openform” action macro using “[Client ID]=[Forms]![Client]![ID]” as the Where Condition. This was working until I closed the access program and reopened the next morning. When the macro [...]
Answer Question
| January 16, 2009 9:13 PM
Database programming, WHERE statement
I want to open a group of receipt forms using the “client ID” from the open form “Client” as the parameter. I created a button which runs the “openform” action macro using “[Client ID]=[Forms]![Client]![ID]” as the Where Condition. This was working until I closed the access program and reopened the next morning. When the macro [...]
Answer Question
| January 16, 2009 9:13 PM
Database programming, WHERE statement
How to convert DBGrid database information to text files with VB 6
how to convert dbgrid database information in to text files (vb 6.0)
Answer Question
| January 7, 2009 3:12 PM
Data conversion, Database programming, DBGrid, VB 6, Visual Basic, Visual Basic 6
how to convert dbgrid database information in to text files (vb 6.0)
Answer Question
| January 7, 2009 3:12 PM
Data conversion, Database programming, DBGrid, VB 6, Visual Basic, Visual Basic 6
Microsoft Access database too large – Can I divide my Access file?
Im new to access and have been given a task to compile a data base, which i have very nearly completed, Im in the military and using a PC networked into a military system. However i found out whilst compiling the Database the system has many limitations, the Document has got to 1.99 GB now [...]
Answer Question
| December 17, 2008 7:39 PM
Database programming, Microsoft Access
Im new to access and have been given a task to compile a data base, which i have very nearly completed, Im in the military and using a PC networked into a military system. However i found out whilst compiling the Database the system has many limitations, the Document has got to 1.99 GB now [...]
Answer Question
| December 17, 2008 7:39 PM
Database programming, Microsoft Access
PL/SQL: How to use EXCEPTION statement before INSERT?
Hi Experts how to use EXCEPTION statement before INSERT stm in PL/SQL Block Please help me with syntax or format is this option possilbe as well?
Answer Question
| January 5, 2012 4:20 AM
Database programming, EXCEPTION statement, INSERT statement, PL/SQL, PL/SQL block
Hi Experts how to use EXCEPTION statement before INSERT stm in PL/SQL Block Please help me with syntax or format is this option possilbe as well?
Answer Question
| January 5, 2012 4:20 AM
Database programming, EXCEPTION statement, INSERT statement, PL/SQL, PL/SQL block
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
How to fill Combo Box at runtime in VB 6.0 …I’ve used RecordSet object but rec.count of rs obj returns (-1).I hv enough data in the DB
[Private Sub Form_Load() FillCombo End Sub Sub FillCombo() Dim rs As New ADODB.Recordset, SQL As String SQL = "Select Spare_Name from Spare" rs.Open SQL, Conn, adOpenDynamic, adLockOptimistic Dim i As Integer For i = 1 To rs.RecordCount cboSpare.AddItem rs("Spare_Name") rs.MoveNext Next MsgBox "Successss", vbOKOnly End Sub]
Answer Question
| December 8, 2008 7:49 PM
ActiveX Data Objects, ADO, ADO Recordset Object, ComboBox, Database connectivity, Database programming, Recordset Object, RunTime, VB 6, Visual Basic, Visual Basic 6
[Private Sub Form_Load() FillCombo End Sub Sub FillCombo() Dim rs As New ADODB.Recordset, SQL As String SQL = "Select Spare_Name from Spare" rs.Open SQL, Conn, adOpenDynamic, adLockOptimistic Dim i As Integer For i = 1 To rs.RecordCount cboSpare.AddItem rs("Spare_Name") rs.MoveNext Next MsgBox "Successss", vbOKOnly End Sub]
Answer Question
| December 8, 2008 7:49 PM
ActiveX Data Objects, ADO, ADO Recordset Object, ComboBox, Database connectivity, Database programming, Recordset Object, RunTime, VB 6, Visual Basic, Visual Basic 6
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
RPG procedure
Hello Martin, Below is the codeline which i used for reading a DB file via RPG: FMYFILE IF E K DISK C READ PFRPG1 C DOW NOT%EOF C NAME DSPLY C ID DSPLY C ADDRESS DSPLY C ENDDO C SETON LR could you verify the code b’coz i am not getting the output.
Answer Question
| November 25, 2008 5:32 AM
Database programming, fMyFile, RPG, RPG/400
Hello Martin, Below is the codeline which i used for reading a DB file via RPG: FMYFILE IF E K DISK C READ PFRPG1 C DOW NOT%EOF C NAME DSPLY C ID DSPLY C ADDRESS DSPLY C ENDDO C SETON LR could you verify the code b’coz i am not getting the output.
Answer Question
| November 25, 2008 5:32 AM
Database programming, fMyFile, RPG, RPG/400
Display different fields in VB Data Report
In VB Data report based on the option selected from Form, the same data report should display different fields. For eg, when I choose “Tution Fees” it should display tution fees only, When I choose “book fees” it should display book fees only. I am using dataenvironment as dat source
Answer Question
| November 26, 2008 4:06 AM
Database programming, DataEnvironment, VB, VB Data Report, Visual Basic
In VB Data report based on the option selected from Form, the same data report should display different fields. For eg, when I choose “Tution Fees” it should display tution fees only, When I choose “book fees” it should display book fees only. I am using dataenvironment as dat source
Answer Question
| November 26, 2008 4:06 AM
Database programming, DataEnvironment, VB, VB Data Report, Visual Basic
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
Random values selection
how i can select random values from a coloumn from a given table
Answer Question
| November 25, 2008 5:12 AM
Database programming, tables
how i can select random values from a coloumn from a given table
Answer Question
| November 25, 2008 5:12 AM
Database programming, tables
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
