|
Recently Converted to 2003 format
I have both a Frontend and a backend database. The backend has all the tables
linked to the frontend. I am running a test of the database with one of my
employees who has the same permissions as the rest of the group. She is the
only one I am testing: Here is the problem, there are two buttons that when
she clicks on them, it brings up an "Save Action Cancelled" and when she
clicks on t...
|
4 |
26.09.2006 15:40:55 |
|
|
XP update quirks
Microsoft, please allow me a few words. Would you PLEASE remove the squirks
you introduced into my operating system since a few updates ago. And find
other ways to do business other than to tamper with computers essentially
taking up our precious time. We understand there is a new OS coming. Only
every time we "shutt down" windows it inevitably makes think of Mr. Gates and
Microsoft (in ...
|
2 |
26.09.2006 15:26:02 |
|
|
Expression Builder and Code Editing
Hey All,
Does anyone know where I can find a nice online guide that shows the syntax
of the expression builder and the access code.
I am trying to be able to code my own formulas that will require "if"
statements. I am not sure of the syntax for these commands.
One of the challenges I am trying to tackle is calculating business days and
non business days in a date field.
For Exa...
|
1 |
26.09.2006 15:06:14 |
|
|
Access Report Code
I have a report. On the report are fields brought in from a query which is
pulling the fields from a table, common knowledge, on the report I want to
know the code to create a dollar amount for grades. For example, A shows up
on the report and for each A, in another column, I want a dollar amount
assigned, for example A=$7.00, B=$5.00, etc, etc. How can I accomplish this?
Thanks.
Tim ...
|
2 |
26.09.2006 14:48:02 |
|
|
three tables relationship
Hi
I have a three tables in the Access 2002
Tabel A
Invoice number
Date
Customer
Table B-Receipt
Invoice number
Paid Date
Customer
Table C-Receipt(2006)
Invoice number
Paid Date
Customer
I tried to create One query based on the Table A's Invoice number to match
with Table B and Table C in order to find out the Invoice of Table A (is it
paid and then when)
I can...
|
3 |
26.09.2006 14:41:07 |
|
|
Muliple labels from one record
Help - I have a query with one record and want to make sheets of labels for
that one record. How do I do it in Access. ...
|
7 |
26.09.2006 14:34:39 |
|
|
Query and filtering dates
I have a date field named dateFIELD in my database whose output or
display is a LONG DATE and the input mask is a SHORT DATE:
I type: 08/31/2006
Access enters: Thursday, August 31, 2006
In a query if I type Day([dateFIELD]) i get 31, what is the formula to
return Saturday, instead of 31? Or is there a formula to return the
actual name of the day rather than the number of the day?
Tha...
|
5 |
26.09.2006 14:32:33 |
|
|
getting access to create folders using field data
I need to get access to create a folder on my computer using data such as the
job name in a field in the database. I want it to do this by clicking a
button on a form and it popping with the newly created folder and therfore
then being able to drag fiels into that folder which relate to that job,
thanks for any help, WK...
|
5 |
26.09.2006 14:06:51 |
|
|
Convert Date to week
Hi,
I have Sv_Date. I want to display W1, W2, W3, W4. Instead the following
DatePart("ww",[Sv_Date]) would give me week 38 if Sv_Date = #9/17/2006#.
What I want is week of each month eg W1, W2, W3 AND W4
SF
...
|
3 |
26.09.2006 13:55:04 |
|
|
Breakout Forms/Objects for Multiple Monitor Setups
One thing that would be a big help, that I have either not figured out in
Access 2000/2002/2003 and don't have the resources to check in 2007 because I
don't have a multiple monitor setup system to spare for beta testing is
support for breaking out forms/reports/etc. so that they can be moved to and
maximized on another desktop/monitor.
With my end users, it would be a big help if there...
|
3 |
26.09.2006 13:50:02 |
|
|
Access database
How do I set it up to automatically load a particular access database when I
open Access?...
|
5 |
26.09.2006 13:44:02 |
|
|
Deletion of views created via ADOX
I have created a series of Views(virtual tables) in MS Acces via the ADOX
library.However when I try and delete it via the delete method of thee Views
collection ,an error code pops up stating "the requested object isn't part of
the collection".
Can anyone,please, help me out of this situation?
Code sample:
Sub Main()
On Error GoTo DeleteViewError
Dim cat As New ADOX.Ca...
|
5 |
26.09.2006 13:40:27 |
|
|
RENAME TABLE
Why doesn't Access support the SQL statement, "RENAME TABLE name1 TO name2"???
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and t...
|
4 |
26.09.2006 13:40:19 |
|
|
Database creation
I have been asked to create a database for an event. The database will need
to track the invited attendees, if they will be attending the event, as well
as their meal selection.
To track this information, they would like the attendees to fill out a form
on line and then later run a report to provide a summary of how many people
are going and what their meal selection is.
Is this pos...
|
2 |
26.09.2006 13:37:02 |
|
|
Close form
I hav very strange situation. In database from menu with asinged funtion i
open Form. In this form i hav DTPicker Control. In Form_Load i set value of
this control to today.If i close form from form close button everything is
ok, but if i close from the Access main window close button i recive error:
DTPicker returned the error:Property is read only.
, and program close.After some experime...
|
6 |
26.09.2006 13:01:02 |
|
|
re: table help
How can I center text and add comma's to a numeric column when I'm designing
or working in a table? ...
|
4 |
26.09.2006 13:01:01 |
|
|
Calculate Workdays
How can I manipulate the public function found at
http://www.mvps.org/access/datetime/date0012.htm
to subtract 2 days from the given date?...
|
3 |
26.09.2006 12:48:02 |
|
|
How to link a table with Outlook Contacts ?
Is quite simple using Menu File\load external data\link...
but the table I obtain do not have the EntryId of the contact, and I
need it.
Now in am looping through Outlook.ContactItem, but is too slow.
Do you know how I can link a table with Outlook Contacts that display
EntryId?
Thank you very much
...
|
1 |
26.09.2006 12:47:09 |
|
|
Repairing FE can populate drop-down lists/queries
In case someone is searching for reasons why combos/list boxes may not show
any records, here's a strange one.
After repairing the back end and re-creating some relationships, some of the
combos in the front end were not populating. The solution ended up being to
run a compact/repair on the front end.
That's not something I think to do very often, particularly in an MDE with
no temp ...
|
3 |
26.09.2006 11:38:30 |
|
|
like function
hi all !
i want to use the "like" function in a query but i want the user to
enter the search variable.
i have tried "like[enter name to search]" but this doesnt return any
results for some reason.
any ideas ???
thanks
brino
...
|
3 |
26.09.2006 11:23:37 |
|
|
if statement
hello i am new to if statments so please help
i am trying to indicate in a query records that have been placed by saying
if a record has a placements Id (represented as a number... example -100000 )
then the value i want is YES if not then NO
i have tried the following
=iif(<1([placementid]),[yes],[no])
any ideas...
|
2 |
26.09.2006 11:12:25 |
|
|
Getting Data from GPS on Com7
I'm trying to find Access/VBA code to monitor the data coming from a GPS
through Com7.
When you click a button (control), I'd like to capture the current data
coming through com7.
Where can I find info/examples on accessing a com port through Access?
Thank you!
-Clint Marshall
...
|
5 |
26.09.2006 10:38:58 |
|
|
Opening an Access file
I am a student and need to open a Access file that I created at school. I
used Access 2003 and saved it to my jump drive. When I start the file on my
laptop I can not open it because I do not have Access. Is it possible to
still open the file?...
|
5 |
26.09.2006 10:24:50 |
|
|
Turning off macros
I have a question regarding two different macros.
One macro is a "prepopulate" type macro. It loops through a field and
prepopulates a number of fields with semi-random data.
However, the idea is that you can then go into a form and change a couple of
those fields if you need to make adjustments. There is a second macro that is
linked to the "On Change" event of that field that checks ...
|
4 |
26.09.2006 09:21:29 |
|
|
Problem!
Hey i am new to this group! I am going to make a database in Access and
i have a design. But i have a small problem. In my design i decided to
have an input form where the fields in which you enter data are red,
but when you have typed some information into the field the box
automatically turns white. Please could someone tell me how to do this
in Access i would be grateful.
Nellz
...
|
4 |
26.09.2006 08:58:29 |