Hi all,
I'm trying to get "Regular Expressions" to work in MS Access. I am relatively new to "RegExp" and have been reading up on it in experts exchange. I've created a module in Access and...
Hi Experts,
Can anybody give me a working example for data access over internet using ADO through VB6 application?
1. Connection to a remote machine
2. Reading and Writing data from/to ...
Is there any way of writing a function that will calculate the no of working days between two dates, WITHOUT looping through each row.
I am currently using this ...
Public Function ...
In my Microsoft Access database I have a table of Users, each with a user name and password, and a login form set up. I have entered the coding where username and password is entered into the ...
I have a table containing a lot of text, contained within the text is ASCII coding, I am looking for a way to update the ASCII code to its string value
E.g. change [ to [
I have multiple computers that have Access 2003 and the linked table manager (tools > database utilities > linked table manager) comes up empty even though the database has dozens of ODBC link...
Hello, simple question but can't get it.
I have an insert statement - it works unless the string contains upostrophe. Then it stops with a run-time error '3075'
"Syntax operator missing...
Dear experts:
In MS access' Edit Relationships options, there are:
(1) (by default) Enforce Referential Integerity
(2) Cascade Update Related Fields
(3) Cascade Delete Related Record...
Hello,
I am trying to create an update query that will grab a parameter, do an insert, and then return the autoincrement ID. I realize that this will throw a syntax error, but this should g...
I noted on my reports that I generate from Access 2003 that our company logo was missing.
Upon further investigation, I also noted that the logo will not appear in the inbedded OLE field.
Wh...
Everytime I try to add a picture to a field in Access through an OLE object i keep getting the error message "The operation on the OLE object failed. The OLE server may not be registered. To ...
I would like to update a field to an inputed value on a combo box using the Domcd.runsql function in VB.
Does MS ACCESS support CASE statements like sql?
I basically want to do this:
select customerNo,
(select case count(*) from visits where visits.customerNo = customerNo
when ...
Using google maps with microsoft access. Anyone ever use this or understand this:
http://www.issociate.de/board/post/268098/Using_Google_Maps_In_MS_Access.html
I was good up until this p...
IS THERE ANY WAY WE CONVERT MDE INTO MDB. I LOST MY MDB APPLICATION. I HAVE ONLY MDE . IS THERE ANY WAY I CONVERT INTO MDB WITH ALL SCREENS AND REPORTS .
access VBA
Hi.
I called module2 in the same data base inside another function which executing as Event, but Error occured
why ?!!
Option Compare Database
Option Explicit
Privat...
Hello, im trying to get this command to work in access....
What is the equivlent to this command?
I am using MySQL as my main database, however I want to become more universal and allow ...
I have this code to audit some Excel files...
Dim FSO As Object
Set FSO = CreateObject("Scripting.FileSystemObject")
Dim Fl As Object
strFolder = "P:\..."
strfile ...
If I were to come across the following line of code in Access 97, how would I know EXACTLY what this command does?
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
The online help ...
I am looking for a solution that would be similar to Oracle's minus query. I have two tables, an employee table and an employee_skill table. I need a query that will pull out all employees t...
Hi All,
I am working on a query in MS-Access Environment, where I have to search for a date [input from user] between two dates [stored in the table, "from_date" and "to_date"]. I am able to ...
I am tyring to use the Microsoft DataGrid Control on a MS Access 2002 or 2003 Database.
I have included the reference: Microsoft DataGrid Control 6.0 (SP5) (OLEDB)
In My form I placed a ...
I've got a function that inserts some values into a new table in an access 2000 database. For a really simple example of this:
SELECT Field1,Field2,Field3 INTO [NEW TEMP TABLE] FROM [OLD TE...
I'm at the point where I'd pay someone good money out of my own pocket to make this work. -_- I have a crosstab query that has different numbers of columns depending on one field in the quer...
Run-time error '3051': The Microsoft Jet database engine cannot open the file C:\Program Files\MBRMS\xxfile.mdb. It is already opened exclusively by another user or you need permission to vie...
