Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: theDBguy
Forum: General Today, 01:14 PM
Replies: 4
Views: 44
Posted By theDBguy
Re: how to convert access database from mdb to accdb

Hi. Glad to hear you got it to work. Good luck.
Forum: General Today, 12:16 PM
Replies: 4
Views: 44
Posted By theDBguy
Forum: Queries Today, 12:15 PM
Replies: 11
Views: 121
Posted By theDBguy
Re: Using DateDiff on Multiple Records

Hi. Congratulation! Glad to hear you got it sorted out. Good luck with your project.
Forum: Modules & VBA Today, 12:14 PM
Replies: 16
Views: 131
Posted By theDBguy
Re: Access Form Convert to PDF VBA Code not working

Hi. Please post the path. Also, please repost the complete code showing where you put the Debug.Print line.
Forum: Modules & VBA Today, 12:09 PM
Replies: 16
Views: 131
Posted By theDBguy
Re: Access Form Convert to PDF VBA Code not working

Yes, put it within the same code as mentioned. If you don't see anything, then it means there is no value, which could mean you're getting an invalid filepath.
Forum: Modules & VBA Today, 12:08 PM
Replies: 10
Views: 89
Posted By theDBguy
Re: strSQL

As another option, you could try using this little utility (http://www.utteraccess.com/forum/index.php?showtopic=1992076) to search your database.
Forum: Modules & VBA Today, 12:07 PM
Replies: 10
Views: 89
Posted By theDBguy
Re: strSQL

Okay, but what is generating the error? You could start there. For example, if your clicking a button on a form, then check the code and trace its steps.
Forum: Modules & VBA Today, 12:06 PM
Replies: 11
Views: 96
Posted By theDBguy
Re: combo box to fill form

You can use the WhereCondition argument of the OpenReport method. For example:
DoCmd.OpenReport "ReportName', acViewPreview, , "ID=" & Me.ID
Forum: Queries Today, 12:04 PM
Replies: 6
Views: 45
Posted By theDBguy
Re: Merge tables with different columns

Sounds good. Let us know how it goes.
Forum: Forms Today, 11:59 AM
Replies: 4
Views: 50
Posted By theDBguy
Re: search bar for form

Hi. You're welcome. Good luck!
Forum: Queries Today, 11:56 AM
Replies: 6
Views: 45
Posted By theDBguy
Re: Merge tables with different columns

I still think the UNION query idea will work, but I can't say for sure without seeing what you're dealing with. To use a UNION query though, you'll need to have the same columns on the queries or...
Forum: Modules & VBA Today, 11:51 AM
Replies: 10
Views: 89
Posted By theDBguy
Re: strSQL

Hi. Since I can't see your computer screen and I don't know what you're trying to do, I don't understand your problem. If you're getting an error message, can you post the error message? It might...
Forum: Modules & VBA Today, 11:39 AM
Replies: 2
Views: 35
Posted By theDBguy
Re: Dynamically change label of a field

Hi. One way is to "tag" each label to change and loop through the controls. For example:
Dim ctl As Access.Control
For Each ctl In Me.SubformControlName.Form
If ctl.Tag = "ChangeLabel"
...
Forum: Modules & VBA Today, 11:33 AM
Replies: 10
Views: 89
Posted By theDBguy
Re: strSQL

Where are you looking? Are we talking about an Access database or SQL Server? How did you know to look for this particular SQL statement?
Forum: Modules & VBA Today, 11:31 AM
Replies: 16
Views: 131
Posted By theDBguy
Re: Access Form Convert to PDF VBA Code not working

Hi. Do a Debug.Print filePath and check what it says when you get an error. Folder paths cannot have invalid characters.
Forum: Queries Today, 11:26 AM
Replies: 6
Views: 45
Posted By theDBguy
Re: Merge tables with different columns

Hi. You should be able to use a UNION query like using a FULL OUTER JOIN in SQL. However, you might have less problems if you simply combine the two tables into one, so you won't have to maintain the...
Forum: Modules & VBA Today, 11:04 AM
Replies: 11
Views: 96
Posted By theDBguy
Re: combo box to fill form

So, putting it back together one piece at a time didn't give you an idea what made it stop working again?
Forum: Modules & VBA Today, 10:52 AM
Replies: 11
Views: 96
Posted By theDBguy
Re: combo box to fill form

When you created the test db, you must have taken out a few things. Try putting them back in one at a time until you find which one is causing the problem and then let us know what it is, so we can...
Forum: Modules & VBA Today, 10:51 AM
Replies: 10
Views: 89
Posted By theDBguy
Re: strSQL

Huh? Find what exactly?
Forum: Introduce Yourself Today, 10:35 AM
Replies: 1
Hi
Views: 29
Posted By theDBguy
Re: Hi

Hi. Welcome to AWF!
Forum: Forms Today, 10:34 AM
Replies: 4
Views: 50
Posted By theDBguy
Re: search bar for form

Hi. I think the easiest way is the one you're already using in your other thread (https://www.access-programmers.co.uk/forums/showthread.php?t=306511).
Forum: Modules & VBA Today, 10:32 AM
Replies: 11
Views: 96
Posted By theDBguy
Re: combo box to fill form

Hi. Thanks! I'm not getting any errors with your form. Can you provide the steps to duplicate the problem?
Forum: Queries Today, 09:58 AM
Replies: 9
Views: 78
Posted By theDBguy
Re: IIF statement to count multiple records instances in a query

Hi. It might be easier to understand what you mean/want if you could post a sample set of data for us to play with.
Forum: Modules & VBA Today, 09:53 AM
Replies: 11
Views: 96
Posted By theDBguy
Re: combo box to fill form

Hi. I don't see anything wrong with that code other than you're not clearing the variable at the end. Since that code is in the AfterUpdate event of the combobox, and if you're getting an error about...
Forum: Queries Today, 09:34 AM
Replies: 9
Views: 78
Posted By theDBguy
Re: IIF statement to count multiple records instances in a query

Hi. Thanks for posting the query SQL. What happens if you change the criteria to something like this?
...WHERE ((([Tardy CURRENT TOTAL Query_Crosstab].[Total Of Date])>=7));
Showing results 1 to 25 of 500

 
Forum Jump



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