Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 2.67 seconds.
Search: Posts Made By: Minty
Forum: The Watercooler Today, 07:07 AM
Replies: 33
Views: 485
Posted By Minty
Re: Distractions, Distractions, Distractions

A long time ago I had a Dension HD(40gb I think) unit in an old Audi A4.

I used to fix VW group diagnostic equipment in a previous life, so the ODB car protocol units are something I know a...
Forum: Access Web Today, 06:03 AM
Replies: 8
Views: 70
Posted By Minty
Re: Advice on connecting Access to SQL Azure with Dynamic IP addresses

Gasman is on the right track, assuming the companies have a web site, you can use the Web site IP to do a fancy redirect based on the DNS records presented to it from memory.

To be brutally honest...
Forum: The Watercooler Today, 05:58 AM
Replies: 33
Views: 485
Posted By Minty
Re: Distractions, Distractions, Distractions

Well, I wasn't sure tbh. Maybe use it for browsing the web when trying to murder some woodworking project, and I've left my phone in the house??

As it happens I purchased a newer car, and it can...
Forum: General Yesterday, 08:20 AM
Replies: 23
Views: 243
Posted By Minty
Re: Calculate the age

Age was the name of the returned item, so you will have to change every reference from Age in the function to xcalcAge
Forum: Forms Yesterday, 05:20 AM
Replies: 5
Views: 67
Posted By Minty
Re: Open form from combo box

Bizzarely I think the issue is with the square brackets, try;

DoCmd.OpenForm "Contact Details", , ,"ID=" & Me.Combo288
Forum: General Yesterday, 03:22 AM
Replies: 4
Views: 77
Posted By Minty
Re: Composite Key relationship

I think you need a third junction table - tblServer_OpSystems

BUT - I'm confused by the Server ID in tblOsServers is that not unique?

In fact, I'm generally confused by the naming of the tables...
Forum: Forms 10-16-2019, 07:50 AM
Replies: 6
Views: 113
Posted By Minty
Re: When checkbox checked it shows textbox

You would need to use the on current event as well that fires when you move between records.

Something like

Me.Text1.visible = False

Also your code is overly complicated, I'm pretty sure...
Forum: General 10-16-2019, 06:23 AM
Replies: 4
Views: 78
Posted By Minty
Re: Error "The record source '|' specified on this form or report does not exist"

Totally stabbing in the dark without more information, maybe a linked excel file or table that isn't on their system?
Forum: Queries 10-16-2019, 12:58 AM
Replies: 12
Views: 131
Posted By Minty
Re: UNION Query syntax Issue

Simple debug experiment; cut and paste the individual selects into fresh queries to make sure they work?
Forum: General 10-15-2019, 09:36 AM
Replies: 7
Views: 128
Posted By Minty
Re: Access front end -to- SQL back end

This is the answer

Unless your VPN connection is unbelievably good, which it isn't from what you described. There are lots of other mitigating circumstances, but the RDP solution is pretty...
Forum: General 10-15-2019, 06:45 AM
Replies: 5
Views: 85
Posted By Minty
Re: Best method to get Access 2013

No idea on how legit they are but : https://www.softwaregiants.com/en_uk/microsoft-access-2013.html?gclid=Cj0KCQjw3JXtBRC8ARIsAEBHg4nsQ2xiLokuWIwk7nixan3YXhY0GuXy-ENnuJ8WlWS7LxOJrA47sREaAhAmEALw_wcB...
Forum: Forms 10-14-2019, 01:15 AM
Replies: 9
Views: 143
Posted By Minty
Re: Form Code

How are you cancelling a record? There is no code attached to your Delete Order button?

EDIT: Ok- having read the reply from Arne I see you are using the combo. Bit of an odd way to delete a...
Forum: Modules & VBA 10-09-2019, 08:08 AM
Replies: 12
Views: 208
Posted By Minty
Re: Use records retrieved from SQL server in an Access Report

Use the view recordset to create a temporary local table?

I think it would help if you could explain why you appear to be using a sledgehammer to crack a small pistachio? ?
Forum: Modules & VBA 10-09-2019, 03:25 AM
Replies: 12
Views: 208
Posted By Minty
Re: Use records retrieved from SQL server in an Access Report

Unless that stored procedure is doing anything clever, why not simply create a SQL view and link that to your database, then use that for your report?
Forum: Forms 10-09-2019, 01:24 AM
Replies: 49
Views: 517
Posted By Minty
Re: Clearing Multiple Forms using Add New Record button.

Yes - there will be scroll bar properties for that text box, simply set them to none.
Forum: Forms 10-09-2019, 12:19 AM
Replies: 49
Views: 517
Posted By Minty
Re: Clearing Multiple Forms using Add New Record button.

Set the subform to single form, instead of continuous.

Normally (but not always) a subform is used to enter multiple related records. Hence the ability to see many contacts for a customer for...
Forum: Queries 10-08-2019, 08:45 AM
Replies: 21
Views: 225
Posted By Minty
Re: Close Queries if no records

In each if>then loop, set a flag to indicate if there no records for that query and add the query name to a string with VbCr after it. Obviously not real code but ;

At the end of all the checks ...
Forum: Forms 10-08-2019, 06:07 AM
Replies: 49
Views: 517
Posted By Minty
Re: Clearing Multiple Forms using Add New Record button.

Correct. The subform should be a form with the information you wanted on it, placed on the relevant tab page.
Forum: Forms 10-08-2019, 06:04 AM
Replies: 49
Views: 517
Posted By Minty
Re: Clearing Multiple Forms using Add New Record button.

You need to set the subforms default view to Single Form or Continuous form within the form design, exactly the same as a normal form.

Did you drop the table or the form onto the tab page?

If...
Forum: Queries 10-04-2019, 05:30 AM
Replies: 6
Views: 100
Posted By Minty
Re: Trying to Count IIF a date formated as "dddd".

I'm assuming [Day] is your calculated dayname field? If so you can't refer to it in the same query in another calculation. Use the weekday() function instead;

Monday:...
Forum: Modules & VBA 10-04-2019, 03:40 AM
Replies: 4
Views: 83
Posted By Minty
Re: Dlookup returns blank :(

Are your dates UK style by any chance?

Try
=DLookUp("[Patient ID]","[Diary]","[AppointmentDate]=#" & Format(Me.[Text13],"yyyy/mm/dd") & "# and [SlotNumber]=1")

Worth a read here...
Forum: Modules & VBA 10-04-2019, 03:37 AM
Replies: 7
Views: 105
Posted By Minty
Re: Filtering records retrieved from SQL server

And to answer your second question, assuming you are on the form you are running this from;

Dim conn As ADODB.Connection
Dim strArea As String
Dim sExec as String

Set conn = New...
Forum: Modules & VBA 10-04-2019, 03:29 AM
Replies: 7
Views: 105
Posted By Minty
Re: Filtering records retrieved from SQL server

Actually, in addition to Galaxioms statement, I'm unsure why you would be using a transaction for a simple select?


USE [IPTTracking]
GO
/****** Object: StoredProcedure...
Forum: Modules & VBA 10-04-2019, 03:10 AM
Replies: 7
Views: 105
Posted By Minty
Re: Filtering records retrieved from SQL server

You need to concatenate your variable into the Exec statement ;

rs.Open "EXEC issues.sp_Select_tabled '" & strArea & "'", conn

If you built the exec string into a variable you would have seen...
Forum: Forms 10-02-2019, 08:01 AM
Replies: 49
Views: 517
Posted By Minty
Re: Clearing Multiple Forms using Add New Record button.

You wouldn't default it per se, you would simply look it up from the related record. Once you have it stored once in the correct place you can always "find" it through table relationships.

That...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 06:11 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