Search:
Type: Posts; User: IkkeEnGij
Search:
Search took 0.04 seconds.
-
tested with access 2003 :
just changed the field-type from text to numeric
and access did remove the prefixes automaticly
-
if the table is updated at every day
i would think that the last date of update is always today or yesterday
depending of the time of the day
seems logical to me
-
if the table is updated at every day
i would think that the last date of update is always today or yesterday
depending of the time of the day
seems logical to me
-
it is just a crosstab query of the table A of your first post
notise that not all Course codes are included, because not all Course codes that are in your Table B, are also in your Table A
-
did this in access 2003:
TRANSFORM First(Status) AS TheStatus
SELECT [Course Code]
FROM TableA
GROUP BY [Course Code]
PIVOT Persons;
-
did this in access 2003:
TRANSFORM First(Status) AS TheStatus
SELECT [Course Code]
FROM TableA
GROUP BY [Course Code]
PIVOT Persons;
-
I'm wondering, what is the problem, this is supposed to be a solution for :confused:
-
yes,as confirmed by MS
question is: if that is so, then why does the op get wrong results ?
using international format (YYYY-MM-DD) for dates, there can be no confusion
also, be aware of the...
-
depending where you live in the world, (9/1/2018) can be the first day of september, or the 9the day of januari
(2018-09-01) is the first day of september anywhere in the world
-
exactly, that is why s/he is creating a problem, where there is none
it is as simple as pie:
both shifts start at the same day
so why not make that day the production day of both shifts ?
and the...
-
Why are you creating a problem where there is none
both shifts start on the same day,so why not count their production as produced on that day
(what you already seem to be doing judging by your...
-
just replace all those shape controls by label controls with a center alignment
why would you use a shape and a label to do what can be done with just a label alone ?
the only things i can think...
-
Have you considered using just a label control to make a bar
instead of a shape and a label
-
yes,it works in MSaccess, provided you tell MSaccess to use SQL-92
(SQL-92 is an option since MSaccess 2003, if i remember correctly)
but i am almost 100% sure it will not return what vbgedo...
-
if i understand correctly, you want users to fill in times (hours,minutes,seconds) in a grid
why does that grid not have 3 columns to do that ?
1 for hours, 1 for minutes,1 for seconds
-
may (or not) exclude a day's worth of data
-
maybe yes, maybe no
2018-01-01 00:00:01 is later than 2018-01-01
-
-
have a look at the SPLIT and JOIN functions
-
you are realizing you are opening the .mdb in full shared read-write mode ?
-
try the rowrolchange event ?
-
kimaleah,
the most important line in your code is:
Debug.Print Query1
is the result really what you expect it to be ?
if you really want someone to help you:
show the result
-
a possibility:
have a module:
Dim TheForm(1 To 5) As New Form1
Sub Main()
Static TheLeft As Long
Static TheTop As Long
For i = 1 To 5
-
how many records were affected:
run the procedure twice to see what the responce is when no records are inserted
Sub AffectedRecords()
Dim db As DAO.Database
Set db = CurrentDb
...
-
-
could you please post the code and the program used to create a new database
-
if you want to search on a name,
why not just put an index on the name field
-
i suppose:
if you create the database with code (DAO)
then the version that is included by default in windows will be used
i am on windows 10
with access 2003
if i create a database with DAO, a...
-
i suppose:
if you create the database with code (DAO)
then the version that is included by default in windows will be used
i am on windows 10
with access 2003
if i create a database with DAO, a...
-
please explain step by step how these RDP users, who also have Access installed, open the same database from the same location.
such as:
1)user starts computer
2)user starts RDP
3)
4)
5)
6)...
-
i see
i see,but confused, what has Remode Desktop Protocol to do with this ?
-
am i interpreting that correct ?
there is 1 computer with msaccess installed, that 1 computer also holds the database
multiple users start that copy of msaccess via RDP, to access the database
so,...
-
I see, each year copying an empty template database is to easy ?
-
-
https://www.cl.cam.ac.uk/~mgk25/iso-time.html
-
there is no mysterious reason at all
what is the date 05/06/2018 ?
that depends on the part of the world you'r in
it can mean the 5th day of June ---say in belgium
or the 6th day of may ---say...
-
does the following succeed ?
SELECT Numéro, Date FROM Histo WHERE Numéro=4 AND Date=#2017-06-29#
-
siadly,
can you place your database here (with only the needed tables,and compacted, and zipped)
and please explain clearly what you expect as a result
-
i can not test this at the moment
but if memory serves me well, the autonumber is given right after the addnew,for ado and dao
try
rs.AddNew
MsgBox rs("ID")
rs.CancelUpdate
-
??
maybe use the merge method of the datatable object ?
|
Click Here to Expand Forum to Full Width
|