Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.38 seconds.
Search: Posts Made By: theDBguy
Forum: Forms Today, 04:50 AM
Replies: 1
Views: 2
Posted By theDBguy
Re: Open form from combo box

Hi. Give this a try.
DoCmd.OpenForm "[Contact Details]", , ,"ID=" & Me.Combo288
Forum: Tables Yesterday, 09:17 PM
Replies: 4
Views: 63
Posted By theDBguy
Re: table relationships issues

Hi. Welcome to AWF! It might be easier to give you design guidance if we could actually see your database. Are you able to post a sample copy with test data?
Forum: Macros Yesterday, 07:05 PM
Replies: 1
Views: 37
Posted By theDBguy
Re: [Macro]How to print the query name in a Macro into a table

Hi. Welcome to AWF! Not sure if there's a built-in function or feature for that. You may have to resort to building your own or tweak the other documenter samples available from others.
Forum: Macros Yesterday, 05:33 PM
Replies: 4
Views: 87
Posted By theDBguy
Re: Write conflict: I want to always Drop Changes

Hi. I'm not sure you'll find a setting for that (if it exists, I don't know where it is). However, my motto is usually to try and avoid a problem rather than react to it. So, maybe we can get to the...
Forum: Modules & VBA Yesterday, 05:30 PM
Replies: 12
Views: 125
Posted By theDBguy
Re: Output Open Form to PDF

Hi. Before you give up, see if there's anything in here (https://thesmileycoder.com/crash-reporter/) you could use (I'm referring to the screen capture part). Good luck!
Forum: Queries Yesterday, 05:26 PM
Replies: 18
Views: 269
Posted By theDBguy
Re: Appending an auto-increment date to a Query

Hi. Thanks for the additional information. I have one more question. Let's say you have 10 teachers but you only wanted to schedule 5 days for now. That means teachers 1 to 5 will be added to the...
Forum: Modules & VBA Yesterday, 05:21 PM
Replies: 10
Views: 88
Posted By theDBguy
Re: Access VBA DAO records need to know ID field

Hi Paul. Here's all I know about @@IDENTITY (https://docs.microsoft.com/en-us/sql/t-sql/functions/identity-transact-sql?view=sql-server-ver15) If you have another method that works, there's no need...
Forum: Forms Yesterday, 05:17 PM
Replies: 14
Views: 106
Posted By theDBguy
Re: Conditional visibility based on input

Hi. Check out the attached. This is just one approach out of many. There are probably better ways to do it, but it's just something I did with the little time I had to work with. I'm sure we can do...
Forum: General Yesterday, 03:53 PM
Replies: 6
Views: 86
Posted By theDBguy
Re: Set Recordset = Nothing

Hi. What does your own testing tells you. I try to close/destroy any objects I created, just to be safe; but like others have said, Access is supposed to do it for you anyway. Recordsets are...
Forum: Queries Yesterday, 03:02 PM
Replies: 12
Views: 102
Posted By theDBguy
Re: Exact age

Hi. Since you already have a working solution from Pat, I guess we don't have to pursue this anymore. However, saying "it didn't work" wouldn't be enough information for us to help you troubleshoot...
Forum: Queries Yesterday, 02:16 PM
Replies: 12
Views: 102
Posted By theDBguy
Re: Exact age

Hi. It looks like you wrote DateDiff instead of Diff2Dates.
Forum: Queries Yesterday, 02:07 PM
Replies: 12
Views: 102
Posted By theDBguy
Re: Exact age

Yes, you should be able to. What have you tried? Can you show us?
Forum: Modules & VBA Yesterday, 02:01 PM
Replies: 10
Views: 88
Posted By theDBguy
Re: Access VBA DAO records need to know ID field

Hi. Pardon me for jumping in. In either case, I prefer to use the @@IDENTITY function.
Forum: Forms Yesterday, 01:53 PM
Replies: 19
Views: 207
Posted By theDBguy
Re: Time Stamp after clicking a Command Button

Hi. Glad to hear you got it to work. Good luck with your project.
Forum: Queries Yesterday, 01:52 PM
Replies: 12
Views: 102
Posted By theDBguy
Re: Exact age

Hi. You may have missed it. I added a link in my earlier post.
Forum: General Yesterday, 01:49 PM
Replies: 7
Views: 94
Posted By theDBguy
Re: Calculate the age

Hi. I just posted a link to a similar question. Maybe you could also give this a try (http://www.accessmvp.com/DJSteele/Diff2Dates.html).
Forum: Queries Yesterday, 01:36 PM
Replies: 12
Views: 102
Posted By theDBguy
Re: Exact age

Hi. You'll probably need a custom function for that. You could try this one (http://www.accessmvp.com/DJSteele/Diff2Dates.html).
Forum: Forms Yesterday, 01:31 PM
Replies: 7
Views: 74
Posted By theDBguy
Re: copy value from form to subform

Hi. Do you know which one is causing the error? If not, try them out one at a time. Maybe it has something to do with the data.
Forum: Forms Yesterday, 12:09 PM
Replies: 19
Views: 207
Posted By theDBguy
Re: Time Stamp after clicking a Command Button

You're probably using the wrong event. You'll have to recalc after the data is changed in the table. What's wrong with binding the form and the textbox to the table. You wouldn't have spent this much...
Forum: Forms Yesterday, 11:43 AM
Replies: 14
Views: 106
Posted By theDBguy
Re: Conditional visibility based on input

Okay, thanks. Give me some time to go through this. I'll try to get something back to you tomorrow, unless somebody else beats me to it.
Forum: Forms Yesterday, 10:49 AM
Replies: 8
Views: 1,448
Posted By theDBguy
Re: Sending SMS to phones.

This happened to me the other day too. I'm trying to be more careful now.
Forum: Forms Yesterday, 10:35 AM
Replies: 14
Views: 106
Posted By theDBguy
Re: Conditional visibility based on input

How about this? Can you post a copy of your db with test data, so can help you design it?
Forum: Forms Yesterday, 10:18 AM
Replies: 14
Views: 106
Posted By theDBguy
Re: Conditional visibility based on input

Hi. Your form design tells me your table design may not be optimized for a database system. However, if that's what your form looks like, then it's easy to hide the filled in boxes. Unfortunately...
Forum: Forms Yesterday, 09:58 AM
Replies: 14
Views: 106
Posted By theDBguy
Re: Conditional visibility based on input

Okay. Let me ask you another way. What would letting the users view all the data except the names help them do? If none, then it's easy enough to only show new records and hide away all previous ones.
Forum: Forms Yesterday, 09:43 AM
Replies: 14
Views: 106
Posted By theDBguy
Re: Conditional visibility based on input

Hi. If you have a way to identify who is currently viewing the data, then a better approach is to filter the form, so that all they can see are their own records. Are you able to determine who is...
Showing results 1 to 25 of 500

 
Forum Jump



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