Microsoft Access / VBA Forum

Need to get some Pervasive SQL or Btrieve data into a Microsoft Access database? For those needing to do so, we sell a very useful tool for Btrieve and Pervasive SQL Databases. Has an explorer type interface. Lets you browse and edit your Btrieve and Pervasive SQL database DDF and data files. Lets you see everything as it's native type or...

Hi all, I have an invoice table query that returns 10 records. ie. there are 10 invoices. When I try to join a subjects table to retrieve the subject name associated with an invoice it returns 11 records. I know this is because for each invoice, there might be multiple subjects. So when I join the subject table to get the subject's name,...

I am developing a weed management database for the preserve I work on. One of the queries I'm working on will allow the user to run a query and see which weed patches have NOT been treated in the current calendar year. This query involves two tables. The first contains the static information about the weed patches. The second contains...

Should this line work? x = Shell("WordPad.exe", 1) I get an error citing the 'file cannot be found'???

Hi and TIA. I have a text field that holds date info (01/01/01). My customer wants to keep it a text field so I'm stuck with it. The problem I have is that several users have added the date as 01/01/20 because they thought they were entering 01/01/2003. Is there a procedure/function I can run that will find the records with /20 and update...

Hi, I am using Access2000 and have developed a data base which successfully uses DAO code in some of the forms to update tables. Recently I converted the data base to a split MDE data base and now get errors in the DAO methods. IE: Dim Rst As DAO.Recordset Set Rst = CurrentDb.OpenRecordset("TableName") Rst.Index = "IndexName"

I can open WordPad directly (Start, Run...), then open a document & click File, Send... Out goes the email without a hitch. However, if I open WordPad from Access this way... Sub Button1_Click () x = Shell("c:\windows\system32\dllcache\WordPad.exe ", 1) SendKeys "%FOc:\cr\docs\packets\ntrolttr.rtf~", False End Sub

Using Access97 I saved a form using "Save as Report". A column of textboxes show they are un-bound in design view, yet, when I preview the report these textboxes contain data even when there is no controlsource connected. They seem to inherit the static controlsource (="LCD") from the form. I can't find a place in the report properties to...

Dear group, here is my problem In the code of a form, i want to declare a variable : Dim Base_Photo as Database, But Access 2000 don't propose "Database" and don't accept it. But, in an other Base, with Access 2000, this is possible and accepted and works !

How do you return the last Active Control when the control is on a tab control? Screen.ActiveControl does not seem to work. Here's the statement that my code uses. Set ctlOld = Screen.ActiveControl The code line work when all controls are placed on the form page rather than a tab control. This code should pass the last active control to...

(access 2002) Anyone have any suggestions as to what may be causing access to not save form changes after I "tell" it to, exit database, then re-open later to discover the changes had not been saved (or somehow reverted). BUT, new form module code is saved. Example: created txtTitle control on form. Create AfterUpdate event code for...

I have one main form that I use to view data as well as add new records. When I click the add new record button, many of the form's controls that arn't needed get set to invisible. When I'm done entering the new record, I want to click on a command button that resets and requeries the form to the state it is in when it first opens. What...

Hi, I have a form with buttons (Ok, Close etc) on the form footer. As the user tabs through the form controls focus will not move to the footer controls. Am I missing something here? Do I have to trap the Tab key on the last control (keydown, keypress) in the tab order and move focus to the first control in the footer. Paul Copeland --

I use a picture for the background for a form (picture property). This small (6ko) attached file make a mosaic (property Picture Tiling set to yes). The problem : with this image, the form seems to rebuild itself during one or two seconds each time I select a new record or when I use the navigations buttons . Of course, i could forget this...

Hi Ive got an Access97 db with a record in one of the tables that appears to be locked by another user even though no one is using it and the ..ldb confirms this. I need to delete this record but cant!!! Can anyone tell me how I can do this? Thanks

Hello My form is based on a query returning rows of a table. Practically, it is based on a table, so simple the query is. A field on the form is formatted as short time. The column in the table, on which this field is based, is also formatted as short time. When the form opens, everything is OK, the time field shows time as it should. When...

On a client's machine with Office 97, my access program gives an error "The Expression you entered refers to an object that is closed or doesn't exist" when I am assigning a value in the checkbox. chk_multiuser.Value = 0 What could be the cause of this error ?

Does anyone know how I can print a report that autonumbers each row/record it prints. Nothing complicated, just from 1 upwards. TIA Denis

After getting around a problem with the Norton utilities, I have finally been able to get .jpg images linked to my table. When I try to display the images using a form, the form presents icons which, when selected, will then display the image. Is it possible to get the actual images (they are small thumbnails) to appear on the form without...

Hi NG I am not able to make an MDE e file in Access 2002.I get an error msg. The format is Access 2002 and the database is compiled. The database is separated in a FE and BE file that automaticalli relink at startup. Any clues? Sigurd

Is there anyway I can use CTRL-C in Windows XP to copy this string... Copy C:\Program Files\Windows NT\Accessories\wordpad.exe \Windows .... and then somehow 'paste' it into a CMD compatibility window then execute it? Look, I've already been hit with "Why would you wanna do that?" Its like an addiction, OK? Sorry for my weakness.

I have a database that is used for tracking customer survey data. Each customer can have multiple products. I have a report that lists customers that have not yet been surveyed )(rptCustomersNotSurveyed), and another report that lists the customers that have been surveyed (rptCustomersSurveyed). A survey can be done for each product, since...

What do I have to do to get help from other newsgroup members? Whenever I try to get help from the NG I never get results... If I do something wrong, please tell me about it! Stephan

Hi My customer wants salary statistics for a number of similar organisations expressed in percentiles something like the following: Administrator Salary Total package 25 precentile $xxxxx $xxxxx 50 precentile $xxxxx $xxxxx 75 precentile $xxxxx $xxxxx Average $xxxxx ...

Sorry about the unwieldy title, it's difficult to describe it in any other way. Basically I have a table in Access 97 which contains a number of records in different states. When originally created, I do not wish to make the field Original ID required, however once the state of the record is changed I require this field to be completed and...