Search results

Feedback Hi all, Thanks for the posts. Just to let you know - setting the Format property to Fixed didn't work. I wasn't using the Round function and yes, that did work. Regarding the last post, setting if DATA TYPE to currency and the Field size to currency worked, but setting the DATA TYPE...

Hello, I am using the DSum function on a field that is specified as having: Field size: Single Format: General Decimal Places: 2 I add 5 records to the new table. The contents of the records are: Record 1: 1 Record 2: 2 Record 3: 3 Record 4: 4 Record 5: 5 The results of the DSum function...

Hey there, I would like to find a value from a record, and I am using the DLookup function. To find the right record I need to provide two references, the customer id and the booking id. I have tried to use 'And' such as: dateineed = DLookup("[Arrival date]", "detbooking", "[BookingID]= " &...

Hey, I am trying to enter a user-defined parameter in a CrossTab query with little luck. It works fine if I enter the code already defined as in: >= #12/06/2006# but when I enter the code for a user-defined / input such as: >= [Enter date:], or if I try to redirect to a textbox on the active...

Thanks Doc Man & GP. I am running a peer-to-peer network using IPX, with 2 Win XP machines. There is only one logon used for both XP machines, no passwords needed. I have tried opening earlier versions (I am currently on 11). Version 7 opened, version 8 comes up with the same error. Version 7...

Yes, I joined it - still no luck

Hello, I get this error when opening my MS Access database - You do not have the necessary permissions to use the ...[flie name and path]... object. Have your system administrator or the person who created this object establish the necessary permissions for you. The database works fine on...

Thank you you star! It worked. Can't thank you enough.:)

Hey, Happy New Year to all. I have a replicated access database, and I want to move the design master to another computer. I have tried using the Windows 'Copy and paste' command, and the 'Save as' command, both result in creating a replicated database. I have also tried chnging the design...

Cheers Thanks for the replies. Is there any way I can find out what the problem is without having to go through the code? I have around 12 forms, all with a load of VB code behind them, and I want to avoid going through every bit of code to find the problem. Cheers again, Adam.

thank you cheers. Will do.

I want to enter in data so I get stars (*****) when I type, and encrypt the data when entering the data in a form. How do I do that? Cheers, Adam.

Hi, On Compiling my assecc database VB code I get the following error message "User defined type not defined". I understand it is beecause I have not declared the Variable Type, but have no idea to exactly which part of the code the error is referring to. How do I find out WHICH User defined...