Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 30
Search took 0.00 seconds.
Search: Posts Made By: Auntiejack56
Forum: Tables 10-25-2019, 03:55 PM
Replies: 5
Views: 192
Posted By Auntiejack56
Re: Relinking via DSN to SQL Server

Hmm, DBGuy, I think that must be it. I am indeed using a File DSN, and Access does convert that to a DSN-less connection, one of its cool attributes.
However, the *old* LTM prompts you to browse for...
Forum: Tables 10-25-2019, 04:56 AM
Replies: 5
Views: 192
Posted By Auntiejack56
Relinking via DSN to SQL Server

Hi, I'm just starting to use Access 365 and a newly downloaded SQL Express. The LTM is confusing. My tables are all connected to a Prod server on a different machine, and I'd like to relink them to...
Forum: Queries 09-17-2019, 03:18 AM
Replies: 2
Views: 92
Posted By Auntiejack56
Re: Calculated Fields in SQL

Thanks. As I continue to work with ever newer versions of Access, I am slowly pulling out my old habitual workarounds that have accumulated since version 1.1 (some of which, as you suggest, may have...
Forum: Queries 09-17-2019, 02:59 AM
Replies: 2
Views: 92
Posted By Auntiejack56
Calculated Fields in SQL

Hi all,
There was a time when this query would give an error, because you couldn't use a calculated field in a second calculation in the same query:
SELECT Len([EntrantName])*[EntrantID] AS...
Forum: Access Web 08-15-2019, 02:10 AM
Replies: 6
Views: 470
Posted By Auntiejack56
Re: How to update/distribute Front-end Clients with Sharepoint

Hi, I'm no expert on this, but I have used Sharepoint instead of a fileshare to store and deploy front ends. It works because of the WebDAV capability of Sharepoint (and Box and other web...
Forum: Modules & VBA 12-07-2017, 06:28 PM
Replies: 6
Views: 372
Posted By Auntiejack56
Re: enable textboxes if three criterias met in table

So, based on Ranman's reply, you could try, in the OnLoad event:
txtMyTextBox.enabled = (nz(Dlookup("userpermissions","tbl_Admin","username = '" & environ("username") & "'"),"") = "ReadWrite")
...
Forum: Modules & VBA 12-07-2017, 06:15 PM
Replies: 27
Views: 1,298
Posted By Auntiejack56
Re: Gantt Chart Woes

Wow! Try this:
Dim n As Long, i As Long

For n = 1 To 20
If Len(Cells(n, 1)) > 0 Then
Debug.Print Cells(n, 1)
For i = 2 To 27
If...
Forum: Reports 11-23-2017, 02:42 PM
Replies: 14
Views: 617
Posted By Auntiejack56
Re: Cannot work out how to extend the layout to a new section

Hi, so sorry I haven't replied - flat out here! I've tried to work out a way to explain the problem.

Basically, I'm creating all my reports using a Layout.
I'm not explicitly using the Wizard -...
Forum: Reports 11-20-2017, 07:59 PM
Replies: 14
Views: 617
Posted By Auntiejack56
Re: Cannot work out how to extend the layout to a new section

Hi, Your replies much appreciated, thanks. JHB, a good idea but it just creates a new layout grid, doesn't extend the existing layout grid to the new section.

In fact, it seems that you can't...
Forum: Reports 11-19-2017, 07:05 PM
Replies: 14
Views: 617
Posted By Auntiejack56
Re: Cannot work out how to extend the layout to a new section

thanks, but not there yet - still can't extend the layout into the ProviderShortName Header section. Agreed that the rest of the formatting is dodgy, but that is more a result of me trying every...
Forum: Reports 11-19-2017, 06:16 PM
Replies: 14
Views: 617
Posted By Auntiejack56
Re: Cannot work out how to extend the layout to a new section

Sorry, that didn't work - try attaching ...
Forum: Reports 11-19-2017, 06:13 PM
Replies: 14
Views: 617
Posted By Auntiejack56
Re: Cannot work out how to extend the layout to a new section

Sure.

https://imgur.com/a/q0tMA

The orange shows the existing layout. I want to include the new field Provider Short Name into the existing layout in the new section. That is, I want to somehow...
Forum: Reports 11-19-2017, 05:45 PM
Replies: 14
Views: 617
Posted By Auntiejack56
Re: Cannot work out how to extend the layout to a new section

Hi, thanks ridders.
Nope, what I mean is that the new report creates it's own layout, so that in Design view I can see the Layout grid in the Detail section, and I can drop controls into it.
The...
Forum: Reports 11-19-2017, 05:11 PM
Replies: 14
Views: 617
Posted By Auntiejack56
Re: Cannot work out how to extend the layout to a new section

Thanks mate, but you've posted your reply to the wrong questioner. Don't know who asked the question about subreports. Jack
Forum: Reports 11-19-2017, 01:38 PM
Replies: 14
Views: 617
Posted By Auntiejack56
Cannot work out how to extend the layout to a new section

Hi,
I am creating reports automagically by selecting an existing query and clicking Create Report. Very cool and the layouts are easy to modify.
In fact, the same Layout extends from the Header...
Forum: Modules & VBA 10-08-2017, 07:02 PM
Replies: 9
Views: 590
Posted By Auntiejack56
Re: Loop thru Text Values and save to Recordset

Hi, I think I can see what you're trying to do. You need the format rs("NameOfField") to do this:

rs.AddNew
For Each c In Me.Controls
If c.ControlType = acTextBox...
Forum: Modules & VBA 08-27-2017, 06:48 PM
Replies: 7
Views: 313
Posted By Auntiejack56
Re: Code to find first/last DDD in Year

Some logic:

Last Monday logic.
What is the first day of the new Year? Easy, 01/01/(parYear+1)
Say that first day is a Monday, what day do we want to find? The Monday before ie -7 days.
Is there...
Forum: Modules & VBA 08-27-2017, 06:17 PM
Replies: 7
Views: 313
Posted By Auntiejack56
Re: Code to find first/last DDD in Year

It's the first of Jan in the following year. You are finding the Monday prior to that.
Forum: Modules & VBA 08-27-2017, 05:55 PM
Replies: 7
Views: 313
Posted By Auntiejack56
Re: Code to find first/last DDD in Year

Hi, here's a start. Sorry, bit busy at the moment! You'll have to check it.

Function LastMonday(parYear as long) as date
LastMonday = DateAdd("d", -Weekday(dateserial(paryear+1,1,1), vbtuesday),...
Forum: Modules & VBA 08-27-2017, 05:22 PM
Replies: 7
Views: 313
Posted By Auntiejack56
Re: Code to find first/last DDD in Year

So you need a function like
mydate = getFirst("Monday", 2017)
which returns the date of the first Monday in the Year?
And similarly for the last, say, Friday?
Forum: Introduce Yourself 08-08-2017, 02:11 PM
Replies: 3
Views: 361
Posted By Auntiejack56
Re: G'day from Oz

Welcome from a Sydneysider. Lots to learn!
Forum: Modules & VBA 08-07-2017, 08:01 PM
Replies: 16
Views: 776
Posted By Auntiejack56
Re: Button to add data to table

When you create the SQL string, all the values you are inserting into it get converted to strings, so it doesn't matter what data types you've used in your dim statements.

What is important is...
Forum: Modules & VBA 08-07-2017, 06:38 PM
Replies: 16
Views: 776
Posted By Auntiejack56
Re: Button to add data to table

When I look at your SQL string, it has quotes around every fieldname except the date. So would it be correct to say that those other fields are all text? If any field is actually a number, remove the...
Forum: Modules & VBA 08-07-2017, 05:33 PM
Replies: 16
Views: 776
Posted By Auntiejack56
Re: Button to add data to table

Hey Sting,

This is what I would try next - 2 things:
Put square brackets around all those deeply terrible Field names that you have inherited.

If that doesn't work, before your bad line (that...
Forum: Introduce Yourself 08-07-2017, 02:38 PM
Replies: 7
Views: 531
Posted By Auntiejack56
Re: Sydney Aust

Too right I am. You mentioned AWS in a post on UA the other day, so I hopped in the side-car and headed over.
Showing results 1 to 25 of 30

 
Forum Jump



All times are GMT -8. The time now is 02:20 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 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World