• MS access Program / module

    Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY...

    Imtiyaz725310 pointsBadges:
  • securing sql server database object

    I connect my access project to sql server. Is there as simple way to secure sql server object such as table, view, stored proc from editing or deletion since access let us to edit sql server object directly

    Ipong40 pointsBadges:
  • Time limit for use of Access application

    Dear Sir, I have created a access application. Now i want that user should be able to use it for 15 days only. After that the application should say that your trial period is expired and get closed. Eagerly waiting for your reply. Thanks, Sandip

    Ssandbhor10 pointsBadges:
  • Read Only Table

    I create a table in sql server 2k5, the script is look like this: CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [int] NOT NULL, [PmtDInvLU] [int] NOT NULL, [PmtDAmount] [money] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[tb1PmtD] WITH NOCHECK ADD CONSTRAINT [tb1Pmttb1PmtD] FOREIGN KEY([PmtDLU])...

    Ipong40 pointsBadges:
  • Access 2007 Report displaying the content of three different fields in one box?

    I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & " " & [First Name] & " " & [Last Name] but in 2007 I am getting an error. Any...

    JustDave5 pointsBadges:
  • Need Help Importing Data

    Hello, I have a relational database that was created by a former employee. The database has old data and I need to update it with current information. I have the most recent data in an Excel spreadsheet. Questions: 1. How can I get the new data into the database and maintain the relationships and...

    Bluize20 pointsBadges:
  • converting files Lotus to Microsoft

    Our church office has used Lotus Approach 97 for the mailing list. We have about 600 names. Now we are converting to MS office 2007 and using Access. My question is, can I convert the Approch files to Access - my secretary really does not want to retype all of the address unless necessary. Thanks...

    Preacher2335 pointsBadges:
  • Access 2007 Complex Calculations

    In Access 2007 I need to enter raw test data into tables, perform complex calculations including linear trends, then store the calculated results. These are the only numbers I really care about. The raw test data could be deleted for all I care, I just need the calculated results. I will need to...

    Ryanwd10 pointsBadges:
  • Adding prefix to records

    Hi, I have a simple database for some products that has some SKU numbers... ie SKU 1001-01076-0000 1001-01120 1001-01120-2100 1001-01120-2400 1001-01121 1001-01121-2100 What I want to do is add the prefix "GF-" in front of those SKUs. This is a database that will continually get sent to me, so...

    Whoshanh5 pointsBadges:
  • Export from Access to Excel shifts decimal position randomly

    I am exporting from MS Access '03 to MS Excel '03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one...

    MBachman5 pointsBadges:
  • Union Query

    I 've a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a....

    Ipong40 pointsBadges:
  • Compile Error

    I am trying to prevent duplicate job orders from being entered for the same employer. The employer is in the main form and the job order is in the subform. I have this code attached to the "beforeupdate" event of the control on the subform but I get a compile error: wrong number or arguments or...

    Bec10 pointsBadges:
  • Can you help with the following DAO code explaining a step-by-step process?

    I’ve had some exposure to VBA and know the Access Interface very well (Microsoft Certified). I purchased MS Access 2007 Programming By Example by Julitta Korol a couple of months ago and all of the hands-on examples display the results in the Immediate window or a msgBox. Although I was able to...

    Doc3310 pointsBadges:
  • Access databases

    I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?

    Michaelrdowney10 pointsBadges:
  • Switch/Case statment in access

    how i can use Switch/Case Satatment in Mic. Access 2003, am working on database as follow: Field Name: Directions in this field i need to write codes like: TAm Field Name: Translation here i need to read TAm as T=Take, Am= Morning. the problem i have more than 200 codes, which they have to be...

    Darkblue4615 pointsBadges:
  • Problem deleting an object(form) in Access 2000

    When I try to delete a form that is visible in the object list a message 'could not find the object' is being returned. I have tried compact/repair and decompile on the database to no avail. Any ideas....

    Eamonngarvey5 pointsBadges:
  • Access database management

    Hi guys I am managing a database and need to know if there is away of moving 'completed' records into another database but keep them linked. Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle. My query is instead of having this...

    Timanderson5 pointsBadges:
  • processing biometric data

    can biometric data be incorporated into desktop or stand-alone applications like ms excel and ms access?

    Benibo15 pointsBadges:
  • How do I retrieve the most recent date from an access database

    I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.

    TheMooseRI15 pointsBadges:
  • How to show list view in Microsoft Access report

    i sample out some of the data from database. i shows my sampling in a listview in visual basic 6.0. now i want to show the sample to microsoft access. how's the coding?

    Yeohcc10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following