Go Back   Access World Forums > Search Forums

 
Showing results 1 to 11 of 11
Search took 0.03 seconds.
Search: Posts Made By: theDBguy
Forum: Sample Databases 03-02-2019, 09:34 AM
Replies: 11
Views: 496
Posted By isladogs
ResizeForm Me - An Automatic Form Resizing Tutorial

See attached for a detailed article in PDF format about automatic form resizing based on the free open source code by Jamie Czernik.

Having used this code for over 15 years, I have written the...
Forum: Forms 02-27-2019, 05:06 PM
Replies: 17
Views: 223
Posted By MajP
Re: Combo Bx Start Point

@ DBGuy,
The likely reason it worked for you and not the OP was that the Format Property of the combo needs to be Set to Medium Time to match the display. Yours probably matched when you built it....
Forum: SQL Server 02-23-2019, 09:12 AM
Replies: 20
Views: 396
Posted By pbaldy
Re: How to add a SQL connection (without linked tables)?

In a test db this works:

Dim strSQL As String
Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = OpenDatabase("", False, False, "ODBC;DRIVER=SQL Server Native Client...
Forum: Tables 02-20-2019, 09:01 AM
Replies: 5
Views: 149
Posted By Micron
Re: append data from one database to another

Isn't that going to result in 4 new tables rather than one as is wanted? I'm reading that you're suggesting 4 make table queries. Maybe 1 make table query then switch it to append for the other 3?
...
Forum: Modules & VBA 02-15-2019, 07:53 PM
Replies: 20
Views: 378
Posted By MajP
Re: How to create combo a-z to sort list box?

You need to shut up. You have provided nothing to this forum. Look at your Thanks (0) versus DBGuy. You want nothing but to be spoon fed. That is not the way it works. He provided good advice. So...
Forum: General 02-01-2019, 04:09 AM
Replies: 22
Views: 265
Posted By ryetee
Re: Ribbons and getting rid of the File tab

Don't know but I'm like a dog with a bone at times!! Anyway managed to get rid of it by using
<tab idMso="TabOfficeFeedback" visible="false"/>

Now all I need to know is how I can put a custom one...
Forum: Tables 01-14-2019, 10:34 AM
Replies: 28
Views: 840
Posted By isladogs
Re: Repeated Autonumber Gremlins

Congratulations to Frothy for working out how I did this.
He said he knew as he'd also done the same dumbass method himself!!!! :eek:

The issue with repeat autonumbers came about when I created...
Forum: Modules & VBA 01-09-2019, 05:50 AM
Replies: 18
Views: 461
Posted By isladogs
Re: lookat value of two text boxes to deside value of a third

Hi DB Guy
You correctly answered the original question in post 2 - same as Pat's later answer
But the OP actually wanted something else - your second solution
Forum: Modules & VBA 12-12-2018, 05:24 PM
Replies: 3
Views: 1,109
Posted By isladogs
Re: scroll to top of a multi select listbox

Well done DBGuy. It works


Dim lngC As Long
With Me.LstClasses
' For lngC = Abs(.ColumnHeads) To (.ListCount - 1) 'top to bottom
For lngC = (.ListCount - 1) To Abs(.ColumnHeads) Step -1...
Forum: Forms 11-30-2018, 03:18 PM
Replies: 8
Views: 358
Posted By missinglinq
Re: Table acting like a Form

That be correct!

Linq ;0)>
Forum: Queries 10-29-2018, 12:39 PM
Replies: 5
Views: 196
Posted By BennyLinton
Re: Update query "Record Deleted" error

It is a linked Access BE and writing to a linked SQL Server BE
Showing results 1 to 11 of 11

 
Forum Jump



All times are GMT -8. The time now is 08:32 AM.


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