|
INSERT INTO - wrong fields number error
Hi.
I'm trying to insert one record as a copy of existing one with some
fields modified.
Result: Run-time error 3346: Number of query values and destination
fields are not the same.
I've counted the records on both sides, and for me everything seems to
be correct... What is the problem then?
sSQL = "INSERT INTO T_SMP_FIFO([KEY], [STDIV_SKU], [SMDINR], [PKTWL],
[SMARNR], [SMCOLR], [SMTYPE...
|
4 |
12/11/2008 1:45:02 PM |
|
|
how to make the field "e-mail address" to be active
I'm usind a template (call tracker) and when i double click the e-mail
address in the main table customers it is opening me a new window where I
can direcly send a mail, but when I'm puting this field in a new form or
query it is lousing this function. What should I do to keep this function.
Pleas if anybody knows how to do this send me the answer, Please ...
|
2 |
12/11/2008 1:13:20 PM |
|
|
Printing One Page of Tab Control in Report
Is it possible to select one of the pages in an Access form's tab control and
print the associated text fields in a report?
I have several pages in the tab control, but only need to print a specific
page at any one given time.
Please include syntax and where exactly the syntax goes if this is possible.
Thank you ...
|
1 |
12/11/2008 12:11:00 PM |
|
|
Editing by creator only
Is there a way to limit who can edit saved entries? I have a shared
database. I would like only to allow the person that created the entry to be
able to edit it. Is this possible? I am using Access 2003....
|
3 |
12/11/2008 12:04:04 PM |
|
|
Any consensus on stability/readiness of Access 2007 runtime?
This question is intended for MVP's, consultants, etc., who develop and
deploy Access projects in larger/multiuser environments (at least 5 users and
up)...
Is there any consensus on whether or not the Access 2007 runtime is really
ready for production use in "serious" (at least 5 users, many forms, many
reports, complex forms, etc.) projects?
I'm a long time user of previous version...
|
48 |
12/11/2008 8:58:25 AM |
|
|
How to execute SQL strored procedure from Access
Hi All,
There is a SQL stored procedure in SQL Server 2005 which restroes one of the
database with client's backup.
Is it possible to execute the same stored procedure from MS Access, if yes
how it will be?
Advanced Thanks
Vinod...
|
7 |
12/11/2008 8:45:50 AM |
|
|
Sending out email through Outlook using Access
I have done multiple searches on the web, but can never get a clear answer to
this...
I have a query in Access 2007 which contains email addresses. I want to
send those records an email using Outlook 2007. Can someone please provide
me the procedure for this?
Thank you so much!
Robert Stanke
http://robertstanke.com
...
|
4 |
12/11/2008 8:36:44 AM |
|
|
Error Message - Locked table
Hi I keep getting the following error message after I have closed one form
and go to open another.
"You tried to lock table ".... " while opening it, but the table cannot be
locked because it is currently in use. Wait a moment, and then try the
operation again.
When I wait say 30 seconds befor opening the second form, all is well. But I
don't want the user to have to wait. Is there a...
|
4 |
12/11/2008 8:12:01 AM |
|
|
Button wizard
When I run th wizard for a button to open a form based on matching data the
left choice is blank...
|
2 |
12/11/2008 6:27:56 AM |
|
|
RunTime 3709
Hi,
I'm using the command me.refresh in the after update event of a combo
box.It produces this error: RunTime 3709 the search key was not found in any
record.
...
|
2 |
12/11/2008 6:21:45 AM |
|
|
Separating records all in one table to separate fields
I have all personnel records in one table coded by job function. I need to
break the managers from the list of people and make the list of people new
fields in the same table... or something like that! Some managers have one
report, others have 30+.
So I would want the table to be
Manager, manager's info, direct report (DR) 1, DR 1's info, DR2, DR2's info,
etc.
I need to use it t...
|
2 |
12/11/2008 12:37:13 AM |
|
|
Linking Related Records
Hi,
I'm pretty new to Access. I have a table I use to track issues. Each issue
has several fields, one of which is country. I want to create a form where
if I pick country X, I will see all of the previous records for country X.
How do I do this?
Thanks
Drew...
|
2 |
12/11/2008 12:33:18 AM |
|
|
Multi-query filters
I have a combo box with A-Z listed to filter a subform by last name. I have
26 queries to filter with. I want to be able to select "A" in the dropdown,
and have my subform display the "A" query which displays "A" names. My main
form is called lookup_form. The query names are a_last_search, b_last_search,
etc. The subform is called contact_list subform.
I am a newbie to Access, and know ...
|
17 |
12/10/2008 10:05:01 PM |
|
|
Is there a code that deletes all forms,queries or tables?
Hi,
Is there a code that deletes all forms,queries or tables?...
|
8 |
12/10/2008 9:34:12 PM |
|
|
NZ Function to validate Input
Hi all,
any suggestion on how to make this work:
Private Sub NEXT_Click()
On Error GoTo Exit_NEXT_Click:
If Nz(iSTATUS, "") = "" Then
MsgBox "Select a Status to continue", vbOKOnly, "Missing Data"
DoCmd.CancelEvent
iSTATUS.SetFocus
If Nz(iSTATUS, "") = "yes" And Nz(sDATE, "") = "" Then
MsgBox "Enter a valid Date to continue", vbOKOnly, "Missi...
|
3 |
12/10/2008 9:28:44 PM |
|
|
Relationships and adding records
Ok, so I have a database full of employees. Now, every day, I enter what
amployees worked where. When I first Designed the data base, I had the
option to make employees the main focus, or the date the main focus. I saw
multiple pros and cons to both, and eventually decided to make employees the
main focus of the database. Now, here is where I have a problem:
I can go into each indiv...
|
9 |
12/10/2008 9:14:26 PM |
|
|
can't insert a form into a report
access 2007 won't display a form inserted into a report. This worked with
Access 2003. Any ideas???
--
jmb...
|
1 |
12/10/2008 9:01:02 PM |
|
|
Form OnDelete Event
I have 2 unbound subforms I am working with. When entries are added to the
first, I run code ending with a Requery of the second.
I am trying to do the same thing for when a record is removed. Using the
form's OnDelete event, I am able to execute code. However, even though I
again end with a Requery of the second form, the results suggest that the
Requery doesn't actually fire.
He...
|
1 |
12/10/2008 8:25:03 PM |
|
|
hey
hey, I'm just wondering how are things going?
I'm good and I hope to see you soon!!...
|
1 |
12/10/2008 8:19:12 PM |
|
|
Re: iwant this masagemto
"guadalupe medrano" <lupecurly@yahoo.com> wrote in message news:...
> everithing ok...
|
1 |
12/10/2008 7:41:00 PM |
|
|
Remember the Date
Hello everyone,
Using Access ’03…
I have a form that contains a calendar (ActiveX Control). In the same
form is a subform linked to a table. I designed this form so that
users could open it, select a date, and enter stats such as counts and
hours.
This works fine, but I want to link the calendar date to the record
(with the same date) on the subform. For example, a user opens the
...
|
5 |
12/10/2008 7:39:43 PM |
|
|
Union Queries
Okay, so if Union Queries are read only, how can I combine my two tables?
I have two forms:
Main Page -has a check box for O&G
Multi-Tenant Page- has a subform that has a check box for O&G
I need all addresses (main form and multi-tenant form addresses) to be
combined if they have a check for O&G wether it is checked on the main form
or on the subform. A union query works great, but t...
|
6 |
12/10/2008 6:22:12 PM |
|
|
Imagen Objeto OLE
He creado un tabla con un campo nombre y Foto el campo foto es un
objeto OLE, donde inserto un objeto ( Imagen de Archivo ) con
extensión JPG.
Cro un formulario para ver las imagenes y en el campo foto solo me
aparece el el nombre del archivo.
¿ que debo hacer para ver las fotos ?
Gracias...
|
1 |
12/10/2008 6:08:30 PM |
|
|
data that is returned on report is inaccurate
I am trying to build a report in Access 2007 but it reports inaccurate data.
When I look at the data in the table it is correct but in the report it shows
6 records instead of the two records that in the table.
I don't know what to look for to fix this. Any help would be greatly
appreciated.
...
|
3 |
12/10/2008 5:16:33 PM |
|
|
Number comparison
Good morning,
I have 2 tables that I need to compare customer numbers. One table is for
customers that the product was sold to.
One table is for product returned by customers.
The customer number in the sold to table has 8 mumbers with the last 3
being location.
The returned product customer number is entered in as the first 6 numbers.
When I compare the sold to table with the returns...
|
5 |
12/10/2008 5:11:02 PM |