Topic profile page for MS Access.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: MS Access.
Topic "Ms access" was discussed 14,806 times on 784 sites in last 3 months
Started 15 hours, 16 minutes ago (2009-12-04 08:41:00)
by 1973niro
I have upsized my Access 2007 database to SQL server 2005 database (Front end Access Db and Back end SQL server Database). Following part of the MS Access query does not work after upsized the database. Therefore, please help me to solve the problem. WHERE (((DONATIONS.PAY_DATE)>=[forms]![report].[STR_DATE ] And (DONATIONS.PAY_DATE)
Started 1 day, 7 hours ago (2009-12-03 16:16:00)
by TruffleShuffle
I have an access Query which returns results which are effectively product totals. For exmple, each product has about 4-5 different results, so like X product1 - Supply, X Product1 Supply & Fit, X Product2 Supply, X Product2 Supply & Fit, then you will have Y Product1 Supply, Y Product 1 Supply and fit, Y Product2 Supply, Y Product2 Supply & Fit etc etc. How do make the query group all the X...
Started 1 day, 10 hours ago (2009-12-03 13:12:00)
by angeleta
I have a simple Access DB that I am creating to enter support information...everything works well except for the information that I need to update using a form. Eg. If a support ticket is logged, and later that ticket is closed, i need the person to be able to enter the date closed and the person who closed it, along with any other new information that needs to be entered. I have set ...
Started 1 day, 13 hours ago (2009-12-03 10:15:00)
by S D H
I'm trying to set up a database to keep track of company equipment. We are surveyors and so use: theodolites, tripods, prisms, cameras, and numerous other equipment. I want to set up a system whereby people can take kit out of the storeroom and then sign it out using an MS Access form. They can sign kit back in when they return (or take...
Started 1 day, 14 hours ago (2009-12-03 09:04:00)
by bambo
Hi, I have a query that in some cases faults on "ms access can't append all the records in the append query ..." when i put on error on the vba code running this query it doesnt catch it as an error. any ideas how to catch this error so could handle it by code? Thanks!
Started 1 day, 15 hours ago (2009-12-03 08:16:00)
by SVCitian
Hello, In one database in my company. Previously the data in SQL Server, the tables were simple text and number formats and it was easy for me to link the data through ODBC to MS Access and I could do all sorts of queries and calculations, etc. But, now (after several months) I realize that the DBA and Programmer changed, the data in SQL Server to be XML Data Type in the new setup. In SQL ...
Started 1 day, 22 hours ago (2009-12-03 01:01:00)
by GCG123
Hello, I have successfully created an ODBC Datasource to an MS Access database from a 32 bit Windows 2003 server running SQL Server Reporting Services. However, when I set up the exact same thing on a 64 bit Windows 2003 server running SQL Server Reporting Services I get an error when running the report from the SSRS web site as follows: An error has occurred during report processing....
Started 2 days, 4 hours ago (2009-12-02 19:24:00)
by Lawnchair Bill
I am attempting to group records in an MS Access 2003 report by using a field in the table that is different from the one entered into each record. In other words, the groupings available to me are alphabetical or numeric only, but I want to create my own "custom" sort by using the key code for that underlying table, which is numerical...
Started 2 days, 4 hours ago (2009-12-02 19:16:00)
by S D H
I'm trying to set up a database to keep track of company equipment. We are surveyors and so use: theodolites, tripods, prisms, cameras, and numerous other equipment. I want to set up a system whereby people can take kit out of the storeroom and then sign it out using an MS Access form. They can sign kit back in when they return (or take more kit out..). I have a table with staff ...
Started 5 days, 19 hours ago (2009-11-29 04:55:00)
by dvdadler via AccessMonster.com
I am trying to come up with the VBA code I can use in a small application I've inherited to do the following: The access database list a number of cities and the length of the roads that link them Each city is not necessarily directly connected to each other (see example below) What I am trying to do is come up...
Started 4 days, 20 hours ago (2009-11-30 03:38:00)
by lvensen@gmail.com
hi, In my application, getting the word document from users and i saved that doucment in access database. Data type is OLE Object. I want to know how to retrieve the document from db? How it is possible? Thanks in advance.
Started 1 week ago (2009-11-27 13:41:00)
by Johan Buuren
Can anybody help me with this script or another script. This script create a ms-access database and 1 table, it also create 2 rows of data. But the problem is i want import a csv file to ms-access with this script. Johan Here is the script : Option Explicit...
Started 3 days, 10 hours ago (2009-12-01 13:17:00)
by BxWill
Created a make table query that is based on a passthrough query in MS Access to store data from a SQL Server database. Problem that I encountered is that the data types for several fields are incorrect within the MS Access table. Therefore, I altered the make table query below by prefacing several lines with "CInt." SELECT [001_qryPT_Faculty].DATE_PERIOD_NM , [001_qryPT_Faculty].DATE_QTR_NM...
Started 3 days, 15 hours ago (2009-12-01 08:47:00)
by newestAF
I have a word macro that separate different documents attached in one attachment. There are several different documents this works for. I use a word macro to split the docs and save individually. Part of the name saving function is to search the document for the last 4 of the agency code. I have an excel spreadsheet which I want to import into access to reference. The xls has 3 columns to be ...
Started 3 days, 12 hours ago (2009-12-01 11:52:00)
by BCITStudent
( Hi: Have a really simple and perhaps dumb question so here goes: Using MS Access 2002 with hyperlinks to photos stored on network. All hyperlinks currently open in a new tabbed window. I can understand hyperlinks for new websites opening in a tabbed window but shouldn't photos open with picture viewer? Many thanks , Hi: Have a really simple and...
Started 3 days, 20 hours ago (2009-12-01 03:05:00)
by Roger Wright
So, I thought I was finally done with Access and moving on to SQL Server. I am, but this week I took a short detour to help a friend taking a college class in MS Access. I've used it for small projects off and on since Access 95 put Paradox into retirement, and though I've had little success making anything but the simplest apps with it, it has its uses and I'm familiar with VBA. She has to ...
Started 3 days, 10 hours ago (2009-12-01 13:31:00)
by john john mackey
is it possible to embed the "classic" (XP and older) Windows Explorer control in a MS Access form (Access 2007 running on XP, ...)? What I want is the folder view that appears on the left side of Windows Explorer (complete with icons) and the file view that appears on the right side (simple Detail view would be ok.) So, is it possible to get these two views and control it in MS Access form?...
