I thought I could code a function reference in the event-handler box for a control, but I'm missing something, since I can't get it to work. I want to make a...

hi, is it possible to use a function call as event replacement with the form itself (Me) as parameter? In a module i have defined the following: Public...

I have a form in my database that has 4 yes/No fields. I want to create another field that if all the responses in the 4 questions is yes then the other...

What would the code be to find the next character in a string I have so far Strtemp = instr(strin," ") I just don’t know what to put between the " " to...

A program that has been running just fine has now decided to give me a message "Function is not available in expressions in query...

Dear all I am getting the following bizarre error message on one of our databases: 'Function is not available in expressions in table-level validation...

Does anyone know if it is possible to use a function key to open a form in access? Thanks in advance!

There is an embeded subform in my Sales Order form. The said subform is where the user select all the sales items for the transaction. I have a "Transact"...

Hi all I have an MDE file that works perfectly when I copy it to a CD and run it from CD but when I package it up with the developer wizard and then...

In VBA I want to open a form in particular circumstances and close it (if it's open) in other cases. An error is generated if I try to close a form that's not...

I would like to have a control return the contents of a field, but without the internal spaces. I know the trim function can eliminate the left and right...

Hi, Is there a Function that will lock (or unlock) editing for all fields on my form? Would be useful. Thanks.

I need to write a function to test whether a text box contains an entry of a 4-digit number? The text box in question is bound to a "text" field. In other...

I have this expression in a text box control on a form: =IfDirty() & . where IfDirty() activates an OK and Cancel button on the form. I also have another text...

I apologize this is probably a dumb question but I really can't see the problem. I had a perfectly working form that needed changes. I reduced the number...

I have a database running on WinXp and Office 2003 SP3 on my laptop and everything works great! Once deployed on a pc running WinXp and Office 2003 SP3 there...

Hi all. I would like to create a calendar in Access to use for tracking tasks for my team. I want to be able to enter text on certain days, the name of the...

I have made an invoice using a form, and have it nearly completed, I have two functions that I don't know how to create. One is simple, I need an automatic...

I have been trying to use "format", Date(), "Mid", "Left"..etc. in a query. It gives me an error Undefined Function. Could some tell me what to do to fix...

funeral : guest lists. car lists. floral. food.