Microsoft Access / VBA Forum

Hi Access 10 running under XP Pro I have an app that grows every time I decompile it. I've tried importing all the objects into a new .mdb and then immediately compacting. This does return the size to normal. If I then open it decompiled, immediately close it then re-open, compact and close it the file is 500-700 K bigger. Each time...

I Have been asked to try to retrieve data from an application in written in Omnis 7.3 would like any info you folks have -- Murray Carter

I would like to add a scanning feature to my software. Does anyone know of a DLL or OCX that I could use to control a scanner and save the images. Thnaks. Alex

Is there a way to only print the first page for a report? Also, if the report is grouped by person (with each person's data starting on a new page), is it possible to only print the first page for each person? Thanks! Neil

I have a union query joining two other queries, each with 62 fields. Interestingly, when I open the query it has the correct number of 2850 records. But if I then set a filter (using filter by form), when I apply the filter I get only 206 records, when I should get 208. If I then remove the filter I get 2850 records again. But if I then...

I cannot believe I'm having this much trouble doing such a simple thing! I have two tables with identical structure. I can use an A2K select query to show the records in table 1 that match those in table two based on an inner join between two unindexed fields. Here's the SQL code for the select query that DOES work: SELECT...

I have two subforms within a particular form. The one on top is a datasheet of transactions; the one on the bottom is a summary of totals. I would like to have the datasheet fill the entire parent form until a command button is clicked, then have the datasheet form shrunk to half it's original height and have the totals summary form appear...

Hi, Is it possible to add icon images to Form Buttons and still include text on the button? If so, how is this done? Mike

By default, series lines on line graphs don't appear between points that have null values between them. Ie, if one series has values for a, b and c, while the second series only has values for a and c; the first series will have all it's dots connected while the second will not. I believe there is a setting to change this so the lines...

Hello, Hoping someone can help me out. When I select all records in a table, copy them to the clip board, and paste them to Excel the names of the fields appear in the first row in Excel. Such as FirstName, LastName, Phone, etc. I want to be able to paste only the records, not the field names. I know I can delete the first row in...

test

Have some Access code that does operations on c:\x.mdb. I need to know how to perform an operation like "copy t:\myfile.mdb c:\x.mdb" in VBA. Thanks, Mark

I have the following code as part of a procedure in a standard module: Dim ctrl As Control For Each ctrl In MyForm.Controls If ctrl.ControlType = acTextBox Then MsgBox ctrl.name MsgBox ctrl.Locked ctrl.Locked = True End If Next ctrl

Hello--I have 2 tables (illness,event) that a need to query and create a recordset The key fields are personId and description (text field) in each table. I also have other needed fields in the query but these are the 2 that join the 2 tables. I also have unique id's for each table (autoID, SeqNum). It runs ok except one issue--I have some...

I have built a form in Outlook that sends data to the receiver of the email. I would like to be able to import the form into an Access table. I tried the import from outlook wizard and it gives me all of the field information, but not the message text itself. If this helps: Outlook lists my template as Message Class: IPM.note Please...

I seemed to be having problems with structuring the use of NZ with a DSum expression. Having tried numerous variations of the expression without success, I'm asking for assistance. First some background (Access 97) - the DSum expressions are being used in grand total text boxes on the footer of a subform. And when viewing the subform in the...

I've found that the "Remove Filter/Sort" selection in the Shortcut menu (displayed on right click) produces ugly, untrappable errors, even though "Allow Filters" is set to No in the subform. However, the "Sort Ascending" and "Sort Descending" selections provide a helpful feature. Is there a way to get that "Remove Filter/Sort" out of the...

I have an Access 2000 database running on a network in a Citrix environment. The problem I am experiencing is that some users (not all) get the above error message occasionally, sometimes just once or twice a day, sometimes many times. It seems to revolve around two forms that are kept open most of the day. Form A has a list of tasks to...

I am trying to evaluate the latest occurence of a date which will go in the field titled eligibility date. Table is set up as follows and am using update query to update the eligibility date to the latest of hire,award, or accident) Emp Hire Date Accident Date Award Date eligibility Date Hire Date is never a null,...

I am mail merging to Word. Some of my table columns are Yes/No data types. I would like them to come out as check boxes in Word but they merge as 0's and 1's

Is there a way of connecting to a database on my server using Microsoft Access. I want to be able to modify my database without having to download it, ammend it and then upload it back again My account supports MySQL but i dont really know much about this Any help will be appreciated

I have a data application in a2k that I need to create two fixed width text files and then combine them to a single file The first file is header information and the second is transaction data. I have tried and tried but just cant seem to get this right, I am using Queries to created my export files with specifications which works fine, I...

Hi, I need to find how can I know that a program I am going to shell it is already open. This program uses an csv file that I need to refresh before shelling the program, however if the csv file is already in use because the program is open I cannot refresh it (kill it and rewrite it) and I do not get any error message. Right now I have a...

Been asked to create an app to keep records for a horse business. Just getting my head round what it needs. Most is straight forward. Need to create a routine to deal with reservations. Some things, like a box for your horse will be by the week. Others, such as use of the arena will be by the hour. Any thoughts on the neat ways of doing...

I have a database that keeps track of hockey games which I work at. In one table, I have the season's schedule. I want to put together a query that has the complete schedule, but also I want each record to show when the next game is (for example, on game 3's record, I need to know date of game 4). What's the best way to get a query to read...