| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I am trying to create a database to track heavy equipment for building
roads, like Dozers, Excavators, etc., and I would like to display a
calendar /...
RCGUA
|
07-07-2009 05:32 PM
Tony Toews [MVP]  | 6 | 60 |
| | | using access97 with a table linked to sqlserver 2005
with the following
dim rs as dao.recordset
dim lngActionId as long
Set rs =...
Roger
|
07-07-2009 08:42 AM
JvC | 8 | 43 |
| | | I have a field that needs to auto increment each time a new entry is
made. It is a text field that needs to increment in a similar way to
Excel...
Paul H
|
07-07-2009 08:36 AM
Salad | 8 | 76 |
| | | Simple issue. How to initiate a End key (from keyboard) command in an
Click just after Me.Fieldname.SetFocus of a command button?
Bart
2003
AA Arens
|
07-07-2009 08:28 AM
fredg | 1 | 52 |
| | | not sure if I understand which way the above is intended - but as I am
not a programmer I just use what I do know or have learnt from forums
like...
DeZZar
|
07-07-2009 05:51 AM
hbinc | 6 | 49 |
| | | I have 2 tables: Employee Table and Attendance Table.
each contain an EmployeeID.
How do I list all the Employees that do not show up in the...
Greg (codepug@gmail.com)
|
07-06-2009 09:44 PM
Greg (codepug@gmail.com) | 2 | 73 |
| | | Hi everyone,
I am sure someone has a better way for me to handle this than a bunch
of lefts and rights.
Have a field called "contents" that comes...
stevenrec
|
07-06-2009 09:05 AM
Terry Kreft | 3 | 54 |
| | | Hi Folks,
My form is called 'MainForm' in my DB and has a TextBox displaying
'JobNum'.
I have a report called 'Invoice' that uses a query called...
Team Smiths
|
07-06-2009 08:12 AM
JvC | 4 | 52 |
| | | I have a simple report which gets employees details off a query. The
report has a employeeID field as well the name and address fields. All
I want to...
John
|
07-06-2009 07:24 AM
DeZZar | 6 | 63 |
| | | I have a combo box. How to display a value in a box in a form related
to the chosen value from the combo?
Bart
Access v 2003
AA Arens
|
07-06-2009 02:13 AM
DeZZar | 5 | 58 |
 | | Good to know Aravind, thankyou for the clarification.
Cheers
The Frog
Salad
|
07-05-2009 09:03 PM
James A. Fortune | 15 | 99 |
| | | How to add a chosen value from a combo box into a text box, hereby
using a command button?
Bart
Access 2003
AA Arens
|
07-04-2009 04:18 PM
tina | 1 | 70 |
| | | I would like to track changes to some records in my db; if I include
an 'Updated' column, and set it's default value to 'Now()', in what
cases will...
robert.waters
|
07-03-2009 10:27 PM
Tom van Stiphout | 3 | 63 |
| | | If anyone can help converting to Japanese, I'd appreciate it
When I look at the txt files in Notepad, i get
Subject: Ž‘—¿ƒ_ƒEƒ“ƒ ...
EiEiO
|
07-03-2009 09:51 PM
MGFoster | 1 | 30 |
| | | I've never worked on a SQL Server, so rank me a newbie.
If you are working on an app that is partially...or perhaps fully but
needs...
Salad
|
07-02-2009 11:50 PM
Agile Consulting | 6 | 36 |
| | | I have a listbox on a form that is dynamic. The contents of the
listbox change when other controls on the form are adjusted. I would
like to have a...
iwasinnihon
|
07-02-2009 07:11 PM
lyle fairfield | 3 | 64 |
| | | A2003.
Is there a way to set the default font for all forms? I went into
Options but the only font setting I saw was for datasheets. ...
Salad
|
07-02-2009 02:13 PM
Larry Linson | 18 | 137 |
| | | I have an Access database that basically runs select queries using
different criteria inputted by the user. It's not a very complex
database, but it...
Coll
|
07-02-2009 07:11 AM
Coll | 5 | 48 |
| | | I want my command button & start and stop textboxes to return records
within whatever date range is entered.
Instead what returns is 1 of 1 record...
zufie
|
07-02-2009 03:23 AM
Phil Stanton | 7 | 34 |
| | | Using code the frontend, I can copy a table from the frontend to the
backend and create the table link using the following...
JohnP
|
07-01-2009 11:03 PM
Tom van Stiphout | 13 | 82 |
| | | I just revised a system for a customer, and they want to deploy it to
several remote sites with read only data. The sites do not have Access,
so it...
John von Colditz
|
07-01-2009 05:03 PM
John von Colditz | 10 | 99 |
| | | Hi,
Can anyone help me with displaying the table contents on a form, and
also to create a graph for the fields on a tabbed form
Deepak Reddy
|
07-01-2009 04:30 PM
Larry Linson | 1 | 64 |
| | | Can someone tell me how to add/delete references in Acc 2007.
Thanks
Mono Cultural Brit
|
07-01-2009 02:54 PM
David W. Fenton | 8 | 55 |
| | | Thanks, MGFoster.
I had not read that article, and I learned things from it.
I remain in awe of people who voluntarily provide advice to...
Composer
|
07-01-2009 11:51 AM
Composer | 1 | 28 |
| | | So the table is tlkpGender
SELECT tlkpgender. gendernumber, tlkpgender. genderDescription FROM
tlkpgender;
table
Gendernumber ...
sparks
|
07-01-2009 10:32 AM
sparks | 2 | 45 |
| | | I am getting requests from my clients to provide my software
application for dentists (www.VisualDentist.com) on a palm / cell
phone and provide...
JohnP
|
07-01-2009 10:28 AM
Rich P | 3 | 70 |
| | | Hello,
Can anyone tell me a vba code (or any other way) where I can have a
dailog box pop up for the user(when he clicks as button) to IMPORT...
Deepak Reddy
|
06-30-2009 01:26 PM
MGFoster | 1 | 67 |
| | | I was reading the controls on a form.
of course I can read that a label has a parent but is there a way to
say that this parent has a child of the...
sparks
|
06-30-2009 11:42 AM
Krzysztof Naworyta | 3 | 52 |
| | | I have a small application setup to go and filter on a backend Oracle
DB dependant on some inputs from Combo and Text controls on my form.
The weird...
lukethegooner
|
06-30-2009 02:56 AM
lukethegooner | 3 | 60 |
| | | I'm trying to import a CSV file produced by Excel. The file is comma-
delimited, and one field contains a 2-digit text field which contains
values...
Stonedjw
|
06-29-2009 04:15 PM
MGFoster | 1 | 46 |
| | | I have a subform where the main form contains some option selections
for the user to filter the subform.
However, I seem to be only able to specify...
DeZZar
|
06-29-2009 02:34 PM
Krzysztof Naworyta | 1 | 70 |
| | | My trusty old database designed in Access 2003 got tripped up when all
users were upgraded last week to Access 2007.
Thwe problem is with a delete...
Vet Tech
|
06-29-2009 09:52 AM
Vet Tech | 2 | 63 |
| | | Hi Everyone,
Recent threads have prompted me to renew a line of investigation into
a design methodology that I am hoping would make...
The Frog
|
06-29-2009 02:06 AM
Mr.Frog.to.you@googlemail.com | 6 | 80 |
| | | I need an if/then type statement that sorts my records into
categories.
If Date <46 then display "Current"
If Date >45 but <61 display "45-60...
Rosy
|
06-28-2009 10:40 PM
gssstuff | 4 | 59 |
| | | Here is the weird problem I am having today. On only 1 computer out of
30, when the user sends e-mails from Access that are just text,
Outlook is...
musicloverlch
|
06-28-2009 02:16 PM
musicloverlch | 0 | 57 |
| | | Is there a way to conditionally hide a control (on a form) on a
specific record and yet have that control visible on all other records?
Lyle
|
06-28-2009 11:35 AM
fredg | 4 | 29 |
| | | This is an Access97 front-end to a SQL Server back-end. We need to
keep A97 because of a legacy application that's just too horrible to
contemplate...
Richard Sherratt
|
06-27-2009 08:26 PM
Richard Sherratt | 2 | 62 |
| | | Hi All,
I am trying to find a way to auto update a particular field in a table
when the database is opened. Basically, the way the following...
DeZZar
|
06-26-2009 09:12 PM
sandy miss | 17 | 106 |
| | | credit
auto
*** Sent via Developersdex http://www.developersdex.com ***
sandy miss
|
06-26-2009 09:09 PM
sandy miss | 0 | 101 |
| | | I am trying to get my command button to open a Form rather than a
report.
I tried messing with the VBA behind the command button which gave me
the...
zufie
|
06-26-2009 02:29 PM
paii, Ron | 2 | 42 |
| | | Hi,
Is there something wrong with this lookup? It's returning an error no
matter what I try.
=DMax("","invoices","ClientID = 137")
contains...
Cron
|
06-26-2009 10:51 AM
cronoklee | 3 | 69 |
| | | Since one can't modify an Excel worksheet by linking to it like in the
past, what do people do nowawdays? Is the best solution to import...
Salad
|
06-26-2009 08:09 AM
Salad | 16 | 100 |
| | | MochaTrpl wrote:
OK. Then write a function. Let's say it was
Function Test()
Test = (Txt1 + Txt2 + txt3)/3
End Function
then your control source...
MochaTrpl
|
06-26-2009 03:18 AM
Phil Stanton | 6 | 41 |
| | | Hello All
I am trying to import all txt files in a directory into memo fields
(one file = one record)
the following code tries to delimit (I think...
EiEiO
|
06-25-2009 12:51 AM
EiEiO | 5 | 44 |
| | | All,
Can a text box has both "Password" and "00000" as the
inputmasks? (i.e. I want to limit the number of characters as well as
masking the...
pc
|
06-24-2009 09:14 PM
tina | 3 | 49 |
| | | Have you looked at "default" settings for opening a database?
tools->options->advanced tab.
default open mode
Shared
Exclusive
The above...
Albert D. Kallal
|
06-24-2009 03:22 PM
bobh | 1 | 57 |
| | | DoCmd.GoToControl "Command14" or "txtMyTBox"
Over time, I've been having intermittent problems going running
this command. Access often returns this...
MLH
|
06-24-2009 09:05 AM
tina | 3 | 34 |
| | | Someone came up with the bright idea that we should
list all variables and values and labels from a database into
excel.
If we are asking something...
sparks
|
06-23-2009 05:04 PM
Rich P | 8 | 81 |
| | | Hello all,
I'm trying to copy some files to a CD from within my application. I'm
using Win XP and A2000. I've learned that it is a two-step...
zuckermanf@gmail.com
|
06-23-2009 04:00 AM
Phil Stanton | 5 | 94 |
| | | Is there a simple way to use the Expression builder or VBA to generate
the AVG of calculated Totals?
I have created a form that creates the total...
MochaTrpl
|
06-22-2009 11:36 PM
MochaTrpl | 0 | 49 |
