Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.08 seconds.
Search: Posts Made By: theDBguy
Forum: Queries Today, 07:27 PM
Replies: 3
Views: 45
Posted By theDBguy
Re: Append aSelect Query

Hi Dave. Can you show us what you tried? Was it something like this?
INSERT INTO TblCompletedJobsAddressed SELECT * FROM QueryName
Forum: Forms Today, 08:47 AM
Replies: 8
Views: 154
Posted By theDBguy
Re: Filtering form inside a navigation form

Hi. See if this is what you wanted. Cheers!
Forum: Queries Today, 08:40 AM
Replies: 15
Views: 136
Posted By theDBguy
Re: Help required

Okay, that's different than what you asked for initially. In this case, a Totals Query, like Gasman originally suggested, would be a better approach. For example, try the following query:
SELECT...
Forum: Queries Today, 08:29 AM
Replies: 15
Views: 136
Posted By theDBguy
Re: Help required

Hi. I don't understand, I don't see any duplicates in the query. For example, take a look at this screenshot.

...
Forum: Queries Today, 04:56 AM
Replies: 15
Views: 136
Posted By theDBguy
Re: Help required

Hi. Have you tried using the DISTINCT keyword in your SELECT query?
Forum: General Yesterday, 08:16 PM
Replies: 6
Views: 122
Posted By theDBguy
Re: Linking

Hi. As Paul said, if the FE is 2016 and the BE is 2013, then it should be fine.
Forum: General Yesterday, 11:29 AM
Replies: 14
Views: 228
Posted By theDBguy
Re: Odd New Error

Not sure what code you were using before, but this is what I use (http://www.accessmvp.com/thedbguy/codes.php?title=backup), which is similar to what Alc just posted, and I don't remember getting any...
Forum: Modules & VBA Yesterday, 11:23 AM
Replies: 9
Views: 114
Posted By theDBguy
Re: Determine if this is a New document

Hi Gale. If you're using code to process a record in like the Current Event of a form and want to exclude "new" records, then you could use the NewRecord property of the form. For example, the...
Forum: Queries Yesterday, 10:17 AM
Replies: 5
Views: 97
Posted By theDBguy
Re: Query with Three Arguments

Hi. First of all, "Type" may be a reserved word. Recommend maybe using AccountType instead. I think you want to "nest" your IIf() statements. For example:

...
Forum: Forms Yesterday, 09:53 AM
Replies: 11
Views: 222
Posted By theDBguy
Re: Have combo box on form save to table on new record subform

Hi. Glad to hear the demo is helping you a little bit. The code between the AfterUpdate and GotFocus have slight differences. If you'll notice, in the AfterUpdate event, I am using "Me" only. But in...
Forum: Modules & VBA Yesterday, 09:18 AM
Replies: 10
Views: 132
Posted By theDBguy
Re: Installing ODBC driver in code?

Hi. Are you creating this "app" using something like Inno Setup? If not, maybe you could...
Forum: Reports Yesterday, 06:29 AM
Replies: 4
Views: 88
Posted By theDBguy
Re: Report filtering by Logged in User

Hi Tiger. As Gasman said, you can use the WhereCondition argument of the OpenReport method. For example:
DoCmd.OpenReport "ReportName", , , "UserNameField='" & GetUserName() & "'"Hope that helps...
Forum: General 11-17-2019, 10:41 PM
Replies: 21
Views: 450
Posted By theDBguy
Re: remove the "Unknown Publisher" security warning

Just setting Trusted Locations should be good enough.
Forum: SQL Server 11-17-2019, 07:54 PM
Replies: 3
Views: 121
Posted By theDBguy
Re: date between

Hi. Glad to hear you got it sorted out. As long as it works. Cheers!
Forum: Queries 11-17-2019, 01:52 PM
Replies: 42
Views: 461
Posted By theDBguy
Re: User Defined Function in SQL Select

Hi. Not in front of a computer again but try binding the Textbox to txtSalePrice.
Forum: Forms 11-17-2019, 01:07 PM
Replies: 20
Views: 266
Posted By theDBguy
Re: Time picker

Hola, Dick! Buen viaje!
Forum: Visual Basic 11-17-2019, 01:04 PM
Replies: 1
Views: 99
Posted By theDBguy
Re: Summarizing calculated field in a form

Hi. Actually, it's possible to sum a calculated value, you just have to calculate it again. For example, if you had something like:
PALLETPCS: [PRODUCTPCS] * 100And doing something like this doesn't...
Forum: Tables 11-17-2019, 09:19 AM
Replies: 2
Views: 62
Posted By theDBguy
Re: Copying data

Hi. If it's not too late, I would like to discourage you from using "lookup fields" at the table level. Check out this site for reasons why (http://www.theaccessweb.com/lookupfields.htm).
Forum: General 11-17-2019, 07:46 AM
Replies: 21
Views: 450
Posted By theDBguy
Re: remove the "Unknown Publisher" security warning

So, I think it's:

2007 = 12.0
2010 = 14.0
2013 = 15.0
2016 = 16.0

There was no 13.0
Forum: General 11-16-2019, 01:28 PM
Replies: 21
Views: 450
Posted By theDBguy
Re: remove the "Unknown Publisher" security warning

Hi. Sorry, you beat me to it before I was able to add the link above. Please check my previous post again. I edited it to add a link. But just in case, here it is again...
Forum: Modules & VBA 11-16-2019, 09:33 AM
Replies: 3
Views: 96
Posted By theDBguy
Re: Importing excel data - sample database

Hi. First place to look is in the "similar threads" list down below.
Forum: Forms 11-16-2019, 06:22 AM
Replies: 12
Views: 180
Posted By theDBguy
Re: New to Navigation Forms

It's a new DoCmd method (https://docs.microsoft.com/en-us/office/vba/api/access.docmd.browseto) that came with the new Navigation Form.
Forum: Forms 11-15-2019, 07:19 PM
Replies: 20
Views: 266
Posted By theDBguy
Re: Time picker

Hi. Check these samples:

Demo1 (http://www.utteraccess.com/forum/index.php?showtopic=1454249)

Demo2 (http://www.utteraccess.com/forum/index.php?showtopic=1901319)
Forum: Forms 11-15-2019, 01:54 PM
Replies: 11
Views: 222
Posted By theDBguy
Re: Have combo box on form save to table on new record subform

Here's a quick test db... It's not perfect, but should be doable.
Forum: Forms 11-15-2019, 11:52 AM
Replies: 11
Views: 207
Posted By theDBguy
Re: Display correct value

Hi. You could try:

IIf([Duty Type]='B' OR [BobNewNear]=0,0,IIf([BobNewNear]<6,6,[BobNewNear]))Hope that helps...
Showing results 1 to 25 of 500

 
Forum Jump



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