How do you convert Executive Asst.1 to EXECUTIVE ASST.1
how do you convert Executive Asst.1 to EXECUTIVE ASST.1
how do you convert Executive Asst.1 to EXECUTIVE ASST.1
5 pts.
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 into a Notes...
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 into a Notes...
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 for instance...
View Answer
| Feb 1 2009 5:55 PM GMT
Microsoft Access 2007, Microsoft Access 2007 Reports, Access 2007
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 for instance...
View Answer
| Feb 1 2009 5:55 PM GMTMicrosoft Access 2007, Microsoft Access 2007 Reports, Access 2007
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
I cant Save any data in tables when i pressed the save button icon in vb 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
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
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"
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"
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?
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?
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...
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...
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)
how to convert dbgrid database information in to text files (vb 6.0)
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 and...
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 and...
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?
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?
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...
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...
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...
[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...
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,...
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,...
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...
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...
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
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
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?
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?
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 the query and could not. IF I...
View Answer
| Nov 19 2008 12:15 AM GMT
Microsoft Access, Database programming, Microsoft Access forms
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 the query and could not. IF I...
View Answer
| Nov 19 2008 12:15 AM GMTMicrosoft Access, Database programming, Microsoft Access forms
