ms-access-2007 Questions
2
Solved
How to select Data in ms access above this datetime range
like select * from logevents where logTime>='12/6/2012 3:54:15 PM'
logTime is Datetime field
Swiftlet asked 7/12, 2012 at 19:15
4
Solved
I developed a windows application, back end DB is Access 2007. I heard that max limit of Access 2007 is 2GB.
Now my question is, is there any way to increase the size beyond that limit? How to cre...
Revisory asked 29/6, 2012 at 6:53
4
Solved
Like a lot of developers who are comfortable with SQL syntax I get frustrated when working with Access's query editor. I'm talking about the raw SQL Syntax view, obviously.
One of its many annoyin...
Piddle asked 8/11, 2011 at 11:15
6
Solved
So the function =Now()....is there a way I can use this and only get the date, not the time?
or is there just a function for this idea?
Terris asked 24/6, 2010 at 1:10
2
Solved
It would be nice if there was a right-mouse-click menu on the edit panel to change the font size, but there isn't.
Is there a system setting somewhere else that lets me increase the default font ...
Morel asked 21/10, 2009 at 6:35
3
Solved
Is it possible to connect to a web service (for example send a HTTP Request) via VBA in Microsoft Access?
For example, the user clicks a button on a form, then a HTTP Request is sent to a web servi...
Satisfaction asked 26/3, 2013 at 18:2
3
I'm running MS Access 2007, connecting to a MS SQL 2008 R2 server. I have a form with a multiselect box that I use to update status for several fields for the servers selected. Currently I'm using ...
Coldshoulder asked 15/11, 2013 at 15:46
2
Solved
If I use RecordsAffected with CurrentDb.Execute, it always returns 0. If I first make a instance of a Database object it works properly. Why?
Like this:
Dim Db As Database
Set Db = CurrentDb
Db....
Aulos asked 9/6, 2010 at 8:30
5
Solved
I am in charge for migrating old Access 2007 project to MS SQL server 2008 Express. The first stage is to move all the data from MS Access database to SQL server while keeping the Access forms and ...
Ophite asked 1/2, 2012 at 9:12
7
Solved
I am using Microsoft Access 2007 to move and massage some data between two SQL Servers. Yesterday everything was working correctly, I was able to run queries, update data, and delete data.
Today I...
Puttyroot asked 19/9, 2008 at 13:25
2
I typed this code to create a view in a pre created database:
CREATE VIEW NHTrips AS
SELECT TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type, Season
FROM Trip
WHERE State = 'NH' ...
Terzas asked 24/9, 2015 at 20:28
2
Solved
I have an access 2003 (mdb) database on housing projects I update for our local planning office on a quarterly basis. Other folks in our office could benefit from seeing the same data. I thought th...
Impost asked 7/10, 2013 at 19:3
4
Solved
In the Microsoft Access 2007 with an SQL Server Backend, we usually take a linked table from the SQL Server as Form.RecordSource of an editable form for a single table data modification. A local qu...
Nanji asked 19/9, 2013 at 14:53
1
This is one of the stranger issues I have seen in MS Access. I have the following code in a continuous form:
Private Sub thisForm_BeforeUpdate(Cancel As Integer)
If Not Cancel Then
Debug.Print "p...
Gaul asked 13/1, 2012 at 21:42
2
Solved
I'm trying to make a query like so:
UPDATE table1 SET col1 = 'foo', col2 = 'bar';
UPDATE table2 SET hi = 'bye', bye = 'hi';
But when I go to save, Access errors with:
Characters found after e...
Fin asked 25/9, 2012 at 11:27
3
Solved
Just getting to grips some VBA (this stuff's new to me so bear with us!)
From query ContactDetails_SurveySoftOutcomes, I'm trying to first find a list of all the unique values in the DeptName fie...
Varicolored asked 2/5, 2013 at 10:43
3
Solved
Is there a way in Access to search for a certain text in object properties and so on? Just not only in the VBA source code.
I'm asking this because if I change for example the name of a field in a...
Chuff asked 20/6, 2011 at 9:6
3
Solved
I need to version control a Microsoft Access 2007 database and application. Currently everything is contained in a single mdb file.
The application includes:
Forms
VBA code
Actual database
I w...
Crust asked 5/7, 2009 at 20:53
3
Solved
Objective:
The intent of this query is to select all of the distinct values in one column that don't exist in a similar column in a different table.
Current Query:
SELECT DISTINCT Table1.Column1...
Dulaney asked 5/2, 2010 at 22:6
3
Solved
How can I retrieve the value of specified column of the selected row in a multicolumn listbox?
I populate the listbox by setting the RowSource property with a SQL string. BoundColumn set to value ...
Colostomy asked 10/1, 2011 at 16:29
4
Solved
I have an MS Access application that contains all tables linked to SQL Server, so in MS Access VBA code or query I work with those tables very simple, I access them via name, like [Customers].
Als...
Cuneo asked 14/9, 2013 at 10:24
1
Solved
In MS-Access 2007, I have a table, [Test_Master] where I have a field [DT_REPORT]. I want to update [Test_Norm_Due] by 2 months if field [Size] = "small". If the field "Size" = "Med." then by 3 mon...
Patton asked 19/4, 2014 at 2:2
6
Solved
How can I UPDATE a field of a table with the result of a SELECT query in Microsoft Access 2007.
Here's the Select Query:
SELECT Min(TAX.Tax_Code) AS MinOfTax_Code
FROM TAX, FUNCTIONS
WHERE (((FU...
Mortimer asked 16/5, 2009 at 7:30
1
Solved
I inherited an old web application, that is writing data collected in a form into an Access 2007 database using classic ASP.
Now they need it to be able to collect input in the Cyrillic alphabet.
...
Lemmon asked 26/2, 2014 at 22:33
2
Solved
I am new to MS Access. Could anybody tell me how to define a composite primary key in MS Access 2007.
Divulsion asked 13/6, 2011 at 19:13
© 2022 - 2024 — McMap. All rights reserved.