• How to publish a MS Access application as a regular web page in Internet Explorer.

    I'm publishing a Microsoft Access application, on a Windows Server 2008 machine, with RemoteApp. I want to know if there is a way to access this application over the Internet without using the web access feature. To be more precise, I want to publish my application as a regular web page in Internet...

    WindowsServerATE335 pointsBadges:
  • Lotus Notes Calendar to Microsoft Project or Access

    I want to be able to track the current meetings in my Lotus Notes (LN) calendar. Am I am able to link my meeting entries to Project or Access to track them. I realize there are CRM databases and etc. However, I do not want to re-write the information that is already in my meeting calendar. Any...

    Hillars775 pointsBadges:
  • How to use an form field in a SQL from a combobox

    I build an Ms-access application. In a form i selet project information based on project-nr. In that form I want to select in a combox records that are based on the project selected in the form. I think somethink like [forms]![<formname>]![<fieldname>] but it doesn't work. what is the...

    Haro5 pointsBadges:
  • Duplicating Form FieldsAccess 2007

    I need to duplicate all fields in a form based on a table based dynaset. The duplicate record will then be modified and given a new pk.

    Garyh5 pointsBadges:
  • Access Subform Repeating Data

    I have brought in a subform into my main form and link the child and master fields, but under each page the subform repeats the information down the page, but in the report on its own (i.e. before it is a subform) it doesn't repeat - what do I need to do to sort this?

    SJJ5 pointsBadges:
  • Populate Access 2007 object in form

    I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.

    OhioPat5 pointsBadges:
  • Connectivity between Oracle BI Publisher and Microsoft Access

    I need to make a connection from BI Publisher to an MS Access database. Anyone can help me with the connect string and database driver class details for setting up a JDBC?

    Ms123115 pointsBadges:
  • Runtime Error 2147217900 (80040e14) – Syntex Error (Missing Operator) in query expression

    Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as "Runtime Error 2147217900 (80040e14) - Syntex Error (missing Operator)in query expression "...

    RajeshP20 pointsBadges:
  • Retrieving Records based on Record Selection from another table

    I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables,...

    Tjlevin10 pointsBadges:
  • SQL or VBA code to loop through two columns of data

    I have a database table with 196000 rows (product code and related product codes) and the columns are: product code link product 000507 000123 000507 000456 000507 000789 000508 123456 000508 654321 000508 879456 000508 123789 etc etc I need this data changed to: 000507 000123, 000456, A product...

    Limey5 pointsBadges:
  • Performance Issue with an Access File Updated through an .accde file with Linked Tables

    I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked...

    EngTech5510 pointsBadges:
  • Access 2007 removing completed data

    I am working on a database where we visit a prospect 3 times and then remove the prospect for the visitation list. Is there a way to do this so that when the third visit field is entered, Access automatically removes the data or at least hides it?

    MeBrainHurts5 pointsBadges:
  • How a S/W in c# working in N/W accesses access database from other computer not having access

    hi, my project code works in network when i place my database of access in the computer which has ms-access, but wht to do when the other comp, with which i want to connect doesn't have ms-access, then how will i connect to it and run my project?

    Fairy5 pointsBadges:
  • Paragraph marks in an ASP blog page.

    My web site includes an asp created blog page that accepts a message in a form text box, sends it to an Access database then returns it to the page. It works without trouble EXCEPT when a user hits enter to go to a new paragraph. The paragraph character is sent to the database but ignored when...

    Boblafferty20 pointsBadges:
  • How to use DateDiff to calculate costs?

    Hi, In my Access bookings system you select a number of Units and a start and end booking time. I need to calculate the cost of each Unit for the booking as well as a total cost for all Units in the booking. The information is stored in two tables: a bookings table called tblHourPeriod with the...

    Dontgetit105 pointsBadges:
  • Open Access 2007 files with Windows 2000 OS

    Is there a reader that that will read .accdb files using a Windows 2000 operating system?

    Skywatcher10 pointsBadges:
  • Access: Form to input dates

    Hi, I was wondering if some Access expert could help me with this short questions. I have an access database with one table, which has 4 columns: ID, Task, Date, Hours I would like to create a form in which a user sees the following headings Task : Mon : Tue : Wed : Thur : Fri and they just fill in...

    Js876525 pointsBadges:
  • DateAdd Function

    I have a dateadd function in a query Cdate:DateAdd("yyyy",[Length],[StartDate]). I need the year added from how long we give someone to complete certain courses. Example, Lenght = 2, StartDate = 1/2/2007, Cdate = 1/2/2009. This works and that's not the problem. Now I need to run the query with the...

    AccessFlunky50 pointsBadges:
  • Access IIF Statement Not Returning All Records based on Option Group

    I’m using Access 2007 and have a query referencing an Option Group on a Form as a filter. The Option Group has 3 choices: Billable Manhours (value = 1), Non Billable Manhours (value = 2), All Manhours (value = 3). My query statement is:...

    EngTech5510 pointsBadges:
  • Access Course/Student Database

    I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with...

    AccessFlunky50 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