Search results

Now i need some help here. I adapted this code from somewhere on this forum. But iam having a problem with using the 'ALL' criteria. It Opens a Report Dynamically from multiple selections in the two multiselect ListBoxes, but when i select 'All' and select any other item in another listbox For...

If you dont have the Developer Version like me,you can also use any windows installer to package your DB. I for one uses wise Installer and it works great for me.

Thanks Man. i Replaced As Bogus with As Correct.

I need help here. i have a multiselect listbox on my form and i want to hard-code its rowsources depending on certain selection criteria.Iam finding a problem. Actually i dont get any results when i use the query below. Any idea what iam missing out. Me.OrgTypesLB.RowSource = "SELECT DISTINCT...

Fixed. Thanks.

thats what i did. Actually Len([Fax_Number]) <7 but it ends up updating every record thus doesnt recognise the criteria.

I have a fax number field iwhich has a mask. +(000)-00-000-000 in a table of many records. The problem is that every record has a number in the first part of country code +(001)which must have come there by mistakes, few records have complete and true fax numbers. I need a query that can Update...

Here is the Solution. Set the form's Borderstyle=None Controlbox=Yes Max or Min buttons= Enabled Option Explicit Private Const WS_THICKFRAME As Long = &H40000 Private Declare Function GetWindowLong Lib _ "user32" Alias "GetWindowLongA" (ByVal _ hwnd As Long, ByVal nIndex As Long) As...

I have run in the same Cave. I have a main form that is maximised on form load.Cosequently it docks its self in a restored state, so when the user restores it it shrinks to a smaller size. I want to completey avoid this. I have researched but also failed to find the solution. Any Ideas to get...

Thats why i simply hard-code it.

thanks Doc Man, the form frmRelations is a popup. So my relationship window falls behind it. Even if i meant not to make it invisible, i wouldn'd meet its purpose. Any more ideas to capture the close event of that Relationships window.

Thanks ghudson, Actually i came up with a better solution. To remove the Min-Max-Close Boxes from my title bar.Something i posted in the samples repository. Then i just disable my Menus and re-enable them when i need them and when i am closing the database. i also make sure that i set the...

Dont worry ghudson. I landed on this thread which has answered my plea. http://www.access-programmers.co.uk/forums/showthread.php?t=48557&highlight=close+form

what you can do is to extract all tables from that external db to your current database. Get that login details table name. Make a form bound to that table, and create a textbox and make it bound to the password field. That should show you the password. If it displays in astericks. Create a...

Check this Out. http://www.access-programmers.co.uk/forums/showthread.php?t=64532&highlight=logging

If the tables are not hidden, then the usernames and passwords are hard-coded. if the login details are not hardcoded, then you need to unhide the tables. There many exmaples in this forum on this issue. Try to search in the Repository.

Folks, i open my relationship window from a form and i after hide its visibility using the code below. DoCmd.RunCommand acCmdRelationships Forms![frmRelations].Visible = False I need to open the hidden form after clicking on the close(x) button of the relationship window. Are there any ideas...

Where is the error tracked to.

I meant right clicking the application windows or forms in the taskbar. I have never disabled my dbs for right clicking,i only protect them by disabling the shift key but if one goes the former way,will it impact on right clicking in the taskbar too? Some thing to do with this thread...

What about a situation when some one right clicks in the taskbar and closes the current form?? He will not be able to close the application window though, so he will be left with closing the whole access process. I think the function in ghudson's example should also be used on the switchboard or...