Access 2007 Recurring Jobs
How can I create a form that allows a user to create recurring (eg: weekly, daily, monthly) appointment/job in access 2007?

Answer Question   |  July 14, 2010  2:05 AM
Access 2007, Access 2007 forms, Access 2007 functions, Windows 7, Windows 7 in 2010

RPG with Embedded SQL needs journaling
When I try updating data in a PF via embedded SQL I get a message saying I need to turn journaling on..   *  change dates on a set of records   C/EXEC SQL                             C+ UPDATE ACC02602P                    C+   SET   CSSTR8 = :$NEWSTR,          C+         CSEND8 = :$NEWEND           C+   WHERE CSSTR8 = :$CSSTR8  AND      C+         CSEND8 = :$CSEND8  [...]

Answer Question   |  October 15, 2010  8:39 PM
AS/400, Embedded SQL, iseries v5r4, RPG

Updates on BLOB Storage Using SharePoint 2010
Can you comment on updates to the BLOB storage problem in MOSS 2007 in relation to SharePoint 2010 please? This question is from the Microsoft Live Chat which took place on June 1st.

Answer Question   |  June 17, 2010  7:47 PM
BLOB, BLOB Storage, MOSS 2007, Sharepoint 2010

convert string to double in Access 2003
Hi – I’m trying to convert a string into a double using this expression in Access Expression builder: Field1: CDbl(string) It’s not working. does anyone know why? thanks…

Answer Question   |  June 17, 2010  6:34 PM
Access, Access 2003, String manipulation

procedure create with compilation error ora-6550
i created table staff with two column a number(3),b number(3) then created procedure p1 but it shows error as procedure created with compilation error & during insert ORA-6550 error at line 1 column 7 create table staff(fno number(3),lno number(3)); create or replace procedure p1 (a in number,b in number) begin insert into staff(fno,lno) values(a,b); end [...]

Answer Question   |  June 17, 2010  7:15 AM
CREATE TABLE statement, ora-6550, Oracle error messages, Syntax errors

Renames clause in cobol
while using renames clause we are defining dataname-1 thru dataname-n. if i am having same datanames in another group which output can i expect?

Answer Question   |  June 29, 2010  6:49 AM
COBOL, COBOL statements, Programming Languages, RENAME statement

Database backup terminating abnormally
m running this code for backing up and to have backup log backup database adventureworks to disk = ‘g:radvent6.bak’ mirror to disk=’g:radvent7.bak’ with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values(‘dreee’,'reserch’) backup log adventureworks to disk=’g:radvent6.trn’ after the backup log command executes shows the error as The statement BACKUP LOG is not allowed while the recovery [...]

Answer Question   |  April 11, 2011  12:38 PM
Backup, Database Backup, SQL Server 2008

web-based GPS tracking application development with asp.net
i’m a final year degree student majoring in network computing.  i’m developing a GPS related web application where data is being taken from a gps tracker (TK-102), which can send data to a ip address and port number defined. there for i need to save this data to a database and then represent it on [...]

Answer Question   |  September 30, 2010  12:52 PM
Application and Web development, ASP, ASP.NET, Database, SQL, Visual Web Developer 2008, Web development

access 2003, create a form that allows you to search for an employee and to edit you have to have permission
How to create a form that allows you to search and edit if you have permisson. I don’t want the information to be edited if the person viewing doesn’t have permission

Answer Question   |  June 17, 2010  1:21 AM
Access 2003, Access 2003 forms, Microsoft Access 2003 permissions

Creating Variable Number of Elements in Array Data Structures
Is there a way to create a variable number of elements in an array data structure or multi occurrence data structure? I have an application where I need to be able to expand the elements or occurrences on the fly Thanks Ron Newman

Answer Question   |  June 14, 2010  2:04 PM
Arrays, Arrays (programming), Data structures

Expression Builder, Calculation confusion in Access 2007
Ok I’m having trouble with this simple calculation.  I have a Query with a field called “% of fire Calls made” it may contain a number (ie 23.34). I’ve tried to create another field in the same query that ask the question, if the # in “% of fire Calls made” is equal to or [...]

Answer Question   |  September 22, 2010  2:21 PM
Access 2007, IIF function, Syntax errors

Search for Records Containing Word(s) in Textbox
How can I bring up records from a table, by using a query, that contain words that are entered into a textbox on a form? I can only get it to work if I enter in the specific word(s) into the field criteria in design view, which is not what I want.

Answer Question   |  June 9, 2010  2:50 PM
Access 2007, Access 2007 functions, Query, TextBox

Moving CA process in Domino 8.5
Hi, our usual Domino administrator has recently left the company and I’ve inherited the admin role due to the fact that I was once a domino admin myself. The only problem is that I was an admin under domino 5/6 and we’re now running 8.5 ! One of my first tasks was to decommission the [...]

Answer Question   |  June 9, 2010  2:31 PM
CA, Certificate authority, Database migration, Domino 8.5

How to validate 2 fields
I have a transaction table, There are 2 fields FuelLiters & FuelAmount. Both should be >0 or =0. If by mistaken FuelLiters entered as 0 and FuelAmount >0, computer should prompt about this mistake.

Answer Question   |  June 20, 2010  7:39 AM
Database alerts, Form validations, trans

Database Design Help
Organizations make business deals with other organizations. When negotiating a specific deal, each organization is represented by one lawyer. The same organization can have deals with many other organizations and it might use different lawyers in each case. Each lawyer has a first and last name, address (Street, City, State, Zip), specialization and fee. Each [...]

Answer Question   |  June 9, 2010  6:33 AM
Database, Database design, Database optimization

Career change from IT hardware/networking to software development
I’ve been in the IT industry of 20 years, on the hardware/network side, be know I am consider changing my career to move into software development, does anyone have some helpful advice?

Answer Question   |  June 10, 2010  8:48 PM
Career change, IT career planning, IT careers, Software development

ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT
I tried example 6 from the book SQL for Microsoft Access and got the error message” CHARACTERS FOUND AT THE END OF SQL STATEMENT. I tried deleing the first semicolon and got a message: missing semicolon at end of SQL statement. Can anyone tell me what I am doing wrong? Thanks, INSERT INTO Toys (ToyID, [...]

Answer Question   |  June 8, 2010  5:33 PM
Access errors, Microsoft Access, SQL, SQL Access

To write a stored procedure
there are two tables one ZipCode and one tempTable each has ZipCode and CongDist as columns. Each Zipcode has more than one CongressionalDistrict. How can I write a SP to have a seperate entry for each senario of Zipcode and Congressional District in tmp Table

Answer Question   |  June 10, 2010  1:49 PM
Relational databases, SQL Server stored procedures, Stored Procedures

Assign Indicators to an Access Table
I have a table in Microsoft Access that has duplicate customer numbers. I want to auto assign a number to the records,i.e. 1 thru 6. But reset to 1 each instance the customer # changes. Is there any easy way to do this?. Thanks

Answer Question   |  June 7, 2010  6:38 PM
Access 2003, Access query, Access Tables

DBFs into SQL Server 2008
Does anyone know of an efficient way to import DBFs into SQL Server 2008 (besides the “import into Access, then import the Access files into SQL server-method”)? I don’t work with SQL Server much, but I do it enough to have had this problem before (to be exact, it seems I have this problem once [...]

Answer Question   |  June 4, 2010  3:28 PM
DBF file, SQL Server 2008, SQL Server import/export