I have written the undermentioned function but it won't work and i do not know why . it returns the following error: user defined type not defined and it...

Using Access 2007 I created a user defined function used in a query that works fine on single criteria but not two or more. These work...

I know this can be done, but it has been so long since I have done it! I have a query that is meant to pull information on what offices (actual rooms) fall...

I would like to create a user defined query, where the USER gets to choose specific criteria on which they wish to query. This means that the user can select...

Hi all and happy new year! I have little issue i can't seem to get a grasp of so hopefully someone has a simple solution. I have a pop up warning box setup...

From what I read http://support.microsoft.com/kb/239482 Jet seems to support user-defined functions by I can't find any examples on the web. I've found...

In access you can select a function. E.g. Now(). Can you created user defined functions that return recordsets and select them like the Now() function?

I'm getting gibberish returned in my listbox when applying my user-defined fucntion on an SQL statement. I've never done this before, so I need help. Here's...

I have created a function to return the windows user's full name (via Windows API calls). This function is run via a query and returns the name ok when I am...

I would like to build a select query where the fields of a table are picked from a form. I don't know how to select the field. It always ends up as data....

Hi all- I am fairly new to access and am currently working on a project that pulls live data from excel every minute or so and stores it into an access table....

Not sure if this is the right newsgroup to post this. If not, please let me know and I'll repost it to the correct one. I'm trying to figure out how to...

The simplest way to do this is just to set the OrderBy property of your form to the name of a field. Remember to set OrderByOn as well. This kind of...

How do i allow users to change the top value number in a query without going into the design mode?

Hi, I'd like to allow employees to access and update their own data in an Access database. Is there any way to retreive the username they use for login with...

I have a SQL database which contains records of all students in my district. The fields include, school, firstname, lastname, etc. and I want to create user...

Anyone know of a program that can search your database and find queries, etc. that are no longer used? Or does Access have a tool that does this and I'm just...

I need to multiply records according to the field. HOW!?

Hello, I have an extracted list of US zip codes and their longitude and latitude. I want to use this data to restrict the sales area of a product. For...

I have a query that reads a parameter from a form. For ex, if the user input the language "Bosnian" on the People form, the Query shows all records with...