Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.61 seconds.
Search: Posts Made By: June7
Forum: Forms Yesterday, 02:00 PM
Replies: 4
Views: 63
Posted By June7
Re: Export Data from Access table to Json file

"Not able to send" still doesn't tell us much. Do you get error message? Does the code divert to the error handler?

As Colin suggests, step debug, disable error handling while developing code...
Forum: Forms Yesterday, 01:07 PM
Replies: 4
Views: 63
Posted By June7
Re: Export Data from Access table to Json file

What does 'no luck' mean - error message, wrong results, nothing happens?
Forum: Queries Yesterday, 10:57 AM
Replies: 6
Views: 63
Posted By June7
Re: Query help

Might need the false return value:

CoverageStatus: IIf(([employee name]='X' OR [employee name]='y') AND IsNull([Notes]), "pending", "")

or

CoverageStatus: IIf([employee name] IN ('X','y')...
Forum: Queries Yesterday, 10:44 AM
Replies: 6
Views: 63
Posted By June7
Re: Query help

Perhaps:

CoverageStatus: IIf([employee] IN("X","Y"), IIf([Notes] Is Null, "pending", ""), "this if not X or Y"))

Recommend use employee ID. If you use employee ID and it is number type, don't...
Forum: Modules & VBA 09-18-2018, 05:56 PM
Replies: 9
Views: 131
Posted By June7
Re: VBA SUB not found when calling from a marco

Works for me. Need to know your macro code.
Forum: Modules & VBA 09-18-2018, 01:54 PM
Replies: 9
Views: 131
Posted By June7
Re: VBA SUB not found when calling from a marco

Make it a Function instead of Sub.

But why use macro?
Forum: Forms 09-18-2018, 09:13 AM
Replies: 3
Views: 74
Posted By June7
Re: error in VBA code

Need a space in front of FROM:

" FROM

I will assume those spaces breaking up the field names are just typos in the post or thrown in by the forum.
Forum: Forms 09-17-2018, 10:56 PM
Replies: 25
Views: 307
Posted By June7
Re: Pick Record from certain record for a parameter query

I don't think the intent is to pass criteria TO subform, it is to reference field of subform to open another form.
Forum: Forms 09-17-2018, 09:50 AM
Replies: 2
Views: 89
Posted By June7
Re: Subform Problem

Why use the Enter event of each control to run data calcs? This means code runs as soon cursor enters the control, not when the Enter key is pressed.

This also causes the record to be in edit mode...
Forum: Forms 09-17-2018, 09:21 AM
Replies: 25
Views: 307
Posted By June7
Re: Pick Record from certain record for a parameter query

The dynamic parameterized query will not work because the referenced form is now within a subform container which requires the referencing to be different. Either change the dynamic parameter to...
Forum: Modules & VBA 09-15-2018, 10:51 AM
Replies: 3
Views: 112
Posted By June7
Re: Custom Ribbons - Show/Hide groups

It is possible to dynamically change ribbon without closing db. That's what the RibbonName property of form and report is for.
Forum: Forms 09-14-2018, 11:56 AM
Replies: 25
Views: 307
Posted By June7
Re: Pick Record from certain record for a parameter query

Yes, I got it to work as described in post 13.

Since I don't see any problem with posted code, provide db for analysis. Follow instructions at bottom of my post.
Forum: Forms 09-13-2018, 10:39 PM
Replies: 7
Views: 108
Posted By June7
Re: show a value from another table in a form

Why do you change to textbox? Use combobox. Otherwise options are to include Students table in form RecordSource joined to Course table or use DLookup function.
Forum: Reports 09-13-2018, 10:31 AM
Replies: 2
Views: 105
Posted By June7
Re: Automatically Update Textbox Value on Report Load

Why using Text property? Probably really want to set Value but this cannot be done with textbox on report. Since Value is default, no need to type it.

If you are trying to save to table - why? Why...
Forum: Forms 09-12-2018, 10:48 PM
Replies: 2
Views: 76
Posted By June7
Re: Record-dependant image

Yes, lots of images in db does use up file size limit. However, if db will have very limited data growth and unlikely to migrate to another db platform, I see small size images like jpg or png in...
Forum: General 09-12-2018, 11:08 AM
Replies: 7
Views: 759
Posted By June7
Re: Html email with image and hyperlink

You have space before a in < a href> and before / in < /a>. I did a test and those spaces cause issue. Remove them.

If still an issue try using HTML and BODY tags:

oEmail.HTMLBody =...
Forum: General 09-12-2018, 10:38 AM
Replies: 7
Views: 759
Posted By June7
Re: Html email with image and hyperlink

On the email, hover cursor over image. Do you see message 'ctrl+click to follow link'? Link works for me.
Forum: Forms 09-11-2018, 11:33 AM
Replies: 4
Views: 110
Posted By June7
Re: requery field after every entry

If the combobox does not have a ControlSource then it is UNBOUND. If it is used to save value to field and you want to limit its list to values not already associated with a master record, that...
Forum: Forms 09-11-2018, 10:47 AM
Replies: 4
Views: 110
Posted By June7
Re: requery field after every entry

This is an UNBOUND combobox?What are you using it for? Requires code to set it to Null or empty string.
Forum: General 09-11-2018, 09:56 AM
Replies: 7
Views: 759
Posted By June7
Re: Html email with image and hyperlink

What do you mean by "on" HTML?

Use Outlook automation to manipulate email object with an HTMLBody using HTML code tags. Tutorial site for HTML
https://www.w3schools.com/tags/tag_a.asp

Example...
Forum: Forms 09-11-2018, 08:52 AM
Replies: 25
Views: 307
Posted By June7
Re: Pick Record from certain record for a parameter query

I prefer you to provide your attempt for analysis.
Forum: Forms 09-10-2018, 11:55 PM
Replies: 25
Views: 307
Posted By June7
Re: Pick Record from certain record for a parameter query

I did a test with dynamic parameterized query referencing continuous form and it works - opens form to record of ID button is next to. However, I don't use dynamic parameterized query. I prefer WHERE...
Forum: Modules & VBA 09-10-2018, 05:53 PM
Replies: 1
Views: 82
Posted By June7
Re: How to export access query to excel

For example code review http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm
Forum: Forms 09-10-2018, 12:57 PM
Replies: 25
Views: 307
Posted By June7
Re: Pick Record from certain record for a parameter query

If you are going to use VBA, why bother with macro? Just use VBA command suggested by Ranman.

Is IDFKVehicle a number type?
Forum: Forms 09-10-2018, 11:08 AM
Replies: 12
Views: 164
Posted By June7
Re: Passing data from one form to another

Must commit record to table before requery. Assuming cboReference is UNBOUND:

With Forms![frmRecords]
!cboReference = Me.txtReference
Me.Close
.Requery
End With

Record is...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 02:14 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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