|
 |
| Recent blog posts: | |
|
| They have birthday today: | |
|
| Forums: | | |
|
| Discuss: | |
|
| Recent forum topics: | |
|
| Recent forum comments: | |
|
| Модератор: | |
|
Thursday, 10 August 2006
|
| Prevent Report Preview from Escaping into Design Mode Guest 05:37:03 |
| | I must be missing something, but I have a report that when it is opened
programmatically as a Preview, there is a limited toolbar which
prevents the ability to edit the design, among other things. However,
if the use presses the <ESCAPE> key, it automatically reverts to Design
Mode.
How do I prevent this?
|
| |  2 answer | Add comment |
|
| Generate Number on MS. Access Orchid 00:35:20 |
| |
Hello,
I am looking to generate a unique ID field on MS. Access. The ID is
with 10 digits with the combination of 5 Letters from the 26 letters
and 5 Numbers from 1 to 9. The letters and numbers are picked
randomly. When I click a button with the VB code on a form, it will
create the ID on a table call "Customer table". Can someone help me on
how to write the VB code to generate the ID??
Thanks in advance for your help!!
|
| | 15 answers | Add comment |
Wednesday, 9 August 2006
|
| Report showing number of records based on a value in a field Ricktech101 23:57:12 |
| | Hi,
I have a table with a field that shows the number of pieces that a
parcel contains. It looks like this:
ParcelID, Pieces, Description
Data example:
1001, 5, Jackets
1002, 10, shoes
etc
I need to print labels for each piece that shows to which parcel it
belongs. The report will look like:
1001, Total pieces = 5, 1 of 5 pieces, Jackets
1001, Total pieces = 5, 2 of 5 pieces, Jackets
1001, Total pieces = 5, 3 of 5 pieces, Jackets
1001, Total pieces = 5, 4 of 5 pieces, Jackets
1001, Total pieces = 5, 5 of 5 pieces, Jackets
and
1002, Total pieces = 10, 1 of 10 pieces, shoes
1002, Total pieces = 10, 2 of 10 pieces, shoes
1002, Total pieces = 10, 3 of 10 pieces, shoes
1002, Total pieces = 10, 4 of 10 pieces, shoes
1002, Total pieces = 10, 5 of 10 pieces, shoes
If I could populate a table where the number of records equal the value
of the pieces column then it's a pretty simple report but I can't
figure this out.
Can anyone help?
|
| | 2 answer | Add comment |
|
| Lookup data in another database using DLOOKUP Bruce Mogayzel via AccessMonster.com 23:48:54 |
| | What is the syntax to lookup data in another database?
Thanks
Bruce
--
Message posted via http://www.accessmonster.com
|
| | 2 answer | Add comment |
|
| Emailing multiple list box items from ms access using Lotus Notes Rups 22:44:53 |
| | I am using Ms Access to send email automatically through Lotus Notes.
What I require now is that I have a List Box in my form which when
loads,fills in the data's from the backend table.
In the body of the mail,I use the object that contains the item
selected from the list.
i.e. MailDoc.Body=ListBox225.Column(0) & List225.Column(1)
When an email is generated,it output is as below.
126 Rupam.
Now I want a syntax code that would include multiple rows from the list
box and not just 1 row.
Please can you help me with this I am in desparate need of it.
Your help much appreciated.
Regards
Rupam.
|
| | 4 answer | Add comment |
|
| AccessXP and Group control Bobh 22:12:47 |
| | Hi All,
In AccessXP I put a option group control on a form and using vba I
wrote Case logic. Neither the On-Click or the After Update event of the
control kick off the vba code. What am I missing.
Option Group control name = grpView
On-click or After-update vba code
Select Case grpView
Case 1
Docmd.OpenForm "frmViewClients"
Case 2
Docmd.OpenForm "frmViewAgents"
End Select
thanks for your help
bobh.
|
| | 2 answer | Add comment |
|
| Guided creation Marco Silvestri 20:38:45 |
| | Goodmorning,
when use the guided creation of tables, query, and other appears an error
message that says the characteristic is not installed or something is not
activated.
Someone knows to give some council?
Thanks to all
Marco
|
| | Add comment |
|
| APD connect manually only Cornelius.Eckhoff@Web.de 20:21:43 |
| | Hello,
I just want my ADP not to connect on startup. Normally when opening the
xx.adp-file Access tries to connect automatically.
Is there any option, trick, workaround? I found a source to reconnect
or change the connection via vba code, now I want to prohibit Access to
start a connection on startup as this takes too much time.
Thanks in advance!
|
| | 2 answer | Add comment |
|
| Hide the database window Nick 'The database Guy 20:07:55 |
| | Hi People,
How do you go about hiding the database window. The reason for doing
this is that sometimes have to manually add data to tables. I have a
fully interatctive menu system from which you can show the 'database
window', the same button that you have to press to show the database
window opens a small modal form which has one button which will return
you to the menu system, but I also want it to close the database
window!
Hope that I have made myself clear.
TIA
|
| | 11 answers | Add comment |
|
| id3 tag issue Guest 19:50:44 |
| | alright, ive got another issue. i have a database that reads the id3
tags of an mp3 file and puts them into a table, it then edits them to
my liking and now i want the database to write the id3 tags back to the
file. Any ideas on how I can accomplish this?
|
| | Add comment |
|
| Spalten summieren Aglo 18:57:53 |
| | Halllo, zusammen,
stehe hier wieder einmal vor einem Problem, von dem ich hoffe, dass es
überhaupt lösbar ist:
In einer Abfrage habe ich mehrere Spalten, in jeder Spalte sind
positive und negative Werte dabei. Die Aufgabe ist, HORIZONTALE Summen
und Mittelwerte pro Zeile zu bilden, aber nur von positiven Zahlen.
Hoffe, jemand kann mir weiterhelfen
vielen Dank und viele GrГјГџe
olga
|
| | 1 answer | Add comment |
|
| Parameter Query - need previous 2 days worth of data Vinfurnier 18:54:51 |
| | Hi -
I've been struggling to produce a working parameter query that will
allow the end user to type in any date (mm/dd/yy) and obtain the
records of the previous 2 days. In other words, if the user types in
08/07/06, the records of 08/05/06, 08/06/06 and 08/07/06 will all
appear in the qry.
I have the following code, which is real basic, but I am running into
"the expression is typed incorrectly or is too complex etc".
SELECT [111].Start_Date
FROM 111
WHERE ((([111].[Start_Date])<=[Enter Start Date]-2));
Any help would greatly be appreciated.
Thanx in advance,
vf
|
| | 5 answers | Add comment |
|
| Storing calculated values... Exception! James Hallam 18:19:54 |
| | I have read through all the past topics and couldn't find what I was
after so...
I am looking to store some calculated values (don't flame just yet,
just read on!). I have an piece of code behind a form which calculates
a percentage completion and an expected completion date of a job. I
would like to store this information in a separate table, along with
the actual date the values were calculated.
Whenever a job is completed I can see how far off my estimated
completion date is off the actual date and make any changes neccessary.
Within the code there are a few different algorithms used to calculate
the estimated completion date, so I would need to store this value as
well.
So Questions...
* Is this a valid exception to the "never store calculted values"
* Would the best idea be to use an append query?
If so could someone post the base code as I am not too hot with SQL!
Cheers,
James Hallam
|
| | 11 answers | Add comment |
|
| Update of Field after Change Colleen 16:35:10 |
| | Hello All,
I have a table for my employee data. I have a field that generates
date before update of latest changes made. I also have two fields
within called CreatedBy and UpdatedBy. I would like this autogenerated
but not sure how to make this happen. Since this over a network, the
system knows who is creating and working within a database, I'm at a
loss as to how I point to this to update the field.
Any suggestions? I'm rather new at this!
Thanks!
|
| | 7 answers | Add comment |
|
| Any options other than ODBC? Guest 14:51:50 |
| | Hi,
I currently have a mySQL database running on a database server and am
creating a front end for the forms e.t.c
Im currently connecting the two via ODBC, however i have noticed its a
bit slower than I would of wanted.
Can anyone suggest a faster method of retrieving the data?
Being portable isnt a big issue, I just used ODBC as I thought it was
the only way of accessing a mySQL database from Access.
If this is the best way, can anyone point me in the right direction of
some optimization tips i can use, either on the Access front-end or the
ODBC driver itself.
Thanks
|
| | 4 answer | Add comment |
|
| Function needed - String Part(Source,Section) Ima Loozer 11:58:39 |
| | OK folks here is what I need help with. Lets assume I have a text field
that will contain AlphaNumeric data. There is no set pattern to the
field such that any given character can be either alpha or numeric. I
need a function that will return the requested 'part' of the contents of
the field. A 'part' would be defined as consecutive Alpha or Numeric
characters in the text field.
Examples:
Field Name = cFoo
Field Value = "102ab3xz4"
StringPart(cFoo,2) should return "ab" (as a string).
StringPart(cFoo,5) should return 4 (as an integer).
Field Value = "a0914zva33"
StringPart(cFoo,1) should return "a" (as a string).
StringPart(cFoo,2) should return "914" (as an integer).
Thanks for whatever assistance you can provide.
DB
|
| | 12 answers | Add comment |
|
| "Merge to printer"problem MirzaSila 10:15:23 |
| | I am using mail merge option in msWord for creating labels, data source
is msAccess.
Problem is when I choose option "merge to printer" it only prints the
curent page even though I completed the merge.I'am not sure is it
printer proporties causing the problem or something else?
Any reply would be appreciated.
|
| | 3 answer | Add comment |
|
| MSysAccessStorage Error when opening and closing db rdemyan via AccessMonster.com 08:26:36 |
| | I'm getting the following error message both when opening and closing my dB.
The Microsoft Jet database engine cannot find the input table or query
'MSysAccessStorage'. Make sure it exists and that its name is spelled
correctly.
I'm using Access 2003 but the file format is Access 2000.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200608/1
|
| | 5 answers | Add comment |
|
| Relationship problem when adding records Ron 07:51:05 |
| | Hi All,
Using Access2000, winXP.
Table 1 = tblClients displayed on frmClients via qryClients. 2nd table =
tblInvoices shown on frmInvoices via qryInvoices. 2nd table = tblDetails
shown on subform(to frmInvoices) sfrmDetails via qryDetails.
Relationship built between tblClients/tblInvoices/tblDetails by ClientID.
Relationship between tblInvoices/tblDetails by InvoiceID. All works fine if
I input data into frmInvoice first and then sfrmDetails after. But, if I
take the defaults of frmInvoice and just want to put in data on sfrmDetails
first, everything freezes. Nothing gets added. InvoiceID and DetailID get
incremented, but never show up anywhere. I think it's probably a
relationship problem. tblInvoices doesn't get a new record prior to the prg
trying to store the new record into tblDetails.
What am I doing wrong? How can I get the tblInvoice table to add a record
prior to the first record being added by the subform for tblDetail table so
it's available for storing that InvoiceID to tblDetail?
Thanks in advance for any suggestions.
ron
|
| | 7 answers | Add comment |
|
| Access 2003 keeps confusing form names AnandaSim 06:44:50 |
| | Hi All,
I'm experiencing what I think is a bug - can't figure out how it would
be stated so difficult to search the NG.
I have a form. It has four listboxes. Each listbox has a rowsource. The
four listboxes cascade in criteria. So the next listbox in the sequence
uses the formname!listboxX as the criteria for the rowsource. Not
unusual.
Now comes the odd part. As I edit the rowsource - using the query
designer UI but keeping it as an SQL string, when I'm ready, I run the
Form. But the SQL strings now reference some other Formname, not the
current formname. So I thought it was me and I edit them and save and
run. Reverts again. Finally, I don't use SQL string, I save each
rowsource as a query and use a queryname as an SQL string. Happens
again - the formname changes somehow.
Tried Repair and Compact.
Seen that?
|
| | 3 answer | Add comment |
|
| Closing a PDF file from VBA Regnab 04:38:48 |
| | I've written some code which opens a PDF file using :
"Application.FollowHyperlink strdbFilePath & strFileName, , True"
The user then types some information into the form and then clicks a
button which generates a new filepath for the file. Unfortunatly, if
the user doesn't close the PDF file, the whole thing grinds to a halt.
Just wondering if there is some code that I could put in the button to
close the pdf file when clicked??
Cheers
Reg
|
| | 3 answer | Add comment |
|
| Unable to compact database converted to Access 2003 format rdemyan via AccessMonster.com 03:57:30 |
| | I've converted my application from A2K format to A2003 format.
I tried to follow Allen Browne's protocol in getting my app into A2003
(although I was unable to find informtion on the conversion process). Lots
of decompiling and lots of compacting of the original application in A2000.
Then the app was opened in A2003 and compacted, decompiled and compacted.
Next I imported everything into a blank A2003 database. Then this db was
converted from A2000 to A2003.
I had some issues with some missing references but this was fixed.
However, whenever I try to run the Compact command from the menu bar for my
converted application, I very quickly get an invalid operation messagebox.
Clicking Ok, simply restarts the app without compacting. So my DB is now 50
MB and climbing (typically it is around 20 MB after compacting in A2000.)
What can I do about this. I have to be able to compact the database?
Also, I still have one error in the converted database (that is not present
in the A2K format version).
It's on the following line where I'm trying to set an application icon.
dbs.Properties("AppIcon") = strFile
Is this error occuring because in Access 2000 you can't set a universal
application icon for each form, whereas I think you can in 2003. Still why
wouldn't it allow me to code the application icon.
Thanks.
Thanks.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200608/1
|
| | 8 answers | Add comment |
|
| Re: ''Get free calling cards now '' Larry Linson 03:30:56 |
| | <socald.smit@gmail.com> wrote
''Get free calling cards now ''
Not only spam, but completely off-topic spam. Yech!
|
| | Add comment |
|
| Run Time Error 3075 Missing Operator William 03:07:05 |
| | Hello Everyone,
I'm using Access 2000. I entered the following code to do some data
validation, however it is not working. I'm trying to ensure that the
user cannot enter a duplicate inspection date for the same room. I'm
getting the following error message: Runtime error 3075. Syntax error
(missing operator) in query expression '(Room = 189B) AND
(InspectionDate = #10/05/05#)'.
Here is the code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim strWhere As String 'Where clause to lookup dupe.
Dim varResult As Variant 'Result of lookup: null if no dupe.
If IsNull(Me.InspectionDate) Or IsNull(Room) Then
Cancel = True
MsgBox "Both Room Number and Inspection Date are required."
Else
'Build the Where clause.
strWhere = "(Room = " & Me.Room & ") AND (InspectionDate = " &
Format(Me.InspectionDate, "\#mm\/dd\/yy\#" & ")")
'Record doesn't clash with itself.
If Not Me.NewRecord Then
strWhere = strWhere & " AND (InspectionID <> " &
Me.InspectionID & ")"
End If
'Do the lookup.
varResult = DLookup("InspectionID", "tblInspections", strWhere)
If Not IsNull(varResult) Then
Cancel = True
MsgBox "Inspection Record No." & varResult & " has already
been entered.", vbExclamation, "Duplicate Entry"
Me.InspectionDate.SetFocus
End If
End If
End Sub
Thanks for your help
William
|
| | 8 answers | Add comment |
|
|
