Microsoft Access / VBA Forum

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

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

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

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

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

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)

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

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?

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

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

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

Hi All, I am working on a sub that will loop through a recordset and validate that the ranges are valid, ie no overlapping values - no gaps in the ranges. I am pretty sure I have the validation part right but not sure since I keep getting an error message "Compile Error: Loop without Do". Of course I have a Do in the code and have looked...

Okay, I'm having a really strange problem. I have a user who is trying to print an MS Access 2k database. She gives it the print command, and that's it. It never prints. She waited once 3 hours after telling it to print and it never did. To make matters worse, if she goes to another PC right near her, it prints without a hitch. She...

Hello, Perhaps a stupid question, but anyway : I am using an Access 2000/XP base to to register and handle deviations in my lab.For each deviation I make a Word-file (or Excel). In each row in a form, I put in the path and name of the word-file. When double-clicking the file name the word-file opens. My question is :

We are using hyperlinks quite extensively in our Access XP application, and would like to control the working directory (default folder) used by the Insert Hyperlink dialog. Thanks in advance for any ideas...

Could anyone tell me if they have experienced any problems with MS Access 2000 especially if their database contains over 20,000 records. I have found that once I have grown the database to over 10,000 Access starts doing some strange things. For instance, I have a column in my main table that allows me to place a check mark next to those...

I'm trying to capture when a user presses a particular key (escape), so I'm coding in the KeyPress event. Yet the code seems be bypassed (breakpoint is never encountered). Should I be coding in a different event? Is this a known issue? FYI, this is happening in both Access 97 and 2000.

Is there anyway I can enter the words bellow in a query Field? This line has to be added to every line. That's the way I have to submit my filtered table. Thanks <p><img border="0" src="http://abcdefg.com/images/

Hi all, I have a general question and a specific problem. We make extensive use of amatuer Access97 dbs at work over NT4 but have restricted access as we are forbidden to cross over a LAN. Can someone explain, or point me to websites, about good network practice in terms of loading forms based on tables, running queries that either return...

I have several Access 97' applications I would like to convert to Access 2000. I would also like to create run time versions of some applications with the Office 2000 Developer package (I have used the 97' Access Developer's Toolkit). I am running Windows 98 and would like to stay with that OS if possible (or recommended). I have the...

I'd like to add an 'Admin' form to my db, just a plain and simple (!) form with 7 buttons, each button just runs macro1, macro2, macro3 and so on. But - I'd like each button to only have focus after the preceding button has been pressed (and the macro run). I'd like to fire this form up from the db's startup form, and allow only 2 or 3 users...

Hi, I have the following lines of code: stLinkCriteria = " BETWEEN " & & " AND " & DoCmd.OpenForm stDocName, , , stLinkCriteria Every time I try and run this I get the following error: Run-Time Error 2501 The OpenForm action was cancelled.

I need a SQL query that will return row1 and 2. The rule would be "2 (and only 2) occurences of Store_Number where Forms_Count is not the same. Store_Number Forms_count 3 5 3 6 4 8 5 14 6 2

I'm running a batch file using the Shell function. When I manually launch the batch file, the window remains open, since I use the 'pause' statement. But when I launch the batch file within Access, the Shell window becomes a blip on the screen and then is gone. Why does the Shell window not stay open on the screen? I want to visually...

hi there, if i buy a copy of access2000 today (new), will i have to register the copy with Microsoft in order for it to work (like 2002)? will the program not work (not install) otherwise? or are the older versions still useable without registration. thanks, deb