ms-access Questions
3
Solved
I get the "data type mismatch in criteria expression" error when trying insert a row of data into Access. After messing around a little, I narrowed it down to the DateTime being the issue.
Here's ...
1
Solved
I have built a spider with scrapy. I run it and have the output in the json file as shown below. Then I am using clsJsonParser in a VBA, with the following code. But I am getting an 3265 error "ele...
5
Solved
I have problem with adding values to multiple columns in listbox in access.
I have tried solution like this: Adding items in a Listbox with multiple columns and this: vba listbox multicolumn add [d...
4
Solved
I have several years experience with VBA in MS Office applications (for automation and ETL processes) but have not had the need to mess with Forms in MS Access until recently. I'm laying out the de...
4
Solved
The MS Access 2007 Form Design view property sheet exposes some color options that I can't seem to find constants for in order to use them in code. Specifically: Text Dark, Text Light, Background D...
Shikoku asked 5/1, 2011 at 19:7
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
1
Solved
Basically I'm trying to update Column1_mbgl field data in Table1, all based in MS Access database. The script gets executed without any errors, but when the table is checked no update occurred. I h...
2
I have been trying to extract data from a .mdb database and get it into Odoo 8 class columns.
This is my .py file
class attendance_biometric(osv.Model):
_name="attendance.biometric"
_rec_name...
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
3
Solved
I'm sure this is very simple, but I can't find it. In the close event of an Access Form, how can I cancel closing the form? I have a test that counts the records in a table. If that table has recor...
4
Solved
How can I get the same result I would get with the SQL code below in ms access? It does not recognize the EXCEPT clause...
SELECT DISTINCT
P.Name,
T.Training
FROM Prof AS P,
Training_done A...
6
I've tried a number of things but nothing seems to be working properly. I have an Access DB and am writing code in VBA. I have a string of HTML source code that I am interested in stripping all of ...
1
I'm trying to extract all the attachments contained within each record in a table:
As each record may have multiple attachments, I would like to loop through each record, creating a folder on disk...
3
Solved
I was just testing my database and I realized that I run into problems wherever a text entry in my database contains a ' character (single quote). My solution for now is that before any .execute op...
16
Solved
How can one programmatically sort a union query when pulling data from two tables? For example,
SELECT table1.field1 FROM table1 ORDER BY table1.field1
UNION
SELECT table2.field1 FROM table2 ORDER...
Aesthete asked 17/10, 2008 at 21:5
2
Solved
Something terrible as happened with my poor attempt at adding a CountIf forumula to my access report.
I am trying to add a formula within my report header to count the number of entries in my Serv...
5
On this Access form I am working on I have a global variable that take its value from another form on its Form_Load event. For some reason unknown to me the variable "loses its value" (becomes = ""...
Kwh asked 11/7, 2013 at 19:37
4
Solved
I have a query called qryAlloc_Source that has two paramaters under one criteria:
>=[forms]![frmReportingMain]![txtAllocStart] And <=[forms]![frmReportingMain]![txtAllocEnd])
A have a sepa...
5
Solved
I know this is a simple question for someone out there, but I have never really used function module at all because I did not understand what they were.
So I have a whole bunch of things I can use...
Photometer asked 2/7, 2009 at 2:2
12
Solved
This question was inspired by one I asked almost a year ago - any-orms-that-work-with-ms-access-for-prototyping - which has recently become active again, but as an Access vs SQL Server debate.
The...
Outcast asked 29/9, 2010 at 15:48
9
Solved
How can I get the field names of an MS Access database table?
Is there an SQL query I can use, or is there C# code to do this?
7
Solved
How do I read data in ms access database and display it in a listbox. I have the codes here but i got errors.
private void button3_Click(object sender, EventArgs e)
{
using (OleDbConnection con...
1
Solved
I'm having trouble declaring new object using CreateObject()
Sub A()
Dim x
'This works
Set x = CreateObject("Scripting.FileSystemObject")
Set x = Nothing
'This throws an error 429 "Active c...
Combo asked 5/5, 2016 at 9:0
7
I am trying to scrape PDF tables which span across multiple pages. I tried many things but the best seems to be pdftotext -layout as advised here. The problem is that the resultant text file is not...
Mt asked 6/8, 2013 at 10:58
2
Solved
I'm reading data from an .mdb file (MSAccess 2000 format). There are some tables that have colons in their names. I'm getting an exception when I try to open queries on these tables:
EOleException...
Lotus asked 30/4, 2016 at 16:10
© 2022 - 2024 — McMap. All rights reserved.