Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 295
Search took 0.05 seconds.
Search: Posts Made By: vba_php
Forum: Forms 01-12-2020, 12:17 PM
Replies: 7
Views: 198
Posted By vba_php
Re: Print Reports From A Reports Table

yes you can Nicole. you can actually write an SQL statement in the rowsource property of the combo box that looks at the system table which lists the user-created objects. once you do that, you can...
Forum: The Watercooler 01-11-2020, 04:13 PM
Replies: 7
Views: 203
Posted By vba_php
trolls and spammers using "whois" database

If you guys didn't know, I wanted to let you know what I found out yesterday from my hosting company "HostGator". I purchased a 2nd domain, which is going to be part of my own business, and because...
Forum: Modules & VBA 01-07-2020, 09:23 PM
Replies: 72
Views: 904
Posted By vba_php
Re: editable query without primary key

I'm sorry, but I seriously have to laugh at this. No offense to anyone. eshai, I'm really glad you solved your own problem! Way to go! :)
Forum: Modules & VBA 01-07-2020, 06:49 AM
Replies: 4
Views: 103
Posted By vba_php
Re: Function in Query

here's an example of a way to accomplish what you want to do, using the example function and sql you provided in your question'VBA called function
Function Title(strTitle As String) As String
Title...
Forum: Other Software 01-06-2020, 07:17 AM
Replies: 10
Views: 166
Posted By vba_php
Re: MP3 files App

Dick,

I hear you about the nursing home. My mother was in one for 20 years after suffering a terrible and unrecoverable brain injury. She passed away last week after suffering a stroke. ...
Forum: Queries 01-06-2020, 06:41 AM
Replies: 1
Views: 121
Posted By vba_php
Re: Problem with Count query

Benny,

You might have it more complicated than necessary, but I can't say for sure. Try changing this:SELECT Count(*) AS Applications, dbo_People.education
FROM (dbo_certs INNER JOIN...
Forum: Modules & VBA 01-06-2020, 05:50 AM
Replies: 27
Views: 738
Posted By vba_php
Re: User intervention, abort .copyfile() with a button

daryll,

I was suspecting that you're issue was unsolvable, primarily because of the apparent inability of VBA to execute more than 1 process at a time (check with others here about that though). ...
Forum: Modules & VBA 01-05-2020, 11:19 AM
Replies: 17
Views: 358
Posted By vba_php
Re: Collecting statisctics in db with VBA

that's why this place exists! :) I'm about to head out for an interesting engagement with another newbie to the software industry, so you might see me disappear for a while. If you need further...
Forum: Modules & VBA 01-05-2020, 11:06 AM
Replies: 17
Views: 358
Posted By vba_php
Re: Collecting statisctics in db with VBA

this is what you can do to accomplish that:


ditch the *embedded macro* behind the button, and write this instead behind the *click* event of *results*:Private Sub cmdResults_Click()
...
Forum: Modules & VBA 01-05-2020, 10:26 AM
Replies: 17
Views: 358
Posted By vba_php
Re: Collecting statisctics in db with VBA

I don't think so. when clicking on the *stats* tab and checking the recordsource for the subform control that appears, it is listed as *qryMDEMexamsCompleted*. you must be referring to the domain...
Forum: Theory and practice of database design 01-05-2020, 08:09 AM
Replies: 8
Views: 170
Posted By vba_php
Re: Design of a database to log site audits

I was referring to the evils of using lookup *fields* in tables. the real experts around here have always advocated against them. this is why, I suspect:

The evils of using lookup fields in...
Forum: Theory and practice of database design 01-05-2020, 06:10 AM
Replies: 8
Views: 170
Posted By vba_php
Re: Design of a database to log site audits

Here's a 2-bit take on what you might want to do:if you're talking about including combos in your actual *table fields* instead of on forms, that's not a good idea. everybody else around here will...
Forum: Forms 01-04-2020, 08:16 PM
Replies: 37
Views: 571
Posted By vba_php
Re: SubForm Record Source

mark the thread solved if the day is over kirk.
Forum: Forms 01-04-2020, 06:00 PM
Replies: 37
Views: 571
Posted By vba_php
Re: SubForm Record Source

Kirk,

the test I ran showed that the current event was trying to fire before the form could appear, and thus before it could load. the answer thus probably lies in what Micron told you. so I...
Forum: Forms 01-04-2020, 05:15 PM
Replies: 37
Views: 571
Posted By vba_php
Re: SubForm Record Source

when i ran a test on the forms, I noticed that the current() event was happening before the form was showing itself on the screen. so yes, in a sense, it sounds like you're right. I've never known...
Forum: Forms 01-04-2020, 04:48 PM
Replies: 37
Views: 571
Posted By vba_php
Re: SubForm Record Source

it's hard to say man. some of the language you're using in your posts can't really be deciphered properly because no one has actually seen what you're working with. stuff like running before Number...
Forum: Forms 01-04-2020, 04:39 PM
Replies: 37
Views: 571
Posted By vba_php
Re: SubForm Record Source

Kirk,

Hopefully the mods don't get mad at me for this, but if you want a real good look at how complex subforms can get, nothing could possibly be more complicated than Larry Ellison's creation...
Forum: Forms 01-04-2020, 04:33 PM
Replies: 37
Views: 571
Posted By vba_php
Re: SubForm Record Source

i'm not sure. I'll have to test it to find out because the answer just doesn't come to mind. I'll run a test just for fun, but before I get back to you someone else might give the answer anyway.no...
Forum: Forms 01-04-2020, 04:02 PM
Replies: 37
Views: 571
Posted By vba_php
Re: SubForm Record Source

see images.... ;)I have no idea, but I would guess not. font types and sizes are connected to controls and objects closer to the interface level of the application rather than the "data" level of...
Forum: The Watercooler 01-04-2020, 03:41 PM
Replies: 16
Views: 355
Posted By vba_php
Re: the differences between country cultures

maybe because they are in bed with Putin, like Trump is? :rolleyes: Or maybe Putin doesn't want anything to do with them, but rather wants to rule the place with an iron hand? i wouldn't be a bit...
Forum: Forms 01-04-2020, 03:24 PM
Replies: 37
Views: 571
Posted By vba_php
Re: SubForm Record Source

nobody else is getting involved it doesn't seem like. not sure what you mean by that Kirk. *get every record as it clicked*?
Forum: The Watercooler 01-04-2020, 03:12 PM
Replies: 16
Views: 355
Posted By vba_php
Re: the differences between country cultures

the issue of "political correctness" is part of a bigger picture of what is tearing down a system that could otherwise be great if conceptual junk like that didn't exist.I used to be a professional...
Forum: Forms 01-04-2020, 03:07 PM
Replies: 37
Views: 571
Posted By vba_php
Re: SubForm Record Source

don't worry about it man. we'll stick with you to get it solved. :) have you considered uploading your file here so these guys can look at it? you might get some better results, and even more...
Forum: Forms 01-04-2020, 02:38 PM
Replies: 37
Views: 571
Posted By vba_php
Re: SubForm Record Source

if you look in the property sheet for the subform, you'll notice there's no value in there. if you change the RS in code, that value listed in the prop sheet also never changes, but the subform...
Forum: The Watercooler 01-04-2020, 01:37 PM
Replies: 16
Views: 355
Posted By vba_php
Re: the differences between country cultures

I won't say anything about the dude in the white house Colin, but hasn't Iran always been a risk to the entire world due to their obsession with the development of nukes? Last I heard, the leader...
Showing results 1 to 25 of 295

 
Forum Jump



All times are GMT -8. The time now is 12:03 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 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World