Microsoft Access / VBA Forum

Hi everyone, I am trying to create a single window interface for my database. As I am using Access 2007, I have my document layout options set to tabbed documents without displaying documents tabs in order to get my main form to appear as the only element in the access application window. I have also set anchoring in the form so that controls...

Hi everyone, I have done some searches and come up with no definitive answer. Is it possible to select a specific item in a list box with vba code in Access 2007 Thanks in advance for your help, Ken.

Are the following two validation the same: 1) IsNull(Me.ColumnName) and Me.ColumnName = "" 2) Me.ColumnName """ It would seem to be better to use: Me.ColumnName """

Dear Newsgroup, Is there a function in Access XP to take a date or month , and return the last day in that month? Ex: the last day in september is 30 or the last day in May is 31 . Thank you very much, Gol

Say a number of people have 2 or 3 addresses each in a query result. How do I select only the first address displayed for each person. For example: John Taylor 33 Dundas Ave. John Taylor 55 Shane Ave. John Taylor 786 Edward St. Ted Charles 785 Bloor St. Ted Charles 90 New York Ave.

I want to have a second combo box have its selection options based on a selection made in a first combo box. The first one gathers data from a table, and the second one should gather data from a related table depending on the selections of the first. Using the wizard will give me a specific field but will not have a WHERE clause. Is there...

Eh, probably not the most specific subject line... But, I've got a number of fields in which I need to do things like remove the first 4 characters, or remove the last 3. Such as: F300006745 Remove first 4 to leave

I am trying to save the current record on a form before opening a report, doesn’t sound to hard does it? The code on a buttons on click event goes like this: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 'First save record I used this for many years with problems using Access 97, when the database is upgraded to...

Cascading Combo/List Boxes This tutorial is to guide you in the creation of Cascading combo/list boxes. That is when you have multiple combo/list boxes where the selection of an option in one determines the available options in the other. TERMINOLOGY Row Source: The table/query from which the Combo Box or List Box gets its values. Note:...

I am assuming this is an easy fix but I want to open a form from a switchboard button. I also want the form to automatically open to the last record of that form. Any ideas on how I can accomplish this? Thanks! Adam

Hello All, i have a listbox control named lstDisplay. I have added items to the list using the additem method. But when i tried clearing the listbox using Clear method i cannot find it. i searched for the listbox control's methods and properties using the object browser but cant find Clear in it. Please help.....Access 2003 Thanks Sassy2009

How do I use VBA to insert a *new* record into a subform? I have a master form with client information, and a sub form with billing information. I want to click on a button ("Add Data") and have a record inserted into the subform's table, with date created and some information from the main table inserted into the proper fields in the...

Seldom does a Database Designer build a Database for themselves and themselves alone. It’s usually built around the requirements of a Customer. Many times, the Database will have multiple Users, and these various Users may (or may not) perform different functions within the Database. MS Access offers a bit of security with passwords that can...

Hello all, I am trying to handle a scenario where a user clicks the 'X' close control on a form window border. I want to force the user to use the form's 'save' button to write the updated record. (If the form is not dirty, the 'X' control will just close it silently.) In the BeforeUpdate event I ask the user if they want to discard their...

Hi all, Here is my dilemma. I have two tables, one called HS DATA and one called ImportedHighSchools. Both tables contain an ID code for each record.

I am trying to insert an employee number into the EmpNbr field in my main table from a form where I add a new employee to my employee table. I was hoping this command would work, but it isn't. DoCmd.RunSQL "INSERT INTO VALUES ()", 0 This is the only field I want to populate in the main table from this form. there are three other fields...

The following code is simply an example of some code that processes through two recordsets. It can be helpful for anyone curious as to how to start processing with recordsets (Which objects to refer to & how to set them up correctly etc), as well as for those who want a quick run-through of some basic multi-recordset logic. Function...

I have a database I originally created on a 32 bit machine, which needs the front end updating, but my computer is 64 bit, and so therefore none of the code runs. However, I don't want to convert the database to 64 bit if I can help it, as all the machines it will be running on are 32 bit, I just need to edit it. All are running Access 2010, and...

Hi all, I have a macro that executes ~200 queries which modify the data, create some tables etc. The macro runs when the user clicks a button on a form. I would like the queries to be invisible while they are running, but currently the user sees 50+ query windows open/close which is ugly. Is there a way to automatically minimize/hide query...

How can I increase the size of the Checkbox used on a form? I can see its going to become a problem for some of the users on my application. (I personally think they could do with a little size increase also) G'Day From downunder.. Rob.

If you are in the VBA section of a form and want to refer to a control on that form then the quickest most efficient way of achieving a connection to this control would be the most direct Me!NewData. (Copied from MS Access help file) also found here: http://msdn2.microsoft.com/en-us/library/aa223099(office.11).aspx ' Implicitly refer to...

I think I may have lost the plot. Just a few years ago I'm sure I wrote something similar to the following code: dim rst as recordset set rst = currentdb.openrecordset("mytable") ' blah blah blah rst.close

Introduction The Advanced Encryption Standard is the algorithm that won the National Insitute of Standards and Technology's (NIST) search for a standardized encryption algorithm in 2001. In 2002, it was adopted by the U.S. government as a stadard for encryption. It is based on the Rijndael algorithm. Even though it was chosen by NIST, it was...

I am having a problem with a relatively simple sql query, and was hoping that somebody could help me on this forum. Basicaly the situation is that I have two tables, a Vendors table (Vendors) and a ProductCatalogue table (ProdCat). I wish to select the VendorID, and VendorName from the vendors table. Additionally I want to run a subquery...

Hi all, I'm trying to update a record in a table with data from text boxes on a form. As a background to this, I managed to add a new record to the table in a similar manner with the following: Set db = CurrentDb Set rs = db.OpenRecordset("Project Table") rs.AddNew rs("Project_Number") = Me!