open a form in datasheet view (1 Viewer)

M

mana

Registered User.

Local time

Today, 13:43

Joined

Nov 4, 2014

Messages

265

• Nov 4, 2014

• #1

Hello,

i have the following code and i want that the form opens in datasheet view but i don't know how. can you help me please?
thank you

On Error GoTo Err_Befehl14_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Copy Of frm_logistik_zeitfehlerein"

stLinkCriteria = "[Fehlteil]=" & "'" & Me![Fehlteil] & "'"
DoCmd.OpenForm stDocName, , , acFormDS, stLinkCriteria
Exit_Befehl14_Click:
Exit Sub
Err_Befehl14_Click:
MsgBox Err.Description
Resume Exit_Befehl14_Click

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 13:43

Joined

Aug 30, 2003

Messages

36,125

• Nov 4, 2014

• #2

I'm pretty sure you have the arguments in the wrong positions. Check help for the proper order.

 

M

mana

Registered User.

Local time

Today, 13:43

Joined

Nov 4, 2014

Messages

265

• Nov 4, 2014

• #3

how can i check with the help? i am new to ms access and vba? can you help me more please?

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 13:43

Joined

Aug 30, 2003

Messages

36,125

• Nov 4, 2014

• #4

After you type

DoCmd.OpenForm

is Intellisense showing you what should be in each position?

 

M

mana

Registered User.

Local time

Today, 13:43

Joined

Nov 4, 2014

Messages

265

• Nov 6, 2014

• #5

hello

i tried a lot and i lso wote it in this way but when i write it in this way the filter condition doesn't work. can you help me please? i don't know what to do ?
thank you

stDocName = "frm_logistik_offlinedate_detail"

stLinkCriteria = "[Fehlteil]=" & "'" & Me![Fehlteil] & "'"
DoCmd.OpenForm stDocName, acFormDS, stLinkCriteria

 

spikepl

Eledittingent Beliped

Local time

Today, 22:43

Joined

Nov 3, 2010

Messages

6,142

• Nov 6, 2014

• #6

You still have the arguments in wrong position - pay attention to commas. Learn how to use the documentation (which answers simple questions like yours) :

http://www.google.com/search?q=DoCmd.OpenForm

 

M

mana

Registered User.

Local time

Today, 13:43

Joined

Nov 4, 2014

Messages

265

• Dec 3, 2014

• #7

[Hello i Hve the following code and i have run time errro that
there is a syntax error(missing operation) in query expression.
can you help me please?


Me.RecordSource = "SELECT * FROM qry_Logistikreview_Zeitfehlerein WHERE qry_Logistikreview_Zeitfehlerein.Zeit Fehler Ein BETWEEN #" & Replace(Format(Me.txt_StartDate.Value, "mm/dd/YYYY"), ".", "/") & "# " & _
"AND #" & Replace(Format(DateAdd("d", 1, Me.txt_EndDate.Value), "mm/dd/YYYY"), ".", "/") & "#"



DoCmd.Requery

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 13:43

Joined

Aug 30, 2003

Messages

36,125

• Dec 3, 2014

• #8

Any field with inadvisable spaces in it would have to be bracketed for starters.

 

M

mana

Registered User.

Local time

Today, 13:43

Joined

Nov 4, 2014

Messages

265

• Dec 4, 2014

• #9

Hello

thank you very much it works now
but i have another problem
when i run the query between two fields it doesn't show anything
but there are some data between seelcted fields

my zeit fehler ein is for example like below
2014-12-04

can you help me please?

 

J

JHB

Have been here a while

Local time

Today, 22:43

Joined

Jun 17, 2012

Messages

7,732

• Dec 4, 2014

• #10

mana said:

my zeit fehler ein is for example like below
2014-12-04

can you help me please?

Click to expand...

Are you sure the field type is Date/Time, (because what you show isn't a normal date format)?
In you query you need the data in the field you are searching to be in the same format as you've in the criteria.
And you criteria shows date like mm/dd/yyyy and not yyyy-mm-dd!

 

M

mana

Registered User.

Local time

Today, 13:43

Joined

Nov 4, 2014

Messages

265

• Dec 4, 2014

• #11

Hello,

yes the data is as date/time field but i really don't know why it doens't work

 

J

JHB

Have been here a while

Local time

Today, 22:43

Joined

Jun 17, 2012

Messages

7,732

• Dec 4, 2014

• #12

mana said:

... but i really don't know why it doens't work

Click to expand...

Did you modify your query to with the below in mind?
In you query you need the data in the field you are searching to be in the same format as you've in the criteria.
And you criteria shows date like mm/dd/yyyy and not yyyy-mm-dd!
Show some real data in a Excel sheet or in a Database.

 

M

mana

Registered User.

Local time

Today, 13:43

Joined

Nov 4, 2014

Messages

265

• Dec 4, 2014

• #13

hello

the attachment is the text file of my query. (some parts of that)

 

Attachments

• qry_Logistikreview_Zeitfehlerein.txt

  10.2 KB · Views: 59

M

mana

Registered User.

Local time

Today, 13:43

Joined

Nov 4, 2014

Messages

265

• Dec 4, 2014

• #14

hello

did you see the attachment?

 

J

JHB

Have been here a while

Local time

Today, 22:43

Joined

Jun 17, 2012

Messages

7,732

• Dec 4, 2014

• #15

mana said:

hello

did you see the attachment?

Click to expand...

Yes, but I can't use it!

 

M

mana

Registered User.

Local time

Today, 13:43

Joined

Nov 4, 2014

Messages

265

• Dec 4, 2014

• #16

Hello

You mean you can't open it?

 

J

JHB

Have been here a while

Local time

Today, 22:43

Joined

Jun 17, 2012

Messages

7,732

• Dec 5, 2014

• #17

I can open it, sorry but I can't use the data in it, it is a mess.
And I don't want the result from the query but the data the query is based on, and it a Excel sheet (so that I can import it into a database), or in a database.

 

M

mana

Registered User.

Local time

Today, 13:43

Joined

Nov 4, 2014

Messages

265

• Dec 5, 2014

• #18

hello


you know i checked the data type and it is text but it is a linked table from sql server and the data type is as date in sql server but i don't know why it is linked with text data type
cany ou help me please?