wats up

hi dad

how to put up 5 PCs with Windows XP and 7?

Hi, I have 3 PCs with Windows XP and 2 windows pc 7. I find it difficult to network to share folders between them. How can I network? thanks ...

Database for cataloguing magazine content

Does anyone have a database for cataloguing the content of magazines by author, subject, keyword, date, etc? It wouold seem to be an obvious application but I have been unable to find one and I've got a lot of learning to do before I could develop one for myself.

MS Access 2007 Query _ Report

I have a table that consists of a field named Minutes, multiple entries for a specific individual may occur for any given day. I am placing a calculation in a query that will break the minutes into 15 increments by using the formula [Minutes]/15. The result value is coming up in correct when the units are rounded; however, some values are rounded up. Example follows: Minutes for a specific record; 5, 90, 50 for the same day = .333, 6, 3.333 respectively. In the report the total = 9.667, which should reflect 9 only; in the report it rounded to 10 The next record reflect M

Where is the startup manager in 2007

I can't even find the word splashscreen or spash screen in 07 help. I inherited a database that uses switchboards and want a splashscreen so they can either go into it, or open a utilities form where I throw my own options and functionality. But I dont see anything on splashscreens, the startup manager to determine which form opens at startup. Only the switchboard manager. And switchboards are idiotic. That level of complexity and abstraction to simply open forms and reports is imbecillic. One form, one function, one button, one function. Its much easier to build, reverse engi

Close Form Event

I have a AC2003 bound form. The condition I'm trying to capture is if the user modifies any item on the form and they close the form without saving changes. Simple...right? I found out that Form_Close doesn't work so I tried the following code in the Form_Unload event and that isn't working either. It does not even trigger the event. Can someone please tell me what I'm doing wrong? I would be much appreciated. Private Sub Form_Unload(Cancel As Integer) If Me.btnSave.Enabled Then Dim strMsg As String strMsg = strMsg & "Save Changes?" & Chr(13) & Chr(13)

Unable check mail inbox

Recently, many students in our campus(Shanghai Jiao Tong University) have been complained about the problem. In detail, we are unable to check the Hotmail inbox with Windows Live Mail, or enter most related website. And the error code is:0��80082EFD

Link table field format puzzle

I have one issue that doesn't make sense. Maybe some expert could help. I have one table in MS SQL (2005), there are two fields. GrossCost Numeric(15,2) NetCost Numeric(15,2) When I did an ODBC link table inside MS Access XP, the format of the two fields are different. For example, GrossCost will show 16.00 and NetCost will show 16 I open the link table in design view and find out the GrossCost's [format] property are set to 'Fixed' while the NetCost's [format] property are blank. Why Access treat the two fields differently if they have exact the same format on SQL side? A

Let's pick a replacement for this (Access) newsgroup 2

There were two big threads on the original 6/1/10 post in the General Questions and New User sections. The gist of the original post was: Folks have recommended various sites to replace this (Access) newsgroup for when poor-listener Microsoft drops it. Why don't we pick a replacement to give it the "critical mass" to fully replace this one? If interested, please respond to this with your recommendation. Also, if you feel like it, in case this goes dead, send me an email with your email address at North9000 at gmail dot com and I'll try to collect / send out the news/results.

nothing!

vkdjvhdkjgdklgdkgckjgkcjn

Exclude most recent month

Hello, I have a query called qryReadmits based on a table called tblReadmits that has fields such as ReadmitMonth, AccountNumber, Readmit (1 or 0), Population (always 1). Data is populated into tblReadmits on a periodic basis. Sometimes the data is fairly current (2 months behind) and other times it is up to four months behind. I want to create a query where I group by month the readmission rate which is Readmit divided by Population. But I want to always exclude the most receent month that is available. I want to automate this since I will be reporting it each month. Can

Unable to read message content

I have a pop3 account. I am able to download all my messages but random ones do not appear in the message reading pane. (They appear totally blank.) If I drag it over to my desktop and open it there, I can read it, (but then I can't reply to it). It also seems random; sometimes they are HTML messages, other times they just seem like simple plain text. Please help! Thank you in advance. - RT Kreger

VBA conditional formatting

Hi there, I have read up about conditional formatting and understand the *concept* clearly (I think). However, is it possible to display conditional formatting of a subform in datasheet view on a form? If so, can someone please help me with the VBA coding of this, as I need to have more than 3 (or 4 if default is used) colours? Thank you! W -- The Psyber Fox http://www.psyberconsulting.co.za

populating an Access table from a text file

A text file has data in a format like the below: Title1 Cell 1 data Title 2 Cell 2 data Title 3 Cell 3 data .. .. .. Title 10 Cell 10 data Title 11 Cell 11 data .. .. .. Title 15 Cell 15 data .. .. .. Title N Cell N data I guess I can read this using some VBA code posted at http://www.mvps.org/access/modules/mdl0057.htm and http://www.granite.ab.ca/access/readtextfile.htm, add an Instr function to it so that when I read the text file, I know when to insert the data properly in the table. 1. Is there another way I can directly import the data into an Access 2

Access as a Front-End

I am wanting to use either MySQL or SQL Server as a back-end to a MS Access front-end. Furthermore, I need to be able to use this front-end over a Wireless router. I know that by default MS Access does not leand itself to wireless connections but have been told it can be done if changes are made...? Can someone give me a little guidance on the matter. Perhaps refer a good article or site that covers this subject to get me going in the right direction. Thank you, QB

Calculating time

I have a single table database that has a drop down box of 60 days, 90 days, and 180 days. I want to calculate to time from the date of entry in the database to count down from the days that was selected in the drop down box. How would I go about doing this please be detailed and if you can include a simple of the code that I would need in order to complete the task.

Display subform total

I have an Access 2007 single form with subform. The subform has a hidden textbox that sums a record in the subform and displays in a textbox on the form. The form textbox is blank, but becomes visable if I click on the taskbar or open another app. If I update the subform or move to another record, I loose it again. I've tried requery and recalc on practually every event of the form, subform and both textboxes to no avail. What will make this textbox stay visible? -- Lafayette, LA

Display a message box "this entry is a duplicate"

How can I display a message box on a form if the shipment number is a duplicate? I need a message box to pop up when user attempts to tab out of the field. Thank you.

Auto scrolling textbox (auto cue)

I have a form that is activated after an user presses <F1> on a field. This so called Help form displays help information on the specific field. The Help form has a vertical scroll bar and it has a limited size (height/width) What I would like is once the help form is displayed, the text starts at the top and automatically scrolls down at a controlled pace. This way the user can 'watch' the help text without selecting the vertical scroll bar. (the scroll bars must be hidden). Is this possible?

2003: Referencing Object On Subreport

I've Googled this and *think* I'm doing the right thing, but no-go. Report A has subreport object "subViolations" whose SourceObject is another report. Within Report A's code I am trying to change the caption on a label in the subreport. Generically, it seems like this should work in the Immediate window: Me.subViolations.Report!lblReportHeader = "Compliant" or, simpler still: ?Me.subViolations.Report.Name But both throw Run-time error '2455'; "You entered an expression that has an invalid reference to the property Form/Report." Anybody have a thought? --

access

��� ����� access? ��� ���� �� ������������? __________ Information from ESET NOD32 Antivirus, version of virus signature database 5167 (20100602) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru/.ml

Hi from Lana

Well Daryl & I are on our way out west. We make it to Bilosi, Miss. had to stop and give them some of our money at there casinos. Well I came them money but Daryl being Daryl came out ahead. So grateful to be sober and have this time with Daryl and being able to make this trip that we have been wanting to make for so long. I will try and keep in touch each day and let you know where and what we are doing. Keep calling me and keeping me in touch with you all so I can keep myself grounded in AA. So grateful to have you all in my life. Love to all Lana

Menu

Here is my menu enjoy!

One field, multiples entries

Many eyars ago I used a database language called "PICK", this enabled you to have a field with multiples entries in one record of a table. I read somewehre that Access 2007 had this capability, I cant find areference to this, can 2007 do this? Rather than have a table referencing a second sub table Pat

Table of Contents for a Report

I have a report in Access that has 33 sections and I would like to create a Table of Contents to show the start page number of each new section. Is this possible? If so could someone please provide details as to how it can be done? Thanks Samantha