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: Reports Yesterday, 04:34 PM
Replies: 4
Views: 38
Posted By theDBguy
Re: Moving Text boxes on a report

It could just be me but I don't think I completely understand the request. What is the problem with moving the textboxes? Are you loosing the set justification?
Forum: General Yesterday, 02:16 PM
Replies: 4
Views: 54
Posted By theDBguy
Re: Backup a Backend - enhanced

Hi. Thanks for the enhancements. I might incorporate that the next time I update the website. I actually have some changes I’ve been meaning to add, like handling password protected BEs. Cheers!
Forum: Forms Yesterday, 02:13 PM
Replies: 4
Views: 53
Posted By theDBguy
Re: displaying data from an xml file on a form

Hi. You will have to store the xml in a variable and then parse it using VBA. There should be some sample code available here to do that by doing a quick search

Sent from phone...
Forum: Queries Yesterday, 02:10 PM
Replies: 3
Views: 66
Posted By theDBguy
Re: Query not accepting Form Value (multi Select List)

Hi. Not sure if this will help but take a look at this article (https://thedbguy.blogspot.com/2018/11/create-parameter-query-to-accept.html). Good luck.
Forum: Modules & VBA Yesterday, 12:55 PM
Replies: 20
Views: 168
Posted By theDBguy
Re: Module - Audit Trail: Read Only Error

Hi. Glad to hear you got it sorted out. Good luck with your project.
Forum: Modules & VBA Yesterday, 12:07 PM
Replies: 20
Views: 168
Posted By theDBguy
Re: Module - Audit Trail: Read Only Error

I think we would only need enough to duplicate the issue. You can convert any necessary linked table into a local table.
Forum: Modules & VBA Yesterday, 09:45 AM
Replies: 20
Views: 168
Posted By theDBguy
Re: Module - Audit Trail: Read Only Error

Looks straightforward enough. You may have to post a sample copy of your db just in case the problem is actually coming from elsewhere. Otherwise, you might consider switching to DAO and hope it...
Forum: Reports Yesterday, 09:43 AM
Replies: 5
Views: 55
Posted By theDBguy
Re: Create This Report?

You could try using code to do that. If you found an Calendar example, you might see the author simply used the Linked Master/Child Fields to show different data in each subform.
Forum: Modules & VBA Yesterday, 09:41 AM
Replies: 20
Views: 168
Posted By theDBguy
Re: Module - Audit Trail: Read Only Error

Hi. I just did a quick test to see if an open table would not allow me to add a new record using ADO. Unfortunately (or fortunately), I didn't get any errors. So, maybe the problem is with your...
Forum: Modules & VBA Yesterday, 08:46 AM
Replies: 20
Views: 168
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 Yesterday, 08:26 AM
Replies: 3
Views: 57
Posted By theDBguy
Re: transferspreadsheet sometimes has strange behavior

Hi. Sounds like a plan. Good luck!
Forum: Reports Yesterday, 07:23 AM
Replies: 5
Views: 55
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 Yesterday, 07:17 AM
Replies: 5
Views: 55
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 Yesterday, 07:04 AM
Replies: 11
Views: 107
Posted By theDBguy
Re: background color value

Of what/which control though? Are you talking about for the Form itself?
Forum: Modules & VBA Yesterday, 07:01 AM
Replies: 15
Views: 167
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 Yesterday, 06:59 AM
Replies: 11
Views: 107
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 Yesterday, 06:54 AM
Replies: 3
Views: 57
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 Yesterday, 06:52 AM
Replies: 11
Views: 107
Posted By theDBguy
Re: background color value

Hi. Welcome to the forum! Have you tried using Expression Is in Conditional Formatting?
Forum: Queries Yesterday, 06:50 AM
Replies: 4
Views: 75
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 Yesterday, 06:30 AM
Replies: 2
Views: 48
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 Yesterday, 04:27 AM
Replies: 3
Views: 57
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 07-18-2019, 07:30 PM
Replies: 15
Views: 123
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 07-18-2019, 04:39 PM
Replies: 7
Views: 116
Posted By theDBguy
Re: Dlookup with two criteria

Try
DLookup("surname","members","[name]=' & search_name & "' And age=" & search_age)
Forum: Queries 07-18-2019, 01:23 PM
Replies: 15
Views: 123
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 07-18-2019, 12:54 PM
Replies: 15
Views: 123
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...
Showing results 1 to 25 of 500

 
Forum Jump



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