Stack Overflow
Stack Overflow

Questions tagged [ms-access-2007]

Microsoft Access 2007 - a rapid database application development tool

Microsoft Access 2007, also known as Microsoft Office Access 2007, is a rapid application database development tool.

Microsoft Office Access 2007 reached its end of extended support on October 10, 2017

It commonly uses the Jet or ACE database engine, but is not limited to these.

It is a member of the suite of applications, included in the Professional and higher editions or sold separately. Applications built with Microsoft Access can be distributed to end users with a free runtime version of the application that lets them view databases without needing the full installation of Access.

Please tag your question so others know what version you are using. Tag your question with if your question involves VBA.

Links:

4371 questions
1
vote
1 answer

How can a reference fields on an Access form using a variable?

I have 20 text boxes on an Access 2010 form called [P101] to [P110] which refers to fields [P101] to [P110] in the source table. The may contain a value or not, but if not I do not want to see them. I also have a field [UsedFields] in the table…
user3083607
  • 11
  • 1
  • 2
1
vote
1 answer

Automatic Email Function

I have a code for private sub function for sending automatic emails. I sourced the code from Pete Leaning ACCESS 2007 - Automatically Send and Email Using Outlook Upon a Specific Event I attempted to turn it into a function myself using the code…
ASM2701
  • 139
  • 7
  • 19
1
vote
1 answer

How to match unequal data sets with unclear common terms?

I have two sets of data, list A and list B. List A is defined as the master list. Everything on this list must be accounted for in the final match. Let's say it has 500 rows of data like DBA, address, city, country, etc. List B is 6,000 rows with…
user3081053
  • 11
  • 1
1
vote
1 answer

Form Dlookup textbox Control Source

I am building a form and having trouble with getting the DLookup to function correctly. Here is what I have. I have a query which contains employee information relating to Profits and Loss. so things like name, salary, etc. Now I am creating a form…
Mr. Finn
  • 99
  • 3
  • 13
1
vote
1 answer

Form Opens blank in form view

I have a database system that logs calls for a department. All the calls for today are displayed on a main form in a list box. When a record is double clicked the call can be opened to view the information. This information is stored across two…
ASM2701
  • 139
  • 7
  • 19
1
vote
1 answer

Checkbox controls subform visibility - how to keep it visible when form is reopened?

A checkbox controls whether a subform is visible. If the checkbox is "true," the subform is visible. The problem is, when I close and reopen the form the subform is no longer visible even though the checkbox is still true. I have to uncheck and…
user3072609
  • 11
  • 2
1
vote
1 answer

Use VBA to determine if a table can be edited

I have the following procedure in Form_Load: Dim accObject As Access.AccessObject For Each accObject In CurrentData.AllTables Me.cboSelectTable.AddItem accObject.Name Next This populates the combo box with ALL the tables including system…
user2137354
1
vote
1 answer

Why won't my sql command work on asp when it showed the correct result in ACCESS?

Now that I have help from this forum's,I have the sql command which can produce the correct result in ACCESS. However when I brought that to use in ASP the error said like this.. Microsoft JET Database Engine error '80040e14' The SELECT statement…
Alxan
  • 295
  • 2
  • 5
  • 16
1
vote
1 answer

How to add where clause in access join query

I have query like this. SELECT account.AccountNumber, account.Name, Sum(agro.price*agro.qty) AS Expr1 FROM account,data INNER JOIN (agro INNER JOIN data ON agro.BillNo = data.BillNo) ON account.AccountNumber = data.acno GROUP BY…
Hiren Raiyani
  • 754
  • 2
  • 12
  • 28
1
vote
1 answer

stop enter from going new record access 2007 vba

I have a form (split form) and i want to prevent access from creating a new record when the user reaches the final field of form and hit the enter key. I already tried to change the Cycle property in the Other tab and didn't work By split form i…
ocr
  • 51
  • 4
1
vote
1 answer

Add-ins not loading when opening MS Access 2007 a second time

I have some add-ins that are used with an MS Access 2007 .accdb application. When I open the .accdb file --the first time-- (after logging into the PC), the add-ins initialize/load successfully. If I then close MS Access 2007, the second (and…
ragazzi
  • 11
  • 2
1
vote
2 answers

Expression Too Complex Access 2007, how can I simplify this IIF sequence?

I am running the below complex statement to provide an value in Column "SODist" that increments for each successive matching value in the "SalesOrderNo" field. I use an "ID" as auto-number to simulate a "row number" function but I need to scale…
Mike Dowdal
  • 23
  • 5
1
vote
1 answer

database search via username

I'm developing a call log system, and for tracking purposes the manager wants each user to be logged in upon entry. I have a module that displays the current logged on user with the code below. I would like for the system to search the table…
ASM2701
  • 139
  • 7
  • 19
1
vote
1 answer

Optional Access column value selection

I have an Access table that looks like this: A | B | C | Final 1 | | | 1 2 | 3 | | 4 | 4 | | 4 5 | 5 | 5 | 5 | 4 | 1 | 9 | 2 | 4 | The values with an asterisk below are the goal. I need a script that can choose between n-columns that…
user1685185
1
vote
3 answers

How do I select records with max from id column if two of three other fields are identical

I have a table that stores costs for consumables. consumable_cost_id consumable_type_id from_date cost 1 1 01/01/2000 £10.95 2 2 01/01/2000 £5.95 3 3 …
Andrew
  • 13
  • 3
1 2 3
…
99 100