Child ID Access

I am posting this for someone else as I’m trying to help them. They are running WIN 2000, and have AVG as their virus protector. Any tips on how they can remove the virus?

ok, you are infected with Trojan.Zlob , that’s why you are getting these kind of dangerous spyware. In actual, Video Access ActiveX is a fake codec and installed itself while watching any porn clips or so on. You can manually remove it from the below link , there you can get free manual removal ,,

http://www.pcontech.com/spyware/remove/spywarelocked-remove.htm

I have to work with several databases originally created in Access 2000, and I’m sick of dealing with flat buttons and a putty-colored default form. How can I update the interface to use the Access 2003 (WindowsXP) style command buttons and color schemes in the forms?
I just started learning about Access 2007’s "Ribbon" menu system – it’s 100% XML. The Microsoft Dev team is going hardcore into XML.

AFAIK, unless you can find a utility on the web somewhere, you’ll have to modify each form/button/scheme yourself. Even if you save your mdb in the new format (Access XP or 2003 or whatever), it will still retain its old attributes. Sorry.

I myself sure wish that the mdb (at least the forms and vb) was stored as xml so you could have a whack at it as text. Maybe Access 2007 is like that…

Collective Soul’s lead singer Ed Roland invites fans into his lakehouse/studio to witness his photo shoot for Yamaha’s All Access magazine. Hear all about how his songwriting process has changed through the years, what makes the new album different, and more, all to the tune of Staring Down.

Duration : 0:3:39

(more…)

trying to create distribution tables and reports with access 2000 and dont really know where to start

Maybe it is do-able in MS Access but exporting the table out of Access and into MS Excel might be easier since Excel will easily let you create a pivot table

(With the table selected, look under "File" or "Tools" menus in Access to export to Excel).

Media has much reported on the fate of more than 300,000 tamil IDPs currently held in internment camps funded by UN and International agencies and their lack of freedom of movement. These rare images emerging from Sri Lanka shows the forgotten storey of Tamils who are dog-taged and arrested by Sri Lankan Military Officers for interrogations as possible suspects of Tamil Tigers. Sri Lankan government has claimed that they have arrested more than 10,000 suspects but ICRC has only access 2,000 of them. None of this suspects were produced in courts and dont have access to any legal support & effectively in illegal imprisonment.

Duration : 0:4:4

(more…)

As a project, I need to create a home inventory database. I have to include at least four tables. What would you suggest would be appropriate tables for this project to create relationships and what should the relationships be? [ex. Location (Room)? or category? ] I have 1 table for electronics, 1 for furniture, 1 for collections and 1 for jewelry. Access is a little frustrating for me and I am having a bit of difficulty planning this home inventory and getting it to make sense so some advice would be so appreciated.
To sum it up, I could use some suggestions on what would be good field names, tables and most of all.. what relationships I should be creating between tables. Thanks all!

A relationship between table is what links the tables together.
Your tables are electronics, furniture, collections and jewelry. For each table you have to have a unique identifier. This will help you link the tables together.

For the Electronics table you can maybe say:
Electronics:
Number – (Field1 – unique identifier – stores the number of electronic items in your household)
Type – (Field2 – type of electronic item eg. TV,radio,Microwave etc.)
Quantity – (Field3 – Number of each type of item eg. 2 TV’s etc)
Price – (Field4 – Price of each item Eg. 3000)

You can include other field names eg. Manufacturer and Model. This can be a separate table where you can store all the Manufacturer and Model names eg. for a TV you can say the manufacturer is Samsung and the Model is LN-T4665F. This is where the relationship comes in. The Manufacturer and Model field in your electronic table will link to the actual Manufacturer and Model table so when you open your electronis table, you will be able to see who manufacturered that specific item from your electronics table. It’s confusing to explain but if you understand the concept, it’s quite easy to do.
You can apply the same idea to your other tables.

If you need more help or still dont understand how to go about doing this, drop me a mail and i’ll try my best to assist. Hope this helps and all the luck!!…:-)

How can I let other computers to access my SQL SERVER 2000 through internet? I have already a StaticIP.
Please let me know if there is any setting for that, in SQL-Server 2000?
Thanks

The only thing you need to do is allow TCP port 1433 through your firewall to your server. Port 1433 is the port in which SQL communicates with applications. Allowing this port to be forwarded from your firewall to your server (using Network Address Translation – NAT) will allow access from internet sources to your server.

**Beware! Opening this port blindly to the internet is a security risk and should not be done unless absolutely necessary. If you know the IP address(s) of the servers/clients that need to connect to your SQL server, you may consider locking down the NAT policy to apply only to requests coming from those specific hosts.**

Anna Paquin and Hugh Jackman talk ‘X Men’ for Access Hollywood
year: 2000

Duration : 0:4:46

(more…)

Using "=Forms!Formname!Fieldname" in the control source doesn’t work, Access automatically inserts [] around the form and field names redering it useless. Is there another way of doing this?

you can go to form view of that form and type

Me.FieldName2.Value = Forms!FormName!FieldName1.Value

Say you have a form named "Users" and a subform named "UsersSub" with a textbox with a name of "UserName"

Code:
Dim UserName As String
My_UserName = Forms!Users!UserName.Value

MsgBox(My_UserName)

The key to the whole operation is "Forms!Form_Name!Input_name"

If the data you need is in the same for or subform all you have to do is

Code:
Dim UserName As String
My_UserName = Me!UserName.Value
MsgBox(My_UserName)

"Me!" is saying the current focused form name/object

Here is a simple usage. Say you have a form of users and you are tracking them by location and what time to contact them and you want to view all the people to call during the day time. You want to click on their name in the subform and have their contact information open in a new form.
The main form’s name is "Users" and the subform textbox name is named "Info"

Code:
Option Compare Database

Private Sud Info_Click()
Dim UserName As String
Dim Contact_Time As String

UserName = Forms!Users!UserName.Value
Contact_Time = Me!Info.Value

‘Now we open a new form
‘Search for that person with that user name and contact time
‘The newly open form’s name is "UserInfo"

‘Define the form to open
Dim NewFormName As String
NewFormName = "UserInfo"

‘Set the username and contact time criteria
Dim Criteria_ As String

‘[] is the field name in the database table
Criteria_ = "[UserName]=" & "’" & UserName &"’ AND [Contact_Time]=" & "’" & Contact_Time & "’"
DoCmd.OpenForm NewFormName, acNormal, Criteria_, acFormEdit, acWindowNormal

End Sub

See viewtopic.php?f=4&t=97 for more DoCmd

I need the chart to change with each record.

As is so often the case, there are several techniques you might use, but the best solution is for you to create a template and then at run time adjust the various settings of the different controls.

For example, if you build a line graph, you need only adjust the Left and Top properties of the [data] points and then draw a line (using the Line method) to connect those dots.

Or, you can build a bar chart and do pretty much the same thing: adjust the Top (or Width, if it’s a aligned horizontally) property to fix the bar’s height.

You really need a copy of Access 2 Power Programming…