Microsoft Access / VBA Forum

An Access 97 database is running quite happily on about 30 IBM ThinkPads. Some of the users, however, have now installed some components of Office 2000 like Word and Excel. On those machines, the A97 db now only stores dates in American date format, so that a British date entered as 23/04/03, for example, is stored as 03/04/23. Existing dates...

Hello, Is it possible to open MDE files for editing in Access? How if possible? Regards, Vladimir.

Hello, Does MS Access support subj like that SELECT * FROM ? What is the syntax of SQL statement to use with OLE DB (for example, Jet OLE DB Provider)? Regards, Vladimir.

I am trying to use the string or string$ (I don't know the difference) function to convert a number to string, but I do not know what the obligatory arguments 2nd & 3d stand for. Thanks for your Help,

Hello, I am having some troubles and was hoping for some help. I have created links to DB2 tables using DB2 Connect I have multiple queries that I run each day and I need to provide them with a date to use in the query. I am trying to set up a textbox on my main form that I will enter the date into and then use that in the queries.

Can you please help me with an Access 2000 matter; I want to produce a simple database, which will store images and associated text such as the image name. You would add the images by clicking on a add button, and if you wanted to remove them you would use the delete command.

I am trying to run a query from the Visual Basic side of Access. What i want to do is have the program input a variable (employer name) into the "conditions" of the query. The variable should come from a For Loop that goes through each employer name in a table and inputs the specific employer name into the query conditions, run the query, and...

Hello, I have just inherited a legacy Access 97 database. While going through it, I noticed something strange... its Relationships window (the one accessed by Tools --> Relationships) is almost empty. Now, as I ponder how a relation database could work without any relationships, I noticed that the queries of the database defined some...

Hello, Have any of you ever controlled MS Access Replication from a VB application? I have a VB6 application where I have to send copies of the underlying MS Access 2000 database in remote areas (no LAN or Internet connections), then get the databases back and synchronize them. Any suggestions, articles, etc. would be greatly...

Hello, I am using an access 2000 project with sql srv 2000 as an administrative tool to edit table data. I select the table names from a combobox in an access form and use myform.SourceObject = Table.dbo.mytable StoredProcedure.dbo.sp_xxx etc. wich gives me the error message "The form name you entered doesn't follow Microsoft Access...

Hi, I am planning a hidden administrative form in an access 2000 adp/ade through which I could run vba functions or procedures just as I can use them in the direct vba window in vba editor. Thought about a textfield to put in the vba command an run it after click on a cmd button: e.g.:...

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

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

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

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

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

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

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/

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.

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

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

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 :

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

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