• set up file not installed in other system

    Dear sir i created an application useing VB 6.0 and MS-Access.i made it exe and packaged as well as deployed using "Pavkge and Deployment Wizard" from Add-Ins menu. it is installed in my own system where i created the application.While i am installing in another system an Warning shows that "SET UP...

    Bipansahoo20 pointsBadges:
  • How Can i restrict the user to insert next record

    Hai all, I have a requirement that , i have to display the data from a table in the subform in a datasheet view mode. I should validate the fileds in such a way that i can restrict the user to insert a next record when the one of the fields in the previous record is null. And also i should pop up a...

    VBAccess5 pointsBadges:
  • Limiting characters in memo field

    In Access how do I restrict the number of characters a user can enter into a memo field?

    Olddog10 pointsBadges:
  • MS Access IIF

    There is a task type column and a cost column. I need to pull out only the costs related to the task type steel. I was thinking an IIf ( [tast type] = steel, sum, 0 ) statement would work. Not making it happen. Any ideas? I actually want to pull out all of the different types of costs seperately...

    Keg5 pointsBadges:
  • auto send e-mail

    How does one auto send e-mail from access

    Mabaxter5 pointsBadges:
  • MS Access – Email from form – VAR email receipients

    Hello, I have an access dbase and I need to email records (usually one at a time) to different receipients. The receipient name is part of the form and I have a table that lists the name and e-mail address. I am hoping to click a cmd button that will e-mail that individual the record on view. I...

    Asuasol10 pointsBadges:
  • Convert time as text to datetime

    I've got a stupid table that I have to work with (and no, I can't change it) that stores times of certain events as text (example: '10:25 pm' or '3:02 am'). This table has an actual date to work with, which is essentially just the date with no time component. Know what I'm going to ask yet? You...

    VentureFree45 pointsBadges:
  • Microsoft Access

    I have created an Iff statement where it will compare two fields and return the bigger number. The problem is that instead of compare the numbers as a whole, it compares them digit for digit. Result is that it will return a value of 150 instead of the bigger value of 1040, because the second digit...

    Jaco65 pointsBadges:
  • MS Access ActiveX Control

    I am using a MS Form where I am trying to fill in a couple of date fields from a Calendar I inserted using ActiveX controls. How do I go about doing that? Thanks, Asuasol

    Asuasol10 pointsBadges:
  • Combined Address

    I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address. Someone suggested that I create a calculated field. I tried this but all that it is doing is...

    Thuzinec10 pointsBadges:
  • Net Present Value

    In an Access Form, I want to be able to have five values in text boxes and use those five values along with another value in the form, the return rate, to produce the Net Present Value

    Mattylar125 pointsBadges:
  • Open Import window via code in MS Access

    Within a MS Access application, I would like to have the window that is opened when you select: File | Get External Data | Import via code.

    Rjwilcox45 pointsBadges:
  • Save Access 2007 format as 2000 format with VBA

    how can i save the curent database as a 2000 format with vba

    Dave b10 pointsBadges:
  • Split Databases – BE Structural Changes Version: 2007 (12.0)

    Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can't you put their copy of the FE on the network, under a folder just for that user?

    Thuzinec10 pointsBadges:
  • Deletion of Macros when doing a repair & compact

    We are experiencing a problem of a number of macros being deleted after performing a repair & compact. Could this be a space problem or could it be a problem with how the environment is set up--what do you think could be the problem?

    SharieL10 pointsBadges:
  • access 07 help

    i have a database in accses o7 that i wont to share over a network and allow users to log in on any system so that they can update or view the database'forms'and reports..please help

    Joe26098615 pointsBadges:
  • Using shell execute from Visual Basic

    How can I use the function Shell Execute in Visual Basic Code. I am running MsAccess. I want to use the Shell execute command ro run sqlloader command which loads data into an Oracle table. Would benice to have an example of this. /Roland

    Rolandsk5 pointsBadges:
  • How to pass a Whereclause from a form to another form’s subform in Access 2000?

    In FormA, I have a start_date and end_date fields for users to select the date range. The start_date and end_date will pass to FormB.subform where the subform is a continous form to display the records after filtered by the date range. My question is: how can I pass the date range to the subform of...

    Wonder195 pointsBadges:
  • Flickering subform in Access

    Hi, I have a continuous subform that, upon opening the database, flickers constantly. This flickering can be stopped either by alt-tabbing away from Access and back again or by hitting F9. The main form has a button that changes the source object of the subframe to a different continuous subform,...

    Mickeymongoose1235 pointsBadges:
  • Access Report Page Setup Won’t Save

    I am running Access 2003 on Windows XP. In the page setup of a report, you can set custom page size and specific printer, etc. I have a PC that the page size will not save with the report. I have two other PC's that it works on. Has anyone had this problem and found a resolution? I should add that...

    Randym1,740 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