ms-access

Lookup Filter dropdown incomplete in programmatically altered SQL backend Access database

In this thread a user had problems with the lookup filter being missing in an acess database that had a SQL server backend. The problem was easily solved simply by checking on an option in the current database settings that allowed ODBC fields to also provide lookup filter dropdowns. For those confused, the lookup filter is the excel l...

Accessing mdb database through ADO slow on Vista

Hi, I'm supporting a customer with strange, very specific mdb access slowdowns. We have a big ( > 100MB) mdb file which is read by our app through ADO, and on some Vista machines (and only on those Vista machines), some, but not all queries take a very long time to execute. The slow query: SELECT * FROM [Table] WHERE [FieldA] = _numbe...

How to add new record to table in Ms Access by form?

I made form by wizard, but when I run this, first I have in fields first record from table, and I can edit this record, but I don't want to have this. I want to have blank field and when I click add button i can add new record, not edit.... ...

vba check if specific process task id is still running

I am using the Shell() function to execute an external application in MS Access. Shell() returns a task ID of the specific process that was started. I need a way to check if that process is still running or if it has closed. I'm sure that I will need to do some sort of windows API call but I can't seem to find anything just now. ...

passing parameter from access into sql-server

REPHRASING QUESTION: i apologize for being unclear. i have a textbox and a button a form. when the button is clicked it runs this saved access query: select * from sqlservertable where field=form!textbox.value i have an access front end and sql server back end. this query is not working. it doesnt like me passing this parameter form...

MS Access 2003/2007 - Import Specification for data import from csv file used in VBA.....validate field names?

I have an import which I made with the wizard, at least far enough just to save the specification. It imports CSV files, with headers, quote text qualifiers, and comma delimited. I then use the import specification in some vba that fires from a button click event. Here are some things I am wondering: So if the fields in the data are ou...

WTF is this Access bug?

Tested on Access 2003 Pro (build 11.8321.8324) SP3. Steps to reproduce: create a new database. create a new form. put a button on the form. paste the following code in the button's Click event procedure: Debug.Print Workspaces.Count Debug.Print CurrentDb.Name close the code editor and form, saving changes. do not skip thi...

How To Print A Single Record from a Microsoft Access Form into a Report

Hello! i'm very new to Access and VB, and im about to print a specific record.. but im getting an error with this code: Private Sub printEksternAVR_Click() DoCmd.OpenReport [Report_AVR Ekstern], acViewPreview, , [Report_AVR Ekstern].Rapport_nr = Forms!Form_AVR End Sub My reports name is AVR Ekstern, and the prime key is Rapport nr...

export to doc/other writeable file / force to print out empty report?

Is there any way to "force" my report to print out the "layout" even if the fields are empty. I have one report, which is always there. and 8-9 sup-reports which not always will be filled, but I want them to be shown anyway because they will be send out to a customer and filled, and then send back? is there any easy way of doing so? (and...

VBA photo/image compression

Hi there, I am wondering if this is possible and within the realms of Access? I currently have a database system where the user can open up directories/folders related to the record; such as images, docs etc... This avoids bloat by attaching the images to the records and what not, and works fine. A user enhancement would be to allow th...

MySQL to MS ACCESS 2007?

Hello! How can i export from MySQL to MS ACCESS 2007 in c#? Any tutorials? Regards, Alexandru Badescu ...

Database Critique - MS Access

Hi there, Would anybody be able to recommend any free or paid for services out there to assess and critique a database produced in MS Access? Any help or advice appreciated, cheers Noel ...

select something i cbo and change the text of another txt - #name? error

For some sort of reason, which i can't seem to spot, this fail and i get my #Name? error, when i tried to do this, i use pretty much the same code another place in my form, the only difference is the cbo and the names of my txt and alike. Private Sub cboVarenummer_AfterUpdate() Dim LSQLVareNavn As String LSQLVareNavn = "select V...

ms-access: when i change extension to ACCDR forms/tables disappear

i would like to distribute an access front end to some people and i want to make sure that they do not edit anything in it; however when i change the extension to ACCDR it makes all the forms and tables disappear. what settings do i have to change in order for them to be able to open forms but not view them in design view or make any cha...

Trouble with SQL UNION operation

I have the following table: I am trying to create an SQL query that returns a table that returns three fields: Year (ActionDate), Count of Built (actiontype = 12), Count of Lost (actiontype = a few different ones) Bascially, ActionType is a lookup code. So, I'd get back something like: YEAR CountofBuilt CountofLost ...

access sql statement is returning nothing!

i am having a problem with access sql SELECT statement. the problem is that when the backend is ACCESS-2007 it works; however when the backend is sql-server-2008, it is not returning anything. here is the statement: SELECT IIf([Lab Occurrence Form].[1 0 Preanalytical (Before Testing)] Like '*1.11*Other*','1.11 Other',[Lab Occurrence For...

access: best way of allowing users to simultaneously edit table?

i have an access front end. users need to be able to open a table and edit the contents of a table. this is a multi-user application. please note that i do not care that i might run into problems with people editing the same data. how do i allow a user who only has the access RUNTIME to be able to edit and view a table? how do i force ...

sql-server: how do i know who is in my database?

i have an access front end and sql server backend. i would like to know which users are currently using the database. is this possible to do using access or sql-server? ...

ms-access: how to do a proper requery?

i am distributing ms-access-2007 front ends. the back end is sql server. a user will click on a button and it will return a query from the sql server 2008 database. is it possible to requery this query if the user clicks the button again? usually the behavior of access is that if you query it again, it displays old results. how do i m...

will access disconnect from sql-server if it is idle?

i have multiple users connecting to sql-server-2008 database. i would like to know whether they will be disconnected if left idle? ...