Microsoft Access / VBA Forum

Hi All, Does anyone know of a place where a corrupted mdb(front-end) can be sent and have that place be able to tell me what got corrupted within the db? Here's the issue; All pc's are WindowsNT on a Novell network using Office97 Pro. I built a db application(work distribution and log app) which has been running in this environment for more...

Hello experts, I am a VBA newbie. Most of the tricks I apply to my applications I learn from here or google. I couldn't find a solution for the following two things, they both are related to using default user preferences. I hope someone can help me with samples. Question 1: Keeping filter settings I have a form with some unbound...

Hello, I am developing a simple ASP application with VBScript and Access database. I am testing it on my Win98SE machine using Personal Web Server. My machine is Celeron 2000 with 512Mb RAM. On the Access I have 2 tables, each one with less then 20 rows. The problem is, that each time my application access the database, the response is...

I have an Access 2000 database connected to a SQL Server and am trying to execute my first stored procedure. I created the stored procedure and verified that it works, but when I try to execute it from Access: cnn.Execute("sp_IPT") it says: 'Could not find stored procedure 'sp_IPT' Any ideas?

Hey there eveyone, I hope this is a simple question...... I need to be able to change a session variable when a wondow closes. Does anyone have any idea how this could be accomplished? Thanks in advance, Jeff

Using a button control...Why does this only launch the command interpreter but not the batch file? The batch file portion of the string is being ignored when run. strAppName = "Cmd.exe c:\Payor DB\Batch File\pbsout.bat" Call Shell(strAppName, 1)

At the moment I am having a problem with relationships and updating tables. The following is a production run. Table1 -- MainFormTable1 -- Basic Table Record Table2 ----SubFormTable2 -- Components of the Production Table3 ----SubFormTable3 -- QC Of the Production Table4 ----SubFormTable4 -- Customers to whom the production is sent. The...

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...

Hi Guys, I have two tables, table A and table B. I would like to acheive Table A is one to many relationship with table B, where is related by . I have created a form (bound to A) and a multi selectable list box (unbounded) and I am able to sucessfully use SQL to insert selection into B. ** The question**

Okay, I have worked on this and then some, but cannot seem to crack it. So if someone can straighten my code out, or suggest a new approach, then I'm all ears. Here goes: I have two tables - one (tblReports) with all of the fields appearing on a report selection form (frmReports). The other one (tblGroup) is only use for the eight group...

I would like to have a query of all duplicated items. I don't want to delete the duplications. What should I type in the criteria? Thanks

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...

Thought maybe I could do this with a hyperlink field in a table...........but doesn't seem to be working. I basically got a vendors table with all the contact info. One of the fields is EMAIL (for the email address of the contact). Basically I want people to be able to click on the email address or field and have their default mail program...

I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used the SQL Profile to watch the T-SQL-Command which Access ( who creates the commands?) creates and noticed:

Good evenig to all, I use Access 2000 and i want to build a database for my photographs (jpeg files). All the 3 methods I saw make the base grow up. Is it a activeX control which could display the picture without importing it in the base ? and where could I find it. Thank you Alan

I have an ACCESS db from a DEXA machine (bone scanner). The data is in seperate tables and I want to link them so that I can query and create one table with all the data I need from the seperate tables. When I try to create a query with multiple tables in design view, if I run it to see the data view, only the names of the columns appear, but...

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

Is there any way to do this on a form in Access 97? If the value of a combo box is .5, I want two check boxes to be visible (labels are a.m and p.m.). If the value of the combo box is 1, I want the two check boxes to be invisible. Thanks, JD

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...

Here's what I have and I'm stumped. I have a table that has several thousand names and addresses. I only want to send to one address in a household. So what I would like to do is create a new column that runs a macro or whatever it takes to flag records so they are housholded. Some records have a Father and son at the same address, so I would...

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...

My table has a record called date/time - filled (not surprisingly) with a date and time. I can format the date in one query field, also the time, using format in an expression. My user wants me to provide a listing of all table entries between 22:00 and 07:30 the next day, between a given set of dates (typically one week apart but in...

How can I write an update query that removes part of a field? Like if I have a field with values such as 8/3/68 (a birthday obviously) and I need to put values in a new column but I need everything after and including the final / removed to end up with simply 8/3

Let's say that I use send object and I want to build a body text (string) of a few hundreds digits as follow; My regular multilines paragraph. XXXXXXXX XXXXXX XXXXXXX XXXXXXXXXXXX XXXXXXX XXXXXXXXXX XXXXX XXXX XXXX XXX XXX TITLE1 TITLE2 TITLE3 data1a data2a data3a data1b data2b data3b data1c ...