Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.11 seconds.
Search: Posts Made By: Ranman256
Forum: Excel 04-16-2018, 05:29 PM
Replies: 5
Views: 148
Posted By Ranman256
Re: search computer from Excel sheet

paste this code into a module. (Alt-F11, insert , module)

Then it will open ANY file via its extension....
.pdf files will open in acrobat,
.doc files in word

Forum: Modules & VBA 04-09-2018, 05:34 AM
Replies: 2
Views: 127
Posted By Ranman256
Re: Access sending outlook emails

make a report to show the data, then:

docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,,sSubj,sBody
Forum: Modules & VBA 04-06-2018, 04:05 AM
Replies: 5
Views: 110
Posted By Ranman256
Re: Code to change query criteria

The query looks at the form....

Select * from table where [id]=forms!myform!txtID
Forum: Queries 04-06-2018, 12:40 AM
Replies: 8
Views: 164
Posted By Ranman256
Re: Invalid Bracketing error

if you use queries instead of sql code, you wont have this error.
Forum: Modules & VBA 04-06-2018, 12:38 AM
Replies: 11
Views: 206
Posted By Ranman256
Re: Can you add Option Explicit or Error Handling to several modules at one time?

you dont have to add these. Access can run them all without Dim or Option explicit.
You would only need to add them IF the code is not working, where youd need to track down the cause. THEN Option...
Forum: Word 04-05-2018, 09:44 AM
Replies: 2
Views: 211
Posted By Ranman256
Re: Insert file into a Word Document

ActiveDocument.Hyperlinks.Add Anchor:=Selection.Range, Address:="C:\Documents\myPDF.pdf" _
, SubAddress:="", ScreenTip:="", TextToDisplay:="mypdf.pdf"
Forum: Forms 04-05-2018, 09:37 AM
Replies: 3
Views: 133
Posted By Ranman256
Re: Runtime error 2114

this is an object error. Did the error box not show you what code if failed on?
when you do an updgrade the references are lost due to the new versions.....
in VBE (alt-F11), menu, tools,...
Forum: Modules & VBA 04-04-2018, 08:22 AM
Replies: 3
Views: 145
Posted By Ranman256
Re: Unbound form: Update a record and get another record

there's no need to connect to ADO. you are already in the database.
why go outside the database to come back into the same database?

use a bound form , thats what theyre for.
no need for code. ...
Forum: Queries 03-30-2018, 01:16 AM
Replies: 6
Views: 182
Posted By Ranman256
Re: Average item count per hour query calculation

Q1, put the data in Hour blocks,
Select person ,count( work) as CtPerHr, hour(timeField), format(timeField,"Mm/dd/yyyy") as Day from table

Q2, get Total of Q1
Select person, sum(CtPerHr) as...
Forum: Queries 03-30-2018, 01:15 AM
Replies: 6
Views: 182
Posted By Ranman256
Re: Average item count per hour query calculation

Q1, put the data in HR blocks,
Select person ,count( work) as CtPerHr, hour(timeField), format(timeField,"Mm/dd/yyyy") as Day from table

Q2, get Total of Q1
Select person, sum(CtPerHr) as...
Forum: Forms 03-30-2018, 12:59 AM
Replies: 3
Views: 121
Posted By Ranman256
Re: Check combobox is not blank

Combos are usually null,

If IsNull(cboBox) then
Forum: Modules & VBA 03-29-2018, 06:08 AM
Replies: 2
Views: 134
Posted By Ranman256
Re: refresh a subform on a tab control on a subform on a tab control

the tab should be irrelevant.
if you want to refresh data, refresh the subform.
Forum: Queries 03-28-2018, 09:43 AM
Replies: 14
Views: 227
Posted By Ranman256
Re: Select last record meeting conditions

what do you mean LAST?
last record in the list sorted that way?
latest date record?

if date, then you can use MAX, but it takes 2 queries and you only want 2 fields
Q1 = Max(Date), KeyFld...
Forum: General 03-28-2018, 08:21 AM
Replies: 8
Views: 278
Posted By Ranman256
Re: docmd.runsql - error 438 - object doesnt support this property or method

It seems legal. (is notes the table name?)
put it in a query and run it.
Try to use queries instead of sql. (for just that reason)
Forum: Queries 03-28-2018, 06:49 AM
Replies: 4
Views: 114
Posted By Ranman256
Re: Query criteria help??

make 2 queries:
1 for Bus addr
1 for home addr

then you can pull what you need in query or in forms.
Forum: Forms 03-28-2018, 06:26 AM
Replies: 8
Views: 142
Posted By Ranman256
Re: How to Display PDF file on Form

you DONT want to display pdf on a form. It looses resolution.
Just open the pdf.
Forum: Excel 03-28-2018, 06:25 AM
Replies: 3
Views: 130
Posted By Ranman256
Re: Excel Query from Access Location

somewhere in your data connections is the connection to the database (and thus, the query)

either in code,
or Data tab, connections
Forum: Reports 03-28-2018, 06:23 AM
Replies: 11
Views: 224
Posted By Ranman256
Re: Report Won't Sort By MaxOfDate Field

MaxOfClassDate should be in the query.
Is it in the query?
yet wont show in report grouping?
Forum: General 03-28-2018, 04:26 AM
Replies: 2
Views: 271
Posted By Ranman256
Re: Running the front end from one-Drive

as long as you connect to the server tables, I dont see any.
Forum: Forms 03-27-2018, 04:06 PM
Replies: 1
Views: 110
Posted By Ranman256
Re: Placing a qry parameter into chart legend

enter the param on a form text box,
reference it in the chart... forms!myForm!txtBox
Forum: Forms 03-27-2018, 09:00 AM
Replies: 13
Views: 191
Posted By Ranman256
Re: #name error with DCount

does [jobs with ncrs distinct test] run without errors or params?

in the field source did you say: =Dcount(....)
Forum: Forms 03-27-2018, 03:23 AM
Replies: 4
Views: 129
Posted By Ranman256
Re: Subform not working

we dont know much:
is the combo bound to a field?
is the subform connected to the master form?
does the combo have a working query as source?
Forum: General 03-27-2018, 03:20 AM
Replies: 2
Views: 265
Posted By Ranman256
Re: Checkbox show all if not ticked

sub chk_Live_Afterupdate()
if chk_Live.value then
me.filter = "[md_live]=true"
me.filterOn = true
me.filterOn = false
end sub
Forum: Modules & VBA 03-26-2018, 10:38 PM
Replies: 3
Views: 122
Posted By Ranman256
Re: Autoexec and close the database

application.quit does work...but you dont need it in the function,
put it in the autoexec AFTER your function.

i use it all the time.
Forum: Modules & VBA 03-26-2018, 10:04 AM
Replies: 13
Views: 260
Posted By Ranman256
Re: Close PDF before saving a new PDF

if you didnt open it in vb, you cant close it, what window is it in?
what if there are many pdfs open, what pdf is it?

The error itself tells you to close it.
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 03:37 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World