Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.20 seconds.
Search: Posts Made By: June7
Forum: General Today, 11:51 AM
Replies: 6
Views: 64
Posted By June7
Re: Forms don't show in Split DB FE

OP says everything works on his computer, but not on coworker's so can't be issue of button/event naming.

Is the code all macros or all VBA or mixture?

If table links were not valid, opening...
Forum: Modules & VBA Today, 12:01 AM
Replies: 5
Views: 169
Posted By June7
Re: relink to password protected BE

Interesting since it indicates a working solution. I've never had to worry about password protection.

"Doesn't work" means what - error message, wrong results, nothing happens?
Forum: Modules & VBA Yesterday, 11:15 PM
Replies: 5
Views: 169
Posted By June7
Re: relink to password protected BE

Have you searched?

Bing: Access VBA link backend password

Lots of hits. Here is one https://stackoverflow.com/questions/31844592/connecting-to-access-backend-from-access-2013-frontend-using-vba
Forum: General Yesterday, 02:51 PM
Replies: 7
Views: 558
Posted By June7
Re: Formatting access cells for inputing data in hh:mm format

hours:minutes:seconds (elapsed quantity, not clock time) or degrees:minutes:seconds, the calculations to convert to/from decimal hours or decimal degrees are the same. Exclude seconds if that...
Forum: General Yesterday, 11:27 AM
Replies: 6
Views: 382
Posted By June7
Re: Feeding Ms Access Form by Outlook (Contact's Photo)

@MajP, it seems links posted in CODE tags are not clickable unless you use HTML tags. If you want to emphasize them then maybe just 'white space' them - add carriage returns.
Forum: General Yesterday, 11:19 AM
Replies: 7
Views: 558
Posted By June7
Re: Formatting access cells for inputing data in hh:mm format

Have to convert to decimal if you want to do calcs. 235:24 is 235.4 hours. Review...
Forum: Forms 12-08-2018, 07:03 PM
Replies: 2
Views: 384
Posted By June7
Re: Subform showing only 1 record

Gotta be issues with PK/FK linking. If you want to provide db for analysis, follow instructions at bottom of my post.
Forum: Forms 12-08-2018, 06:17 PM
Replies: 9
Views: 254
Posted By June7
Re: Combo box items changed to continue to show previous field

I am sure the demo will clarify. But I also answered in your duplicate thread https://access-programmers.co.uk/forums/showthread.php?t=302791

To repeat:

This is a widely-discussed issue of...
Forum: Excel 12-08-2018, 01:03 PM
Replies: 5
Views: 1,155
Posted By June7
Re: Find Cell Value. and perform Loop

I edited my previous post after you read it.
Forum: Excel 12-08-2018, 12:25 PM
Replies: 5
Views: 1,155
Posted By June7
Re: Find Cell Value. and perform Loop

I often 'get started' with Excel VBA coding by macro recording. Perform steps manually then modify the generated code as needed. I used recorder to get the Find syntax then figured out the rest. So...
Forum: Forms 12-08-2018, 12:07 AM
Replies: 7
Views: 567
Posted By June7
Re: Is an input form with a run-time variable possible?

And another http://www.accessmvp.com/TomvanStiphout/ZoomBox.htm
There are probably more out there.
Forum: Modules & VBA 12-07-2018, 11:42 PM
Replies: 13
Views: 612
Posted By June7
Re: Insert Into Help

Yes, if this is an UNBOUND form, I could see these as multiple controls feeding data to same field. So how many etc are there? Will they all have input?


For x = 1 To etc
If Not...
Forum: Modules & VBA 12-07-2018, 07:42 PM
Replies: 13
Views: 612
Posted By June7
Re: Insert Into Help

Why are there multiple SigX controls? Screams 'I am not normalized data structure'.
Forum: Forms 12-07-2018, 01:38 AM
Replies: 12
Views: 438
Posted By June7
Re: Open a form with same ID, but as text string

Do you mean the field in table has been converted to a text data type?
Forum: Introduce Yourself 12-06-2018, 02:20 PM
Replies: 10
Views: 1,731
Posted By June7
Re: Feedback form added

I am not even seeing a 'Featured Forum post' entry.
Forum: Forms 12-05-2018, 02:44 PM
Replies: 9
Views: 234
Posted By June7
Re: Form Setup

Width is width of the design area.

Manually size the form frame (window) by grabbing and dragging corner anchor.

Height property is set with each section.

Do you have db set for Tabbed...
Forum: Queries 12-05-2018, 01:09 AM
Replies: 3
Views: 234
Posted By June7
Re: Run Monthly Payroll

No, not specific to Access. Compound join is joining datasets in query on 2 or more fields. The query will show multiple link lines. You will have to manually set these links.

A compound join...
Forum: General 12-04-2018, 02:20 PM
Replies: 3
Views: 338
Posted By June7
Re: customize ColumnHistory??

I don't think can modify the date/time stamp. Would have to save the user ID with the memo input. Can use code to concatenate the User value with the text input.

As far as displaying modified...
Forum: Queries 12-04-2018, 12:08 PM
Replies: 3
Views: 234
Posted By June7
Re: Run Monthly Payroll

Do you want the additions and deletions summarized into 1 Addition and 1 Deduction value for each emp/period?

Build an aggregate query for Additions, GROUP BY EmpNo, Period

Build an aggregate...
Forum: General 12-04-2018, 11:57 AM
Replies: 28
Views: 722
Posted By June7
Re: eMail Databases with attachment option

Sorry, yes with the variable declaration there are 3 lines to add to your code:

Dim strAttach As String

strAttach = Me.FilePath
.Attachments.Add strAttach
Forum: General 12-04-2018, 12:53 AM
Replies: 28
Views: 722
Posted By June7
Re: eMail Databases with attachment option

No, use your original code and modify with the two lines in post 19. I ran YOUR code with that simple modification and it works.
Forum: Modules & VBA 12-03-2018, 11:56 PM
Replies: 4
Views: 337
Posted By June7
Re: Apply parameter to queryDef

Please explain exactly what you are trying to accomplish.

Do you want to just modify a parameter for an existing query object? Or do you want to create a new query object? What is parameter "p0"?...
Forum: Queries 12-03-2018, 11:37 PM
Replies: 6
Views: 355
Posted By June7
Re: My query doesn't work

But what is the value of AmountPaid for record when it returns Yes and should be No?
Forum: General 12-03-2018, 11:26 PM
Replies: 28
Views: 722
Posted By June7
Re: eMail Databases with attachment option

Yes, this was happening in your first version.

I just tried hard-coding of a filepath in the code and it works. So there is something about referencing the textbox. Stepping through code, I see...
Forum: Modules & VBA 12-03-2018, 07:48 PM
Replies: 4
Views: 337
Posted By June7
Re: Apply parameter to queryDef

You want to modify a query object in Build11.mdb? Try:

cnn.CreateQueryDef
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:55 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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