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: Modules & VBA Today, 12:05 PM
Replies: 1
Views: 27
Posted By theDBguy
Re: How to create a folder with query conditions

Hi. Try doing a Debug.Print ToPath to see the name of the folder you're trying to create. Make sure it doesn't have any invalid/illegal characters.
Forum: General Today, 08:02 AM
Replies: 40
Views: 192
Posted By theDBguy
Re: count weekdays into friday

I see. Thanks for the clarification. Good luck!
Forum: Modules & VBA Today, 08:00 AM
Replies: 3
Views: 48
Posted By theDBguy
Re: Syntax Error 3320

Hi John. Try:.DefaultValue = """SEUSQL50\INST01,1437"""


Edit: Oops, too slow...
Forum: Modules & VBA Yesterday, 06:02 PM
Replies: 39
Views: 348
Posted By theDBguy
Re: Populate the name of the active control on focus in a form.

Hi. Try the attached modified version. It's just one of many ways to do the same thing.
Forum: Modules & VBA Yesterday, 11:18 AM
Replies: 6
Views: 95
Posted By theDBguy
Re: I cannot running a function with macro

Embedded macros (with safe actions) should run even for non-trusted files. I think...
Forum: General Yesterday, 11:07 AM
Replies: 40
Views: 192
Posted By theDBguy
Re: count weekdays into friday

Hi. Earlier, in your first post, you had this idea:

So, if you're running this query everyday, I would probably just try something like:
WHERE tbl.ShipDate=Date()-[Enter Number of Days]So, if...
Forum: SQL Server 09-17-2019, 10:04 AM
Replies: 18
Views: 202
Posted By theDBguy
Re: Set Default Values

Hi. I was able to use the following in SSMS:
alter table test add constraint notes_def default 'client:'+char(13)+char(10)+'server:' for notes;Edit: Oops, too slow...
Forum: Modules & VBA 09-16-2019, 07:32 AM
Replies: 9
Views: 127
Posted By theDBguy
Re: Late Binding Question

Hi. Here's an article with some examples (https://www.devhut.net/2016/11/08/vba-early-binding-and-late-binding/). Hope it helps...
Forum: Tables 09-16-2019, 07:26 AM
Replies: 13
Views: 175
Posted By theDBguy
Re: Calculated Field?

Hi Chris. Glad to hear you have a solution now. Calculated fields are very limited, as CJ mentioned earlier, so using a calculated field to do what you wanted was probably not possible anyway. Good...
Forum: Modules & VBA 09-16-2019, 05:36 AM
Replies: 9
Views: 127
Posted By theDBguy
Re: Late Binding Question

Hi. Then, you just need to late bind the objects you automate, eg. Excel and PP.
Forum: Tables 09-14-2019, 07:25 PM
Replies: 9
Views: 143
Posted By theDBguy
Re: table problem, field shows #deleted

Hi. If you did a C&R and there were errors, you should see an error log created by the process. It might tell you what is the problem.
Forum: Queries 09-14-2019, 05:54 AM
Replies: 15
Views: 274
Posted By theDBguy
Re: How to filter a Union query?

Hi. I may not be remembering it correctly, but the exception to that rule is you canít sort each individual query. I think youíll have to sort the entire union query.
Forum: Forms 09-13-2019, 02:09 PM
Replies: 10
Views: 161
Posted By theDBguy
Re: Enter date after use of tab

Hi Nicole. How exactly did you enter the code and what exactly happened? Did you go to the AfterUpdate event of the control and then selected [Event Procedure] from the dropdown and then clicked the...
Forum: Forms 09-13-2019, 10:37 AM
Replies: 10
Views: 161
Posted By theDBguy
Re: Enter date after use of tab

Hi Nicole. For example, in the AfterUpdate event of the Targe_$ control, you could try something like:
Me.TargetDate=Date()Hope it helps...
Forum: General 09-12-2019, 07:04 AM
Replies: 9
Views: 160
Posted By theDBguy
Re: User Interface Form - Report

Hi. Thanks for the explanation. And where do you store these clauses? If in a table, is your report bound to this table?
Forum: Queries 09-12-2019, 04:31 AM
Replies: 7
Views: 135
Posted By theDBguy
Re: Adding Count to a select query

Hi. Glad to hear Arnelís suggestion worked better. Good luck with your project.
Forum: General 09-12-2019, 04:01 AM
Replies: 9
Views: 160
Posted By theDBguy
Re: User Interface Form - Report

Hi Mark. Could you please define what a “clause” is? Thanks.
Forum: Queries 09-11-2019, 07:31 PM
Replies: 7
Views: 135
Posted By theDBguy
Re: Adding Count to a select query

Right. A subquery solution might look something like:
SELECT T1.FieldName, (SELECT Count(*) FROM TableName WHERE SomeField=T1.FieldName) AS RowNum
FROM TableName T1
Forum: Queries 09-11-2019, 06:10 PM
Replies: 7
Views: 135
Posted By theDBguy
Re: Adding Count to a select query

Hi. Have you tried using DCount()? However, it might run a bit slow.
Forum: Forms 09-11-2019, 12:22 PM
Replies: 8
Views: 116
Posted By theDBguy
Re: ODBC Error 3621 closing bound form

Hi. It all depends on the user experience you want to achieve. For example, in the BeforeUpdate event of the form, you can check for any missing required fields and ask the user to provide them or...
Forum: Modules & VBA 09-11-2019, 09:19 AM
Replies: 10
Views: 68,484
Posted By theDBguy
Re: Round() - Can I round DOWN?

Hi. Welcome to AWF! But that would make too much sense. :)
Forum: Forms 09-11-2019, 07:29 AM
Replies: 3
Views: 55
Posted By theDBguy
Re: sub form tab control repeated each tab/page

Hi Liz. Yes, it depends on how you added the subform to the form. To attach a subform to a specific tab page, you'll have to select the tab page first before dropping the subform on to it.
Forum: Tables 09-11-2019, 06:51 AM
Replies: 17
Views: 269
Posted By theDBguy
Re: Identify and rename MS Access latest table - SQL

Also, just another option for renaming objects, not just tables:
DoCmd.Rename NewName, acObjectType, OldName
Forum: Reports 09-10-2019, 02:55 PM
Replies: 7
Views: 149
Posted By theDBguy
Re: "Auto Height" vs. "Can Grow" / "Can Shrink"

Hi Otto. They could be doing the same thing, or at the very least, they are having the same effect. But the way I understand it, AutoHeight depends on the sizes of the controls in the section, and...
Forum: Introduce Yourself 09-10-2019, 06:43 AM
Replies: 7
Views: 114
Posted By theDBguy
Re: Hello!

Hi. Welcome to AWF!
Showing results 1 to 25 of 500

 
Forum Jump



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