Go Back   Access World Forums > Search Forums

 
Showing results 1 to 13 of 13
Search took 0.03 seconds.
Search: Posts Made By: Beetle
Forum: Debates 06-18-2018, 12:00 PM
Replies: 38
Views: 17,199
Posted By MarkK
Dude, don't get your rotini in a knot! I know...

Dude, don't get your rotini in a knot! I know there are some TRUE Pastafarians...
Forum: Modules & VBA 05-23-2018, 05:07 PM
Replies: 28
Views: 4,601
Posted By isladogs
Re: Obtain current geolocation data using VBA

A further update:
2 days ago, I started getting 'Allow Blocked Content' messages when the HTML file was opened in IE. This prevented the code working ... AGAIN!

After wasting a lot of time on...
Forum: Queries 04-12-2018, 11:09 PM
Replies: 10
Views: 443
Posted By Galaxiom
Re: Auto Fill of a table values

Just use a subform recordsouce query with a similar structure. The main form values were just for the particular need in that thread. Enting data to the subform records will work just the same.
Forum: Tables 02-11-2017, 03:25 PM
Replies: 17
Views: 7,650
Posted By MarkK
Nice code beetle. I thought maybe you would find...

Nice code beetle. I thought maybe you would find some of these alternatives interesting...
Const SQL_INSERT As String = _
"INSERT INTO Table2 ( Customer, Product ) " & _
...
Forum: The Watercooler 05-20-2014, 05:09 AM
Replies: 5
Views: 956
Posted By AnthonyGerrard
Re: Abu Hamza - Fair Trial or Scapegoat

Do you mean - was it even handed?
Forum: Queries 05-13-2013, 05:33 PM
Replies: 15
Views: 9,217
Posted By Galaxiom
Re: "Fat Fingering" Query

Found another Damerau-Levenshtein function. This one is more sophisticated because it can weight the scores on different types of mismatches.
...
Forum: General 05-01-2013, 01:57 PM
Replies: 12
Views: 6,609
Posted By AccessJunkie
Re: Access 2013 Template for Sharepoint

Hi Alexander,

Good question.
Some background first needs to be explained.

Access 2010 introduced the concept of creating a web database that could be published to a SharePoint Server running...
Forum: Modules & VBA 02-26-2013, 09:37 PM
Replies: 4
Views: 605
Posted By Galaxiom
Re: A 2010 / SQL / Select

Not quite.

It is true for CurrentDb.Execute because the database engine does not have scope of Access objects such as forms.

However if the SQL is run using DoCmd.RunSQL it can include direct...
Forum: Modules & VBA 08-24-2012, 11:50 AM
Replies: 11
Views: 1,172
Posted By vbaInet
Re: Single String to Multiple String on LineBreak

I would have expected something more simple:

="**" & Replace([MemoField], Chr(13), Chr(13) & Chr(10) & "**")
... but we still need to know the Default View and how many lines on average you will...
Forum: The Watercooler 07-25-2012, 05:45 PM
Replies: 192
Views: 15,405
Posted By Galaxiom
Re: My Country, Your country

Sharia = No Beer

No Beer = No Way
Forum: The Watercooler 07-03-2012, 08:49 PM
Replies: 6,024
Views: 552,289
Posted By John Big Booty
Re: Are you an atheist?

There is no need to assume anything about beer. I sleep soundly every night, comforted by the knowledge that a beer volcano and a stripper factory await me in the afterlife.
Forum: Forms 04-26-2012, 12:13 PM
Replies: 11
Views: 2,644
Posted By missinglinq
Re: Help with Checkboxes and Color Highlights

Didn't mean to step on Beetle's toes! Started answering this question then my 'Otto' had to go outside to commune with nature and I didn't check before sending my reply!

I think you have to use...
Forum: Modules & VBA 03-26-2012, 03:54 PM
Replies: 2
Views: 1,265
Posted By Galaxiom
Re: Need Data Types!!

The loop in Sean's code is not required.
Refer directly to the field and return the Type with:

db.TableDefs(strTable).Fields(strField).Type

BTW, In a loop it is considerably more efficient...
Showing results 1 to 13 of 13

 
Forum Jump



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