Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Run-time error '3075': in microsoft.public.access.modulesdaovba
Started 1 month, 2 weeks ago by Toni Miletic
Hi all, I'm using Access 2000 SR1 Could you please help me with this code. I'm trying to run SQL query from VBA: VBA code: strSQL = "SELECT tblUzorak.IDVrsta, Avg([tblUzorak]![PEN14647_6h]) AS 30A_PEN14647_6h, Avg([tblUzorak]![PEN14647_1d]) AS 30A_PEN14647_1d, Format(Avg([tblUzorak]![pastaENpoc]),""Long Time"",2,...
Site: Discussions in microsoft.public.access.modulesdaovba  Discussions in microsoft.public.access.modulesdaovba - site profile
Forum: microsoft.public.access.modulesdaovba  microsoft.public.access.modulesdaovba - forum profile
Total authors: 2 authors
Total thread posts: 4 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

Toni Miletic replied 1 month, 2 weeks ago
Hi all again me, If I change regional settings on the PC to English US then everything is working fine. I was using before Croatian regional settings. Any idea how to solve tis without changing regional settings? Kind regards Toni "Toni Miletic" wrote: > Hi all, > > I'm using Access ...
Size: 3,029 bytes
Customize:  Customize "<b>Reply 1</b>: Run-time error '3075': in microsoft.public.access.modulesdaovba :: microsoft.public.access.modulesdaovba :: Discussions in microsoft.public.access.modulesdaov..."

John Spencer replied 1 month, 2 weeks ago
Try changing the clause AND (tblUzorak.datum BETWEEN #" & startdate & "# AND #" & enddate & "# ) to force the date format into the unambiguous yyyy-mm-dd format AND (tblUzorak.datum BETWEEN " & Format(startdate,"\#yyyy-mm-dd\#")& " AND " & Format(enddate,"\#yyyy-mm-dd\#") & " ) Also why are you using LIKE and not ...
Size: 3,386 bytes
Customize:  Customize "<b>Reply 2</b>: Run-time error '3075': in microsoft.public.access.modulesdaovba :: microsoft.public.access.modulesdaovba :: Discussions in microsoft.public.access.modulesdaov..."

Toni Miletic replied 1 month, 2 weeks ago
Thanks John for your help it's working now with your code even I was in the meantime fixed it differently. Instead of this code: AND (tblUzorak.datum BETWEEN #" & startdate & "# AND #" & enddate & "# ) I used this one: AND ((tblUzorak.datum) BETWEEN #" & Format(CDate(strStartDateAsText), "mm\/dd\/yyyy") & "# AND #" ...
Size: 4,739 bytes
Customize:  Customize "<b>Reply 3</b>: Run-time error '3075': in microsoft.public.access.modulesdaovba :: microsoft.public.access.modulesdaovba :: Discussions in microsoft.public.access.modulesdaov..."

 

Top contributing authors

Name
Posts
Toni Miletic
3
user's latest post:
Run-time error '3075':...
Published (2009-11-10 23:01:00)
&nbsp; Thanks John for your help it's working now with your code even I was in the meantime fixed it differently. Instead of this code: AND (tblUzorak.datum BETWEEN #&quot; &amp; startdate &amp; &quot;# AND #&quot; &amp; enddate &amp; &quot;# ) I used this one: AND ((tblUzorak.datum) BETWEEN #&quot; &amp; Format(CDate(strStartDateAsText), &quot;mm\/dd\/yyyy&quot;) &amp; &quot;#...
John Spencer
1
user's latest post:
Run-time error '3075':...
Published (2009-11-10 18:57:00)
&nbsp; Try changing the clause AND (tblUzorak.datum BETWEEN #&quot; &amp; startdate &amp; &quot;# AND #&quot; &amp; enddate &amp; &quot;# ) to force the date format into the unambiguous yyyy-mm-dd format AND (tblUzorak.datum BETWEEN &quot; &amp; Format(startdate,&quot;\#yyyy-mm-dd\#&quot;)&amp; &quot; AND &quot; &amp; Format(enddate,&quot;\#yyyy-mm-dd\#&quot;)...

Related threads on "Discussions in microsoft.public.access.modulesdaovba":

Run-time error 3075 - help in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Run-time error 3075 - help in microsoft.public.access.modulesdaovba
Run-time error 3075 - help in microsoft.public.access.modulesdaovba
Reference and 3075 error in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Reference and 3075 error in microsoft.public.access.modulesdaovba
Reference and 3075 error in microsoft.public.access.modulesdaovba
Error 3075 Missing Operator in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Error 3075 Missing Operator in microsoft.public.access.modulesdaovba
Error 3075 Missing Operator in microsoft.public.access.modulesdaovba
Error 3075: functions such as CHR$ not working on Vista...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Error 3075: functions such as CHR$ not working on Vista in microsoft.public.access.modulesdaovba
Error 3075: functions such as CHR$ not working on Vista in microsoft.public.access.modulesdaovba
Runtime Error 3075 only on one machine... in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Runtime Error 3075 only on one machine... in microsoft.public.access.modulesdaovba
Runtime Error 3075 only on one machine... in microsoft.public.access.modulesdaovba
Delete record and Error 3075 in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Delete record and Error 3075 in microsoft.public.access.modulesdaovba
Delete record and Error 3075 in microsoft.public.access.modulesdaovba
Runtime 3075 in microsoft.public.access.modulesdaovba  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Runtime 3075 in microsoft.public.access.modulesdaovba
Runtime 3075 in microsoft.public.access.modulesdaovba
Lost in error 3075 in microsoft.public.access.modulesdaovba  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Lost in error 3075 in microsoft.public.access.modulesdaovba
Lost in error 3075 in microsoft.public.access.modulesdaovba
Runtime error 3075 - missing operator in...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile Runtime error 3075 - missing operator in microsoft.public.access.modulesdaovba
Runtime error 3075 - missing operator in microsoft.public.access.modulesdaovba
How come thsi group is called access.modulesdaovba, for...  Discussions in microsoft.public.access.modulesdaovba - site profile microsoft.public.access.modulesdaovba - forum profile How come thsi group is called access.modulesdaovba, for MS Access Front End - SQL Server Backendmicrosoft in microsoft.public.access.modulesdaovba
How come thsi group is called access.modulesdaovba, for MS Access Front End - SQL Server Backendmicrosoft in microsoft.public.access.modulesdaovba

Related threads on other sites:

Access Report Save as PDF using microsoft Addin in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Access Report Save as PDF using microsoft Addin in microsoft.public.access.modulesdaovba.ado
Access Report Save as PDF using microsoft Addin in microsoft.public.access.modulesdaovba.ado
INSERT records from local Access-DB to another Access-DB...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile INSERT records from local Access-DB to another Access-DB in microsoft.public.access.modulesdaovba.ado
INSERT records from local Access-DB to another Access-DB in microsoft.public.access.modulesdaovba.ado
How do I access a field in a previous record? (Access...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile How do I access a field in a previous record? (Access 2997) in microsoft.public.access.modulesdaovba.ado
How do I access a field in a previous record? (Access 2997) in microsoft.public.access.modulesdaovba.ado
Connect to Access DB without installing Access in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Connect to Access DB without installing Access in microsoft.public.access.modulesdaovba.ado
Connect to Access DB without installing Access in microsoft.public.access.modulesdaovba.ado
Access form in Module question, Can Access do this? in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Access form in Module question, Can Access do this? in microsoft.public.access.modulesdaovba.ado
Access form in Module question, Can Access do this? in microsoft.public.access.modulesdaovba.ado
Access 2007 File Disappears in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Access 2007 File Disappears in microsoft.public.access.modulesdaovba.ado
Access 2007 File Disappears in microsoft.public.access.modulesdaovba.ado
Import .dbf files to MS ACCESS in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Import .dbf files to MS ACCESS in microsoft.public.access.modulesdaovba.ado
Import .dbf files to MS ACCESS in microsoft.public.access.modulesdaovba.ado
Opening Lotus Notes from Access in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Opening Lotus Notes from Access in microsoft.public.access.modulesdaovba.ado
Opening Lotus Notes from Access in microsoft.public.access.modulesdaovba.ado
Opening Outlook from Access in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Opening Outlook from Access in microsoft.public.access.modulesdaovba.ado
Opening Outlook from Access in microsoft.public.access.modulesdaovba.ado
Reading VB Random Files with Access in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba.ado - site profile microsoft.public.access.modulesdaovba.ado - forum profile Reading VB Random Files with Access in microsoft.public.access.modulesdaovba.ado
Reading VB Random Files with Access in microsoft.public.access.modulesdaovba.ado
Thread profile page for "Run-time error '3075': in microsoft.public.access.modulesdaovba" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Run-time error '3075': in microsoft.public.access.modulesdaovba", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity