Error Message: The instruction at ... referenced memory at ... The memory could not be "read."
This is happening in an Access97 database on Windows NT. Here is a list of what has happened a...
Hey Experts
I've been forced to use MS Access (usually use MS SQL). Now I need to Average (AVG) a Field (type text 10)
Here is my SQL.
SELECT AVG([cmi-core-score-raw]) AS [average],...
I have an Access database (XP) from which I created several Crystal Reports (8.5) because Access would not handle all the fields required for the reports.
I tried using the Wizard only to...
Hi
I need to find the value of an item selected in a list box. I can find the index of the item using the following code:
Private Sub Command335_Click()
Dim frm As Form
Dim ctl...
We have 7 Access 2007 databases that need to be converted back to Access 2003 if they can. How can this be done. I noticed that everything else can be opened with the microsoft download but ac...
I am using ms access to generate reports for our online transactions. My database uses linked csv tables which are downloaded periodically to update the data. My problem is that the table my...
Hello.
I am using MS Access 2000 and after repairing an old database and importing tables from another database (that users copied... and were inserting information), I wrote a few queries...
I want to drop a Foreign Key constraint in MS Access but if it doesn't exist I get an error (CHECK constraint 'FK_MemberFamily' does not exist.). Fair enough. Therefore I want to check if it...
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...
Access neophyte here...in need of assistance.
I have two issues I think..
First off, I moved three access 2000 databases from one folder to another, then created shortcuts to the .MDB fi...
Do you know how index_of/substring or InstrRev works in plain Access SQL ??
I need to extract from this string - "P_80000463_194802" two sections:
1. "P_80000463"
2. "194802 "
Can any...
Hi
I have a simple Access form with a button that creates a new record.
There is however no btton to save the entries made to the table.
What VBA code would I use to commit the data to th...
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 need the code to diplay the Julian Date (The number of that day of the year).
Eaxmple 1 - Today's Date = 9 Jan, 2001
Today's Julian Date = 009 (indicating the 9th day of the y...
Hi Experts,
I have a database that needs to be open to multiple users. Currently when it is opened by one user it creates a Lock File. The main window is a form that allows record searchin...
hey guys
basically i'm near completion of my project. its due in on thursday and i want to add a fgew "killer applications" (as i like to call them!) to the project - your know a few bells...
Hi,
Can someone tell me how I would create a text box on my form using VBA? Would there also be a way to position it where I like?
Thanks
Hi all,
I'm having problems exporting data to Excel using VBA. What I need to do is complicated, and well above my skill level, so I hope you can help.
I need to transfer data from a ...
Hi,
I know that this has been asked before but I want some code to create an inputbox in MS Access that has a password character * in it rather than displaying the text.
I know this is ...
Access documentation seems very poor in regard to SQL SELECT. Can someone explain the use of EXISTS in a WHERE clause?
Hello all,
Can the following be done in SQL or do I need to use JavaScript or ASP. What I want to do is update a date field with data from a text field.
Field A - is a text field contain...
My computer has short date format dd/mm/yyyy in Regional settings. Suppose I write SQL query:
INSERT INTO Dates ( Date1 ) VALUES ('01/02/2007');
01/02/2007 means February 1, 2007.
What happ...
Hello Sirs,
I get the following error message when I try to open an access database from a VB6.0 application running under windows 98
"Provider Cannot Be Found, It May Not Be Properly In...
Greetings,
I am developing a Delphi apllication and need to import both CSV (comma separated) and SDF (fixed lenght) files into an Access database.
Lets say that the Access database is DB1...
The following code snippet is assigned to the onclick event of a button. When the code runs, the inserted record is actually duplicated. It appears twice in my table, exactly the same apart fr...
