• VB and MS access

    I have finished develop a project in VB 6. Back end as Ms Access(Office 2003). Finished up to SETUP file. MY question is how to install the setup file with the database.

    Coordinator5 pointsBadges:
  • Deleting out partial data from a field

    I need to delete out partial data from a field in Access. I have a field of numbers that begin with '1NF' ex.(1NF123424). This needs to be deleted, but leaving the number alone '123424'. How can I do this with out manualy deleting it out myself?

    Mk198315 pointsBadges:
  • Strange behavior in Access 2003 user interface

    I create a form in access 2k3 data project connected to sql server 2k5. I put two check boxes on my form. On runtime, when i click on one of check box, it also fires on the other check box...set check box value from false to true. But it works normally when i use keyboard shortcut to fire that...

    Ipong40 pointsBadges:
  • Cannot open second copy of Access 2003 database

    I have created several databases that we use it the office. They are kept on a server. Recently, we started getting a security warning window everytime we open Access. It asks DO YOU WANT TO OPEN THIS FILE? and points out that the publisher is UNKNOWN PUBLISHER. If you click yes, it opens normally....

    tlsanders11,340 pointsBadges:
  • MS Access IIF Statement

    I am pulling options from a table of "1", "2" or "3" and cannot get the Iif statement to produce the results that I need. Please find the Iif statement below: =IIf([lepamtpaid]=1, “Your premium bill will reflect this new premium amount.)”,(lepamtpaid = 2, “This lump sum amount will be...

    Jsweitzer15 pointsBadges:
  • Accessing an SQL 2005 Synonym with ODBC

    Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?

    Randym1,740 pointsBadges:
  • Automated data entry for some controls based on data in other controls in Access 2003

    Hi: I am creating a bilingual (english/french) database wherein I need to have the french controls automatically filled when I choose an english term from a dropdown list in the correspopnding english control. Example: I have a list of terms in a combo box control (named 'domain') containing the...

    Willis125 pointsBadges:
  • How to pass value at run time from VB 6 to Access 2000 Query for reporting

    I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is...

    Mayuri155 pointsBadges:
  • Decimal places rounding to whole number

    In my Access 2003 form values with decimal places are rounding to whole number. I've set the property to fixed formal with 2 decimal places and the problem continues.

    Juju335 pointsBadges:
  • Justified alignment in Microsoft Access

    Dear Sir, I have put one memo field in Ms-Accees report. I want it to be printed like this : |.....................................| |.....................................| |.....................................| |..................| Please reply, Thanks, Sandip

    Ssandbhor10 pointsBadges:
  • Microsoft Access printing

    I had developed an application using MS Access 2003 and have no problem whether viewing or printing it in one page from my PC or Notebook. Also no problem when I opened this application in MS Access 2007 and printing it via MS Access 2007. By the way my printer is HP Laser Jet 1022. My problem is...

    Pusparaj7515 pointsBadges:
  • email query recordset

    "I have a query (emailnotifytest) based on 2 tables . One table (shipmentdata) filters on new records. the other table (contact) filters which contains the email address filters whether the address is not null. The tables are joined by the companyname. the code below works as far as sending the...

    Roundy5 pointsBadges:
  • importing an EXCEL tab

    while importing an EXCEL tab with the import wizard, ACCESS 2003 changes a text field with only numbers that exceeds the long integer format to scientific notation. Is there a possibility the numbers do appear?

    GIT02110 pointsBadges:
  • Creating a Form

    I'm creating a form and have an dropdown combo field on my form. (dz, each, Bag, case etc.) I want to use the dropdown on each line independantly. What ever is selected on the first line goes on all the lines. How do i get each line to have different selections based on a new line?

    Sims5 pointsBadges:
  • must Access be installed to use Analysis Server

    Working with Analysis Manager Version: 8.00.194, my Sales cube looks good until I try to browse the data that comes from Foodmart 2000.mdb. Is this because Access is required?

    Psf55 pointsBadges:
  • Microsoft Access in a Server

    Hi I am using Vb6 as front-end which is installed in the client machines and MS access 2003 in my server as back-end. Can I create local copies in each client system and at a particular time I need to update the server database with the local databases

    Threeeye5 pointsBadges:
  • 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:

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