I've got a text file that contains data in the following format:
ID START END COMMENT
01 9am 12pm Login
12pm 1pm Lunch
1pm 5pm Logout
02 7am 11am Login
11am 12am Lunch
12am 4pm Logout
Now I...
I bought a lap top a few months ago that shipped with XP Home.
I'd like to upgrade to XP Pro. However I'd rather buy the XP full install rather than the XP Pro upgrade simply because my laptop didn't ship with the discs to reinstall the OS should it ever become corrupted.
ANyway to make a long...
I’ve got a database and I’d really like it to be as easy as possible on the end users to export a report in snapshot format, open a new piece of mail from outlook, and attach the report.
I decided to do this using the SendObject command. My code works fine for exporting the report and attaching...
I'd like to be able to store the hyperlink of a graphic file in my table but be able to display this image (rather than the link) any time I query it for a web page or form.
Is this possible, or am i taking the wrong route on this?
Basically I’ve got a query that returns the values of anyone who has tested greater than the value of a combo box. For this I use:
>([Forms]![Rpt_Form]![Score Type 1]-0.01)
>([Forms]![Rpt_Form]![Score Type 2]-0.01)
Each employee has the option of two test types. So I’ve got 2 of the above...
I've got a combo on my form, it refers to query that has 6 coloums but is only bound to the 2nd.
How can I go about having the records sorted in alphabetical order?
I've tried sorting the query that the combo box refers to but it doesn't seem to work.
I currently have the following code:
DoCmd.SendObject acReport, "Report", "SnapshotFormat(*.snp)", "[Forms]![Menu]![Email]", "", "", "Call Outs", "", False, ""
My problem is that instead of checking the email text...
Ok, I’ve been an Access user for 2 ½ years now and I am looking to expand into using it on a website.
Basically I want to have a table, lets call it main table.
It will have a query called Main Query
And finally a data access page that displays the data.
I would like to be able to select a...
At my job all of the workstations are running Windows 2000. I would like to be able to write a simple batch file to copy and paste a database to the desk top of the users.
Example:
Copy Database.mdb C:\Documents and Settings\JJohnson\DesktopDatabase.mdb
The problem I run into is each person’s...
I need a formula to show the last number keyed in a series of cells.
Example:
Day 1: $15
Day 2: $25
Day 3: $30
Day 4:
Day 5:
Week Ending: $30 (this number will change when Day 4, and then finally Day 5's numbers are keyed)
Any ideas?
I consider myself a pretty experienced Access user however I’ve never been able to get the Data Access Page to do what I want. I’m currently running Access XP Developer.
Anyway I create a Data Access Page using the Wizard using a basic table as my source. I have the option to scroll through the...
Is it possible to list just the top 10 highest percentages in a query?.
I've tried using that little drop down that appears in the query to limit it to just 10 records but the records that are returned aren't the top 10 but appear to be an average?
Spyder757
I've got a database at work that at any time may have 10 to 15 people using it.
I would like to be able to view either the address of the machine on the network....
-OR-
The user ID used by the person to log into the work station. We run Windows NT 4.0, 2000, and a few machines have XP.
The...
I've recently upgraded from Windows 98 to Windows XP, and I noticed while running my firewall that MSBLAST.EXE will open 10 to 15 connections on port 135 to an IP registered to http://www.iana.org.
When I terminate MSBLAST.EXE nothing bad seems to happen and my system goes about its business...
I've recently (today) bought a new lap top running Win XP Home Edition. I'd like to be able to have a test envroment to play with web site design.
Where could I download/buy MS Internet Information Server?
Spyder757
I went to change my homepage back to the default setting after some adware switched it on me.
The problem is when I went to change it I got a message stating I could not make the change and that I would have to speak to my network admin for permission.
If I attempt to make any system changes...
Ok I’ve got a table named main table.
It contains Paid Time Off (PTO) requests for all of our employees. As these people change supervisors and even departments (which they do rather frequently) I would like to go in and change the data previously entered for these people to their new...
I currently run Windows 98 and Office XP Developer.
I’ve just recently become interested in web design and I was wondering how I could create a web site and test it locally on my computer.
I’ve tried making ASPs but Front Page states they need to be published in order to be viewed properly...
Is it possible to have a query look at a subform for data?
What I mean is I’ve got a main form called “PTO Review”. Within that form there is a sub form named “Current Skill” and it contains a field called “Skill”.
What I need to have happened is a query need to look at “Skill” for the value...
I’ve got a main table that contains:
Agent Name
ID
Vacation Days
And I’ve got a table of employees who have been termed that contains:
Agent Name
ID
Term Date
Now I need to be able to automatically go back and delete the dates the termed agents had been requested out of the main table.
How...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.