Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.38 seconds.
Search: Posts Made By: boblarson
Forum: The Watercooler 03-09-2014, 11:02 AM
Replies: 19
Views: 2,894
Posted By boblarson
This time goodbye is for good

I just wanted to say goodbye to everyone here and some may miss this because it is in the Watercooler but I think it is best here. I am now on a different journey. I am deeply involved in SQL...
Forum: General 12-22-2013, 05:22 PM
Replies: 2
Views: 840
Posted By boblarson
Re: Access ODBC Drivers - 32 bit and 64 bit

I have been running 32 bit Office on Windows 7 64 bit for many years now. 64 bit drivers can, and are, on my machine. The problem you may be facing is trying to use the wrong drivers from the wrong...
Forum: Forms 12-16-2013, 10:12 AM
Replies: 9
Views: 1,031
Posted By boblarson
Re: Exclude object from Read Only?

You can do it in several ways. One I like to do is to set each control's Enabled property to NO in design view and then enable based on role. Put in the TAG property of the control the levels you...
Forum: Modules & VBA 12-15-2013, 11:27 PM
Replies: 8
[SOLVED] DSUM syntax
Views: 2,136
Posted By boblarson
Re: DSUM syntax

Actually, I goofed. It should be this:


DoCmd.RunSQL "Update TEST_TNS Set Total_Net_Sales = Nz([Total_Net_Sales],0) + " & DSum("Total_Net_Sales","TEST_TNS","[Division] =" & Chr(34) & "Common" &...
Forum: Modules & VBA 12-15-2013, 11:00 PM
Replies: 2
Views: 821
Posted By boblarson
Re: Access 2010 BrowseTo shows only ONE record

You need to use this method instead:

http://www.baldyweb.com/Bookmark.htm

The way you are currently doing it is filtering for a specific record so that is the one that is returned.
Forum: Modules & VBA 12-15-2013, 10:54 PM
Replies: 8
[SOLVED] DSUM syntax
Views: 2,136
Posted By boblarson
Re: DSUM syntax

DoCmd.RunSQL "Update TEST_TNS Set Total_Net_Sales = Nz([Total_Net_Sales],0) + DSum('Total_Net_Sales','TEST_TNS','[Division] ='" & Chr(34) & "Common" & Chr(34) & ") " & _
" Where...
Forum: General 11-25-2013, 02:28 PM
Replies: 1
Views: 1,220
Posted By boblarson
Re: MsAccess 2010 throught CITRIX

You need to have each user have their own copy of the frontend. We solved that by making the published app icon actually be a command batch file. It then makes a copy of the frontend to the server...
Forum: Modules & VBA 11-25-2013, 02:20 PM
Replies: 5
Views: 10,535
Posted By boblarson
Re: Access Memo Field copy with VBA to Excel truncates at 255 characters

I have found that in some instances I have to export using VBA and do it record by record instead of CopyFromRecordset.
Forum: Queries 11-25-2013, 02:00 PM
Replies: 11
Views: 2,124
Posted By boblarson
Re: Update SQL tables

And are you using functions within the queries?
Forum: Queries 11-25-2013, 01:59 PM
Replies: 6
Views: 560
Posted By boblarson
Re: ADO any opinions?

ADO has its place and DAO has its place. ADO is great when you are using a SQL Server as the backend. DAO works quite well in most instances for internal Access operations or between Office apps. ...
Forum: Queries 11-25-2013, 01:53 PM
Replies: 8
Views: 853
Posted By boblarson
Re: File already in use. Not really!

I think it is what you are using for the connection. If you are connecting to the database where your code is located, the code should be:

Set cnADO = CurrentProject.Connection
Forum: Queries 08-20-2013, 03:43 PM
Replies: 3
Views: 1,451
Posted By boblarson
Re: Count if function in query help

MyCounts:Sum(IIf([amount] >=10, 1, 0)) + Sum(IIf([amount] = 100, 1, 0))

You don't use quotes for the >=10 or = 100.

And won't the count of >=10 AND adding count of =100 double count?
Forum: Modules & VBA 08-20-2013, 03:40 PM
Replies: 7
Views: 900
Posted By boblarson
Re: Varibale Problem in VBA

I, personally, use the Chr(34) method because I find that it helps me keep straight what quotes are needed for the strings and which quotes are needed to be quotes. For me it is an easier thing...
Forum: Modules & VBA 08-20-2013, 03:31 PM
Replies: 7
Views: 900
Posted By boblarson
Re: Varibale Problem in VBA

Or if you don't want to type so many quotes:

StrWhere = "Job_ID = " & Chr(34) & Me.cboJobID & Chr(34) & " AND AMonth = " & Chr(34) & Me.cboMonths & Chr(34)

And Mihail - you missed the AND.
Forum: General 08-20-2013, 01:26 PM
Replies: 9
Views: 1,524
Posted By boblarson
Re: backend path syntax in intranet

Get rid of the part below in red.

Set rs = db.OpenRecordset("Invoiceyr", dbOpenTable)

So like this

Set rs = db.OpenRecordset("Invoiceyr")


From the help file:
Forum: Forms 08-19-2013, 02:34 PM
Replies: 4
Views: 545
Posted By boblarson
Re: I quick question

You shouldn't be putting in the address more than one time ever in the database for that customer unless they move. You put it in once and then in the other tables you only select the customer which...
Forum: Queries 08-19-2013, 02:31 PM
Replies: 2
Views: 622
Posted By boblarson
Re: Error Handling in a query that was run from a macro

1. Use an input form for inputs. Don't use parameter prompts. If you just had a combo where they select the month, etc. it won't be incorrect ever.


2. What do these queries do? Are they...
Forum: Queries 08-19-2013, 02:21 PM
Replies: 2
Views: 522
Posted By boblarson
Re: Add "ALL" selection to combo box

SELECT tblAuditStaff.AuditStaffID, [tblauditstaff].[auditstafflastname] & ", " & [tblauditstaff].[auditstafffirstname] AS [Auditor Name], tblAuditStaff.AuditStafffirstName,...
Forum: Modules & VBA 08-19-2013, 01:59 PM
Replies: 7
Views: 1,679
Posted By boblarson
Re: str variable in dlookup criteria

This should have also worked:

Me.Text64 = DLookup("[ModuleName]", "tblModule", "[DatabaseName] = " & Chr(34) & strDBName & Chr(34))
Forum: Forms 08-19-2013, 01:48 PM
Replies: 9
Views: 3,891
Posted By boblarson
Re: Wrong focus when switching among pages of TAB control

The click event is essentially useless in a tab control. You need to use the ON CHANGE event instead and then evaluate which tab was selected.

So, like
Private Sub TabControlNameHere_Change()
...
Forum: Macros 08-19-2013, 01:43 PM
Replies: 1
Views: 845
Posted By boblarson
Re: transferspreadsheet File Name

You can do it with VBA but not really with macros (if I remember correctly).
Forum: Forms 08-19-2013, 01:41 PM
Replies: 4
Views: 2,677
Posted By boblarson
Re: Runtime Shortcut Menu

You have to build your own custom menus. You can select existing menu items but they need to be added as custom items on your own menus.

Do a search for the Access Freak's website. I can't seem...
Forum: General 08-19-2013, 01:36 PM
Replies: 3
Views: 1,178
Posted By boblarson
Re: Installation Packages

Windows 7 (or 8) won't let you execute an Access database file from the program files directory. You need to put it in another folder on the C drive (or elsewhere).
Forum: General 08-19-2013, 01:34 PM
Replies: 5
Views: 1,579
Posted By boblarson
Re: Questionable "Object Variable or With Block variable not set" Error

If you use the recordset object the visible records in the form are affected immediately instead of if something is found. You can navigate back and forth within a clone without affecting the...
Forum: General 08-16-2013, 10:26 AM
Replies: 5
Views: 1,579
Posted By boblarson
Re: Questionable "Object Variable or With Block variable not set" Error

Also, you should probably use a RecordsetClone to search and set the value instead of the actual recordset.
Showing results 1 to 25 of 500

 
Forum Jump



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