Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 1.35 seconds.
Search: Posts Made By: theDBguy
Forum: Queries Today, 04:37 AM
Replies: 3
Views: 27
Posted By theDBguy
Re: Crosstab and ACCDE

Can't say I have. What do you see happening? Are you getting an error message?
Forum: Introduce Yourself Today, 04:09 AM
Replies: 2
Views: 28
Posted By theDBguy
Re: Introduction

Hi. Welcome to AWF!
Forum: General Yesterday, 06:57 PM
Replies: 5
Views: 72
Posted By theDBguy
Re: Record Locked

Did you click on the Show All Macro Actions button on the Ribbon? Just curious...
Forum: Reports Yesterday, 06:53 PM
Replies: 5
Views: 75
Posted By theDBguy
Re: Davg in report group footer

Hi Victoria. Are you able to post a copy of your db with enough test data to duplicate the problem?
Forum: General Yesterday, 06:24 PM
Replies: 11
Views: 202
Posted By theDBguy
Re: What;s this line of code do?

Hi. Glad to hear we weren't steering you wrong. Cheers!
Forum: Queries Yesterday, 04:25 PM
Replies: 16
Views: 221
Posted By theDBguy
Re: Appending an auto-increment date to a Query

That was a good question. My understanding was if the number of teachers were 11 and the number of days inputted was 10, then the last teacher will not be included. So, as Pat said, this is still a...
Forum: Macros Yesterday, 04:22 PM
Replies: 11
Views: 90
Posted By theDBguy
Re: Before Change SetField Editable

No, it's not the only option, but it's the most appropriate one, I believe. You should still be able to fix your data macro, if you want to continue with that route. If it was me, I would be happy...
Forum: General Yesterday, 04:05 PM
Replies: 11
Views: 202
Posted By theDBguy
Re: What;s this line of code do?

Hi. The proper syntax, I think, needs to include the "Form" part before the control name, e.g. Me.subCDTracks.Form!ControlName But if it works, then I won't complain. If Me.CurrentView=conFormView...
Forum: Forms Yesterday, 03:55 PM
Replies: 5
Views: 95
Posted By theDBguy
Re: Time Stamp after clicking a Command Button

Good. So like I said, you can bind it to the table were you will store the date and add the date field Textbox to the form.
Forum: Forms Yesterday, 02:32 PM
Replies: 5
Views: 95
Posted By theDBguy
Re: Time Stamp after clicking a Command Button

Hi. Is the form bound? You'll have to store the date last updated in a table and you can bind your textbox to that. Just don't forget to update it when the user clicks the button.
Forum: Macros Yesterday, 02:30 PM
Replies: 11
Views: 90
Posted By theDBguy
Re: Before Change SetField Editable

No. I would use it wherever I need to use field2. For example, in a query for a form or report.
Forum: Queries Yesterday, 02:29 PM
Replies: 8
Views: 91
Posted By theDBguy
Re: Dlook for text with 2 criteria

Hi. Glad we could assist. Good luck with your project.
Forum: Queries Yesterday, 01:06 PM
Replies: 8
Views: 91
Posted By theDBguy
Re: Dlook for text with 2 criteria

Hi. What do you get with this?
DLookUp("[drug name]","[drug list]","[drug name] ='" & [Drug name] & "' AND [Chemo_drug]=0 ")
Forum: Reports Yesterday, 12:42 PM
Replies: 5
Views: 75
Posted By theDBguy
Re: Davg in report group footer

Hi Victoria. Are you saying a simple Avg() function in the group footer doesn't work?
Forum: Queries Yesterday, 11:32 AM
Replies: 6
Views: 79
Posted By theDBguy
Re: Yearly odometer reading- subtract from last years

Hi. One way to do this is to use DLookup(), but it might run slow.
Forum: General Yesterday, 10:55 AM
Replies: 12
Views: 129
Posted By theDBguy
Re: Insert calendar picker in tabular form

Hi. Congratulations! Glad to hear you got it sorted out. Cheers!
Forum: Modules & VBA Yesterday, 10:51 AM
Replies: 2
Views: 45
Posted By theDBguy
Re: Get page # from web control

Well, since you are using a browser control, I wonder if you could use JavaScript to do what you want. What are you planning to do with this information?
Forum: Forms Yesterday, 10:44 AM
Replies: 8
Views: 4,926
Posted By theDBguy
Re: Start in the first position the cursor!

Hi. You might consider starting a new thread rather than tagging on a 7-year okd discussion. You can add a link to this one for reference. In any case, I'm not sure I fully understand your question....
Forum: Modules & VBA Yesterday, 10:37 AM
Replies: 3
Views: 46
Posted By theDBguy
Re: Get folder name

Okay. There may be a better way but one approach I could suggest is grab a sample code to store the folder names in a table. Using queries or code, you will be able to determine the next folder name...
Forum: General Yesterday, 10:32 AM
Replies: 5
Views: 70
Posted By theDBguy
Re: Best method to get Access 2013

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.
Forum: Modules & VBA Yesterday, 10:29 AM
Replies: 3
Views: 46
Posted By theDBguy
Re: Get folder name

Hi. Welcome to AWF! You can use the Dir() function to loop through the folders. Where does the record number come from? Did you say you want to create a subfolder under the last folder you found?
Forum: Macros Yesterday, 10:02 AM
Replies: 11
Views: 90
Posted By theDBguy
Re: Before Change SetField Editable

Ah, I see. If field1 can never change, then we could assume an empty field2 should be equal to field1, right? Essentially, Nz(field2, field1). You should still be able to fix your macro, but if it...
Forum: Modules & VBA Yesterday, 09:52 AM
Replies: 15
Views: 512
Posted By theDBguy
Re: Play different sounds as Quick as DoCmd.Beep

Hi. You're welcome. Good luck with your project.
Forum: General Yesterday, 09:36 AM
Replies: 3
Views: 70
Posted By theDBguy
Re: Access front end -to- SQL back end

Hi. Yes, if you're talking about batch updates and deletes, one option is to convert your queries into pass through queries to let the server do the work instead of Access.
Forum: Macros Yesterday, 09:33 AM
Replies: 11
Views: 90
Posted By theDBguy
Re: Before Change SetField Editable

Hi, not sure I completely follow. If field1 was originally a "yes", for example, you want field2 to say yes as well. Then, you want the user to be able to change field2, so you could have field1=yes...
Showing results 1 to 25 of 500

 
Forum Jump



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