|
Filenames and fields
Hi there, i have just used this code to create a folder using a field name
Dim strPath As String
strPath = "\\Server\Database\CKS\Data\" & Me.JobNo
If Len(Dir(strPath, vbDirectory)) = 0 Then
MkDir (strPath)
End If
Shell "explorer.exe " & strPath, vbNormalFocus
However i want to create more folders in the directory but have been
unsuccessful in my attempts, for example, in ...
|
3 |
27.09.2006 12:54:11 |
|
|
Upsized to SQL Server BE - Requery causes Access to crash
I have recently upsized an app to a sql server backend. After a few
alterations it is working well, apart from when I am requerying forms. When
I use Me.Requery or Me.subform.Requery, access crashes with the "Microsoft
Office Access has encountered a problem and needs to close" error message.
I have since discovered that my problem was omitting the "form" from my
requery so Me.Requery ...
|
1 |
27.09.2006 12:35:42 |
|
|
Access 2000/2003 and Word 2003
How can I do a report with word 2003?
I can't merge to applications, and the common reports of access have a size
limitation on "page lenght" or detail section lenght.
thanks
...
|
1 |
27.09.2006 12:15:01 |
|
|
Import Excel table from SparePoint
I can’t import Excel table from SharePoint document store to Acces 2003
database.
The import works form SharePoint lists, but doesn’t work from document store....
|
1 |
27.09.2006 12:07:01 |
|
|
How do I create a relational database using MS Access?
I need to make a relational database with three tables but dont know how. Can
anybody help me...
|
2 |
27.09.2006 11:09:10 |
|
|
Access Bugs, sorry bout last post
Hi
I am using access to devlop a database and a strange thing keeps happening.
Every so often when i press the windows key + D to show the desktop my
computer goes crazy and opens loads of random windows, like i have msn open
and i open liek 95 windows in there and it fulls my task bar with things some
i can't get rid of unless i restart. I have had it on two differed computers
now. ...
|
2 |
27.09.2006 11:04:01 |
|
|
Are all objects being used?
I am fairly new to Access Databases. I have created a few for work here. As
I have been working on them I would experiment with a query for example. If
that qry was working but did not give me exactly what I was looking for I
would try a different qry and keep the previous one because I thought that
data would be useful later. Well now the deal is I have a query that I am
not sure if it ...
|
6 |
27.09.2006 11:03:55 |
|
|
Deleting a space from mid post code
Please help
I am trying to do a lookup accross post codes and can not, as one data set
has a post code with no space and the other data set has a post code with a
space in the middle as below.
data set 1 AB12 1AB
data set 2 AB126AB
Is there a way of either removing the space from one or adding a space to
the other?
I unfortunately can't export to excel as the data is over 65k li...
|
3 |
27.09.2006 11:00:19 |
|
|
Go paperless
I'm trying to add employee pictures and other information such as drivers
licences to my database much like the Northwind sample db but need hel;p in
getting started. Cannot see were the pictures are stored in the sample
database.
Help...
|
6 |
27.09.2006 10:35:10 |
|
|
Access Bugs
...
|
1 |
27.09.2006 10:15:01 |
|
|
test
test...
|
1 |
27.09.2006 10:14:00 |
|
|
Pre-select first row in ListBox
I have a ListBox with a SELECT statement as RowSource.
How can I pre-select first row?
Listindex property is read-only...
I don't know the Value properties's contents.
TIA
--
AP
...
|
6 |
27.09.2006 09:33:34 |
|
|
zero shows in new record
Hi,
I have a table that shows zeros in two fields in the new record. I
don't know why this only happens in two fields out of many that are of
the same type and have similar data in them. The zeros also show up in
the form the is used to enter data. I don't think this effects my data
in any way but I would like to know why the zeros occur in only some
fields and how to prevent them.
Tha...
|
5 |
27.09.2006 06:31:23 |
|
|
How do i sum fields in a record?
Hi, I have a database created in Office 2003 in which I need to total
amounts in various fields within a record. I cant seem to get it to work.
Can anyone help?
Thanks...
|
5 |
27.09.2006 05:49:02 |
|
|
pop-up field to enter data not appearing
I have a database whereby a switchboard has been created that when you first
open it has lots of buttons that essentially initiate different queries in
the background.
Several of these buttons pop a data entry field up so that you can type in a
start date for the query to use.
I have now upgraded from Access 2000 and windows 2000 to Access 2003 and
Windows XP. These pop-up data entry fie...
|
2 |
27.09.2006 05:03:40 |
|
|
Can't change the path of a linked table
I create a new database and import the linked tables, when I want to
change the links to the new location it said "THe Microsoft Jet
Engine couldn't find the (tblName).Make sure the object exists and
that you spell its name and the path correctly.
The path of the Old Database is like that P:\MyDatabase\ MyDatabase
Back End\My_Database_ be.mdb and I want to change it to
P:\NewDatabase\ NewDat...
|
2 |
27.09.2006 04:42:48 |
|
|
63.7777777777777777
Dear all ,
I have an unbound text box on my form that's used to view the resukt of a
certain calculation: the results appear like this 63.7777777777777777
While i want it to appear like this 63.77
What should i do ?
Regards...
|
4 |
27.09.2006 04:00:18 |
|
|
how do i remove the letter overide icon on botton bar?
ovr appears on bottom bar. It overtypes letters. How do i remove this feature?...
|
2 |
27.09.2006 03:34:33 |
|
|
Refreshing Combo Box
Another one I cannot figure out
When I add a record that affect the list in a combo box, understandably that
the combo box is not updated until I manually refresh it in some way,
usually by sending the F9 key. Is there a way to automate it?
Example:
Form Invoice (invoice header - name, address, date etc)
Subform Invoice Details
Product_ID (Combo), Quantity, Price, Line Total (calculat...
|
7 |
27.09.2006 03:34:00 |
|
|
Running total in a query
Hi all, I apologize if my question sounds rather simplistic, but I bet
many novices have encountered similar problems.
I'm trying to query a database table that approximately resembles
the following:
PRODUCT UNITS SOLD REGION YEAR
X 100 West 2001
X 25 South 2001
Y 50 South 2002
Z ...
|
10 |
27.09.2006 03:33:02 |
|
|
change report using VBA, then view and close it
this is the simplified code to: win XP, access 2003, 2000 file format
everything works fine, except when you close the report after viewing it
(using the close button on the toolbar) it opens in design view, if you use
the close window on the top right it works fine.
Why this different behaviour and can it be changed without juggling with the
toolbars?
'open report in des...
|
7 |
27.09.2006 02:51:54 |
|
|
Tab Forms and Sizes
I have created multiple TABS in a form. My problem is that everytime I go
from one Tab to another it jumps up/down in the overall form. Is there a way
to prevent this so that every tab is fixed, and when you click on another tab
there are no jumps?...
|
5 |
27.09.2006 02:19:02 |
|
|
nested iif not working!!!!
I have an nested IIF that will only display one vlaue in my report section
footer. I am sure that this is a simple ( ) problem or something, but it is
very frustrating!
Here is the statement: =IIf((([combo16]="24"),"Total for Section
24"),IIf(([combo16]="DLSS"),"Total for DLSS"),IIf((([combo16]="DTS"),"Total
for DTS"),"Total for Section 65H"))
Here is the explanation:
Combo16 has ...
|
4 |
27.09.2006 02:04:01 |
|
|
How do I get my daily calendar to show up?
I did a search for a birthday and now I can't get my calendar to go back to
the daily calendar!! All I have now is the list of birthdays, etc. Please
help!!
...
|
2 |
27.09.2006 01:14:42 |
|
|
Help with tables, importing PDF and relationships.
Sorry if this is a double post.
I saw a post in here before when I searched for "multiple tables" but it was
only part of what I need answered so I'm starting a new one.
I have a "Distributers" and a "Products" table. The Products table has a sub
table linked in because one of the products has a few slight variations that
are different enough to need their own table. It was suggested ...
|
3 |
27.09.2006 00:52:17 |