Go Back   Access World Forums > Search Forums

 
Showing results 1 to 18 of 18
Search took 0.01 seconds.
Search: Posts Made By: rpeare
Forum: Modules & VBA 06-13-2019, 08:50 AM
Replies: 2
Views: 107
Posted By rpeare
Connecting to Google Sheets

I am trying to connect to a google sheet document. My intention is to copy the information to a spreadsheet, then import it into MS Access, but I want all the code to be done from a MS Access user...
Forum: Modules & VBA 06-10-2019, 11:23 AM
Replies: 12
Views: 245
Posted By rpeare
Re: Fastest Way For VBA To Delete 4 Local Tables

yeah if you're only dropping four tables, and it's the same four tables each time I'd just execute four drop table statements. Adding items to an array is unnecessary.
Forum: Queries 06-10-2019, 11:22 AM
Replies: 9
Views: 1,020
Posted By rpeare
Re: Expressions to extract portion of a text string in Access

yes, I botched the second instr statement
Forum: Modules & VBA 06-10-2019, 10:30 AM
Replies: 12
Views: 245
Posted By rpeare
Re: Fastest Way For VBA To Delete 4 Local Tables

Dim rst
Dim sSQL As String


sSQL = "SELECT MSysObjects.Name AS table_name, MSysObjects.Type "
sSQL = sSQL & "FROM MSysObjects "
sSQL = sSQL & " WHERE (((Left([Name],1))<>'~') AND...
Forum: Queries 06-10-2019, 09:53 AM
Replies: 9
Views: 1,020
Posted By rpeare
Re: Expressions to extract portion of a text string in Access

iif(instr([Fieldname], <SearchString>), mid([Fieldname], instr([Fieldname]), len([Fieldname]), null)

would return the search string if exists in the field, otherwise return a null value
Forum: Queries 06-04-2019, 08:42 AM
Replies: 6
Views: 136
Posted By rpeare
Re: Find Greater Alphanumeric Character

I think there's a fairly easy solve here.

If you break your route number into the numeric portion and the alpha portion in your query, then sort on those two fields you should be golden.

i.e.
...
Forum: Modules & VBA 06-04-2019, 08:34 AM
Replies: 18
Views: 502
Posted By rpeare
Forum: Modules & VBA 06-01-2019, 01:48 PM
Replies: 18
Views: 502
Posted By rpeare
Re: Unwanted CR LF character when using Chr(26)

You may be right about it being an end of file character gemma, even so filesystemobject would still work you'd just use 'writeline' for everything except the last line and 'write' for the last line
Forum: Modules & VBA 06-01-2019, 03:24 AM
Replies: 18
Views: 502
Posted By rpeare
Re: Unwanted CR LF character when using Chr(26)

Have you tried using filesystemobject commands instead?

with filesystemobject you should be able to define your own end of line character

Sub main()

Dim f
Dim fs

Set fs =...
Forum: Queries 05-31-2019, 10:07 AM
Replies: 9
Views: 205
Posted By rpeare
Re: Unruly query: multiple iterations of same table, poor performance

Are you allowed to create your own custom functions? you could create one to lookup the value you want rather than relinking the same table multiple times. You may also be able to solve this by...
Forum: Macros 05-31-2019, 07:08 AM
Replies: 2
Views: 449
Posted By rpeare
Re: Compile Error 64-bit system

if you are using a split database and distributing a front end specifically for this person I would check to see if the api call references the same driver. I've run into instances where a specific...
Forum: Queries 05-31-2019, 06:35 AM
Replies: 11
[SOLVED] Aliases in SQL
Views: 164
Posted By rpeare
Re: Aliases in SQL

Also, you don't use AS when you alias your table, only your field names

Select TESTFIELD as OMGTEST
from qryIm_Temp_SystemVersionsNMtblSystemVersions3 Q3

TESTFIELD is aliased to OMGTEST...
Forum: VB.NET 05-31-2019, 06:29 AM
Replies: 2
Views: 4,384
Posted By rpeare
Re: griddataview duplicate data message

Instead of displaying the message box immediately, you can store an 'errorsfound' variable (1 or 0) then at the end of your code running display the message box if the errorsfound value is non zero. ...
Forum: Modules & VBA 05-31-2019, 06:23 AM
Replies: 14
Views: 555
Posted By rpeare
Re: Loop for DoCmd.RunSQL ("INSERT INTO tbl

Dim i As Integer
i = 1

' Input 14 days Timesheet dataset

Do While i <= 14 'this will do x rotations

For i = 1 To 14

With Me
Forum: Reports 09-15-2016, 10:02 AM
Replies: 4
Views: 526
Posted By rpeare
Re: Report with sub-reports running out of memory

if you are nesting them and you are not applying filters to the subreport then you have way more than you think you do

6*24*382*736 = 70,800 possible record combinations

That still doesn't seem...
Forum: Reports 09-15-2016, 09:32 AM
Replies: 4
Views: 526
Posted By rpeare
Re: Report with sub-reports running out of memory

I've got some reports that have up to 15 or so subreports but they are short and do not take much calculation to run, if your subreports are very menory intensive (lots of calculations in both the...
Forum: Modules & VBA 09-15-2016, 09:29 AM
Replies: 15
Views: 509
Posted By rpeare
Re: Filling an excel worksheet from a recordset

You have to terminate your excel connection after the file is created otherwise you're going to encounter this problem repeatedly. If you ran this code multiple times then went to look at your task...
Forum: Modules & VBA 09-15-2016, 07:50 AM
Replies: 10
Views: 437
Posted By rpeare
Re: Very strange behaviour in collection of arrays

If all you're interested in is changing the column headers can't you just artificially create the first row of the array then add all the subsequent records from your file skipping over the first...
Showing results 1 to 18 of 18

 
Forum Jump



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