|
Can I extract VBA code from *.mdb file and run VB program from outside the database ?
I have a *.mdb Access database which contains VBA code with a couple of forms.
Can I somehow extract all the VBA code into an external file (or multiple files)
and run the VB code from there (including forms and databases accesses of cause) ?
Tony
...
|
1 |
6/29/2007 9:41:21 AM |
|
|
Help New here would like to know how to do an if Command
Hii guys this is my first post here , first of all Thank you for reading this
message and even more is you can help me with this issue .
I am trying to do a querue from various tables and need to include a
computed field which will work like the if command in Excel ie
= if ( field XX > 0, field XX * Field YY,Field XX * Field ZZ)
can some tell me if this is possible and if yes how i...
|
6 |
6/28/2007 10:16:01 PM |
|
|
Jet Engines
We have about 70 users on the DB and about 8 of them can not run a command to
print a report. They get the message "The Microsoft Jet Database egnine
could not find the object*. Make sure the objects exists and that you spell
its name and the path correctly." I know that it is working on the majority
of the users and yet these 8 are preplexing me to say the least since I have
tried to ...
|
7 |
6/28/2007 9:22:34 PM |
|
|
How do I make a List box Prompt the user to Populated the field
I have created a List box in the form View but how do I make it Prompt the
user to Populated the field ?...
|
13 |
6/28/2007 5:46:18 PM |
|
|
Need help creating a yes/no box in a report
I have a database that I need to have a yes/no box based on crieteria that is
output in the report that I have created. The employees are getting bonuses
based upon the following: attendance, department productivity(effectiveness),
and QC Occurances. Is there an easy way to create a box that will say YES if
they have 0 absences and QC Occurrances and 85% department productivity, or
NO if they...
|
3 |
6/28/2007 4:39:59 PM |
|
|
Problem importing db paradox
Hi everyone
I have installed MDAC 2.8 to import db paradox.
But I can only import db if I'am log as administrator.
If I'am not log as administrator access can not import db paradox.
Somebody could help me?
thanks
Roberto...
|
1 |
6/28/2007 3:26:34 PM |
|
|
Adding new item using combo box
I have deveopled a form with a number of comboxes. The CBs will display the
records from an underlying table without problem however I need to now how to
add a record to those tables when the user types information that does not
already exists.
CmBx: Name - lists all names in the underlying table
When a new name is entered/typed and it is not present in the underlying
table can acces...
|
4 |
6/28/2007 2:06:02 PM |
|
|
Selecting from a list
Hi,
I have a table with several fields and on of the field has a combo box.
I want to write a query such that the end user can select from one of the
value on the combo list.
I tried this
select * from table where field1 =[Enter Value];
This works, but the values in the field are too long for the end user to
memorize.
I want something like this:
select * from table where field...
|
2 |
6/28/2007 7:46:01 AM |
|
|
How do i put borders on my pictures?
I am not sure how to put borders around my pictures, which are JPG and GIF
file types....
|
3 |
6/28/2007 7:42:03 AM |
|
|
Msg box help
Hello, I have this event on a button on my form. I have a cboReport combo box
that gives a list of my reports and when I select the report I want to
preview from the list I click the cmd button to view it. How would I add a
message box to display if there isnt anything selected in the cboReport cobmo
box? Thanks!
Private Sub cmdReport_Click()
Dim strDocName As String
Let s...
|
2 |
6/27/2007 10:26:02 PM |
|
|
Tables & Relationships
I think I figured out my tables and relationships.
Tables:
Table 1
tblTowedVehicles
fldTowID
fldReportDate
fldReportTime
fldlReportNumber
fldTowRequestDate
fldTowRequestTime
fldTowLocation
fldTowCompanyID(1)
fldTowArrivalDate
fldTowArrivalTime
fldTowTypeID (8)
fldTowReasonID (8)
fldNotes
Table 2
tblTowCompanies
fldTowCompanyID(8)
fldCompanyName
fldAddress
fldCity
fldZi...
|
8 |
6/27/2007 10:08:04 PM |
|
|
help me create a inventory input and output when items sold
...
|
2 |
6/27/2007 7:12:53 PM |
|
|
Using Append/Update Query with Passwords
I have inherited two separate Data Bases which are very similar. The Table
of the second Data Base is Linked. Both Data Bases have the same password
that is required on opening.
There is an Append Query & an Update Query that can be used to transfer
specific information or Update to the second Data Base.
The problem is that when you run either query, it says you are about to
append/upd...
|
2 |
6/27/2007 6:42:46 PM |
|
|
Generate Sequential numbers for new records
I am developing a Work Order Database for my job. I have a combo box with
"Contract Numbers" to select from. When you select on any Contract Number I
need a new "Work Order Number" to appear. There are 10 different contract
numbers (A0009041N, A0009041P, etc...) so I need 10 different work order
numbers (N10001, P100001, etc..) to generate sequential for each new record.
This is my layo...
|
8 |
6/27/2007 6:04:07 PM |
|
|
stay on current record if error
i am trying to keep the user from adding a new record if an error
occurs on the current new record.
i used the following code but it doesn't get me there:
Private Sub UniqueID_AfterUpdate()
If UniqueID.Value = SpecimenID.Value Then
Dim longRec As Long
longRec = Me.Recordset("ID")
MsgBox "You scanned the same barcode twice!", vbCritical, "Scan
Error"
DoCmd.GoToRecord , , acGo...
|
2 |
6/27/2007 4:02:04 PM |
|
|
Code vs Add ons
I've been battling with writing code that will fit my DB and I've lost. I'm
just no good at it. NO matter how I try to massage it to work for my DB I
just can't get it. So I was wondering if I should just buy an add on to take
care of my automatic emails or not.
My boss just wants it to work. If I could get the code to work, that would
be fine, but my boss wants it to be automatic...
|
5 |
6/27/2007 4:00:04 PM |
|
|
No Duplicates allowed
I have a Data Base that has a particular number field where No Duplicates are
allowed.
If I enter a number that is already allocated and move to the next record, I
get an error message stating that there is a duplicate (OK).
However, if I hit Exit, the data Base exits without any warning and when you
reopen the record is naturally missing. Is there a way that you can get an
error mess...
|
7 |
6/27/2007 8:14:01 AM |
|
|
Referential Integrity Problem
I'm building a database that consists of frontend and backend. Some
of the lookup tables need to reside in the frontend database. The
data in the lookup fields that relate to the backend tables will never
change, but a descriptor for items in these fields will. I may need
to update the descriptors periodically, hence the need to keep these
tables in the frontend database so that the new de...
|
4 |
6/27/2007 5:28:03 AM |
|
|
users in database
Is there a way to find out which users are in a particular database in
Access? When you try to open exclusively it will let you know that someone
else is in the database but can you find out which user so you can ask them
to get out?...
|
5 |
6/27/2007 4:36:28 AM |
|
|
Logins and Security
I only have a few more things to do to my DB and it's 'done.' I need to set
up logins for all my users, initiate the security protocols and slit it into
front end/back end.
What should I do first? Thanks.
Freehal...
|
2 |
6/26/2007 4:58:01 PM |
|
|
我想單ç¨è²·access2003
我已有office 2003家用版，想增購access 2003，如何處ç†...
|
1 |
6/26/2007 4:35:12 PM |
|
|
Delete Record trouble
Hello, I have a form with a sub-form in it. The subform has a list of
employees. I want it so you can delete an enployees name from the subform
list. I have the properties set of the subform set to record selectors (Yes),
Allow deletions (Yes) but it will let me select the employees row and give
the little arrow pointing to it on the left but wont give me the list so I
can cut it to dele...
|
8 |
6/26/2007 8:57:00 AM |
|
|
Access Table
Hi All,
I have set the password to my access db when i try to open from Visual Basic
gives an error not a valid password how do i solve this.
TIA...
|
5 |
6/26/2007 5:45:02 AM |
|
|
Learning code
I've been having a really hard time trying to figure out how to get anything
but the simplest of codes to work. I've used code from people who swear up
and down it works, i try to use it and nothing happens. There's always some
kind of error.
Is there a manual or tutorial, or training program that's out there that can
help me understand code better so I'm not at the mercy of vba and...
|
11 |
6/26/2007 3:20:19 AM |
|
|
Newbie ? using multiple users in one database at same time
I am very much a newbie when it comes to databases but I have been given
Microsoft Access 2003 and/or Microsoft SQL 2000 server to use to accomplish
my task. With Access I could probably limp my way along but SQL Server I
wouldn't even know where to begin.
GOAL:
20 users travel from store to store taking inventory of cash in safe. Each
user has there own laptop all connecting to one ...
|
10 |
6/26/2007 12:30:17 AM |