Newest 'ms-access-2010' Questions - Page 62 - Stack Overflow

Questions tagged [ms-access-2010]

Microsoft Access 2010 Personal Relational Database Management System.

Filter by
Sorted by
Tagged with
0
votes
1answer
2k views

Calling a SQL server procedure from a function in VBA

I am trying to call a SQL Server procedure to validate user from a function in VBA. Please see the code below: proc_validate_user accepts userId and password as input parameters and returns a bit ...
1
vote
0answers
105 views

shorten sql union all

Is there a way to use the select and where statements once when using Union All? Don't want to repeat it again and again SELECT PayrollNo FROM Table1 where PayrollNo like 99 UNION ALL SELECT ...
1
vote
1answer
224 views

how to locate a hyperlink field

I have an access 2010 table with a hyperlink field where i store the E-Mail adress of clients. Before I add a new E-Mail I want to check if the E-Mail address is already there. I try to use a locate ...
0
votes
1answer
548 views

Reset password subform

I come to you today to ask some advise about a coding in which I still have issues. It was working at the beginning as it was in a normal form, but then I decided to adapt it to the real situation ...
2
votes
1answer
565 views

Calling a UDF (Sql server) from VB Access “Undefined function <function name> in expression”

I am trying to call a udf (SQL server) from Vb code in access. Connection to DB was successful and I am able to run queries on SQL server tables. However, when I try to call the UDF, it throws me an ...
2
votes
1answer
483 views

“Bookmark not valid” error in Access database

I have a simple application that writes data from a MySQL database into an Access .accdb database. I have used it for 4 months and I haven't had any problems. Yesterday I tried to use it and now I ...
0
votes
1answer
2k views

Field Values to Column Names in MS Access SQL

How do I convert this: Name Attributes ---- ---------- John Height John Weight John Age Mary Shoe Size Mary Hair Color Mary Eye Color to this: Height Weight Age Name ...
1
vote
0answers
105 views

java.lang.AbstractMethodError: com.hxtt.sql.by.bu()Lcom/hxtt/global/a0;

I am trying to work with MS ACCESS and Hibernate. And I caught such exception: Exception in Application init method java.lang.reflect.InvocationTargetException at sun.reflect....
0
votes
3answers
1k views

sql Select query only when a condition is met

In MS Access I have a two-column table (publications) that includes authors' names and the year they published their articles. author year Davis A 1973 Boyd B 1973 ...
0
votes
1answer
4k views

Find and delete duplicates only if two fields have matching data Ms Access

I want to create a query that would find and delete duplicates only if two fields have matching data. Not meaning those two fields match exactly, like field A and field B both have "unprocessed" but ...
1
vote
2answers
412 views

ADO Command in VBA

I'm using Access 2010 with Excel 2010 and I'd like to perform a query using ADO Command. See below what I did in Excel VBA: Public Sub test() On Error GoTo TrataErro Dim cnn As ADODB.Connection Dim ...
0
votes
1answer
191 views

Editing Records in MS Access

I am using MS Access (2002-2003 file format) and in the file I have a form. When I click on the form, I get a table with records. I would like to edit those records, and want that edited records are ...
1
vote
1answer
363 views

MSAccess not opening database when started using System.Diagnostics.Process.Start()

I am having trouble to start an Access Database (msaccess.mdb) programmatically using System.Diagnostics.Process.Start(). This is the Scenario: vb.net aspx page starts [installpath]\cmd\ERPImport....
0
votes
2answers
1k views

Access 2010 Login Form won't close itself

I have a database with a login form, and upon a successful login the main navigation form is supposed to open and the login form is supposed to close... except that the login form refuses to close ...
0
votes
2answers
6k views

MS Access - Track changes made to existing table into another table (using table datasheet view - not form)

I want to be able to track any changes made to any of the fields in an existing table. The scenario is as follows: the user opens the datasheet view for an existing table in MS Access 2007/2010 ...
0
votes
0answers
287 views

COUNT function when grouping a union query in Access

A legacy database has an association class represented as several fields. Even if the association class doesn't get normalized, I need to standardize the values to remove minor spelling variations. ...
0
votes
1answer
70 views

Returning unique values in a MS Access query based upon a set a rules

I have a query that returns a dataset with UserID, CourseID, Course Completion date, Course Registration Date and Status (successful, not attempted, not finished). However people are allowed to do a ...
0
votes
1answer
36 views

insert data to a record already saved to a table

I have a recordset that is missing one field for each record and would like to add some data from a form by looking up certain criteria. I used a select query to get data onto the form in the first ...
0
votes
2answers
2k views

Access VBA function While…Wend or Do …Loop

I am working on a function for my access database that fills in a form field in my task form automatically based on the data entered in products forms. Function IsProductReceived(varID As ...
1
vote
2answers
562 views

ordering query by grouped, calculated field

In an MS Access 2010 database, I am trying to design a query that will return results ordered by the ratio of the sums of two grouped fields. But my attempts so far are resulting in an immediate ...
1
vote
2answers
1k views

Set Text Box equal to Query

I have a query in an Access Db that counts the number of observations that meet a certain criteria as defined by two comboboxes. The query works fine, and I can get the result of the query to display ...
0
votes
1answer
1k views

Access - Drop Down List Open Form

Please be gentle, i'm new to access but I'm trying to create a down down list that opens forms. I've done a fair bit of Google searches and not really found anything. On my ComboBox on both "After ...
0
votes
1answer
662 views

Access Query - Not Like

I have a Access DB with a customer list that needs to be contacted. As soon as the person has finished contacting the customer the "Status" column should be updated to "Done" or "Call Back" or "...
1
vote
2answers
46 views

Converting null/empty fields to the value from another field

In an MS Access 2010 database, SomeTable has two fields named Field1 and Field2. The actual data always includes values for Field1, but there are often missing values for Field2. Both Field1 and ...
-1
votes
1answer
50 views

SELECT DISTINCT query with numeric totals of other field for each distinct

How do I write the following SELECT query in an MS Access 2010 database? Here is the situation: Kids in school get put in detention for bad behavior. Some parents have numerous kids. How can I ...
0
votes
1answer
72 views

How To Reduce Database Size

So I've had a database for some time now, accumulated some 20 tables with a variety of records per table. I've since made a copy of the database and pretty much gutted everything except one table, ...
0
votes
1answer
746 views

Access - User tacking history system

I am designing an Access database and I would like to set up a user history tracking system. My Objective: Save all the logins and users actions (login attempts and searches) Doing so, I got 1 table ...
0
votes
2answers
1k views

Search and filter in MS Access forms

Background: I have a table named 'SNR_log', out of which I have queried to obtain below list. Next,I designed a split form, with a text box.In this text box SNR is enterted to find and filter from ...
1
vote
3answers
2k views

Get VBA to Evaluate Formula In String

I have a table that stores a string representing a formula that I would like to have either Access or VBA evaluate. A few example strings look like: table.FirstName & ' ' & table.LastName ...
2
votes
1answer
1k views

MS Access 2010 Import Specification Location?

I have an MS Access DB where the Saved Imports inside the External Data has Import Jobs which are actually importing certain data from various locations to SOME tables. I am unable to find out which ...
1
vote
1answer
1k views

disabling the bypass key

I would like to disable the bypass key of my database on the open form event during the autoexec so that the user is not able to view the underlying tables of my form. I have found the following code ...
1
vote
1answer
5k views

Microsoft Access Compact and Repair using C# .accdb files

I need to Compact and Repair .accdb (last MS Access) version using C# I tried using this: var jroEngine = new JRO.JetEngineClass(); var old_ = Provider=Microsoft.ACE.OLEDB.12.0;Data Source='c:\a....
1
vote
0answers
993 views

MS Access Stored Procedure and Sql from VB.NET

I have built a system in VB.NET where all the sql is automatically generated and executed with CommandType.Text (default). In addition I have created a stored procedure in my access database I wish to ...
0
votes
1answer
40 views

Model doesn't accept its value

This code doesn't accept the values I give with the user's department data. If i replace user.Department.ID with just a simple int variable, it works fine. This is also the problem with user....
1
vote
1answer
224 views

Subform won't add new records

In MS Access, I have a form directly from a table and a subform connected to a query. The reason the subform is connected to the query is because I only want the user to add data for the current month ...
1
vote
0answers
37 views

what vba references do I need for access 10 app

So I was given a access 2010 application. I'm trying to deploy it and it was developed in access 2010 sp2. The end users do not have access on their laptops so I installed access runtime 2010. I'm now ...
1
vote
1answer
394 views

VBA:importing CSV file

I created a button in ms access to import csv file into access database something like this DoCmd.TransferText TransferType:=acLinkDelim, TableName:="student", _ FileName:="C:\Saurabh\test.csv", ...
1
vote
2answers
9k views

calculating age in years and months in Microsoft Access (2010)

I have two fields (Date of Physical Exam and Date of Birth). I calculated the age in years((Date of Physical Exam- Date of Birth)/365.25). What I want to do is calculate age in years and months in ...
0
votes
1answer
61 views

SQL Server connection to local MS Access 2010

I have created a relational database in MS Access 2010. Till now it is local and one user access only. Now i need to make it multi-user friendly. So is it possible to connect local MS Access software ...
1
vote
1answer
1k views

Access SQL unique records with latest date including null dates from single table

I have a table with the following sample structure: Identifier| Latitude | Longitude |...many columns...|DateWhenStatusObserved|ID| ----------+----------+---------- +------------------+---------------...
0
votes
2answers
3k views

VBA/Access: Removing warning prompts

I've built a Macro that runs 7 queries. The macro works exactly like I want, but because they are update and append queries Access prompts the user to approve of the updates and appendages. I would ...
2
votes
2answers
1k views

Access Rich Text to Word via VBA: Formatting Ignored and Added Linebreak

Goal I'm publishing data from our access database to word via VBA. Some of the content being published is in rich text format, and some of it is being formatted on the fly using HTML, and I'm using ....
0
votes
1answer
28 views

Method for logging user access

Goal: Keep table of user logins and write a record on exit Tried using API code to get Windows ID with idea of writing it after that. Couldn't access the function. Thought about using a username ...
0
votes
1answer
2k views

Setting up a microsoft access database connection with node.js

Hy guys, I recently started looking into node.js, and I decided to rewrite all the php code to javascript code. That all went well, but now I'm trying to set up a database connection to a microsoft ...
-2
votes
1answer
509 views

Cant insert data in database (Access) VB.NET

Im working on a project. Our system is Hotel Reservation. In VB it says that it added in my database but then when I check my database there is none. What is the problem btw Here's the code: Public ...
0
votes
2answers
3k views

Access VBA: SUB designed to refresh an Excel Spreadsheet giving an error

Relative VBA newbie here. I created a new Module "QCDataRefresh" with a Public Sub "RefreshExcel" that is designed to open an Excel spreadsheet (housed on my network drive) in the background and ...
1
vote
2answers
2k views

Access query: Sort date logically, not alphabetically

SQL for query is: SELECT DISTINCTROW Format$([Client Accounting].[Closing Date],'mmmm') AS [Month], Count([Client Accounting].[Loan Number]) AS [DB Error #], Sum([Client Accounting].[Write Off]) AS [...
1
vote
1answer
4k views

Wrap text in a list box - ms access 2010

I have a list box in MS Access which retrieves results from a query. The Fourth Column contains text which is pretty long and I am wondering if I can add additional code to wrap the text in the ...
2
votes
1answer
1k views

Data Macros: Using default values if LookupRecord does not find a match

I have been trying to set-up a Data Macro on one of the tables in Ms Access to add a 'path' and increment a level based on a parent record in the same table. Before Change, if the parent node doesn't ...
-1
votes
2answers
91 views

Vb from Access importing data from multiple tables

I have the following code in visual basic which currently allows data from one table to populate a form. I need to be able to select data from another table and add that data onto the same form ...

1
60 61
62
63 64
118