VBA seems to think in 'American' when dealing with dates. Is there any sort of a 'regional setting' to default to dd/mm/yyyy?
John
I'm helping a friend trying to debug this issue as he's posted all over the web, so I've come to the experts for some help... here's the question below:
I have a problem converting linked t...
For many years I have used code that sends email from MS Access via Outlook.
That same code does not work with the 2007 versions of Access and Outlook. I can not find any sample VBA code sea...
sSQL = "INSERT INTO Call_Notes (Track_ID, Contact_ID, Call_Date, "
sSQL = sSQL & "Call_Time, Call_Subject, Call_Notes) VALUES ("
sSQL = sSQL & "'" & GBL_Staff_ID & "',"
sSQL = ...
Hi all,
Normally I would consider putting this directly under the MS SQL category, but I'm pretty certain the problem I'm having lies with VBA/Access.
I am attempting to pass values from...
I have two identical tables - I need to Delete the records in the 'Data' table that are identical to whole record (all the fields) in the Data_Intermediate table
The Tables:
Data:
Date...
Have a user that is opening a database, getting a macro security warning. When they open it, the database locks up. It opens for other users.
The macro security is set to medium, if you try...
In Oracle, i can retrieve the row number of selected records by using rownum.
Example:
Select rownum, id, name from MyTable;
But how can i retrieve the row number of a record in Ms-Acce...
What's the best way to find out how many records in a query via VBA?
Good morning,
I'm new to SQL view of Access Query, but I need to do an update query that goes outside to another database.
The tables are the same in both databases (table name and fi...
I have a corrupted mdb file with a .ldb . I tried to Repair the database but it errors out saying that another user has the database in exclusive mode. No one else is on the system.
How c...
Hello,
Okay I'm a SQL guy and am used to replace an integer or a string that is null with a value this way:
isnull(vendor, ' ')
isnull(qty, 0)
Is there a way to do this with an Acc...
Hi,
I have this question regarding autoincrement. I know Access already has an autoincrement option for a number field but the problem is that if I delete a record then when you add another...
I have a search form for my database (frmSearch).. the results show in a subform called frmSearchDetails, which is in Datasheet view.
The applcable tables on my database have a One-To-Many ...
Access 2003
Excel 2003
I want to open an excel workbook, Select a ashett and sort it by Column C
I do not need to see excel do this.
I can't get this to work
Public Sub sortExcel()
...
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...
Hi i'm an asp newbie and am just trying to insert some data into a database table.
i can successfully retrieve data but it wont let me insert.
my code is below, if you have any questions...
I need to write code that will import a file that is tab delimited and also may contain #EMPTY strings that I want removed. I can not use the import wizard because there are several date field...
When running the below code, it successfully creates a pdf file from the report, but I receive the following error when it attempts to attach the pdf file as an Outlook attachment:
"Can't f...
Hi there,
I have a query in Access that accepts a date as a parameter. I execute this query for each day of a month so currently have to run the query manually and enter the day.
In VBA,...
Like it says, really! Most times when I open Access or one of its apps, a dialog box comes up telling me that it is installing, configuring, etc... it. The app then opnes but the following pro...
We have an Access 2003 database that was originally a multi user database. Now it allows multiple users to open it, but only the first user has full rights the rest have RO.
What happened ...
I have two Access database, db1 and db2. Both has an exactly same table, [Table1]. I like to update value in [Table1] in db1 and automatically update value in [Table1] in db2. Is it possibl...
Hi,
there is one MDE file, but unfortunatly we lost the original MDB file. is there any method to open an MDE file?? please help
I have an Access table with a column called LogonUser. There are about 8 distinct values in this column, and each value is repeated multiple times. I would like some sort of SQL query that wil...
