Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.76 seconds.
Search: Posts Made By: Minty
Forum: SQL Server 03-15-2019, 04:39 PM
Replies: 10
Views: 151
Posted By Minty
Re: How to install SQL Server native Client 11.0?

Sorry I'm away from the PC for the weekend. Hopefully someone else might help, if not Monday!

Sent from my SM-G955F using Tapatalk
Forum: Tables 03-15-2019, 06:09 AM
Replies: 11
Views: 185
Posted By Minty
Re: Noobieissues

You sound as if you need a Unit "header table" and then at it's simplest an event / entity table, and an event type table.

So your tblUnkits would store the top level info the unit number,...
Forum: General 03-15-2019, 02:38 AM
Replies: 11
Views: 130
Posted By Minty
Re: lookup

Assume you have created a txtbox called txtSuppName and you combo is called cmbSuppId

In the control source for txtSuppName simply put
= cmbSuppId.Column(1)

And it should all work swimmingly.
Forum: SQL Server 03-15-2019, 02:02 AM
Replies: 10
Views: 151
Posted By Minty
Re: How to install SQL Server native Client 11.0?

Try here https://www.connectionstrings.com/sql-server-native-client-11-0-odbc-driver/info-and-download/

Think that is exactly what you need.

I have actually moved every one onto Microsoft SQL...
Forum: SQL Server 03-15-2019, 01:29 AM
Replies: 10
Views: 151
Posted By Minty
Re: How to install SQL Server native Client 11.0?

I think this page has what you need https://www.microsoft.com/en-gb/download/details.aspx?id=36434
Forum: Forms 03-15-2019, 01:25 AM
Replies: 4
Views: 72
Posted By Minty
Re: New Record Saved, before I've asked to save

By default Access saves a record as soon as you move off the form or to another record.
Programming your way around this is awkward, and mostly unnecessary .

The simplest way to prevent a...
Forum: Modules & VBA 03-14-2019, 08:59 AM
Replies: 12
Views: 222
Posted By Minty
Re: Update form with barcode in Ms Access

@Cronk, depends on if the BC reader is set to send an <enter> after a successful read. That's how ours are set up.

Makes for quick data entry. :)
Forum: Queries 03-13-2019, 06:08 AM
Replies: 9
Views: 101
Posted By Minty
Re: Update Query Lock Violation

Okay - got it... It's only the last record you updated that isn't saved.
Forcing the subform to save from the main form;

Me.MySubform.Form.Dirty = False.

The dirty property is set to true if...
Forum: Forms 03-13-2019, 03:15 AM
Replies: 4
Views: 89
Posted By Minty
Re: query based cbo doesn't allow choice

Have you linked your combo box query / source to the forms record source? That can make things read only.

Without seeing your form and the underlying set up or a lot more information we are...
Forum: Forms 03-13-2019, 02:22 AM
Replies: 7
Views: 100
Posted By Minty
Re: before i try my idea

Sounds like you want a "find as you type" combobox or textbox.

Something like this https://access-programmers.co.uk/forums/showthread.php?t=273977 ?
Forum: Modules & VBA 03-12-2019, 08:40 AM
Replies: 19
Views: 750
Posted By Minty
Re: Error when using ADO to insert blob into SQL Server linked table

No problem, I wouldn't call myself a SQL expert by any stretch, but do use it daily, and the versoning has bitten me on the backside a few times.

Is this someone else's SQL Server I guess, you...
Forum: Modules & VBA 03-12-2019, 08:31 AM
Replies: 4
Views: 110
Posted By Minty
Re: Weird Adobe Export Error

Hmmm. I think I've read your tests correctly.

What if you juggle the null PO position or have nulls in all three...
Or don't have nulls anywhere....
Same issue?
Forum: Queries 03-12-2019, 07:35 AM
Replies: 16
Views: 201
Posted By Minty
Re: Trim Funtion from HELL

Len and Mid functions are you're friends here, but you'll need to be a bit creative.
Forum: Forms 03-08-2019, 04:21 AM
Replies: 10
Views: 188
Posted By Minty
Re: Opening unique documents based on Combo Box Selection

If your listbox was called lstFileList then on the build event property of the list box.

Add the code below

Dim sFullPath As String
Dim sTopPath as String

sTopPath =...
Forum: Forms 03-07-2019, 09:01 AM
Replies: 10
Views: 188
Posted By Minty
Re: Opening unique documents based on Combo Box Selection

I actually disagree with ranman about storing the whole path. I would store the top level path is a system table, so "\\MyNetworkShare\MyFileStore" would be in a table.

If you ever need to move...
Forum: Hardware Questions and Answers 03-07-2019, 01:47 AM
Replies: 21
Views: 350
Posted By Minty
Re: Hum Hum Hum!

To elaborate on Galaxioms second suggestion, if you have a multi meter, set to AC volts, measure from a bare metal part of the case (lid) to a known good earth point.

If you see a reading of more...
Forum: Modules & VBA 03-06-2019, 07:58 AM
Replies: 3
Views: 67
Posted By Minty
Re: Dlookup on form load

Each user in your table should have an access level. Assuming if they are level 1 they can access stuff then it should read something like

Dim AccessLvl as Int

AccessLvl = ...
Forum: Modules & VBA 03-06-2019, 04:15 AM
Replies: 4
Views: 100
Posted By Minty
Re: Get ID of created record overflow problem

I suspect you have used

Dim intNewID as Integer

and the value being returned is > 32,767

Use Dim intNewID as Long

To allow much bigger values to be used.
Forum: Queries 03-04-2019, 05:38 AM
Replies: 9
Views: 112
Posted By Minty
Re: Update query to Concatonate

If they are fields then surround them with square brackets.

UPDATE Tbl_Accounts SET Tbl_Accounts.Accpcode = [Account Name] & " " & [Postcode];
Forum: Forms 02-28-2019, 07:18 AM
Replies: 18
Views: 192
Posted By Minty
Re: Subform on Navigation form

Try the immediate window as Galaxiom suggested in the other thread.

If not perhaps post up a stripped down version of your DB for someone to have a look at?
Only needs the forms and minimum dummy...
Forum: Modules & VBA 02-28-2019, 03:05 AM
Replies: 7
Views: 109
Posted By Minty
Re: Apply filter by text AND Date

A good hint for these is to build the filter as a string and examine it as a debug.

Dim sFilter as String

sFilter = "(USER = '...to be allocated')AND (AllDateTU <#AllocationDate#)"
Forum: Queries 02-21-2019, 04:05 AM
Replies: 3
Views: 96
Posted By Minty
Re: Full outer join in Access

As far as I'm aware there is no such thing as a Full Outer Join in access.

I use them occasionally in SQL Server to produce exception lists when comparing multiple data tables with the same...
Forum: Modules & VBA 02-19-2019, 01:25 AM
Replies: 36
Views: 577
Posted By Minty
Re: How to Check if a database is open and close it if it is?

I have had issues with a locally generated batch file called from an access app not completing copies before trying to open, apparently it can't happen, But it does!
If you run the batch / cmd file...
Forum: Forms 02-15-2019, 08:21 AM
Replies: 5
Views: 132
Posted By Minty
Re: Query ith expression in a continuous form

That's a dreadful name for a query. Anything with weird characters }{()~# or spaces will give you problems somewhere down the line.

That query isn't in your subforms datasource, so it's not part...
Forum: Queries 02-15-2019, 01:56 AM
Replies: 7
Views: 151
Posted By Minty
Re: SQL query with input parameters (stored procedure)

USe something like ;

Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim qdfpt As QueryDef

Set db = CurrentDb
Set qdfpt =...
Showing results 1 to 25 of 500

Forum Jump

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

Microsoft Access Help
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