gostaria de receber noticias
| | 0 | 58 | 11/11/2009 5:59:35 AM |
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, | | 5 | 65 | 11/11/2009 5:22:43 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...
| | 1 | 56 | 11/11/2009 5:06:39 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 | | 1 | 65 | 11/11/2009 4:53:02 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 | | 2 | 65 | 11/11/2009 4:51:47 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 | | 1 | 53 | 11/11/2009 4:51:00 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 | | 0 | 62 | 11/11/2009 4:44:14 AM |
ѧϰ ��С�� ó��0606 ��С�� ó��0606 ѧ�ţ�11
| | 0 | 60 | 11/11/2009 4:36:49 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. | | 2 | 64 | 11/11/2009 4:26:10 AM |
Selecting and Printing Specific Records Access 2003
Is there a way that I can select specific records from a database to print out specific columns for those records? As an example, I have a database of restaurants. I w | | 28 | 46 | 11/11/2009 4:02:32 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 | | 1 | 59 | 11/11/2009 3:55:01 AM |
Access - what tab is the page header/footer located in?
| | 0 | 60 | 11/11/2009 3:30:12 AM |
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 | | 3 | 56 | 11/11/2009 3:29:00 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 | | 0 | 59 | 11/11/2009 3:28:08 AM |
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 | | 4 | 54 | 11/11/2009 3:27:07 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 | | 1 | 58 | 11/11/2009 3:19:03 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 | | 1 | 50 | 11/11/2009 12:47:40 AM |
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 | | 5 | 48 | 11/10/2009 11:24:21 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 | | 3 | 47 | 11/10/2009 10:48:01 PM |
hello Hello my name is jordy we are my friend?
| | 2 | 53 | 11/10/2009 10:01:34 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 | | 2 | 49 | 11/10/2009 9:42:33 PM |
Time Server Computer System Network Domain And Workgroup Settings Name MICROSOFT-PC
| | 1 | 57 | 11/10/2009 9:15: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 | | 2 | 59 | 11/10/2009 9:13:46 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 | | 4 | 61 | 11/10/2009 9:08:09 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 | | 4 | 60 | 11/10/2009 8:48:43 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 | | 1 | 60 | 11/10/2009 8:36:12 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] | | 1 | 53 | 11/10/2009 8:26:23 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?
| | 6 | 55 | 11/10/2009 7:26:02 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 | | 1 | 51 | 11/10/2009 7:09:28 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 | | 1 | 53 | 11/10/2009 7:07:01 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 | | 0 | 52 | 11/10/2009 7:06:51 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 | | 0 | 50 | 11/10/2009 6:35:01 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 | | 2 | 58 | 11/10/2009 6:24:47 PM |
Count Where Hi,
I've tried every combination I can think of to get all results from a query
where a selected field is more than zero; this is the expression that I used:
Amount In Coun | | 7 | 51 | 11/10/2009 5:42:56 PM |
Refresh a subform I have two subforms on one page. When I double click on an object from the
first subform I want it to move to the second subform. I can get it to work
fine with exception of refreshing t | | 4 | 53 | 11/10/2009 4:51:55 PM |
SaveAs Hi
I have Module that prints out reports for me. there is command:
DoCmd.Save
How can I change to SaveAs?
(I would like put there a path so it saves as:C:/My Documents
T | | 3 | 54 | 11/10/2009 4:18:07 PM |
Word 2008 makes new folder of newly created document. I have recently installed Microsoft Office 2008 onto my G5 Mac PPC running on
Leopard 10.5.8.
Every time I save a new document, Word also saves a folder with sub folders
in addition t | | 2 | 53 | 11/10/2009 4:01:01 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 | | 2 | 38 | 11/10/2009 2:53:01 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 | | 1 | 59 | 11/10/2009 2:51:03 PM |
importing text files into access and generating queries and reports I have 50 word documents in Word 2007 format. The data in the word
files is in a table of two columns and 10 rows consisting of
paragraphs which is basically a report how a unit in our compa | | 8 | 48 | 11/10/2009 2:50:41 PM |
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. | | 2 | 51 | 11/10/2009 12:45:58 PM |
SubQuery Hello All,
I need a list from All the Items in the Inventory, the Last Date each item
was sold, and the qty sold on that date.
Doug Steele told me to use a subquery, it works fine | | 1 | 49 | 11/10/2009 12:05:41 PM |
testing tst
| | 0 | 57 | 11/10/2009 11:46:08 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 | | 1 | 49 | 11/10/2009 10:17:01 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 | | 2 | 49 | 11/10/2009 10:01:01 AM |
Printing Control Properties Is there a way to loop through the controls on a form and print the details
such as Top, Left, Width, Height
Thanks
Neal
| | 2 | 53 | 11/10/2009 9:35:01 AM |
http;//newsupdaties.blogspot.com 4paI4peV4paI4peV4paIIFdFTENPTUUgVE8gICAgICAg4paI4peV4paI4peV4paICmh0dHA6Ly9u ZXdzdXBkYXRpZXMuYmxvZ3Nwb3QuY29tCgrimaVgKuKAoi7CuMK4LuKAoirimaUgU3VjayBDb2Nr ICYgR2V0IEZ1Y2sgTWlsayBGZWVkaW5nIFlvdW | | 1 | 85 | 11/10/2009 8:14:02 AM |
Error opening subform MS ACCESS ERROR ON OPENING A SUBFORM
1. For some records, when I click on a button to open a subform, I get an
error. It appears to happen when 1 of 3 different fields for that record | | 3 | 44 | 11/10/2009 8:09:01 AM |
madeline perez
| | 1 | 61 | 11/10/2009 8:06:02 AM |
comprtilhar Gotaria de obter ajuda offline para baixa e exucutar m�sica em meu
computador
| | 1 | 51 | 11/10/2009 6:49:02 AM |
powerpoint teacher at school only runs powerpoint 2003, i only have powerpoint 2007,
what can i do?
| | 2 | 54 | 11/10/2009 6:48:45 AM |
Problem with Expression Good afternoon,
I have a parent form with 2 list boxes and 2 text boxes that supply
information to an expression located within a calculated control in a
subform.
Li | | 1 | 56 | 11/10/2009 6:01:01 AM |
Query to show latest price I have a stock/ ordering systesm
i have a tblProducts and then i have a tblProductPurchasePRice
tblProductPurchasePRice hold the price and the date i bought new
stock. This | | 3 | 36 | 11/10/2009 5:03:52 AM |
Wish List This is a multi-part message in MIME format.
------=_NextPart_000_0015_01CA617A.6C4C13F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: | | 1 | 91 | 11/10/2009 4:02:24 AM |
Relationship / query problem I have a master client table (Access 2003) which includes a number of companies. I also have a separate table for shareholders of the companies using a combobox with data from the master cli | | 9 | 146 | 11/10/2009 3:59:18 AM |
Auto email when due date is due Hello,
I've created a very simple DB to log customer complaints, nothing
complicated except the due date calulation which is due 30 days from the date
that the complaint was doc | | 2 | 52 | 11/10/2009 3:48:57 AM |
Calculating by an expression and another field I have created an expression in Access to figure out the amount of hours it
takes for a person to complete a work packet. Using the below formula
Expr1: DateDiff("h",[Order | | 0 | 51 | 11/10/2009 2:39:01 AM |
Run time error 438 I have a form with numerous subforms. Within the subform I am using a
function to hightlight the field the user currently is in. This highlight on
and off is hooked to the got focus and | | 2 | 62 | 11/10/2009 2:02:03 AM |
Scipting for Data Dump Hey everyone, I have a question about how to atumate a process. My
raw data is coming from Scantron forms. They are student application
data with address, dob, etc etc. I have the scannin | | 1 | 55 | 11/9/2009 11:35:58 PM |
9856078211@message.sprintpcs.com <9856078211@message.sprintpcs.com> 9856078211@message.sprintpcs.com
<9856078211@message.sprintpcs.com>9856078211@message.sprintpcs.com
<9856078211@message.sprintpcs.com>9856078211@message.sprintpcs.com
< | | 0 | 88 | 11/9/2009 11:31:40 PM |
Dupplicate Data I am trying to create a report that will return a format for a time frame. My
program is for a landscaping business that needs to know who's lawn needs to
be cut. Since this a weekly task | | 5 | 61 | 11/9/2009 10:41:01 PM |
Wierd Characters Access 2003.
When I reference a control value from a subform which is on the main form, I
get japanese looking characters.
The Main for has a control whose data source is:
| | 2 | 57 | 11/9/2009 10:38:23 PM |
intercambio de enlaces web de motor
AUTOIMPORTACION INTERCAMBIO DE ENLACES SOLO WEB RELACIONADAS
Enlazanos y consigue m�s visitas para tu web. Solo tienes que ponernos un
enlace en tu web
para aparecer como w | | 0 | 55 | 11/9/2009 9:53:25 PM |
INTERCAMBIO DE ENLACES
AUTOIMPORTACION INTERCAMBIO DE ENLACES SOLO WEB RELACIONADAS
Enlazanos y consigue m�s visitas para tu web. Solo tienes que ponernos un
enlace en tu web
para aparecer como w | | 0 | 66 | 11/9/2009 9:51:37 PM |
Format a Percent I posted a question on 6/24/09 titled "Format a Percent" that was answered
and resolved.
However I have an update to this question. The suggested solution worked
gr | | 3 | 48 | 11/9/2009 9:42:18 PM |
The Ignite Opportunity This is a multi-part message in MIME format.
------=_NextPart_000_0025_01CA6151.3AFEC1E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: | | 0 | 54 | 11/9/2009 9:28:04 PM |
Dropdown lists do not display for all users I have created a "Host / Child" dB for multiple users. This dB was created
using 2007 but saved as 2003 (some users using both apps). The host is
stored on our "public&quo | | 6 | 40 | 11/9/2009 9:01:02 PM |
Holding down form record navagation arrow does not work Holding down the arrow key used to zip thru lots of records. Now it only
works 1 record at a time.
| | 1 | 44 | 11/9/2009 8:49:47 PM |
hola hola
| | 1 | 51 | 11/9/2009 8:41:00 PM |
checking email add hope this works
| | 3 | 65 | 11/9/2009 8:15:16 PM |
Trouble with three firlds I have receivables form that has 3 fields I am having trouble with.
UnitsInStock AddUnits TotalUnits
UnitsInStock is drawn from a Products table, AddUnits is put in | | 7 | 47 | 11/9/2009 7:41:32 PM |
Managing a ComboBox DataSource in a Continuous Form Hi
I have a continuous form which has a combobox on each line.
I want to change the datasource for the combobox depending on what type of
data is in the other fields of tha | | 4 | 48 | 11/9/2009 7:31:42 PM |
esqueci a senha redefinir senha para YEKTJ12009400
| | 0 | 93 | 11/9/2009 7:19:16 PM |
Research project: one database or several I'm a bit of an access novice and I've had a wee search around these posts
but I apologise if my question has already been covered elsewhere.
I'm trying to build a database to hold qu | | 6 | 35 | 11/9/2009 5:49:39 PM |
Merge or Combine Tabels I have been asked to clean up a very complicated Access database. I have two tables, with the identical headings, different information. --Table1 is all the customers in one part of town
| | 4 | 45 | 11/9/2009 5:48:21 PM |
xxxxx
--
Isolete
isoletepieri@hotmail.com
fones - 19 - 38064367
9611-9174
| | 0 | 56 | 11/9/2009 5:08:37 PM |
hyphenation We started a document with the hyphenation box clicked and now we don't want
any hyphenation. I went under tools and unchecked hyphenation, but it is only
unhyphenating that text box. Is t | | 2 | 54 | 11/9/2009 4:54:01 PM |
Inconsistent working of SQL I have found that the following query works very well in OpenOffice. I am not
sure what is wrong with MS Office. It just doesn't work. Can anyone help me
please ?
select count(d | | 1 | 59 | 11/9/2009 3:51:03 PM |
2007 powerpoint School can only run 2003 powerpoint presentations, I have powerpoint
2007,what do I do?
| | 2 | 55 | 11/9/2009 3:28:11 PM |
atuoformt gives the word "overflow" & wont change design i keep getting this message every time i try and change the autoformat. it
won't even allow me to use the look up wizard correctly because it ask you to
confirm the autoformat change also. | | 2 | 45 | 11/9/2009 3:25:03 PM |
TransferText method -- pass parameterized query? I have this pretty big dataset and output 70+ csvs to a charting
program twice a year ... be lovely to loop through the dataset to
output my text files.
Took the approach of creat | | 0 | 56 | 11/9/2009 3:24:19 PM |
Use a combo box to find an Employee Hi,
I’m trying to identify a route driver based on the route number the location
& the time the route was at the location.
I have many routes with the same number (i.e. 100, 200, | | 1 | 48 | 11/9/2009 3:21:02 PM |
how do i run access 97 on laptop with XP os I take 'OUT OF MEMORY' message when run Access 97 on XP
| | 2 | 58 | 11/9/2009 3:16:04 PM |
kk ll
| | 0 | 52 | 11/9/2009 2:56:07 PM |
Format a Percent I posted a question on 6/24/09 titled "Format a Percent" that was answered
and resolved.
However I have an update to this question. The suggested solution worked
gr | | 0 | 54 | 11/9/2009 2:28:02 PM |
query query I've got a table of Memberships and a table of Membership types. I'd
like to build a reporting interface that has an unbound box that
allows users to select from the list of membership type | | 3 | 56 | 11/9/2009 2:19:18 PM |
using iif to set rate value I have a main form called Jeff Employee Info on there are two text boxes with
rates on txtRate and one txtRate2BP (which is a second rate that could
possibly apply for some jobs - that the | | 2 | 52 | 11/9/2009 2:06:01 PM |
Converting NETWORKDAYS Hi
i need to convert a function in an excel spreasheet into access using a
query.
NETWORKDAYS is the function. Does anyone know the equivelent in Access.
Thanks in advance. | | 3 | 59 | 11/9/2009 1:58:24 PM |
Auro-attaching Many photos at once from a SD Card Hello again,
Alright What I am looking for is a way to upload a batch of Jpeg files
to a specific record with as little effort as possible. What I would
like to have happen, is t | | 0 | 45 | 11/9/2009 1:29:39 PM |
FORCING A ZERO AT BEGINNING OF A NUMBER I have a number of 4-digit numbers in a table that I need to show as a 5-digit numbers. For ex., 1234 needs to show as 01234.
What's the best way to do this?
-- William | | 4 | 59 | 11/9/2009 1:09:10 PM |
Outlook Express willnot open or delete! "Deleted Items"willnot op Can anyone help me? Outlook Express has come up with "Unable to open Deleted items folder and will not let me delete incoming mail/or outgoing mail!
| | 3 | 47 | 11/9/2009 12:54:44 PM |
informazioni C.A. Direttore
per quanto concerne il preventivo del servizio di pulizia, verr� contattato
direttamente dal dott. Stefano Consoli di cui Le lascio recapito in caso di
necessit�: | | 0 | 57 | 11/9/2009 11:15:55 AM |
invio documenti This is a multi-part message in MIME format.
------=_NextPart_000_0010_01CA6135.84503390
Content-Type: text/plain;
format=flowed;
charset="iso-8859-1";
repl | | 0 | 54 | 11/9/2009 11:09:41 AM |
hola presiosura
| | 0 | 52 | 11/9/2009 10:25:05 AM |
que honda susana
| | 0 | 94 | 11/9/2009 10:16:57 AM |
hola como as estado
| | 0 | 59 | 11/9/2009 9:33:45 AM |
prova buongiorno,come va ?
| | 0 | 54 | 11/9/2009 8:38:18 AM |
listbox align right I have an Access 2003 Form with a listbox that has three columns. I
know that using a list box like this is not ideal if I want to control
the left-right alignment, however, I am using the | | 1 | 49 | 11/9/2009 3:34:56 AM |
all ms word documents changed to gibberish. now are illegible I turned on my Dell Inspiron 530S that uses Vista and all of my MS Word
documents are now illegible. All Docs look like gibberish and I don't think
it is html, because it looks different t | | 1 | 50 | 11/9/2009 12:55:02 AM |
How to Find & Replace a Particular Phrase in Access 2003 I have a database of over 10K records, each has the following phrase that I
want to change from
border="0" /><center><strong><font color="#990000&quo | | 2 | 44 | 11/9/2009 12:13:01 AM |