|
changing data
Hi,
I have a continuous form based upon a query.
This query links 2 tables
I notice I can not change the values in the continuous form because (I
think) it is based upon this linked query..
Am I wrong and is there a way to solve this?
Thanks
JP...
|
4 |
11/22/2008 1:55:00 PM |
|
|
Copying / Creating New version of data
I have a databse that genrates quotations and consists of a mian form and
several tabbed subforms. The user base needs to be able to copy the
quotation. I currently do this in what I consider not particularly smart way.
In VB I basically run the copy command for the main forms data then using a
querydef recordset to loop through the other related records from the related
tables. In the l...
|
3 |
11/22/2008 11:30:01 AM |
|
|
Performance Issues
I have a form with a series of unbound text boxes and list boxes and a few
buttons. What causes forms to mortally slow down? Whenever I call up the form
it takes forever to open. Also, if I switch from form view to design view, it
changes pretty quickly; but if I change from design to form view it takes
forever. What am I missing?...
|
3 |
11/22/2008 5:01:10 AM |
|
|
date field
Hi,
Have following problem:
When I enter a date in a field and base my query upon this field, I get
no result.
I noticed, when I enter a date like 01/05/08 (the format=dd/mm/yy) acces
actually stores it like 010508, so in the query, of course I get no
results because I think the query doesn't see this like a date.
How to solve this?
Thanks...
|
5 |
11/21/2008 11:18:05 PM |
|
|
Alpha key to surrogate key
I have a database that I need to convert. Currently it uses a 40-position
alphatic key on customer name. It's painfully slow and I know I want a
surrogate key. How do I go about converting and adding a surrogate key? Do
I use an append/table creation? If so, how is the key added?
TIA...
|
13 |
11/21/2008 11:04:01 PM |
|
|
Mulitple Form Parameter Boxes before Opening Report
I currently have a report that relies on 2 different forms for parameter
entries before the report will run correctly. I have the first form
parameter set to open the second form and then the report and then close the
form:
Private Sub cmdOK_Click()
DoCmd.OpenReport "rptMonthlyInventoryPG4"
DoCmd.OpenForm "frmCurrentInventoryDateQuery", acNormal
DoCmd.Close acForm, "frmDSA...
|
7 |
11/21/2008 7:14:14 PM |
|
|
REPost Need Urgent Help On Open Splash Form
This is my second post on this, sorry but I really need help on what should
be a simple task. I have a splash form that I wish to display when the
system starts (called by the on start). I have tried it several ways,
including on open, on load, and even on timer but the results are the same.
When the form opens I need to call a sub to run a macro that loads my data
tables. But here is...
|
3 |
11/21/2008 7:13:01 PM |
|
|
network connect/disconneced
when i install a new copy of win xp pro sp3, the modem restarts all the
time,,,.......so i have no internet connection.
and then i install again win xp sp2 x64 version which im using and internet
conn. works fine. why??????...
|
2 |
11/21/2008 7:12:16 PM |
|
|
Send email ?
I have 200 records in my table (ContactName, ShippedDate and ContactEmail
columns) and I have one report Letter.
Base on my records I need to send 200 emails separately with attached report
(in pdf format) and send “TO:†would be whatever in my ContactEmail column.
I know how to send one at the time. How to send 200 emails without clicking
200 times to send button?
DoCmd.SendObject ...
|
5 |
11/21/2008 7:00:02 PM |
|
|
timming help needed
I have a click value from a treeview going into a txtbox. The treeview has
the ID number, space, space, name. In the txtbox I need to only show the
name. Currently there are 3 in front of the name. There will be more in
front of the name as the ID gets larger.
How would I be able to remove what's in front of the name?
Thanks.
.... john...
|
3 |
11/21/2008 6:34:01 PM |
|
|
How to get current record read reliably from a combo control
I have a form that is made up from a numbe of combo boxes each sourced by
different queries.
I have a 'submit' button on the form which (amongst other stuff) has the
following code
Set rsPlayer1 = Me.[cmbPlayer1].Recordset
Set rsPlayer2 = Me.[cmbPlayer2].Recordset
Set rsResult = Me.[cmbResult].Recordset
intPlayer1_Score = rsPlayer1.Fields("Points")
intPlayer2_Score = rsPl...
|
5 |
11/21/2008 6:08:55 PM |
|
|
pop-up form
I have a Main form and a Subform with a Subform on it. I want to create a
pop-up form on the 2nd Subform and when it pops up I want the 2nd Subform's
PK (which is a number) to be automatically put into the pop-up form. Is there
a way of doing this?
The reason for the pop up is the information isn't always required or can be
added later on.
Thanks...
|
2 |
11/21/2008 5:42:11 PM |
|
|
splash form problem
I have a FrmSplash form open and then I run code to load the data and check
out the user. All works fine accept the forms boarder and title appear and
the body of the form does not until the other code is finished.
I have tried loading on timer and tried running fromt he autoexec macro
nothing seems to work. Is there a way to delay the code until the form is
completly loaded or to set...
|
3 |
11/21/2008 3:59:00 PM |
|
|
Editing photos- ActiveX control?
I have a databse that displays linked photos.
I need a software module (preferrable linked to a form field) that will
allow me to manipulate the pictures (and later save the results):
1. Resize the picture to a predefined resolution / color depth.
2. Draw on te picture (marking selecting areas with a "pencil"- like tool).
3. Clicking on a picture and record the x-y coordinates of the cursor....
|
2 |
11/21/2008 2:21:52 PM |
|
|
Writing Custion Messages in Access 2003
I have a database in Access 2003. Apart from the standard ID field, I have a
field called TrackingNumber which is a text field for bar code numbers (text
and numbers). I have indexed this field disallowing duplicates. This field
takes input from a bar code scanner and then automatically moves onto the
next field for entry. What I would like is that if a duplicate bar code is
scanned in, a ...
|
3 |
11/21/2008 2:16:30 PM |
|
|
Open existing form calling it from a texbox in vb2008
hi. my progect contain about 100 forms. i would call them runtime, giving
it's name in a texbox. (fox example: i write "DATA" in textbox and programm
open form that have the same name)
of course, i can use select case/ case = "DATA"/ data.show().
But, 100 forms are too much. There's a more dinamic solution to retrieve the
form by a string like texbox.text? thanks!!...
|
5 |
11/21/2008 2:05:01 PM |
|
|
option group code
i have entered the following code but i get error message 13:
Private Sub vehicle_criteria_AfterUpdate()
If Me.vehicle_criteria = 2 Then
DoCmd.Minimize
DoCmd.OpenForm "Form2-VEHICLES"
Else
DoCmd.CLOSE "Form2-VEHICLES"
End If
End Sub
my goal is to minimize the current form and open or close another form
according to the option selected. what am i doing wrong?...
|
2 |
11/21/2008 11:54:40 AM |
|
|
Access 2003 Pivot chart title dynamic
Hello everyone,
I am having a form with a pivot chart. What I would like to do is for
the chart title to take values according to the selection I am making
(criteria). Any ideas?
Demosthenis...
|
1 |
11/21/2008 6:38:31 AM |
|
|
dlookup in a form to lookup a value in a query
Hi
I am having a bit of trouble with a dlookup not functioning properly.
I have a continious form based on a table, tblTFCMASTER, in which I need ot
lookup a value from a query,qryMAXSAILDATANDSAILWEEK. Table TFC master
contains amongst others a text field called SHIPNO, which I want to use to
search for the MAXWEEKNO in the query. The query qryMAXSAILDATANDSAILWEEK is
based on another...
|
6 |
11/21/2008 4:58:00 AM |
|
|
Object doesn't support this property or method
hi,
I don't know vba code well. I am trying to recreate a subform from another
application and place it in a new form. It is a call log with several text
boxes. Most are blank and need to be filled in by the users except the first
field called BusinessDate which has all weekdays in 2008 and 2009.. The data
gets imputted into a form which is based on a query. I had the old form,
w...
|
2 |
11/21/2008 4:34:10 AM |
|
|
Date in SQL Insert statement
Help!
I have an sql INSERT INTO statement that won't work when I include a date
field. Can anyone advise?
I've removed the date field/value and it works fine.
I've enclosed the Date in # characters.
I have a message box which shows the statement before running it and that
looks fine too.
Thanks in advance.
James
...
|
3 |
11/21/2008 4:02:04 AM |
|
|
Orderby doesnt go away
I have a form with this on load event. "AllBalancesByFCandDBPD" is a
crosstab query.
Private Sub Form_Load()
Me.OrderBy = ""
Me.OrderByOn = False
Dim rst As Recordset
Dim db As Database
Dim q As QueryDef
Dim i As Integer
Dim j As Integer
Set db = CurrentDb
Set qdf = db.QueryDefs("AllBalancesByFCandDBPD")
For Each prm In qdf.Parameters
prm.Value = Eval(prm.Name)
...
|
5 |
11/21/2008 3:51:14 AM |
|
|
ODBC connection not returning records.
Office 2003 on windows XP pro. A form with a text box where the user enters
in the Work Order ID’s.
I have a SQLBASE server. I can connect to it using an ODBC connection. In
Access I use the “Get External Dataâ€, click on the “Link Tables†and on the
very bottom select from the drop down list “Files of Type†I select “ODBC
connections†and then select my machine data ...
|
2 |
11/21/2008 3:36:28 AM |
|
|
INSERT table issue
Hi,
I have a Generic form that consist pending costs awaiting for superior
approval.
___________________________________________________________________
Private sub ApprovalButton_On_Click
if MyForm.SubFormName.CostingType = "MachineCosts" then
'Execute SQL INSERT Statement to MachineCosts_Table
elseif MyForm.SubFormName.CostingType = "MaterialCosts" then
'Execute S...
|
1 |
11/21/2008 3:27:37 AM |
|
|
Special Format for text in combo box
I have a lookup field on table1 to a field on table2. It is bound to the
primary key (auto-number) of table2, and the value I want to look up is a
10-character text field with an input mask of xxxx.xx.xx.xx
When I view the text field in the table2, it is formatted correctly.
When I view the field in the drop-down list of my combo box on my form, it
is formatted correctly as xxxx.xx....
|
3 |
11/21/2008 3:26:01 AM |