|
 |
| Recent blog posts: | |
|
| They have birthday today: | |
|
| Forums: | | |
|
| Discuss: | |
|
| Recent forum topics: | |
|
| Recent forum comments: | |
|
| Модератор: | |
|
Sunday, 13 August 2006
|
| Erroe during move from one table to another Eric 10:38:29 |
| | When i run my query it transfer last 4 digits of account number from
one table to another and its wrong. There are two tables one i use for
parsing. Second thru query i use to move data from temp table to actual
table with some little changes in temp table. I use the same code in
two different databases One database works fine and another database
wont move the account number with 9 digit size. Difference is only the
structre of text files so parsing is little different. But after
parsing same method i use to move from temp table to actual table. when
it parse it move the account number from temp to actual table with this
function: AccountNo: Right(Trim([AccountNum]),9) but it shows only last
4 digit of account number instead of last 9 digit (75-02) and that is
wrong. I dont know why its doing that becuase same method in another
database works fine. Length of account number in temp
table(tblcustomers is 100 of tpe TEXT). Length of account number in
another table is 10 type TEXT input masrk AAAAAA\-AA. It moves fine in
tblcustomer but it wont move correct in another table which have an
input mask
[Account Number]
07836-105575-02
Thanks
|
| |  3 answer | Add comment |
|
| listbox2 Jonnh 10:31:58 |
| | I could already solve the problem that a textbox had the value of a
line of a listbox, now what I need is that another textbox of another
form has the value of a listbox because access it returns me error that
an object is required. the textbox this it is the expression that
digitando am:
Formularios![Precios Nestle]! [txtcodigo].value = listbox.Column(0)
|
| | 1 answer | Add comment |
|
| Move from one table to another one value is wrong Eric 10:23:39 |
| | After parsing i move the values form tblcustomer to tblRequest. There
are too many spaces in all the field of tblcustomer
but they all move good accept field Account number. Below is the query
which i use to move values but it still give me last
4 digit from tblcustomers.
tblcustomers
AccountNum Text 100
Value: 07836-105575-02
Input Mask: CCCCCC\-CC
tblRequest
AcctCustNum Text 15
Value: 75-02
INSERT INTO tblRequest ( AcctCustNum, CableDataDate, CreditRequested,
ZipCode, CorpNum, BoxType, Comments, CustFName,
CustLName, NewRequest, BoxQty, ReturnMethod, DateLoaded, ConverterNum,
RequestRecd, RequestRecdDtl, RequestDate,
RequestStatus, ErrorType, RequestType, SenderInitials, SenderCorp,
CableDataID )
SELECT Right(Trim([AccountNum]),9) AS AccountNo,
tblCustomers.ReturnDate, tblCustomers.CreditAmount,
Right(Trim([CityStateZip]),Len(Trim([CityStateZip]))-InStr(1,[CityStateZip],",
")) AS Zip, Left([AccountNum],5) AS Corp,
tblCustomers.BoxType, tblCustomers.Comments,
Left([Name],InStr(1,[Name]," ")-1) AS Expr,
Right(Trim([Name]),Len(Trim([Name]))-InStr(1,[Name]," ")) AS Expr2,
"Yes" AS NewWork, tblCustomers.BoxQty,
tblCustomers.ReturnMethod, tblCustomers.ImportDate,
tblCustomers.ConverterNumbers, "E Mail" AS RecdHow, "KDB" AS
RecdDetail, Left([RequestDate],10) AS ReqDate, "Open" AS ReqStat,
"Open" AS ErrTyp, tblCustomers.Subject,
Left([Sender],InStr(1,[Sender]," (")-1) AS SenderInits,
Right([Sender],4) AS SenderCorp, Left((Right([Sender],8)),3) AS
CDID
FROM tblCustomers;
|
| | 1 answer | Add comment |
|
| Run report on query Eric 10:17:11 |
| | I run a report on the basis of query. I dont know how to i use filters
in my report. I mean i have to ask user information in a drop down list
and on the basis of that information i want to generate the report.
Needs Help
|
| | 1 answer | Add comment |
|
| Code to add a text field not picking up size Dixie 04:47:48 |
| | CurrentDb.Execute ("ALTER TABLE tblMyTable ADD MyNewField Text 25")
The above line does not pick up the 25 size, but instead makes it 255.
What am I doing wrong?
dixie
|
| | 2 answer | Add comment |
|
| TransferText, ExportXML, ImportXML rdemyan via AccessMonster.com 02:14:50 |
| | Will someone please verify for me that these three methods, TransferText,
ExportXML and ImportXML, can only be run on the current database, i.e. I
can't run these from the front end in order to create either text or xml
files for tables in a backend.
Thank you.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200608/1
|
| | 3 answer | Add comment |
|
| Lag at bottom of subform. Guest 00:59:55 |
| | I know this has been discussed, but I can't find a resolution. I have
a subform on a form. The table with the data for the main form has
15,000 records. I am opening and then setting recordsource so as to
only pull 1 record.
The table where the subform data comes from has 130,000 records. There
is a parent/child link. Indexed on those fields. I have set the
datasource to the table, SQL statements and a number of different
queries to limit the data. Anyway I do it, it is SLOW. But only
slow if the new record * is visible. If the new record indicator is
scrolled off the bottom of the page, there performance is fine. But if
you scroll down, there is a big 5 second lag to display the new record.
Adding new records as a result is very slow and aggravating for the
users.
If I open a query with the same data, the results are instantaneous.
Also if I set the datamode to snapshot it is fast, but then you can't
add records which is where the problem is anyway.
By the way the typical display of subform records is only about 12.
Does anyone know of a way around this quagmire?
|
| | 4 answer | Add comment |
|
| listbox?? Reality X 00:25:31 |
| | Hello,
Forgive me if I don't know the proper terminology. I have two
listboxes on a form -- one listbox with values in which users can
select from and one listbox blank. Upon clicking on a value, I want
the value to be removed from the value list and appear on the formerly
blank list box and vice versa.
Can anyone show me how this is done in Access 2000? I am ok at best in
vba. Any help is greatly appreciated.
|
| | 7 answers | Add comment |
Saturday, 12 August 2006
|
| Can I buy Access as a stand-alone? Guest 23:10:16 |
| | If so, where?
========================
The opinions expressed above are not necessarily mine.
And even if they were, I did not necessarily mean them.
So there.
(I'm also at haggisbasher@REMOVE-MEnerdshack.com)
|
| | 6 answers | Add comment |
|
| Entering Data In A Form Cyber0ne 22:10:33 |
| | I'm designing a basic form for data entry into one main table. There
are two fields in the table that I would like to be automatically
populated, not user-entered, when the record is posted.
One is the current system time as a Date/Time value, the other is the
current system username as a Text value.
Being _completely_ new to MS Access, how/where do I set the form to do
this when it posts a record? Also, can I distinguish between an INSERT
and an UPDATE? That way I could have one pair of fields for "record
created" and another for "record last updated."
For reference, I'm using MS Access 2002. The form was created using
the wizard and the only thing I've edited, other than cosmetic changes,
is replacing one of the fields (a foreign key to another table) with a
ComboBox for a support table.
I'm sure this is a terribly trivial task (it's just a matter of getting
the values from the system and putting them into the queries that the
form uses), I'm just entirely unfamiliar with the MS Access environment
and don't know where to look.
A quick nudge in the right direction would be much appreciated. Thank
you.
-cyber0ne
|
| | 3 answer | Add comment |
|
| Criteria in Query Jonnh 22:05:16 |
| | friends help me please:
because a query that the approach is the text of the form of the an any
me the characters of those of it respects of the joker. section of the
one of in of the approach this is what I place:
Como "*[Formularios]![Formulario1]![Texto0].[Texto]*"
any you that I am making bad because the character * any it respects of
the it the and when I execute the consultation me the one anything of
the one returns 0 registrations. thank you! !porque a consultation that
the approach is the text of the form of the an any me the characters of
those of it respects of the joker.
thank you!!
|
| | 2 answer | Add comment |
|
| Help with Code Simon 20:53:08 |
| | Hi, I need some help form someone.
I use my database for my online shop, so once I have entered a order
onto the database I have a button that creates the Email to the
customer to let them know the order has been placed.
I use to use [ProductID] as a auto number but I have just changed it to
[ProductCode] Which is not a auto number as I type them in.
But now my VB code for the email button does not work.
Can any one help me
Old Code
strSql = "SELECT * FROM tblOrderProduct WHERE OrderNumber =" &
Me.OrderNumber
CRS1.Open strSql, CurrentProject.Connection, adOpenKeyset,
adLockReadOnly
While Not CRS1.EOF
strItemsOrdered = strItemsOrdered & "Item : " & _
DLookup("[ProductName]", "tblProduct", "[ProductID] =" &
CRS1.Fields("ProductID")) & vbCrLf & "Qty : " &
CRS1.Fields("Quantity") & vbCrLf
strItemsOrdered = strItemsOrdered & "Unit Price : " & Chr(163) &
DLookup("[PriceIncVAT ]", "tblProduct", "[ProductID] =" &
CRS1.Fields("ProductID")) & vbCrLf
The email use to look like this
Item : Test Strips
Qty : 2
Unit Price : ВЈ15
Total (Inc VAT): ВЈ30.00
I have changed ProductID to ProductCode in the VB code but it does not
work
strSql = "SELECT * FROM tblOrderProduct WHERE OrderNumber =" &
Me.OrderNumber
CRS1.Open strSql, CurrentProject.Connection, adOpenKeyset,
adLockReadOnly
While Not CRS1.EOF
strItemsOrdered = strItemsOrdered & "Item : " & _
DLookup("[ProductName]", "tblProduct", "[ProductCode] =" &
CRS1.Fields("ProductCode")) & vbCrLf & "Qty : " &
CRS1.Fields("Quantity") & vbCrLf
strItemsOrdered = strItemsOrdered & "Unit Price : " & Chr(163) &
DLookup("[PriceIncVAT ]", "tblProduct", "[ProductCode] =" &
CRS1.Fields("ProductCode")) & vbCrLf
Can any one help I am new to all this
|
| | 2 answer | Add comment |
|
| Problem: Network programming, OpenWorkspace? Guest 18:14:09 |
| | Hello,
This is a question regarding MS-Access programming.
1. Network environment:
I got a room with 50 people answering the phone and logging the topics
of the incoming calls. Each has a PC, and the PC's are connected by
LAN to a Windows 2000 server PC.
2. Software Environment:
I built a small MS-Access database program which has the topics as
YES/NO fields. There are also a date/time field and a COMPUTERNAME
field for each logged call. Currently all of the users are opening this
program, which resides on a shared-location on the server, and feeding
directly to the server.
3. My wishlist:
I want to make a program which resides locally in a shared location on
each of the user's computers, and feeds to a database local to the
user's computer. At some instance, I, the network-administrator, will
have a program which logs into each of the shared locations of the
user's computers, opens the current users' database and harvests
their data to my own database table by way of SQL INSERT INTO.
4. My problems:
These shared locations, of the users, are protected by a
login/password. I must keep the login/password on. I need a
programmatic way to log into the current shared location. How do I do
it? OpenWorkspace only handles the password of the user in ACCESS
itself, not in the network. Do I have to use DDE/SendKeys to handle the
dialog being opened when I log in manually?
Thanks in advance,
Max.
|
| | 1 answer | Add comment |
|
| Proper method for creating nightly backups of the back-end file rdemyan via AccessMonster.com 15:38:36 |
| | Here's my plan for creating nightly backups of the production back-end file
(the IT staff in their infinite wisdom have prevented use of Windows
Scheduler and users do not have administrative rights to Windows).
Candace Tripp has an automatic backing up program that I modified for our
use. You can schedule a time for the backup to occur. Since Windows task
scheduler is not available to us, this means that the auto backup program
will have to remain open.
Now this auto backup program will reside on the local PC. A back-end file on
the server will be specified to be backed up to a folder called 'Backups'
also on the server. I think I read somewhere that it is not a good idea to
backup back-end files from one location to another (i.e. server to PC or one
server to another).
My plan seems simple and reasonable to me but am I missing anything that I
should be aware of.
Thanks.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200608/1
|
| | 17 answers | Add comment |
|
| Books on developing access databases for fun & profit? The Woo 11:12:18 |
| | Hello all. Looking to pick up a few extra dollars with my hard-won
knowledge. Not looking to get rich, just have extra cash to buy more
software (thus feed my habit). Are there any books that would offer
advice on becoming an Access db developer for small businesses? Tips
like costing, deploying, tightly-worded, yet simple contracts?
A few years ago, I came across a lady's site (I think it was out of
North Carolina) which offered this advice for small website
developers. If anyone knows her site, I'd be much-obliged, because I'm
sure much of the info would translate. If this question is beyond the
charter of this newsgroup, apologies in advance.
The Woo
|
| | Add comment |
|
| combinations and permutations Brendan 09:37:35 |
| | Hi,
I'm not at all competent in ms-sql, nor vb, as we work in Oracle and Mysql
... however, we need to port a couple of db queries to ms-access (2000) and
I'm having a heck of a time trying to make it work.
The immediate requirement is obtaining permutations of a relational
recordset
Specifically each record row will produce up to 3 letters and I need to
display all the combinations of L1, L2, L3, NULL for that row and avoid
reverse combinations (ie L1:L2 is the same as L2:L1) but including
self-referential combinations (ie L1:L1)
ie If the row produced 3 Letters (A,B,C) The subordinate results would be
A : A
A : B
A : C
A : NULL
B : B
B : C
C : C
C : NULL
In oracle you'd use a nested function to do this in mysql a group_concat
.... does anyone have a quick easy solution for ms-access?
many thanks
brendan
|
| | 1 answer | Add comment |
|
| Hmmm, probs with Date field Graham Feeley 09:05:43 |
| | I have a date field named rcdate
it is a general date eg:
12/08/2006 3:30:00 PM
12/08/2006 3:00:00 PM
I used to update another empty field named rdate with the
with using in a update query " Left(Ratings!RCDate,10)"
This now does not work for some reason
gives me the error
"undefined function in left function"
any help here please
Graham
|
| | 1 answer | Add comment |
|
| Conditional Formatting Based On Row Having Focus? Guest 04:31:54 |
| | Got a continuous form with name, address, and so-forth.
I'd like the name to become bold for the currently-selected row.
The Format|Conditional Formatting menu seems limited to the control's having
focus.
Anything I can do in VBA? ....like in OnCurrent()?
--
PeteCresswell
|
| | 2 answer | Add comment |
|
| query on two multi-select boxes Gambit32 03:19:37 |
| | I have one multiselect box called 'listclient.' I have another
multi-select box called 'listemployee.' I found some code that allows
me to query on the listclient box. I'm trying to figure out how to get
my query to query on the listemployee box as well. Thanks in advance
for any help.
Here's my code for querying on the listclient box:
Private Sub cmdRunQuery_Click()
On Error GoTo Err_cmdRunQuery_Click
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim strSQL As String, strWhere As String
Dim i As Integer
Set db = CurrentDb
'*** create the query based on the information on the form
strSQL = "SELECT
datetest1_tbl.fld_year,datetest1_tbl.fld_day,datetest1_tbl.fld_month,datetest1_tbl.fld_break_mins,datetest1_tbl.fld_break_hrs,datetest1_tbl.fld_date,datetest1_tbl.fld_client,datetest1_tbl.fld_project,datetest1_tbl.fld_subproject,datetest1_tbl.fld_currency,
datetest1_tbl.fld_duration_hrs,datetest1_tbl.fld_duration_mins,
datetest1_tbl.fld_note, datetest1_tbl.fld_rate,
datetest1_tbl.fld_amount FROM datetest1_tbl "
strWhere = "Where ((datetest1_tbl.fld_date) Between
Forms!aspdash_form!date1 And Forms!aspdash_form!date2) and
datetest1_tbl.fld_client IN ("
For i = 0 To listclient.ListCount - 1
If listclient.Selected(i) Then
strWhere = strWhere & "'" & listclient.Column(0, i) & "', "
End If
Next i
strWhere = Left(strWhere, Len(strWhere) - 2) & ")"
strSQL = strSQL & strWhere
MsgBox strSQL
'*** delete the previous query
db.QueryDefs.delete "qryMyQuery"
Set qdf = db.CreateQueryDef("qryMyQuery", strSQL)
'*** open the query
'*** DoCmd.OpenQuery "qryMyQuery", acNormal, acEdit
Exit_cmdRunQuery_Click:
Exit Sub
Err_cmdRunQuery_Click:
If Err.Number = 3265 Then '*** if the error is the query is
missing
Resume Next '*** then skip the delete line and
resume on the next line
Else
MsgBox Err.Description '*** write out the error and exit
the sub
Resume Exit_cmdRunQuery_Click
End If
End Sub
|
| | 1 answer | Add comment |
|
| fill colour in report Feeman 02:15:10 |
| | A while back I asked about changing the background colour of a text box
according to the outcome of a tick box, and the code below was supplied
which worked very well.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me![O/S] = -1 Then
Me![Cat No].BackColor = vbYellow
Else
Me![Cat No].BackColor = wbWhite
End If
End Sub
But now is all I want it to do is change the colour of outstanding to
yellow, but change the font to white, so that when printed stands out a
little more, especially due to the fact that work has decided to reset
all the printer to black and wjite so when using a darker colour you
can not see the text.
|
| | 3 answer | Add comment |
|
| using a cross-tab query in a report... Rob Woodworth 01:30:24 |
| | Hi,
I'm having serious problems getting my report to work. I need to
generate a timesheet report which will contain info for one employee between
certain dates (one week's worth of dates). I have a table containing
records for each job done, the records contain date, employee name, job done
(a code representing the type of job), cost code (another code), regular
hours, and overtime hours. The tricky part is that more than one job can be
completed on the same date. This is how I went about it:
I have a query with paramaters to make sure the employee equals the one I
want and the date is for the current week so I have [Employee?] matching
employee name and [Start date?] and [End date?] which the date has to be
between. So after this query I have only records for the right employee and
dates.
Next I have a cross-tab query with job done and costcode as row headings and
the date (which i format here as the day of week) as the column heading. It
is totaling up the regular hours (I'd like to do both regular hours and
overtime hours at the same time but it only supports one for the cross-tab
query).
Then I have my report drawing information from the cross-tab query.. should
work great but.. it doesn't. First of all when I use the wizard to create
the report and try to choose the cross-tab query, none of the fields show
up. So I do it manually in design view and change the data source in the
Report properties to the cross-tab query which then asks me to enter the 3
paramaters. Then when I add a textbox into the report and tie up the data
source to the query it again asks for all 3 paramaters. Then when I run the
report it repeatedly asks me for the paramaters like it's stuck in an
infinite loop or something... It seems like this should work and I'm not
sure what to do, the paramaters are listed in the query as paramaters as
well.
Thanks in advance for any help you can offer me!
Rob
|
| | 1 answer | Add comment |
|
| assign number from table to record on import and creation Mn 01:15:19 |
| | Hello,
I have a customer table and another table that I need to prepopulate
with special customer IDs, unique and not sequential. Is there a way to
configure Access to assign the customer ID to every record each time
that a record is either created for the first time or imported for the
first time? I would be importing into a temp table and then running an
update query to copy the data to the customer table. Another confusing
issue is that I will be updating the customer table through an update
query occasionally to just update existing customer data -- I don't want
that process to trigger issuing a new customer ID. Any thoughts?
Thanks.
|
| | 5 answers | Add comment |
|
| save table records from select tempquery A_m_is 01:08:04 |
| | Hello group,
hope to anybodys help on my temporary blackout.
(Using Access 2003 on XP Win.)
I know how to create and edit temporary query recordset, then I can set
this data source as my form recordsource.
Until there all this work for me at a glance.
Problem case now!
For another reason I need to store my selected datas from this
datasource in another new table, can we name it as tempTable.
There I stucked right now.
I can recall, how to input records by records by using addNew method.
But absolute blackout for me - how to save whole temporary data set in
new table!
Is it possible? Hope, yes.
By using paste append?
Another question.
My form is bind to tempTable.
I also need test this table for old records each time I open my form.
Then on forms load event I can trigger my combobox routine to select
time period to use for routine selected data according selected period.
How to select and easy delete?
Should I use recordset.count and then some docmd.deleteqry methods?
I know - answers is next doors, might be anybody can help me with
direction?
Thank's in advance
Ainars.
|
| | 6 answers | Add comment |
|
|
