Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.14 seconds.
Search: Posts Made By: theDBguy
Forum: Modules & VBA Today, 08:46 AM
Replies: 1
Views: 2
Posted By theDBguy
Re: Module - Audit Trail: Read Only Error

Hi. Do you know which line is causing the error? If you go to debug mode, can you verify if you were able to open the recordset with optimistic lock?
Forum: Forms Today, 08:26 AM
Replies: 3
Views: 11
Posted By theDBguy
Re: transferspreadsheet sometimes has strange behavior

Hi. Sounds like a plan. Good luck!
Forum: Reports Today, 07:23 AM
Replies: 3
Views: 14
Posted By theDBguy
Re: Create This Report?

Yes, you can, and you can also do the same with subforms. As an example, take a look at some Calendar demos, especially the ones that display appointments or events for each day of the calendar. You...
Forum: Reports Today, 07:17 AM
Replies: 3
Views: 14
Posted By theDBguy
Re: Create This Report?

Hi. Maybe you really only need to create one subreport but use it twelve times on the main report.
Forum: Reports Today, 07:04 AM
Replies: 11
Views: 38
Posted By theDBguy
Re: background color value

Of what/which control though? Are you talking about for the Form itself?
Forum: Modules & VBA Today, 07:01 AM
Replies: 13
Views: 110
Posted By theDBguy
Re: Keep Access Application Minimized

Hi. Just asking for some clarification here... Are you saying all machines are using 64-bit version of Access? Or, are you just saying all machines have a 64-bit version of Windows? Thanks!
Forum: Reports Today, 06:59 AM
Replies: 11
Views: 38
Posted By theDBguy
Re: background color value

Hi. I can't download your file at the moment. What control are you trying to change the color? Sometimes, you could use a workaround by using a Textbox to represent it, so you can apply conditional...
Forum: Forms Today, 06:54 AM
Replies: 3
Views: 11
Posted By theDBguy
Re: transferspreadsheet sometimes has strange behavior

Hi. I can't test this right now but try using your code while the spreadsheet is open just to verify if it will update or not. If it doesn't, then my guess is perhaps during those times when it...
Forum: Reports Today, 06:52 AM
Replies: 11
Views: 38
Posted By theDBguy
Re: background color value

Hi. Welcome to the forum! Have you tried using Expression Is in Conditional Formatting?
Forum: Queries Today, 06:50 AM
Replies: 3
Views: 46
Posted By theDBguy
Re: Multiple search only returning records I want

Hi. Pardon me for jumping in... When you have a child table related to a parent table, the usual approach for entering related data is by using a form/subform setup. The main form will be bound to...
Forum: Modules & VBA Today, 06:30 AM
Replies: 2
Views: 23
Posted By theDBguy
Re: Use TransferSharePointList And Pass Credentials

Hi. You shouldn't have to manually relink the tables. If you want to refresh the links, you can simply right-click on any linked SharePoint table and refresh from there. The login credentials...
Forum: Modules & VBA Today, 04:27 AM
Replies: 1
Views: 35
Posted By theDBguy
Re: Hide Admin Button

Hi. One approach is to not close your login form but merely hide it so you can always refer to the user information when you need it. Either that or save the info into global variables or TempVars.
Forum: Queries Yesterday, 07:30 PM
Replies: 15
Views: 104
Posted By theDBguy
Re: handle time average

Hi Dave. As I had suspected, your data is about time duration or elapsed time and not points in time. Therefore, I would suggest you do not use a Date/Time data type. If you must include seconds in...
Forum: Modules & VBA Yesterday, 04:39 PM
Replies: 7
Views: 99
Posted By theDBguy
Re: Dlookup with two criteria

Try
DLookup("surname","members","[name]=' & search_name & "' And age=" & search_age)
Forum: Queries Yesterday, 01:23 PM
Replies: 15
Views: 104
Posted By theDBguy
Re: handle time average

Hi Dave. It probably works out in your case, but I can't guarantee it does 100%. If the column you're showing in the image is a Date/Time data type, then technically, they don't represent 13 minutes...
Forum: Queries Yesterday, 12:54 PM
Replies: 15
Views: 104
Posted By theDBguy
Re: handle time average

Hi. Just to clarify where I'm coming from, here's an image of a table with a date/time field:
https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=75580&stc=1&d=1563483139


If...
Forum: Queries Yesterday, 12:25 PM
Replies: 6
Views: 64
Posted By theDBguy
Re: Automate Text/Date Criteria

Hi. You're welcome! Glad to hear you got it to work. Good luck with your project.
Forum: Queries Yesterday, 12:08 PM
Replies: 15
Views: 104
Posted By theDBguy
Re: handle time average

Hi. If the data is date/time values and you average them, then you will end up having a point in time, wouldn't you? What were those values supposed to represent? Were they supposed to be time...
Forum: Queries Yesterday, 11:46 AM
Replies: 15
Views: 104
Posted By theDBguy
Re: handle time average

In the Access table though, after you have moved the data from Excel, what is the data type? Also, when you average it, what is the unit of measure? Is it supposed to represent days, hours, or...
Forum: Queries Yesterday, 11:17 AM
Replies: 15
Views: 104
Posted By theDBguy
Re: handle time average

What was the data type of the original data? Was it a date/time field you averaged?
Forum: Queries Yesterday, 11:02 AM
Replies: 15
Views: 104
Posted By theDBguy
Re: handle time average

Hi. How was this data result achieved? What is the data type of the original data? Have you tried using either the Format property or the Format() function?
Forum: Introduce Yourself Yesterday, 11:02 AM
Replies: 1
Views: 34
Posted By theDBguy
Re: hello all

Hi. Welcome to the forum!
Forum: General Yesterday, 10:49 AM
Replies: 8
Views: 95
Posted By theDBguy
Re: Creating an Amortisation Schedule in Access

Hi. Welcome to the forum! Why does it need to be in Access, if you already have it in Excel? Just curious...
Forum: Queries Yesterday, 10:11 AM
Replies: 6
Views: 64
Posted By theDBguy
Re: Automate Text/Date Criteria

Okay, in that case, try using this:
"FY " & Format(DateAdd("m",6,[Enter Date]),"yyyy")
(untested)
Hope it helps...
Forum: Queries Yesterday, 09:49 AM
Replies: 6
Views: 64
Posted By theDBguy
Re: Automate Text/Date Criteria

Hi. I'm not sure I follow. So, if the user enters a month number, do we assume the user "always" refers to the upcoming month for the fiscal year? For example, if the user enter the number 7 today,...
Showing results 1 to 25 of 500

 
Forum Jump



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