Microsoft Access / VBA Forum

I've got a "PlayPen" version of a production app on one user's C: drive - so they can do what-if scenarios without messing with the production data. The prod version has been running for going on seven years now with virtually no data problems. (Well, ok, somebody pulled a cable in the LAN closet once and corrupted the DB....but that's about...

I am using Access 97 on a PC running Windows NT 4.0 SP6a. I have some code (shown below) intended to add a set of records to one table (tblGradeProps) when a new record is created in another (tblGrades) The oddity is that when the procedure Detail_Click is called from the procedure cmbMktSect_Exit, the RunSQL statement doesn't add the...

Running VB coded from Excel to update information from an Access database. When the code is run from Excel it works most times. But occasionally I get error 4866 saying the Access database is opened exclusively by admin. Here is the VB code (it locks up on the line with asterisks ****************************: Private Sub...

Hi all, I know PHP can work with MySQL, but will it work with Access? thanks Nate

I am using DoCmd.OutputTo to allow users to save Access reports in snapshot format or other desired formats. Once the user selects the desired format and clicks "OK", a dialog box appears that informs the user of the progress ("Now outputting page X of...to the file...") This is fine. However, the title of the dialog box is "Printing", which...

An HTML version of this document is available at: http://www.mvps.org/access/netiquette.htm Feeling left out? Alone? Wondering why everyone's ignoring you? Or why you're being flamed for what you deemed an innocent post? The following tips will not only help you, they will help us help you. Please note: The latest changes to this...

Hi again! Does anyone know if there's a program that converts PDM (Perl) files to any files readable by ACCESS 2000? thanks, deb

Hi, there, I am a beginner on Access. I have been taking so long time to try to figure out his, but so far, no clues. I want to select 2 combo boxes and Access will automatically fill in other 5 bound text fields for me. I searched all groups and microsoft support sites, no result.

Well, I'm sure that a better Subject title could have been chosen, but the problem I have encompasses all. What I'm trying to avoid is completely redoing a form that I have created by using subforms. This will not be easy to describe so please bear with me. Perhaps if I just summarize what I'm trying to accomplish, I will lose fewer readers. ...

I have a strange problem that I have not come across before. In a multi user situation I have a readonly query open. When another user tries to post a change to that record it says it is locked. How can a readonly query cause Access to lock the record ? I am not even trying to edit the record. If I move to another record or close the...

I have a strange problem that I have not come across before. In a multi user situation I have a readonly query open. When another user tries to post a change to that record it says it is locked. How can a readonly query cause Access to lock the record ? I am not even trying to edit the record. If I move to another record or close the...

test

Hi all, We are having several "stand-alone" ACT! databases, which are linked to a MS-Access 97 database (dbf only) for summary reports. This works perfectly fine by using the FoxPro file type.

I have a stored procedure that is loading data into a global temp table. Here is all the code for that stored procedure. CREATE PROCEDURE AS SET NOCOUNT ON BEGIN

I have two tables. The first, BudgetPlan, has FundCode and PlanAmount and the second, BudgetActual, has FundCode and ActualAmount. In the beginning of the year the BudgetPlan has its FundCodes populated with planned amounts and over the course of the year as money is spent, records are added to BudgetActual. When I do query to join the...

Hello, I have a sub report that needs to be in 2 columns instead of 1 that the main report should be in. How do I do that and how do I prevent the sub report to start on the next page instead of right below the rows of the main report? I appreciate any help Richard

An HTML version of this document is available at: http://www.mvps.org/access/netiquette.htm Feeling left out? Alone? Wondering why everyone's ignoring you? Or why you're being flamed for what you deemed an innocent post? The following tips will not only help you, they will help us help you. Please note: The latest changes to this...

I have a table(org1) that has fields (a, b, c, d). I can create another table (temptable) in design view and then use the lookup wizard to link field a from org1 into temptable. How can I do this in SQL using a script? thanks, Gaurav

Hi Everybody, I am setting up several users to run the runtime version of msaccess 2002. All the files run fine with the runtime version except one, and when I run it all I get is a blank screen. All of these files where converted from msaccess 97 to msacess 2002 and run fine in 2002. I will be thankful for any help anybody can give...

Hej er der evt. nogen som kan hjælpe mig. Jeg skal til at lave en database til en gård som har heste. Gårdejeren ønsker at have ID for hver hest på følgende måde (2000-1, 2000-2). D.v.s. det forreste tal er det år som hesten er født i og det bageste tal er et fortløbende nummer. Den første hest som blev født på gården året 2000 få ID 2000-1...

I have a db that tracks students and classes. On my main form I have student info. I then have a button on the main form that pops up another form that allows someone to add that student to a class. It automatically populates the student ID in the proper field and all the person has to do is select the class. On this enrollment form I have...

In Access 2000, does anybody know how to write code behind a button, in such a way that the Report Wizard runs when you press the button? I'd really like to use the standard Report Wizard if I can to help the beginner using my program along. I tried "CreateReport" but this just gives a blank report in the standard edit mode. (At least that's...

Hi: Can anyone help me? I have a Multi-Selection List-Box on a Form. After the User selects the deisred records I want to open/edit those records via another Form either indivdually or via a Tabular type Form Thanks in adavnce Bruno

Sorry for posting, something funny is going down with my newsever or network and I can only seem to post new entries. Just wanted to say thanks to Allen and Mr Fenton and Bob. Ill repost when I get it fixed. Regards John

The problem to resolve should be pretty easy for someone. I have a main form which contains a combo box to lookup various vendors. Have several reports for the vendors, but it is print all or none. So here is what I have done and would like to stay on the same track. 1. Created a new vendor query (qryVendorRpt) with only the needed...