Hello,
I have a database .mdb which has got corrupted (Error 3197). I can't open it. I have tried and searched any solution, but apparently there is no one.
Can somebody help me, please?
...
I'm currently utilizing a function that creates a worksheet, and then pulls data from an access database query to populate the new worksheet. In particular, I'm querying an Access query based...
this can be solved 2 ways so whichever solution gets me there first is fine.
i have a sql query that i need to use in MS Access that is as follows:
select companytable.*, prospecttable...
Say I have a table like the one below in MS Access:
tblPay
Payer claim percent
tom 100 10
jerry 200 20
tim 230 5
I'd like to co...
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...
I have an Access front end that has been conneted to Access tables but we are converting our large sites to SQL. we run a number of transactions that insert records in multiple tables, some of...
Hey Experts,
This might be a new one. I'm receiving this error on a server:
--------------
LSASS.EXE - System Error, security accounts manager initialization failed because of the foll...
Hi
I have a table setup with one of its fields setup as a listbox lookup field, the lookup field has 2 columns, the bound column which is hidden and the text column which displays in datashee...
I have a recordset that I copy into an excel file. Is it possible when I copy the recordset that I can also copy the column names from tbl_Quote_Equipment into the excel file?
strSQL =...
Hi,
Im not sure really where in my code this occurs but for some reason my access app has gone crazy!
A double click event that opens up a form comes back with the error
Runtime Error...
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...
I am having a hassle with an ACCESS app that a colleague developed to extract data from a Foxbase database. The hassle that I am having is that all of a sudden after literally years of workin...
How can I get the current Object, Subroutine name, function name, etc. in VBA?
For example in the below, how could I add a line to msgbox the Sub name "cmdClose_Click" and the name of the obj...
(1). I have this code below to hide the tables. I am looking for this type of code to hide the other objects like:
Forms, Queries, Macro and Modules.
(2). I will also appreciate code...
HI,
I have a user using an Access Application developed on 97, working on Windows XP. When the user tries to start the application a blank dialog box pops up followed by Access Error 2950. ...
I have a FE/BE Access 2000 project that I need to lock down a form for some of my users. My form has ~ 100 editable fields of textboxes/cboboxes/etc... I capture their user profile and assi...
I have been wrestling with a data type mismatch problem for several days. The ASP page is submitting to an Access 2000 database. The table has two date fields- StartDate and EndDate. No matter...
I select to hide the Navigation Pane in Access 2007 via the Office Button > Access Options > Current Database > Uncheck Display Navigation Pane. When I restart Access with that database, the N...
Hi Guys,
I am using an external program to send SQL statements to Access.
I cannot send propriety commands to Access but only SQL.
Any idea how I select a record which is the first, n...
I am using VBA code to compare dates the line of code that I am using is:
If Format(PStart, "mm/dd/yy") >= Format("7/1/68", "mm/dd/yy") Then
PStart is a specific date field with dates like...
Kitty's Great Calendar Project gets its data from an Excel table the user generates outside of Access (ExcelCaledar).
Right now, I have the table ExcelCalendar linked to the CalendarProject...
I have an Access query that brings up dates on a table that are several months away. I only want dates that are no more then 3 weeks away (i still want overdue date though). Any way to do this?
I'm having a brain explosion over here trying to read data out of a query;
I have some code that executes when I click a button, and I need it to read some values out of a query. The query ...
I am getting "Not enough space on temporary disk" error message when I try to save a change to a rather large table. I have plenty of RAM and HD. Where do I increase the temporary disk space?
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...
