ms-access-2007 Questions
14
I have the following code for an Access form. It appears as if the SendKeys is messing with my NumLock key by toggling it on and off as I open and close the form.
For perfectly valid reasons whic...
President asked 22/9, 2014 at 15:35
4
I want to Access .mdb files and manipulate like insert / update using nodejs
Please suggest a library that would suite the need.
Thanks.
Ardithardme asked 29/1, 2014 at 9:29
7
I have an MS Access database (intolerably enough), and communicating with it through PHP (ODBC).
There is a DateTime field that I have to include in my INSERT statement. This field is NOT defined ...
Tenon asked 20/8, 2010 at 21:30
8
Solved
I want to log web site visits' IP, datetime, client and refferer data to access database but I'm planning to log every days log data in separate tables in example logs for 06.06.2010 will be logged...
Wagram asked 6/6, 2010 at 19:5
6
I have managed to read data of Microsoft Access file (.accdb) on Windows using PDO but I'm having problem getting to work on Linux (CentOS). I can see modules is installed:
[root@rapid host]# php ...
Fontaine asked 20/11, 2012 at 12:22
3
Solved
I am writing a SQL query with inner join as this
select * from (table1 inner join table2 on table1.city = table2.code)
inner join table3 on table3.col1 = 5 and table3.col2 = 'Hello'
This giving...
Lysol asked 17/5, 2013 at 11:50
4
Solved
I know there's a way to get a list of all tables in an Access database by using the quering the MsysObjects:
SELECT MSysObjects.Name FROM MsysObjects
WHERE
Left$([Name],1)<>'~' AND
Left$([...
Benzaldehyde asked 29/3, 2010 at 9:43
10
Solved
My form is showing up in design, but not form view. There are 700+ records.
In Design View -> Data, the Record Source is:
SELECT act.* FROM act;
This query shows all records in Query view.
...
Roderick asked 14/5, 2013 at 16:48
3
Solved
How can I add "placeholder" text to a Text Box in an Access form?
Before the user has typed anything into the text box I want it to display something like
Name: [Please enter the right name]
an...
Dhaulagiri asked 30/10, 2013 at 11:21
5
I have a column of numbers between 0 - 6 digits long. For those less than 6 I need to pad out with zeros to ensure they are all 6 digits i.e 12563 = 012563 or 23 000023 etc etc. Can someone recomme...
Drugstore asked 24/4, 2014 at 14:5
3
Solved
i have access 2007 form and i want to test if a particular control (toggle button) has the focus ,
something like :
if gotfocus(mytoggle) then
dosomething
endif
or maybe like :
if me.mytoggle...
Karlow asked 4/12, 2013 at 10:54
4
Solved
What's the "best" way to read (just read) an Excel file from within an Access 2007 application. I only want to loop trough the rows and put the data into an Access table.
I don't want a manually i...
Ague asked 25/5, 2010 at 14:20
3
Solved
How can I link a table from one MS Access Database (*.mdb or *.accdb) to another Access database in VBA?
Basically I just was to use VBA to replicate what the External Data wizard does.
I've goog...
Apheliotropic asked 27/4, 2016 at 19:18
3
Solved
We have application built on MSAccess 2007. We want to add a new user login concept for this application.
I want to Authenticate user using Active Directory/Windows authentication.I want create a l...
Kingsize asked 29/4, 2011 at 14:1
4
Solved
every thing work fine locally but this error occurs when I publish it:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
and stack trace
[InvalidOperationExceptio...
Gusto asked 24/6, 2012 at 18:3
5
Solved
I started learning about C# and have become stuck with inserting information from textboxes into an Access database when a click button is used.
The problem I get is during the adding process. The...
Cherry asked 9/10, 2013 at 14:57
7
Solved
i have a shared access application, i created an accde file for 32-bit machine, when user open the application he/she getting a security warning
is there any way to disable this message from app...
Coatee asked 6/4, 2015 at 10:47
5
Solved
I searched all over for a way to do this.
I want to open a Save As dialog box so the user can choose the location to save a file. But, I want the "Save as type" field to be preset with "comma sepe...
Byplay asked 14/10, 2011 at 15:36
4
Solved
I resized my A2007 Navigation Pane and somehow closed it up so tight (maybe 8 mm) that I can't resize it again (can't grab the right margin....) The pane is open and operates, I can type a search i...
Abode asked 13/9, 2010 at 20:34
2
Solved
Am trying to perform some specific actions, before closing the access database (whenever the database is closed by the user).
I know we can use Auto_Close function in Excel VBA to force events bef...
Camouflage asked 21/8, 2012 at 21:34
3
Solved
What is the correct syntax for this:
delete top 2 * FROM table1
in Microsoft Access?
I am trying to delete the first 2 rows, and I don't have an id field. Also, I know it's possible to do:
select ...
Heinie asked 19/3, 2013 at 5:20
3
Solved
I have two tables in my Access-database. They look something like this:
Table1
+--------------+----------+----------+----------+
| Kabelnummer | Column1 | Column2 | Column3 |
+--------------+----...
Disarray asked 29/7, 2013 at 12:9
2
I have an Access database with a many-to-many relation. The origin table is called Property and the destination table is called Person. A property can have more than one owner, and a person can own...
Bartz asked 22/1, 2017 at 21:37
5
Solved
Why do I get a
"Return without GoSub"
error when using subforms in Access 2007?
Welladvised asked 13/7, 2012 at 9:29
3
I have a routine that imports an Excel table, changes several column (field) names, adds an index and several new fields. However, the indexed field imports from Excel as a Double and I would like ...
Amanda asked 1/12, 2015 at 21:11
1 Next >
© 2022 - 2024 — McMap. All rights reserved.