Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.16 seconds.
Search: Posts Made By: theDBguy
Forum: Modules & VBA Today, 12:25 PM
Replies: 2
Views: 3
Posted By theDBguy
Re: Checking empty fields based on another textbox value

Hi. So, what's happening with your code? Is it not working? If not, are you getting an error message?
Forum: Forms Today, 11:52 AM
Replies: 4
Views: 34
Posted By theDBguy
Re: use a textbox as a resizeable and colourful checkbox

Hi. You started to describe what you tried, using the instructions from the other thread, but you didn't finish telling us what the result of your attempts were. We can't tell you what you did or...
Forum: SQL Server Today, 11:24 AM
Replies: 1
Views: 14
Posted By theDBguy
Re: how to export sql server data to access with stored procedure

Hi. Not sure if any of this will help but take a look (https://stackoverflow.com/questions/43409242/export-sql-tables-data-to-ms-access-using-stored-procedure). Good luck!
Forum: General Today, 09:11 AM
Replies: 6
Views: 40
Posted By theDBguy
Re: Property Not Found - 3270 - For some users and not others

No, I don't think it would matter. By putting the file in SharePoint, it means the users have to download a copy before they can use it. So, if the code works before you upload it to SharePoint, then...
Forum: General Today, 08:54 AM
Replies: 6
Views: 40
Posted By theDBguy
Re: Property Not Found - 3270 - For some users and not others

To test the theory, try creating a new blank database but don't change any default settings. Then add your code and run it to see if you get an error or not. Let us know how it goes.
Forum: General Today, 08:38 AM
Replies: 6
Views: 40
Posted By theDBguy
Re: Property Not Found - 3270 - For some users and not others

Hi. Welcome to the forum! Some database properties have to be created first before you can use them. You could add an error handler to trap the error and create the property and set it, if it doesn't...
Forum: Modules & VBA Today, 07:57 AM
Replies: 6
Views: 50
Posted By theDBguy
Re: VBA Open Record to Form

Hi. So, have you tried stepping through the code?
Forum: Modules & VBA Today, 07:48 AM
Replies: 6
Views: 50
Posted By theDBguy
Re: VBA Open Record to Form

Hi. From just looking at it, I would say the third version you posted above should have worked. One good thing about using VBA over a macro is you can step through the VBA code as it executes and...
Forum: Queries Today, 06:59 AM
Replies: 1
Views: 31
Posted By theDBguy
Re: Hex Function

Hi. Yes, you can use the Hex() function in a query. I just tried it.
Forum: Reports Today, 06:41 AM
Replies: 4
Views: 59
Posted By theDBguy
Re: Multple records to pdf

Hi Michael. Not sure I follow. I think I understand the header part, but do you really want to display/print empty records/lines on the report?
Forum: Forms Today, 06:37 AM
Replies: 4
Views: 34
Posted By theDBguy
Re: use a textbox as a resizeable and colourful checkbox

Hi. What were the exact troubles you were having when trying out the suggested approach?
Forum: Forms Today, 06:35 AM
Replies: 5
Views: 56
Posted By theDBguy
Re: How to "copy" data and "pasting" to the acNewRec

Hi. Take a look at the RunCommand method of the DoCmd object and the following arguments: acCmdSelectRecord, acCmdCopy, and acCmdPasteAppend


Hope it helps...
Forum: Introduce Yourself Today, 04:30 AM
Replies: 2
Views: 49
Posted By theDBguy
Re: Hi All

Hi yapsody. Welcome to the forum.
Forum: Access Web Yesterday, 10:47 AM
Replies: 3
Views: 66
Posted By theDBguy
Re: Simple Web application - which technology?

Hi. I know Caspio has a free version, but can't remember if Zoho has the same. Full instructions on how to build applications are available on their websites.
Forum: Forms Yesterday, 10:45 AM
Replies: 4
Views: 78
Posted By theDBguy
Re: Delete from 2 tables on 1 form

Hi. If you don't want to see old data, you could add a date field to the Patrons table to indicate the date when you would have deleted it. On your form, you can add a filter (a criteria in the query...
Forum: Access Web Yesterday, 10:38 AM
Replies: 3
Views: 66
Posted By theDBguy
Re: Simple Web application - which technology?

Hi. Please take the following just as a suggestion rather than a recommendation. You might want to take a look at either Caspio or Zoho. Good luck!
Forum: General Yesterday, 08:44 AM
Replies: 3
Views: 91
Posted By theDBguy
Re: Backup a backend

Hi. You're welcome. Let us know how it goes...
Forum: Tables Yesterday, 06:54 AM
Replies: 15
Views: 179
Posted By theDBguy
Re: Preset values in a field

Oh, if the records are required, then I guess there's no harm in pre-creating them. Cheers!
Forum: Tables Yesterday, 06:28 AM
Replies: 15
Views: 179
Posted By theDBguy
Re: Preset values in a field

Hi. If I understand it correctly, there’s no need to pre-create those nine records, if the user will be entering the certs anyway. If you use a form/subform setup with a properly linked fields, then...
Forum: Forms Yesterday, 05:56 AM
Replies: 4
Views: 78
Posted By theDBguy
Re: Delete from 2 tables on 1 form

Hi. We usually tend to recommend against deleting records. What happens if the patron decides to come back later on? You would have lost all their historical data. In any case, one way to delete a...
Forum: Modules & VBA Yesterday, 05:30 AM
Replies: 1
Views: 70
Posted By theDBguy
Re: Select Distinct with criteria in subform after filtred

Hi. Welcome to the forum. I’m afraid I don’t understand your question. Are you able to post a sample copy of your db with test data?
Forum: Forms 07-20-2019, 09:01 AM
Replies: 11
Views: 163
Posted By theDBguy
Re: Split form record selectors

Hi. The closest thing I could suggest is to set the Subdatasheet Height property to 0.0007"


Hope it helps...
Forum: Forms 07-20-2019, 08:49 AM
Replies: 3
Views: 88
Posted By theDBguy
Re: Insert a form into a subform

Hi Rick. Is "DM" the name of a subform? If so, the INSERT statement is only used to insert data into tables. For dynamic displays of subforms, you can can add an empty subform container to a form and...
Forum: Introduce Yourself 07-20-2019, 08:17 AM
Replies: 4
Views: 91
Posted By theDBguy
Re: Hello All from WA

Hi Rick. Welcome to the forum.
Forum: Forms 07-20-2019, 08:05 AM
Replies: 4
Views: 109
Posted By theDBguy
Re: Changing images on a Continuous Form

Hi. Yes. This should not be a problem if you store the image externally to the database and simply store the path to the images. You can then bind the image control to it and no code is needed.
Showing results 1 to 25 of 500

 
Forum Jump



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