Microsoft Access / VBA Forum

In a form, when you arrive in a new record, what event is trigerred and in which object? I can't find such an event. I need to reset a value when the user arrives in a next record. Thanks, john

When entering a value to a field, is there a way to make only the first letter upper case without using the Shift Key? For example, entering a name.

Good morning people, I wish to use VBA to open an Access Query, loop through each record, and then based on the result of a certain field create calculations in which i wish to place as a new record in a new table. If anyone out there can give be the basic code that will : - Collect the Data, Loop through data create a new table post...

All, I am trying to have something happen on a form whenever the record selectors are clicked. This is access 2003. I tried the form's click event and that does not work at all. Anyone know how I can get a procedure to trigger everytime the form's record selector is pressed? Thanks to everyone. This is driving me crazy and any help that...

Hi, When I do the following in vba: Set rst = db.OpenRecordset(sql) I get the too few parameters (expected 3) error. I've seen quite a lot of this on google but all seem to be caused by incorrect sql, but mine works fine when I print it out into a query. From what I can tell the parameters are optional so I don't really understand...

I'm fairly new to this so I'll try to be as clear as possible. I have a database that stores employee information and all job titles available. I have a main form that is based from a query and displays all job codes and job titles in the Job table. I also have a text box in the main form to keep track of the total number of positions available...

I recently had occasion to want to export the results of a query from Access to Excel using FileDialog. I found researching it that there was a lot of confusion regarding whether SaveAs could even be used in Access and couldn't find a simple routine. I experimented a little and came up with the following which works perfectly. Although I...

What's the trick to running a batch file from VBA? I'm trying to call it using the Shell function but it's not working for me. If I double-click the batch file or run it from the command line it works. I've tried: RetVal = Shell("cmd /c clean.bat", vbNormalFocus) RetVal = Shell("clean.bat", vbNormalFocus) RetVal = Shell("<full...

How can I print the current page of the form on a button click? Thanks in advance

Hey all, I am using Access 2007 and tried to import an excel file by using the Import Wizard. I completed all steps and received an error when I clicked "Finish"... the error came back as "Subscript Out of Range" I googled and lived the issue, but did not find any helpful information. Any suggestions out there J -

Hi, Using MS Access 2000, is it possible to run a UPDATE or INSERT SQL query using some form of conditional IF THEN ?? for example: SELECT * FROM Books IF EXISTS(Select Books.ID = 1)

How do I get the date for the first and last day of the week, and the first and last day of last week?

Hello I may be a little to late but happy newyear to yot all ;-) I need to copy a text into the clipboard in VBA in ACCESS. This means that I have to code it using VBA. When i goto Word then I can paste the string into the worddocument.

I tried Googling this but I get a whole lot of replies about running the SQL statement in VB via ADO. All I want to do is run an existing ACCESS 2000 query from VB with no information returned to VB. I am presuming that I would use Automation somehow. Thanks in advance.

Hello, I'm looking for a way to reference the string name of an enumerator. I know in VB.net you can do "MyEnum.ToString" and get the name instead of the integer value. Is there a way I can do something similar with an Enum created in Access? Alright, here is some air code to explain what I mean Public Enum MyEnum

Hi all, I have two tables with a many-to-many relationship which is causing many problems. My parent and child forms are linked via a junction table. I want to make it possible to create a read-only version of the child table so that you don't have to link to it from the parent table. A form linking the two together has been created with a...

Hey All; I have a form with a ComboBox. I populate the ComboBox with the following query: SELECT ., . FROM customers ORDER BY .; This query populates the comboBox with all the customer names from the customer table. I want to be able to select a customer from the comboBox and pass it as a parameter to another query, but what I keep...

Does anyone know if it is possible to close all objects in a database (tables, forms, queries etc.) using VBA code? I have not been able to find anything online to help me so far... My motivation for doing this is the following: I have two databases, call them A and B. - Database A is linked to a table in database B. - Database B is...

I need to update a record in a table if the record allready exists, but if it does not exist, I need to insert the record. Is there a 1-step SQL way of doing this? I can easily perform the 2 step approach, of using a dLookup to determine if it exists, and based on that do either the Insert or Update, I'm just trying to work smarter, not...

Hello! I have two textboxes and a multicolumn listbox on the form. User enters first name in one textbox and last name in the other. After "submit" button is clicked I want first and last name to be displayed in the listbox (first name in column 0 and last name in column 1). Can anyone help me with what list function I should use? I've tried...

Hello All, I am trying to debug a broken query. The query uses Left$(,4) instead of Left(,4). What is the difference between the Left() and Left$() functions in Microsoft Access? Thanks! --

Can anyone point me to VB/VBA code that will control a TWAIN-compliant scanner?

I am building a form to simulate the Access 2000-2003 database window, to use in Access 2007 so my users don't freak out with the new interface. I have a program called Resource Extractor form Alchemy Mindworks that allows extracting bitmaps and icons from EXE and DLL files, but I can't seem to find which file has the Access icons embedded. ...

We often get questions on this site that refer to the scope of variables and where and how they are declared. This tutorial is intended to cover the basics of variable scope in VBA for MS Access. For the sake of brevity I am sticking to common usage. Wherever the term procedure is used in this tutorial it actually refers to a subroutine or...

One question which pops up frequently here at TheScripts is: 'How do I retrieve data from a Recordset once I've created it?' One very efficient, and not that often used approach, is the GetRows() Method of the Recordset Object. This Method varies slightly from DAO to ADO, so for purposes of this discussion, we'll be talking about DAO Recordsets....