|
Really BASIC question, sorry
I have a database containing just 2 simple tables:
T_Main
Fields are:
MainID (Autonumber, primary key)
MainField (text)
LookupField (text)
T_LookUp
Fields are:
LookupField (text, primary key)
LookupRate (currency)
There is a one(T_Lookup) to many(T_Main) relationship based on LookupField
with enforced referencial integrity.
I have a form for updating T_Main.
This contains a c...
|
3 |
21.09.2006 14:56:50 |
|
|
Checking for the existence of files ?
I am setting some variables with file names and want to check
for their existence before proceeding in my VB code - how do I
do that ? All files will be held on a local hard drive.
Thanks for any help
Regards...
|
3 |
21.09.2006 13:59:02 |
|
|
Automate a filter button on a form
I would like a command button on a form that will ask which field to search
and what word(s) to search for. These are memo fields with info on books. I
have scanned posts in this group and discovered the following string that
seems to accomplish part of this task:
Like "*" & [What word?] & "*"
I would like to make this very simple for users; they cli ck the button,
answer the prompt ques...
|
2 |
21.09.2006 13:53:02 |
|
|
Allow Edits
I have a form that is bound to a Customer Table. On that form, I have 4
different methods of searching the Table that are done through Unbound Combo
Boxes, Customer Name, Account No etc. In setting Me.allowedits = True, I
allow anyone to make changes to the record that is found. I don't want to do
this. I want the record to be "Read Only" until an "Edit Button" is selected.
If I set Me.A...
|
9 |
21.09.2006 12:29:01 |
|
|
List Box & Subform -Recordset bookmark?
List Box subform
200601 content of 200601, 200602, 200603.....etc data
200602
200603
* 200601 = 1st record, 200602=2nd record ......
When i click record at bottom then the subform will list out then data, but
if i direct click on the list box(but record at below still showing 1 record,
but subform change the data base on which value i click) then i move to...
|
1 |
21.09.2006 12:14:02 |
|
|
field formating...
All -
I have a field in a table that is numeric. It should be 11 characters but
the table is omitting the leading zero's.
Ex: 00092557589 is showing as 92557589. The problem is I need the leading
zero's.
Any ideas?
...
|
3 |
20.09.2006 23:01:39 |
|
|
combo box filters another combo box
I’m having problems with one unbound combo box filtering another unbound
combo box. I’ve got the Row Source on cboContact set to filter by cboCompany.
It seems to be using the last company I select as the filter for contacts on
all records. Or... the longwinded explanation: if I choose a new company on
record 2, it erases the contacts for record 1 & refilters showing company 2's
con...
|
7 |
20.09.2006 19:36:02 |
|
|
Editing Sub Forms
I have a general information form that displays names, addresses etc from the
"Customers Table and I also have a sub form "frm_sub_ExtraInfo" that I
display in the main form. Both forms get their inf from the Cutomers Table.
The "Extra Info" is in a sub form because I want to hide or show all the
information easily and without going through a routine of fiealdname.visible
= True / False ...
|
11 |
20.09.2006 19:08:54 |
|
|
Must learn how to write VBA.
Hi there,
I have a new position where I will be maintaining (and hopefully creating)
access databases. I have enough knowledge to make me dangerous (I warned
them ahead of time too), but not enough to write VBA without a lot of sweat
and tears. Wouldn't you know it, the database I will be maintaining is all
done in VBA.
What resources would you recommend. I have a simple grasp of SQL a...
|
17 |
20.09.2006 18:51:06 |
|
|
Formula
I am having problems with a formula - I did not write it originally and am
not very skilled at formula's either. Does something appear to be missing?
=IIf([blocktotal]=0,[Sum Of SumOf# of Contracts1],([Sum Of SumOf# of
Contracts1]-[blocktotal])+[NF Blocks]![actual])
-
-
Bonni...
|
2 |
20.09.2006 18:04:02 |
|
|
Access Library Inventory
I have an Access database with 6,000 books entered. I have barcodes in
the books and want to do a year end inventory. I will scan the barcode
and would like that to show up as present in the database. Finally
those books not "present" would be known to be lost. Any help on how
to do this. Thanks.
...
|
3 |
20.09.2006 17:39:00 |
|
|
HELP! Select behaves differently inside code and in Query builder
I have a select statement as follows.
Select * from qryClassSummaryDetail WHERE [class_code] = 'ML2' AND
Student_ID <> -1
I use it in a bit of code in this way (as_where works out to be the clause
above.)
li_i = fncRefreshQuery("qryClassSummaryDetailBase",
"qryClassSummaryDetail")
ls_temp = "Select * from qryClassSummaryDetail " & As_where
Set rstClassDetail = Curre...
|
4 |
20.09.2006 15:48:04 |
|
|
Search and see One Record
I managed to import a large excel spreadsheet for my database successfully.
How do I create a report/query that gives me a screen shot status of any
particular record. Ideally, I'd like a form where you type in the name, hit
okay, and a single record appears on screen in a nice format for veiwing. Is
this a query or report???
--
Sophia...
|
3 |
20.09.2006 14:23:46 |
|
|
Write a query returning names beginning with the letter "a"?
How do I write a query returning all contact names begining with the Letter
"A"?...
|
5 |
20.09.2006 12:43:01 |
|
|
Multiple select listbox not holding on to values
Hello. I created a multiple select (extended) listbox field in my table and
then selected it from my field list to add to my form. When I select values
in the listbox and then move on to the next record, the field does not hold
on to the values I selected. That field in my table is also blank. I know I'm
missing something big here...what should my next step be after creating my
listbox f...
|
3 |
20.09.2006 12:10:58 |
|
|
Access 2003: Reports
I selected a layout from the six offered and I don't like it. How can I
change it?...
|
4 |
20.09.2006 08:06:15 |
|
|
Loosing data in the backend
I have split a access database into a frontend and backend.
The frontend and backend are placed on two different computers.
I have tryed many times where the user have entered a lot of
data into the backend and then a few hours later, the data
is just gone. After the data have been entered into the
database, I tryed to turn off and on the computer and the
data was still there. but then a f...
|
10 |
20.09.2006 02:00:55 |
|
|
What best training course to get started with access quickly
I am a self trained user of Word and Excel and have been using these programs
for years. I imagine I only take advantage of 30% of the Excel features. I
am looking to get started with Access and have limited time, is there a
online course that can kind of quide me how to get started? If anyone could
recommend the best -fastest training course I would appreciate it greatly.
Thanks in adv...
|
4 |
20.09.2006 00:08:01 |
|
|
Running a Report
I have multiple users that run reports off of my database - each of them have
security to run the reports. Only one user gets an error when trying to run
reports - The error message says "there was an error executing the command"
What is causing this?
--
Bonni...
|
4 |
19.09.2006 23:35:45 |
|
|
Can I display a msg box after form has loaded?
I'd like a message box to display after the form has loaded, but I can't
find an event to use. Open and Load cause the message box to appear before
the data is loaded into the form. Anything else I try doesn't execute, or
executes to often (e.g., 'dirty'). Is there a "post" feature in VB that I
could put in the Load event? Or maybe something simpler?
It's just a text message that's ...
|
4 |
19.09.2006 20:25:17 |
|
|
database
I am real new to access. I need to make a customer service database. I'm
not sure what I should use. Tables, forms, or reports. I need to be able to
enter customers name, address, phone number and a comment area of what the
call was for. I have to be able to pull this up again if they call back and
be able to add more information in the comment (note) area so it continues
on. If so...
|
6 |
19.09.2006 20:08:02 |
|
|
Need to retrieve record using one or two fields of input
I have two questions, which are related somewhat but not reallly.
I want to take several data input forms I have and kind of combine them into
a tabbed setup. Am I going to basically have to combine all three froms into
one big one or do they remain technically individual forms even though they
display using one vehicle (tabbed interface)?
2. I need to be able to search my records an...
|
2 |
19.09.2006 19:19:30 |
|
|
arrays
Am I missing something. Does access handle arrays of a field? Or do I mean
arrays in a field. I would like to reference the ith element in a field.
Code written in basic. TIA
--
____________________________________
In Christ's matchless name
ted & colleen
n6trf kc6rue
...
|
11 |
19.09.2006 17:59:03 |
|
|
Importing from excel
I have an excell table that I am trying to import into Access. However, when
I run the "Table Analyzer" and click on "Finish" I get a message that says
"File Shairing exceeded" CHange the MaxLockFile registry entry". I have no
idea what that means can somone please help me!?
Z...
|
2 |
19.09.2006 16:06:18 |
|
|
Ignore posts - you cant do this in access 2003
...
|
1 |
19.09.2006 14:02:47 |