CodeVerge.Net Beta


   Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums



> NEWSGROUP > Microsoft News > microsoft.public.access
 Post New
 TypeRepliesViewsDate
WQ ET ET EG
DG DG RH FHF HF HR


 096-2860418523 sec. ago
jkkkk
siema

 291-19892300 sec. ago
How to cut & paste with MS Office Picture Mgr?
How do I cut a portion of a picture in Microsoft Office Picture Manager then
paste it to MSPaint? It used to be easy with MS photo editer.
 2118-12333807 sec. ago
gostaria de receber noticias

 02311/11/2009 6:07:54 AM
How do I prevent a number from rounding in Access?
If I enter a number with a decimal, Access rounds the number. For example 1.5
becomes 2, etc...
 02011/11/2009 5:12:12 AM
Another try!
Hi, Janet, I just got back from a very long meetiong with the Pastor, Mark,
and JOE YANKE! He hasn't left! I'm so glad to hear that. Anyway, I've
tried to follow my computer's directio
 03011/11/2009 4:50:38 AM
ѧϰ ��С�� ó��0606
��С�� ó��0606 ѧ�ţ�11


 02611/11/2009 4:43:35 AM
Resize textbox in a datasheet
I have a subform in which I am using a datasheet to display & edit results
from a table.In one of the columns in the datasheet, a user writes his or her
comments.I want the textbox/col
 02711/11/2009 4:29:26 AM
Import a .xlsx file into a MS Access 2000 .mdb table
I have an Access 2000 database that imports an Excell worksheet using
transferspreadsheet. The source of the worksheet changed from Excel 2000 to
2007. Now I receive the error that it is a
 02311/11/2009 3:43:01 AM
Access
- what tab is the page header/footer located in?
 02011/11/2009 3:32:16 AM
increase size of database
Has anyone grown out of their access database >2gb and upgraded to Microsoft
Project for use in a multi user enviroment? I need to know if this is worth
doing or going in another direct
 02311/11/2009 3:32:15 AM
Table set up
How can I make sure that when data is entered in a table the data is all
caps. Example, I need state (two positions) to be all capital letters even if
the state is entered in initial caps.
 02311/11/2009 3:32:15 AM
Max of UniqID in Sql
SELECT dbo.inform.code1, dbo.inform.name, dbo.inform.desc1,
dbo.master.uniq_id, dbo.master.caseno, dbo.master.clnam, dbo.master.state
FROM dbo.inform INNER JOIN dbo.master on dbo.inform.co
 03111/11/2009 3:32:14 AM
Date format when exporting
The date format of my query export to csv keeps howing as mm/dd/yyyy 0:00. I
only want to show mm/dd/yyyy.

My regional settings are set to short date as are the fields in the import
 02211/11/2009 3:32:10 AM
combo box data type
i am trying to have 2 combo boxes, 1st box is to display boxNumber,
2nd combo box is to display ChipID based on the selection of 1st combo
box... 1st combo box is getting list of value from
 02411/11/2009 2:24:30 AM
Data entered stays the same until command button is clicked
Hello,

So I have a form that has the textboxes username and Shipment number. Data
is entered in the textboxes via barcode scanner. Everything is working
great. when I scan a
 03311/10/2009 11:30:07 PM
Time Server
Computer System Network Domain And Workgroup Settings Name MICROSOFT-PC
 02411/10/2009 8:06:46 PM
Want to filter a List Box in a form by entering a date in a text box
Hi.
I want to filter my List Box by the date I write in a Text Box.

I do have one form with a text box and a List Box. The List Box's
row source is a SQL with the qriteria [forms]
 02711/10/2009 7:52:32 PM
Upgrade question - verify media?
Hello,
I'm just wondering about upgrading an older version of access to 07. There
are a couple computers I want to upgrade. Some came preinstalled and I have
no media (but a valid lic
 03311/10/2009 7:42:45 PM
24-hour clock format
I have two issues. I need to show "military" (24-hour) time in my database,
and those fields are also used to calculate the amount of time used by
personnel.

I am usi
 03311/10/2009 7:32:50 PM
hello
Hello my name is jordy we are my friend?
 02111/10/2009 7:28:43 PM
Auto populate fields
These are the fields I have in a form. I already have it that where we have
a query set up to populate Reason1,2, and 3 once a number is entered into the
box the description shows in the
 03411/10/2009 7:18:48 PM
liquid thinking
Hi Damian,
I was at a conference you were part of in Feb for Beaverbrooks. My names
Anne Walsh and i manage the Beaverbrooks in Birkenhead. I wanted to let you
know that one of the pe
 02311/10/2009 7:10:33 PM
Attachments to Access Record
We want to be ablee to attach documents to each record. I ahve seen you can
add it in an 2007 access table. but we need to know how we can create it
from sql side. any suggestions would
 03011/10/2009 7:00:43 PM
continuous subform validation
On Access 2003
I have a main form called f040ProjectMain(PK ProjectID)
I have some fields on the main form that are needed to be populated so I
have the below code..

If IsNu
 02711/10/2009 6:44:45 PM
Access Database and Rss Feeds
Hello, I am looking for some information on how to capture RSS feeds and to
store them in a Microsoft Access database. Specifically I would like to:
1) Set up the feed
2) Capture the
 02311/10/2009 6:36:44 PM
Auto enter an ID # in a sub-form
I have a form with a button that opens a sub-form when I click on the button.
The "ID#" fields are linked via relationship between the form and sub-form.
When the sub-form open
 03111/10/2009 6:32:50 PM
SQL Upsizing Problem with Left Join Queries
I am in the process of testing a database upsized to SQL Express 2005
(originally created through jet/local mdb). The data is comprised a couple
dozen tables: one-to-one, one-to-many and
 02811/10/2009 6:30:36 PM
Reports ComboBox
I have been using Access 97 for years and I have 3 ComboBoxes which lists the
reports that are in the database but I have used the individual reports
properties description to contain inform
 02311/10/2009 5:30:43 PM
Properties - Format, Input Mask, Validation Rule
Hello,

I'm adding a new field to a table to hold a date. The field must be
able to except input in all three of the following ways:

yyyy (just the year, without month or
 03311/10/2009 5:06:49 PM
Closing a subform
I am trying to make a subform close after one entry. The table behind the
subform has a one to one relationship with the table behind the main form.
I've tried everything I can think of,
 03211/10/2009 5:00:42 PM
Report order
Hi
I created report with header sorted out descending. Management asked me to
change the order to specific items, so can I do it without many changes to
the querries or report? I was
 02511/10/2009 4:24:19 PM
Keeping appointments with a graphical "Timeline"!
Hello guys,

I once saw a sample database where you could input your appointment with
dates,and you could see the result in a graphical "Timeline" ,which was very
clear
 02311/10/2009 3:28:31 PM
Form_~TMPCLP216211
I am using Access 2003.
At the top of my VB editor Folder list there is a Form called
Form_~TMPCLP216211.
What is this and how can I get rid of it?

Thanks,
--
deb
 01911/10/2009 1:48:17 PM
Adding to a Ribbon
Is there any way to add to the "comes with" ribbon? Specifically, I'd like to
add Print to the Home ribbon, so the user doesn't have to squint for the
teeny-tiny add-in at the to
 02311/10/2009 1:22:31 PM
Form Not Showing Records buy Record Source Query Does
I have a forming that will allow entries but will not show past entered data.
It's record source is a query. When I run the query the records show.

The form was a copy and paste of
 02411/10/2009 1:06:27 PM
Table Design view question
In design view of a table, I have 50 fields. Is it possible to sort the
names of the fields alphbetically automatically without having to manually
sort them?
 02711/10/2009 11:58:30 AM
testing
tst
 02411/10/2009 11:48:18 AM
Creating a Field in a query from 2 fields in a database table
I want to create a field in a query form 2 fields in a table (Surname and
Last name), so that I can create group field in a report. I have tried a lot
of things and nothing seems to work.
 02811/10/2009 11:42:24 AM
Research Project: one database or seperate
I'm a bit of an access novice and have a wee question. I'm building a
database to store and analyse questionnaire responses for a research project.
I have 11 separate questionnaires for di
 02111/10/2009 9:12:34 AM
Create Unique Number
I hv the following format of records in my acno field (text field)

ACNO
00104/67/011601/34
00104/67/011257/68
00104/67/014142/62

In a query i want to create a fiel
 02011/10/2009 9:04:32 AM
Immediate Window: Annoying Notation?
When I'm debugging, likely as not I'll get something like:
-----------------------
?YieldRate
5.34193893129773E-02
-----------------------

Which means nothing to me, so I wi
 15852/23/2008 5:52:20 PM
Interactive Guide getting "Not a valid Win32 application" error
I downloaded the Interactive Access 2003 to 2007 command reference guide and
when I try to run it, I get a "Not a valid Win32 application" error. I've
downloaded other interactive guides an
 0882/6/2008 8:13:01 PM
Command Button - Need Assistance
Hi,

I have a database that was made for me that has active command buttons for
ID#, last name and Employer. I have since added another text box to the form
for a secondary ID (not
 3692/6/2008 8:08:07 PM
Seems like a silly post - but - I can't KEEP my toolbars !?!
running access 2k;

EVERY single time I start my access application, my toolbars are
missing. I have to go into view, and turn them on.

Why don't they STAY visible!!??

TI
 2782/6/2008 8:05:21 PM
Office 2008
Whenever I try to use Entourage to connect to my .Mac email account it wont
go through. It might be an Apple problem but I just wanted to see if anyone
else had this problem.

-Hayden<
 0942/6/2008 8:00:07 PM
Converting a date to a numeric (1-7 number) day of the week
I am trying to take a date (e.g., 01/01/2008) and have Access tell me the
numeric day of the week (1-7) that corresponds to each date in a table.
Thanks for your help!
 41102/6/2008 7:59:01 PM
Auto generate a label/number
I would like to track orders and have it assign a new, consecutive order
number to each new record. Example we have order MCO25, the next new record
I would like to have it auto generate MC
 18952/6/2008 7:51:00 PM
Importing data into a Lookup Field
Well, I imported a bunch of data into a table with a lookup field.

The lookup field goes to a table of projects and the relationship is
on an auto generated primary key.

When I i
 2732/6/2008 7:50:08 PM
Consolidate records from one table into another?
Due to a design error, we have a table for Invoices and a table for
InvoiceLines and the fields for the various lines are set up as InvLine1,
InvLine2, InvLine3, InvLine4, InvLine5. Accordin
 5872/6/2008 7:47:04 PM










   
  Privacy | Contact Us
All Times Are GMT