Microsoft Access / VBA Forum

Hello I am trying to collect errors and record them in a table instead of a popup message stopping my code. It seems to work ok, but when I try to add ERR.Description to my code it fails on Syntax Error (missing operator). Any help would be very much appreciated Thanks Dave Dim strSql As String strSql = "INSERT INTO...

I have a database that has three linked tables "Projects", "Techniques" and "Vendors". I have a query that asks for the user to input a Project. The goal of the query is to find project information, techniques that were used on that project and vendors that developed those techniques. However, I only get results if the project is linked to...

Hi I'm no expert with reports : I have a query selecting groups of items - having their own itemID so to speak - I have managed to list these in a way so that each group of Items is listed in its own "table" in the report. - - Item1 socks 25 Item1 trousers 90

I have been working on a CSV export of a query, my problem is that I need a header row like in a Report. Any guidance would truly be appreciated........ :) My query provides: month,year,amount,event,activity,accountnumber I need a header row as follows =Count(*), =Sum(),event,activity so the resulting text file will look like:

Hello I have built an application using MSAccess 2000 that has a feature where the user can select a list of clients and then send fields from the client table to a .txt file to be used by a mail merge program.

hello there Info: I have a form on which is displayed information, customer code, address and balance etc.. on that form i also have start of the current week, which is displaying 29th march 2004 today for instance. this text box is active, what i mean is when i press the plus or minus keys this text box moves up and down one week. now i...

I have a report that runs on a parameter query. I run the report, enter the parameter, and it works as long as there is at least one record returned by the query. But if it comes up empty, I get an error in the report. I think there is some way to query the query to see if it's got any records and then exit the report. How is this done? ...

I am trying to set up a search facility by giving the user a form for them to enter a variety of criteria. They will either know the exact criteria they are looking for or will not. Therefore i set a query up using the forms controls as criteria as such !! or !!is null for each of the search criteria which allows me to search for one or...

lets say that i got 12 rows of catID 1 and catOrder (numbers between 1-30) and 12 rows of cat iD 2 and catOrder (numbers between 1-30) and . i need get all the 24 records back and to know what is the the max value of the catOrder for each catID. can it be done with one query?

I trying to build a form that would be bound to a temporary table, if possible. The purpose of the form is to allow a user to select certain records from a table with a checkbox. Then there would be a button on the form that would insert records into another table. So the form should return records from table1. Next to each record would be a...

Ever since I successfully applied some techniques for increasing the speed of my 17 meg. Application; it has only made me hunger for more. First, let me list what I have done so far: 1. Split the application and database into front and back-ends, 2. Increased the load-time of my application by "pre-loading my heaviest forms when the...

Does anyone know what is the best all round reference book/encyclopaedia of ms access thanks --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.647 / Virus Database: 414 - Release Date: 29/03/2004

Hi all, I'm trying actually to find a way to programmatically fax reports inside access. I'm using Win XP, Access 2000, Acrobat Distiller 6 and Winfax PRO 10 There's 2 way i could find out that could work: 1 - I make my report prints directly to Delfax printer and set the Fax Number, recipient, Comments and other stuff programmatically...

hi there, StrSql = "UPDATE TblResults SET TblResults.DOHID = " & intnum1 & _ " ,TblResults!AHS = " & chr(34) & txtAHSto & chr(34) _ & " WHERE (((TblResults.DOHID)=& " Intnum2 & "));" what's going wrong with this sql statement. It produces an error at the textstring. saying ... 'AHStext". error?? any hints??

I am using Access 2000 with OWC 9 (Office Web Components). I have two PivotTables. When I set the Filter Field in PivotTable1, I want to programmatically set the other PivotTable to the same Filter. does anybody know how to do that. Regards, Dahman

Hey Group, How could I import a Data from a Excel Spreadsheet, into a Already Exsiting Table, also can I choose which coloum(s) need what row of data in? Many Thanks MCN

Hello, We are building a report that needs the main form printed in landscape and the subforms in portrait. Everything we've tried to do this has failed, they all come out landscape. Anyone done this, and if so how? Thanks, Mike Hammer

I am having a file-locking problem with an Access database. The .mdb and ..ldb files both remain locked even after all users have closed Access. The project is an Access 2000 database split into a front-end and a back-end. The back-end is on a shared server on a Windows network. I am offsite; when I want to make changes to the back-end, I...

I have been given a secure .mdb file, the .mdw file and the appropriate user name and password. How do I actually open the mdb using the mdw and the supplied username and password. Thanks in advance.

I am looking for a few handy routines. Please advise websites that may have these programs available. Thanks. 1. A routine to check duplicate entries in a query/table and put these duplicates in a separate query/table. 2. A routine to run compare of two queries/tables and put the unmatched in separate tables/queries. i.e. entries in A...

Sorry

Hello all, I was recently browsing the forum and remembered seeing a message relating to MS Access Bugs/Flaws. The thing is I cannot find that thread anymore, and so was wondering does anyone know if MS Access (97-2000) has a bug in it where the user thinks the application is saving a record where in fact the record has not been saved. The...

I have created a subroutine that opens a report in design view, modifies the report (adds text boxes and grouping levels, etc.) then opens in preview mode. I want to be able to close the report without saving the changes, and without being prompted to save the changes. It is easy enough to get rid of the save prompt by using...

Hi there, I was searching the net for some guidance in putting together a query that would select random records from the main table. I came across this and it works like a charm. SELECT TOP 5 * FROM tablename ORDER BY Rnd(IsNull(fieldname)*0+1);

Hi everyone, I started in access just a copple of weeks ago, to automise my ecell DVD database.So I could make forms, ans reports.. Thought it would be easy, but I'm trying nog for weeks and I think I have a bad base to start from. First, I made 3 tables: - Acteurs: acteur ID + acteur - Genres: genre ID + genre