George Oro
Last Activity: Aug 9 '07, 07:40 AM
Joined: Jan 8 '07
Location:
-
I believe MsAccess Northwind and Orders sample db is a very good start.... -
You can use this also, paste this code to a new module and named as you like.
...Code:'This function replace the built-in Replace function: Function FindAndReplace(ByVal strInString As String, _ strFindString As String, _ strReplaceString As String) As String Dim intPtr As Integer If Len(strFindString) > 0 Then 'catch if try to find empty string DoLeave a comment:
-
How I forgot the CDate function?! silly George! thanks for the tip-trick chief!
Regards,
George...Leave a comment:
-
PS.
I agreed on this:
The reason I advised to put Me.Refresh
because its an unbound form (as he said) so it will not trigger any updates and this is what Im using too that works.
Your welcome..
cheers,
George...Leave a comment:
-
First 180 fields in one table is not really normal for me.
To check the file size, first close your mdb then right-click and select properties or just see it in windows explorer.
To compaq and repair: Open your mdb then goto Tools -> Database Utilities -> Compaq and Repair Database.
George...Leave a comment:
-
Why just make a subform form TARA then use Opin as Mother and Child link ID?
HTH,
George...Leave a comment:
-
Put this code where your opening the form:
...Code:Dim intMsg As Integer intMsg = MsgBox("Please note that you are in 2006 Database." & _ " Do you want to continue?", vbQuestion + vbYesNo + vbDefaultButton2, "Please confirm") If intMsg = vbYes Then 'Open your form here Else 'its up to you End IfLeave a comment:
-
Hope I understand you correctly: Lets add Field3, Field4 and Field5
Set Field2-5 to
Enabled=False
Locked=True
'and
Me.Field1="No"
then on AfterUpdate event of Field1 put this:
...Code:If me.Field1.value="Yes" then me.Field2.Enabled=True me.Field2.Locked=False else me.Field2.Enabled=false me.Field2.Locked=true end if
Leave a comment:
-
If me.YourChoicePu lldownName.valu e = "No" then
docmd.openform "YourFormNa me"
else
'In case you have some condition if Yes
end if
Your saying its a subform, so subform is attached to a form and always open. I assumed your subform is another form.
HTH,
George...Leave a comment:
-
Not so sure if this will help but try Crosstab Query.
I believe its more easy to make some queries if you will change your structure. Make one new table e.g tblCustomerCate gory then add 3 fields:
CustomerID - this will link to the main customer table
Category - same approach
Timestamp - default value now() just for your info when the record inserted.
from the structure you are not limited.
...Leave a comment:
-
Im using different code to open an external database and the workgroup to be used is hardcoded. So if you're using workgroup, I believe you have to define it.
HTH,
George...Leave a comment:
-
If you want to open the file using a command button, you can reference the link to the command button property. e.g.
HTH,Code:Me.cmdOpen.HyperlinkAddress = "http://www.google.com/"
George...Leave a comment:
-
An AutoNumber field type only will do. If you want some sort of formatting of autonumber then it should pass to an interface.
George...Leave a comment:
-
What is the size of the file now? Could you run compact and repair....Leave a comment:
-
My pleasure...
BTW, the me.refresh doesn't work? because it works to me. Anyway job done=)...Leave a comment:
-
Copy that...
Regards,
George...Leave a comment:
-
I believe you cannot attache the email itself. As a workaround maybe this will do:
1) Link the Inbox
2) Add an email address field in your Customer Information
3) Create a query from the Inbox
4) Create a subform or form and bound to the above query
5) Link the Email Address from the customer information to the Inbox email address.
6) Then your subform/form will automatically view the respective...Leave a comment:
-
You said:
i have a button next to this, this button takes me to a small form where i insert a new site name with the address details........ .............
So that button for sure there's a command line something like this:
docmd.openform "YourFormNa me"
then put me.refresh on top of it so it will look like:
me.refresh
docmd.openform "YourFormNa me"
I...Leave a comment:
-
Sorry but not 100% clear what you up to but it seems you have to change your approach.
Wish you luck mate.
George...Leave a comment:
-
I see, try to put this before opening your small form
me.refresh
hth,
George...Leave a comment:
No activity results to display
Leave a comment: