Microsoft Access / VBA Forum

Hello all, i'm a new user in this group and was wandering if anyone could assisst me with a problem: I have a form with option groups within it outputig their results to a table called tblTNAform, with contain a very, very large number of fields linked to option groups. My problem is that i wish to display these results as text, not...

Hiya, Anybody know how to do this please? I am opening Access from VB using the code below. However, I don't want Access to close when objAccess goes out of scope. I would like Access to remain open - like MS Excel does if you write similar code. I am trying to avoid using the Shell function because I don't want to have to search for...

I want to track the answers to several questions. The answers are numbers 1-5. Should I make the questions a table and have each question be a Field in a table or is there a better way to do this. This is what I'm thinking. Table 1 - Questions A Complete H&P was completed on 3rd Visit The Physician diagnosis is consistent with Findings...

Hi, is there a way to integrate NT Authentication into an MS Access front end, which uses table links to SQL Server 2000? currently our frontend has 22 users, and uses full access SQL server DSN links. our IT department wants to introduce new policies which forbid: 1. write access to databases (except where absolutely necessary for the...

I know how to fromat dates by weeks, as in Format(,"ww"). However, this displays the week as a number, such as 1, 2, 3, 4, to represent 1st week, 2nd week etc of the year. I am wondering if there is a function in Access that will display the actually dates of each wek in the year. For instance, I want to display Jan 1-7 (as week 1), Jan...

I have access 97 database being run by multiple users. It was working fine until I created a form and a macro to open the form at start-up. Now only one user can open the table. If a second user attempt to open the same table at the same time, there is an error message that says "table cannot be lock, it is being used by user A on machine C or...

I am having trouble opening my data source for mail merge. There seems to be a problem because I am using the database where the source is objWord.MailMerge .OpenDataSource _ Name:="C:\Documents and Settings\David\Desktop\WSS.mdb", _ LinkToSource:=True, _ Connection:="table tblAccenture", _ SQLStatement:="SELECT * FROM WHERE = '" & rst!...

I have an Access form called "Login". "Command10" is a button on the form and "Text5" is a text field on it. When a user enters a value in the Text5 text field and clicks the button Command10, I want my function to check if the value in Text5 matches any value of InstructorID in the Instructor table. If yes, I would like the control to switch...

Hi I have created a hyperlink to a document what i would like to do is read the string and return only the file name i will need to read from the right untill i read the full stop(.) and exclude this i then need to read from the right untill i read the first \ this will give me the file name from here i need to discard the rest of the file...

I am new at this. The database is working correctly stores data except when editing some data. I created an InformationTable with all variables. Then used the Analysis Wizard to create 5 specific tables. The Wizard then created the Query, CustomerInformationTable. I previously had 15 items in the InformationTable when I started adding

Is MS Access 2003 compatible with Crystal Reports Version 9? Yes or No? I am UNABLE to create a connection to my MS Access 2003 dbase using Crystal Reports Version 9! Thanks!

Does anyone know of a way to accomplish this?: I have a table of assets I want to change my asset number field to auto-number (caution: I already have hundreds of records in there so this change alone may be a problem) I have 3 categories of assets "INK" available numbers 10000-19999 "PAPER" available numbers 20000-29999 "MISC" available...

Leaving aside whether the gurus like or approve of DLookup and it's ilk, can someone enlighten me as to what is wrong with the statement below please ? I have a the following - query "qryCostType" query fields are fldCostType fldCostTypeID fldRate

Hi, I have just converted a clients' bespoke database from Access 97 to Access 2003. The also got new machines, so Office 2003 was installed (no previous versions of Office exist). They can view a client in the report preview window and if they select the 'Office Links' --> 'Publish it with Microsoft Office Word', it creates an RTF file...

I'm trying to pull all the parents of a particular animal and I have my SQL statement that says not supported and when I attempt to run the Query, I get The SQL statement couldn't be executed because it contains ambiguous outer joins. To force one of the joins to perform first, create a separate query that performs the first join and then...

I need some help. Here is the problem. Table_1 (gl_Train_KeyIdeas) +----------------------+----------------+-------------------+---------------+ | KeyIdea_ID | Unit_ID | Group_ID | Title | +----------------------+----------------+-------------------+---------------+ | 1 | 1 | 27 ...

We have an Access 2002 database of about 35 M with about 7 users. The data lives on the server (Windows 2000 server), while the queries, forms, reports, etc. live in a file that is on each person's C drive. There is also a workgroup file to set the permissions for various groups. Everybody is running Windows 2000 on their local computer. ...

Hello I need to connect to an access db which is on the internet. I do know that URL of the same. its http://www.vallury.com/balance/bank.mdb. Its just a test db. How can I connect to that db from either my desktop application or from my intranet website. Thanks and Regards

Hi, Please help an aging and not-quite so agile brain. I've looked through MSDN and Googled the planet. I have a very simple structure and want to get full records for distinct combinations of various fields. I just don't know the correct syntax. If this can't be done I can always analyse the data myself, but I would rather do things...

I attempted to replicate a database, but not all the objects are replicating (no indicator beside the elements in the viewer). What causes this and how can it be fixed? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!

I am teaching myself Access. I prefer to create forms to enter data instead of tables. Where possible I want to use Option Boxes instead of having to input data each time. Each option box in a group assigns a value which then populates the table. How do I convert the value assigned by the option box back to the name of the chosen input

Is it possible to update more than one table from within the same query? If I run a query on a single table I can update the table but if I ad a single field from a second table I cannot. Regards

Hi, I need to export all data that was despatched on a specified date to an excel file. I tried creating a query but I am stuck? Thanks...

I'm looking to develop a database in Access but it needs to be used both on a PC and a handheld. The database would be developed on a PC in the full version of Access not the Pocket/Mobile version. Is this feasible and what are the limitations? Any thoughts or suggestions would be appreciated or even articles.

I need help with creating a totals query. My data looks like this (I will only include 2 fields) Policy Number App Status ------------------------------------------- Z9999999 RECEIVED Z9999999 DECLINED Z9999991 RECEIVED Z9999991 DECLINED