Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.05 seconds.
Search: Posts Made By: datAdrenaline
Forum: Modules & VBA 07-21-2014, 01:31 PM
Replies: 16
Views: 60,391
Posted By datAdrenaline
Re: move cursor to end of text in textbox after setfocus

pfPositionCursor is a User Defined Function that should be placed in a Standard Module that does not share a name with any procedure.

The code for pfPositionCursor() is found post #4 of this...
Forum: Modules & VBA 11-02-2013, 02:00 PM
Replies: 16
Views: 60,391
Posted By datAdrenaline
Forum: Queries 06-12-2012, 06:29 PM
Replies: 1
Views: 530
Posted By datAdrenaline
Re: Troubleshoot Weekending Expression in Query

It would be helpful for us to see what the SQL View (your SQL Statement) of your Query object is. But even without that, your expression does not return the correct value. Please give the following...
Forum: Sample Databases 03-22-2012, 11:31 AM
Replies: 0
Views: 14,344
Posted By datAdrenaline
Who's Logged On / Who's Connected

Description ...

This utility will log the users who are connected to an MDB/E or ACCDB/E file via the UserRoster (http://www.access-programmers.co.uk/forums/http//support.microsoft.com/kb/198755)...
Forum: Modules & VBA 03-20-2012, 10:36 AM
Replies: 10
Views: 4,409
Posted By datAdrenaline
Re: Error - 'Cannot execute data definition'?

You're welcome! I am glad to here of your success!
Forum: Modules & VBA 03-19-2012, 01:05 PM
Replies: 10
Views: 4,409
Posted By datAdrenaline
Re: Error - 'Cannot execute data definition'?

Beleive it or not, you can modify the structure of the table that is represented by the linked table object fairly easily ... just provide the "Fully Qualified" path to the source table via the...
Forum: Queries 02-14-2012, 06:56 PM
Replies: 4
Views: 5,011
Posted By datAdrenaline
Re: Concatenate fields in multiple records into one record

I personally find the code found here (http://www.utteraccess.com/forum/Combine-Multiple-Records-t1190033.html) named MakeCSV() to be easier to use and more flexible --- Not that I am biased or...
Forum: General 11-04-2011, 06:37 AM
Replies: 3
Views: 805
Posted By datAdrenaline
Re: i need your thoughts masters :)

As Paul indicated, the .LastModified is relative to the Recordset object variable. But I have to ask -- Why would you enter data through a Query object? While it is possible, it is often times less...
Forum: Queries 10-24-2011, 06:23 AM
Replies: 6
Views: 808
Posted By datAdrenaline
Re: Average Date

>> A date is simply (http://www.access-programmers.co.uk/forums/showthread.php?t=217342#) a Long number <<

As an FYI. A VBA Date and the Date/Time datatype in Jet/ACE is an 8 byte floating point...
Forum: Access World News 10-24-2011, 06:15 AM
Replies: 85
Views: 56,847
Posted By datAdrenaline
Re: David Crake very sad news

<big sigh> ..

I am saddened by this news and priveledged to have coincided with Dave on these forums.

Sympathies are extended to all.
Forum: Modules & VBA 09-15-2011, 11:12 AM
Replies: 12
Views: 6,511
Posted By datAdrenaline
Re: Please read Masters of Access VBA

So assuming that you have a custom group named "History Only", you will want to go into the table MSysNavPaneGroups and find the row that equates to your custom group name. You will want to remember...
Forum: Modules & VBA 09-15-2011, 08:08 AM
Replies: 12
Views: 6,511
Posted By datAdrenaline
Re: Please read Masters of Access VBA

I don't have an example of modifying the data in the MSysNavPane tables since I subscribe to the belief that you really should not have a need to do so. :)

Can you review with us why you would...
Forum: Modules & VBA 09-15-2011, 07:35 AM
Replies: 12
Views: 6,511
Posted By datAdrenaline
Re: Please read Masters of Access VBA

What version of Access are you using?
Forum: Modules & VBA 09-15-2011, 06:00 AM
Replies: 12
Views: 6,511
Posted By datAdrenaline
Re: Please read Masters of Access VBA

Ok ... it seems there is a disconnect between what you are asking and the response you recieved. That much is obvious. With that, it would seem, you should take the time to look at your question, as...
Forum: Modules & VBA 08-04-2011, 11:31 AM
Replies: 14
Views: 4,712
Posted By datAdrenaline
Re: View Users Currently Logged In Sample Database

The v1.6.1 is what I am using (attached it to the post). The 128 character limit is something I can not control.

As far as being able to kick someone (or everyone) out of database, you have to...
Forum: Modules & VBA 08-04-2011, 09:57 AM
Replies: 14
Views: 4,712
Posted By datAdrenaline
Re: View Users Currently Logged In Sample Database

What are the environments that you are both working in? ... Win7 (64/32 bit) / WinXP?; Access version?

As an FYI ... I just downloaded and successfully ran the utility that is attached to post #3...
Forum: General 07-27-2011, 07:58 AM
Replies: 9
Views: 1,274
Posted By datAdrenaline
Re: why does this overflow?

Hello Doc! ...

Just a point of note ..

l = 255 + 1

Will not raise the overflow error because literals are cast as 2 byte integers or higher.

However, to illustrate you point, the...
Forum: General 07-26-2011, 11:30 AM
Replies: 9
Views: 1,274
Posted By datAdrenaline
Re: why does this overflow?

Very much so, I am just used to using VarType() ... :)
Forum: General 07-26-2011, 10:59 AM
Replies: 9
Views: 1,274
Posted By datAdrenaline
Re: why does this overflow?

This has to do with the type of the operands. VBA will imply the datatype of numerics into an Integer, Long, or Double if no datatype is specified. When you perform operations upon the operands,...
Forum: Queries 05-17-2011, 10:38 AM
Replies: 16
Views: 5,172
Posted By datAdrenaline
Re: between And Dates in Query Criteria

Sorry 'bout the dup info ... Bob and I racing to get the finish and his speedy internet prowess beat me to the punch! ... :D

... But ... do take a look at the full value of DateSubmitted from the...
Forum: Queries 05-17-2011, 10:34 AM
Replies: 16
Views: 5,172
Posted By datAdrenaline
Re: between And Dates in Query Criteria

You have a Null "DateSubmitted", as Bob had suspected, for a record in Innovative. Also, of you remove the format of "Short Date" at the Table design level for DateSubmitted, you will see that your...
Forum: Queries 05-17-2011, 10:21 AM
Replies: 16
Views: 5,172
Posted By datAdrenaline
Re: between And Dates in Query Criteria

... Also, understand that parameters that are not specifically given a datatype, will be first interpretted as Text. Most often, Access knows how to coerce the text into a the data type that the...
Forum: Queries 05-17-2011, 08:35 AM
Replies: 16
Views: 5,172
Posted By datAdrenaline
Re: between And Dates in Query Criteria

>> it is a date/time field , but i have no times associated withthis field <<

Times are ALWAYS associated with a Date/Time field. The value of a date/time field is stored as an 8 byte floating...
Forum: General 04-21-2011, 09:40 AM
Replies: 52
Views: 24,808
Posted By datAdrenaline
Re: Access's Yes/No Field=1 bit, VBA's boolean type=2 bytes?

Yes ... I know this is an old thread, but a discussion over at UtterAccess between Banana and myself had prompted a re-visit to this thread. In short, if you don't want to read it all, its seems that...
Forum: General 04-14-2011, 08:32 PM
Replies: 22
Views: 2,396
Posted By datAdrenaline
Re: Serious bloating

Hey ... that code looks familiar! .. :) ..

----

I used your db in A2010. The db size stayed right at 13mg after about 20 opens and closes ... with the FlexGrid and me selecting different...
Showing results 1 to 25 of 500

 
Forum Jump



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